Importing fails due to database connection options
I'm importing a phpBB 3.0.x forum to Vanilla 2.3.
My stack comprises of Nginx, MySQL 5.7, and PHP 5.5
I used VanillaPorter to create an export.txt.gz file and uploaded it into the /uploads folder.
Then within the dashboard, I went into import and started the import process.
The import works fine for a minute until it reaches the step: 9. Insert Tables
As soon as it reaches this step, a red bar pops up with the following error:
"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'set time_zone = '+0:0'' at line 1"
Note: It used to be '+0:0', but I changed it during my troubleshooting so just keeping you informed there.
I have narrowed this issue down to the config.php file.
Within database connections, for parameter 1002, the set time_zone text is set there. Any attempts to change it or remove it end up in even worse errors to come about that breaks the forum entirely.
Has anyone else come across this error?