XF 1.4 Mysql error

[Tower]

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]

How did you do the dump and restore?

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

 

[Tower]

How did you do the dump and restore?

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

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

 

[Paul B]

That's likely the problem then.

You should do it via SSH and mysqldump.

 

[Tower]

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