Importing sql file from mysql - #1064 error

Discussion in 'Installation/Configuration' started by CubeOne, Mar 3, 2021.

  1. CubeOne

    CubeOne New Member

    Today, after a week of every day hard work I finally made it - my ispconfig is online and all works well! But then I tried to import .sql file from my old plesk server (unfortunately does not exist anymore) and I ended up with error of #1064 and I just don't know what I need to do, so any help/advice is welcome.

    I know I will have to fix many in this database, but if someone can point me what I need to change here, later (I guess) I will be able to fix it overall :).

    Thanks!
     
  2. Jesse Norell

    Jesse Norell ISPConfig Developer Staff Member ISPConfig Developer

    Remove 'DEFAULT' from that column definition.
     
  3. CubeOne

    CubeOne New Member

    I tried that, but now another error shows up.

    It seems now some of the '' are too much or?
     
  4. Jesse Norell

    Jesse Norell ISPConfig Developer Staff Member ISPConfig Developer

    Remove the '' from that line.
     

Share This Page