On March 26, 2019 we launched new MODX Forums. Please join us at the new MODX Community Forums.
Subscribe: RSS
  • 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)?
    • 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