MyBB Community Forums
[Error Message] MyBB has experienced an internal SQL error and cannot continue. - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: 1.8 Support (https://community.mybb.com/forum-175.html)
+--- Forum: General Support (https://community.mybb.com/forum-176.html)
+--- Thread: [Error Message] MyBB has experienced an internal SQL error and cannot continue. (/thread-195178.html)



MyBB has experienced an internal SQL error and cannot continue. - JMPRockFm - 2016-07-04

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?


RE: MyBB has experienced an internal SQL error and cannot continue. - ShadowOne - 2016-07-04

Maybe you should post more details about the plugins you're trying to install, assuming they're official ones.


RE: MyBB has experienced an internal SQL error and cannot continue. - JMPRockFm - 2016-07-04

Sorry it's the staff online plugin.


RE: MyBB has experienced an internal SQL error and cannot continue. - Matt - 2016-07-04

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.