I need to fix a legacy of MODX 1.0.4 so I need to import its database into my local MySQL database but I have error below:
Error in query (1075): Incorrect table definition; there can be only
one auto column and it must be defined as a key
CREATE TABLE `modx_categories` (
`id` int(11) NOT NULL auto_increment,
`category` varchar(45) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Categories to be used snippets,tv,chunks, etc';
Any ideas how I can fix this table (and other tables that might have the same problem)?