We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 41970
    • 79 Posts
    Hi,

    I developed a modX website locally using XAMPP and the mySQL version was 4.x. I have installed modX on the server now and have tried to import the database files into phpmyadmin, but I am getting this error:

    Error
    SQL query:
    
    - - CREATING TABLE modx_access_actiondom DROP TABLE IF EXISTS  `modx_access_actiondom` ;
    
    
    MySQL said: Documentation
    
    #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '--CREATING TABLE modx_access_actiondom
    DROP TABLE IF EXISTS `modx_access_actiond' at line 1 


    The new database I am working with is version 5.x, so is it possible that the error happens because of incompatibility? If yes, is there a way to fix this, so that I can still import the database?

    Hope you can help.

    Belinda
      • 3749
      • 24,544 Posts
      Try CREATE TABLE instead of CREATING TABLE.
        Did I help you? Buy me a beer
        Get my Book: MODX:The Official Guide
        MODX info for everyone: http://bobsguides.com/modx.html
        My MODX Extras
        Bob's Guides is now hosted at A2 MODX Hosting