This banned everyone this morning. I imported the product-trolltracker_beta_blockdisabled.xml and then tried to overwrite it with the original product and get this error. Now I have no product showing and can't import either of them.
Invalid SQL:
CREATE TABLE user_troll (
`idx` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL default '0',
`username` varchar(128) NOT NULL default '',
`userlink` int(11) NOT NULL default '0',
`forwarded_for` varchar(128) NOT NULL default '',
`browser` varchar(255) NOT NULL default '',
`http_via` varchar(128) NOT NULL default '',
`realip` varchar(15) NOT NULL default '',
`owner` varchar(128) NOT NULL default '',
`timestamp` int(11) NOT NULL default '0',
`date` date NOT NULL default '0000-00-00',
`time` time NOT NULL default '00:00:00',
`external` int(11) NOT NULL default '0',
`opm` int(11) NOT NULL default '0',
`imported` int(11) NOT NULL default '0',
PRIMARY KEY (`idx`),
KEY `uscan` (`username`,`realip`)
);
MySQL Error : Table 'user_troll' already exists
Error Number : 1050
|