MyBB Community Forums

Trying to move server I've done the database side of it I.E backup as per the mybb details.

However on importing the backup to the new server mysql I keep getting an error thrown up from the subscription_log database.

ERROR 1265 (01000) at line 97: Data truncated for column 'payment_type' at row 1

How do I fix this?

I've dropped this table and the rest all import 100% fine.

This is a snippet of the line where the issue is.
option_selection2,payment_type,payment_status,

It seems to me like you're using a CSV file, the database is trying to import the first line which are the names of the columns. Normally this shouldn't cause any issues but I would suggest trying to remove the last comma, if that doesn't work then simply remove the first line and re-import again.

Thanks for your reply nixpc.

it's the SQL database backup taken from the forum admin section, so it's not a csv file.

I have managed to fix it by removing strict line from the mysql my.ini file.