try adding 'NOT NULL' on the end of this line: cid int( 10 ) unsigned default '0', like this: cid int( 10 ) unsigned default '0' NOT NULL, Abalieno wrote:
So I tried to install the module and I saw also the patch that will allow me to mass delete all that.
But while running the SQL query in phpmyadmin I got the following error:
Error SQL-query : CREATE TABLE spam_comments( cid int( 10 ) unsigned default '0', rating int( 2 ) unsigned default '0', spam tinyint( 1 ) unsigned default '0', last int( 11 ) unsigned default '0', PRIMARY KEY cid( cid ) , KEY rating( rating ) , KEY spam( spam ) , KEY last( last ) ) TYPE = MYISAM MySQL said:
#1171 - All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead
How can I fix this so that I'm able to move forward?