We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 53438
    • 16 Posts
    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)?
      • 13226
      • 953 Posts
      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