Blog Documentation Book a Demo
Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

Importing fails due to database connection options

pg_vanillapg_vanilla New
in Vanilla 2.0 - 2.8

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?

Sign In or Register to comment.