16
well, when we solve this problem then we maybe motivate you to help other users with similar or other problems. So in the theory, then every question is important
First, make a backup of your database!You need to create the missing table, if you use phpMyAdmin you can do it like this: Click query window (small "SQL" icon in the left menu), select your XOOPS database fom the dropdown.
Copy and paste this into the query window:
CREATE TABLE `XXXX_online` (
`online_uid` mediumint(8) unsigned NOT NULL default '0',
`online_uname` varchar(25) NOT NULL default '',
`online_updated` int(10) unsigned NOT NULL default '0',
`online_module` smallint(5) unsigned NOT NULL default '0',
`online_ip` varchar(15) NOT NULL default '',
KEY `online_module` (`online_module`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
XXXX have to be replaced with your prefix, if your prefix is 87dha0 then it will be 87dha0_online
CHARSET=latin1; should be replaced with the character set you use, if you are unsure on what to write there you can open the backup of your database in Notepad and see the buttom of each table-creation (if you can't read your sql-file because it's messy, then drag and drop it to your browser)
Press Go and your table should be created sucessfully, and hopefully is the problem fixed
Databases isn't my very strongest side, so I hope you made a backup first and someone can validate what I wrote.
I'm not sure, but I think "DEFAULT CHARSET=utf8;" could be left out and that it might should be a "PRIMARY KEY (`online_uid`)," right above "KEY"
Best Regards,
Bananadude
--- censored by Bananadude ---
