Hi,

I installed a module called sstatus and it caused my entire site to go blank. I was unable to access anything, so I deleted the module folder from the module directory on the server.

My site came up and an error saying that sstatus module is missing. I went into system module and removed the sstatus module from the system.

I have now copied a backup of sstatus into the module directory but it would not install saying that the table already exists. I have done a debug of this error:

CREATE TABLE xoops_sstatus_memos ( id int(11) NOT NULL auto_increment, serviceid int(11) NOT NULL default '0', uid int(11) NOT NULL default '0', memo mediumtext NOT NULL, status int(11) NOT NULL default '0', posted int(11) NOT NULL default '0', PRIMARY KEY (id), KEY serviceid (serviceid,uid,status), KEY posted (posted) ) TYPE=MyISAM
Error number: 1050
Error message: Table 'xoops_sstatus_memos' already exists

How can i fix this? Can anyone please help me. Im stuck!!

regards,
MG

---------------
XOOPS FOREVER!!!!!!!
---------------

try this from phpmyadmin:

DROP TABLE xoops_sstatus_memos

Excellent!! it worked. Thanks