MyBB Community Forums

I have had this issue with many plugins. Not sure why the authors tend to stick with using NULL when the mysql installation by default does not allow it. Usually it can be fixed by removing null all together; however, in this plugin I cannot seem to remove it.

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:1366 - Incorrect integer value: 'NULL' for column 'gid' at row 1Query: INSERT INTO mybb_settinggroups (`gid`,`name`,`title`,`description`,`disporder`,`isdefault`) VALUES ('NULL','topStats','Top Stats','Settingsfor plugin Top Stats.',102,'0') 

You can view the plugin here

Has anyone had any luck with this?

EDIT: Found the resolution by disabling strict mode on mariadb via this command on only my mybb db.
SET sql_mode = 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,ERROR_FOR_DIVISION_BY_ZERO'

Said plugin hasn't been updated in well over a year so that could be a contributing factor since things have changed a lot in the last year and a half. No build is marked as stable.