Quote:
Originally Posted by ForceHSS
Run this sql
DROP TABLE IF EXISTS `glowhostspamomatic_log`;
CREATE TABLE `glowhostspamomatic_log` (
`date` datetime NOT NULL,
`ip` varchar(15) NOT NULL,
`email` varchar(255) NOT NULL,
`username` varchar(255) NOT NULL,
`message` varchar(255) NOT NULL,
`is_blocked` tinyint(4) NOT NULL default '0',
`user_hash` varchar(50) NOT NULL,
`user_id` int(11) NOT NULL,
KEY `user_id` (`user_id`),
KEY `date` (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|
I'm having the same issue, and running that SQL gets me a second error:
An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE `glowhostspamomatic_log` (
`date` datetime NOT NULL,
`ip` varchar' at line 2