MyBB Community Forums

Full Version: MyBB has experienced an internal SQL error and cannot continue.
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Hello,

I'm trying to install plugins and I'm getting these errors messages when I'm installing the plugins.


MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1366 - Incorrect integer value: 'NULL' for column 'gid' at row 1
Query:
INSERT INTO mybb_settinggroups (`gid`,`name`,`title`,`description`,`disporder`,`isdefault`) VALUES ('NULL','Plugin_name','','The settings used by the plugin: Name','250','no')

Anybody know how to fix this, it's not just one plugin its like three sometimes 4?
Maybe you should post more details about the plugins you're trying to install, assuming they're official ones.
Sorry it's the staff online plugin.
For some reason it's trying to set a value of an auto-increment column to null. I think the reason it's erroring my be because you have strict mode enabled, but if you remove

`gid`,

and

'NULL',

from the query it should work.