1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.4 Mysql error

Discussion in 'XenForo Questions and Support' started by Tower, May 5, 2015.

  1. Tower

    Tower Active Member

    I am moving to Plesk, and importing the database, I get this error,
    Mysqli statement execute error : Field 'id' doesn't have a default value

    What does this mean and how can I fix it?
  2. Brogan

    Brogan XenForo Moderator Staff Member

    How did you do the dump and restore?

    If you are getting errors when importing then that could indicate problems with the dump.
  3. Tower

    Tower Active Member

    Hi Brogan, I used phpmyadmin to do the export and import because I am using a different server.
  4. Brogan

    Brogan XenForo Moderator Staff Member

    That's likely the problem then.

    You should do it via SSH and mysqldump.
    maszd likes this.
  5. Tower

    Tower Active Member

    I exported thru command line and that worked. This can be closed. Thanks

Share This Page