We build. You grow.

Get best community software here

Start a social network, a fan-site, an education project with oxwall - free opensource community software

Bug with update plugin notification | Forum

Cedric Maire
Cedric Maire Mar 5 '13
Hello

After an update for the plugin notification, i've got a erreur 500.


I have switch to debug mode and this is the erreur message : 

Message:SQLSTATE[42S02]: Base table or view not found: 1146 Table 'db416022559.ow_notifications_notification' doesn't existFile:/homepages/19/d415940713/htdocs/ow_core/database.php



Can someone help me please ? 

Purusothaman Ramanujam
How did you tried the plugin? Was the plugin active during the upgrade?
Cedric Maire
Cedric Maire Mar 5 '13
I juste want to update the plugin. I put all the files in the directory. But i have not desactivate the plugin before. I my database there is no table call ow.notifications_notification Can you send me a dump for this table ? I try to install a oxwall on my computer local in order to retrieve this table. Is a solution for desactivate a plugin when you don't have acces to admin panel ? via ftp ?
Purusothaman Ramanujam
CREATE TABLE IF NOT EXISTS `ow_notifications_notification` (
  `id` int(11) NOT NULL auto_increment,
  `entityType` varchar(255) NOT NULL,
  `entityId` int(11) NOT NULL,
  `action` varchar(255) NOT NULL,
  `userId` int(11) NOT NULL,
  `pluginKey` varchar(255) NOT NULL,
  `timeStamp` int(11) NOT NULL,
  `viewed` int(11) NOT NULL default '0',
  `sent` tinyint(4) NOT NULL default '0',
  `active` tinyint(4) NOT NULL default '1',
  `data` text,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `entityType` (`entityType`,`entityId`,`userId`),
  KEY `timeStamp` (`timeStamp`),
  KEY `userId` (`userId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Cedric Maire
Cedric Maire Mar 5 '13
Thanks but i have found another solution. 

I rename /ow_plugins/notification/init.php and no error when i lunch my site. 

i have make a news install of the plugin and all is ok. 


Thanks for your help.

Purusothaman Ramanujam
What you have done is not recommended.


Quote from Cedric Maire I rename /ow_plugins/notification/init.php and no error when i lunch my site.

All the actions and notifications wont happen as the init.php has all under it.


Cedric Maire
Cedric Maire Mar 5 '13
i have rename to init.php and all is ok