MODX legacy - Incorrect table definition; there can be only one auto column and it must be defined as a key

- 16 Posts
laukok Reply #1, 9 years, 4 months ago
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

For
```
 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)?
- 953 Posts
iusemodx Reply #2, 9 years, 4 months ago

I am not sure about this, but after answering your other questions I think you should clear the logs , then optimize the DB and carry out a table repair

Then export it, if you can't export it from PHPmyAdmin, you can export it via Evo itself

Login: Tools => Backup

If that doesn't work, someone else with more advanced DB knowledge will have to answer your question
Download the latest Evo release
Report an issue about Evo
Read the Evo documentation