Tower Active member May 5, 2015 #1 Hello, 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?
Hello, 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?
Paul B XenForo moderator Staff member May 5, 2015 #2 How did you do the dump and restore? If you are getting errors when importing then that could indicate problems with the dump. Upvote 0 Downvote
How did you do the dump and restore? If you are getting errors when importing then that could indicate problems with the dump.
Tower Active member May 5, 2015 #3 Brogan said: How did you do the dump and restore? If you are getting errors when importing then that could indicate problems with the dump. Click to expand... Hi Brogan, I used phpmyadmin to do the export and import because I am using a different server. Upvote 0 Downvote
Brogan said: How did you do the dump and restore? If you are getting errors when importing then that could indicate problems with the dump. Click to expand... Hi Brogan, I used phpmyadmin to do the export and import because I am using a different server.
Paul B XenForo moderator Staff member May 5, 2015 #4 That's likely the problem then. You should do it via SSH and mysqldump. Upvote 0 Downvote
Tower Active member May 5, 2015 #5 I exported thru command line and that worked. This can be closed. Thanks Upvote 0 Downvote
