2022-09-10, 12:20 AM
I had a suggestion to try the Merge system to migrate a forum from MariaDB to PostgreSQL, it clearly hasn't been tested for this.
After supplying credentials, it errors out with:
"MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
0 - ERROR: syntax error at end of input LINE 1: ALTER TABLE mybb_users ^
Query:
ALTER TABLE mybb_users"
Setup details:
Server OS: FreeBSD 12.3-RELEASE
PHP: 7.4
PostgreSQL 13.7
MariaDB 10.6
NGINX 1.22
MyBB 1.8.30
Reproducing it is easy. Take any MyBB 1.8 database, load it into mysql. Then create a new forum install, add merge system, set pgsql driver (pdo errors out!), ignore PHP warnings. Attempt merge with correct credentials.
There are no error.log files produced, even though I set that. PHP error_log shows nothing relevant either.
I'm reporting a problem, but there's no necessary request to fix it as I have another way to try and do this... eventually.
After supplying credentials, it errors out with:
"MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
0 - ERROR: syntax error at end of input LINE 1: ALTER TABLE mybb_users ^
Query:
ALTER TABLE mybb_users"
Setup details:
Server OS: FreeBSD 12.3-RELEASE
PHP: 7.4
PostgreSQL 13.7
MariaDB 10.6
NGINX 1.22
MyBB 1.8.30
Reproducing it is easy. Take any MyBB 1.8 database, load it into mysql. Then create a new forum install, add merge system, set pgsql driver (pdo errors out!), ignore PHP warnings. Attempt merge with correct credentials.
There are no error.log files produced, even though I set that. PHP error_log shows nothing relevant either.
I'm reporting a problem, but there's no necessary request to fix it as I have another way to try and do this... eventually.