Import IPB to Vanilla

LitteulBlack

Hi,

I try to convert a IPB 3.4.8 forum to Vanilla 3.3.

No problem with the Porter 2.5 script. The export.txt.gz it's perfectly create with no errors.

I install a new Vanilla 3.3 forum, and add the line in configuration file to activate the import function.

Create the import path and give the right permission. And after that transfert the export file in the upload path.

But when I import I have this error message:

Incorrect integer value: '' for column `vanilla`.`GDN_zUser`.`HourOffset` at row 14

I decompress file to see the row 14, but a see no null value for the "HourOffset". I check that the file is UTF-8 and retries with the uncompressed file (text file). Same error.

Have any idea ? Did I miss an operation during the conversion process ?

Thank you for your help / support.

Bleistivt

This might be a MySQL strict mode issue. While Vanilla supports it, I don't know if the Porter output conforms to it. You could try disabling it for the time of the import:

https://dev.mysql.com/doc/refman/8.0/en/sql-mode.html#sql-mode-setting

 sql-mode=""

LitteulBlack

Thank @Bleistivt, that working perfect with the SQL mode

It's now sloved !!