1.0 rc3 - Notes problem

[Number8]

When I add a Note to a workspace, then try to edit the note, I get
  Error 500 : OK
    Click to remove

[ignacio]

This shouldn't be happening. Its working fine on demo.opengoo.org. Can you send us your OpenGoo log (first you need to set DEBUG as true on the config), and your PHP version, as well as anything you think could help.

[Number8]

Error (DBQueryError)
Query failed with message 'Table 'server_OG1.og_object_subscriptions' doesn't exist'
Error params:
File:    /home/server/public_html/OpenGoo/Collab/environment/library/database/adapters/AbstractDBAdapter.class.php
Line:    371
Sql:    SELECT * FROM `og_object_subscriptions` WHERE `object_id` = '3' AND `object_manager` = 'ProjectMessages'
Error number:    1146
Error message:    Table 'server_OG1.og_object_subscriptions' doesn't exist

I have followed the upgrade instructions since .8...   Will this require a re-install, or can it be repaired?
Thanks for the help.

[ignacio]

Try executing this SQL in your database:

Code: [Select]

INSERT INTO `og_user_ws_config_options` (`id`,`category_name`,`name`,`default_value`,`config_handler_class`,`is_system`,`option_order`,`dev_comment`) VALUES
 (10,'dashboard','show tasks in progress widget','1','BoolConfigHandler',0,0,''),
 (11,'task panel','can notify from quick add','0','BoolConfigHandler',0,0,''),
 (12,'task panel','tasksShowWorkspaces','1','BoolConfigHandler',1,0,''),
 (13,'task panel','tasksShowTime','1','BoolConfigHandler',1,0,''),
 (14,'task panel','tasksShowDates','1','BoolConfigHandler',1,0,''),
 (15,'task panel','tasksShowTags','1','BoolConfigHandler',1,0,''),
 (16,'task panel','tasksGroupBy','milestone','StringConfigHandler',1,0,''),
 (17,'task panel','tasksOrderBy','priority','StringConfigHandler',1,0,''),
 (18,'task panel','task panel status','1','IntegerConfigHandler',1,0,''),
 (19,'task panel','task panel filter','assigned_to','StringConfigHandler',1,0,''),
 (20,'task panel','task panel filter value','0:0','UserCompanyConfigHandler',1,0,''),
 (21,'dashboard','show comments widget','1','BoolConfigHandler',0,0,''),
 (22,'dashboard','always show unread mail in dashboard','0','BoolConfigHandler',0,10,'when false, active workspace email is shown')
 ON DUPLICATE KEY UPDATE id=id;
 
CREATE TABLE `og_object_subscriptions` (
  `object_id` int(10) unsigned NOT NULL default '0',
  `object_manager` varchar(50) NOT NULL,
  `user_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`object_id`,`object_manager`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `og_object_subscriptions` (`object_id`, `object_manager`, `user_id`)
SELECT `message_id` as `object_id`, 'ProjectMessages' as `object_manager`, `user_id`
FROM `og_message_subscriptions`;

DROP TABLE `og_message_subscriptions`;

CREATE TABLE `og_object_reminders` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `object_id` int(10) unsigned NOT NULL default '0',
  `object_manager` varchar(50) NOT NULL,
  `user_id` int(10) unsigned NOT NULL default '0',
  `type` varchar(40) NOT NULL default '',
  `minutes_before` int(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE `og_event_invitations` (
  `event_id` int(10) unsigned NOT NULL default '0',
  `user_id` int(10) unsigned NOT NULL default '0',
  `invitation_state` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY (`event_id`, `user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `og_event_invitations` (`event_id`, `user_id`, `invitation_state`)
 SELECT `id`, `created_by_id` , 1 as `estado` FROM `og_project_events`
 ON DUPLICATE KEY UPDATE `event_id`=`event_id`;
 
This is executed when upgrading from 0.9 to 1.0. Are you sure you ran the upgrade procedure (<opengoo>/public/upgrade) from 0.9 to 1.0?