solved mysql 8 support

alt=
@nomoo
2 months ago
12 posts
hello! updated mysql from percona 5.7 to mysql 8.0.35 and got the error:
PHP Fatal error:  Uncaught Error: mysqli object is not fully initialized in /www/genosis/modules/jrCore-release-7.0.0/lib/mysql.php:378
jamroom version 7.0.0, i'm using it with genosis.

Is it supported or i'm doing something wrong?
updated by @nomoo: 01/04/24 09:11:12AM
brian
@brian
2 months ago
10,136 posts
Jamroom should run no problem on MySQL 8 - I develop on it and don't see any issues (currently on 8.0.35). Are you sure it is fully installed correctly and that it's not trying to bring in any of the previous Percona install? One thing that might be worth a shot is add this line to your data/config/config.php file:

$_conf['jrCore_sql_mode'] = '0';

Just in case it was installed with the sql mode set to something weird - this will disable it. Not sure if that will help or not but worth a try. Let me know if that helps.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
alt=
@nomoo
2 months ago
12 posts
Thank you, Brian! I figured out that my db installation was broken due to major database update. I've downgraded, made a dump then restored dump to fresh database. Voila, jamroom is alive again.

Tags