MyBB Community Forums

I tried a few plugins and from all i seem to get this error 1366,

for example I tried MyBB Destek Adv. Portal v (6) plugin, and it gives me the following error(the error is the same for some other plugins also);

"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','portalayar','Settings for Portal','Portal plugins includes settings for customizing your.','2','no')
Please contact the MyBB Group for support."

Does somebody know what is the problem?

Everything you need is in the error.

Try uninstalling/deleting that plugin, and the appropriate files from PMA, and then try reinstalling again.

Thanx for the reply but reinstalling it doesn't fix the problem, as I read in other threads with 1366 error title, it is the STRICT mode of MySQL, after I contacted the provider they disabled the strict mode and after it worked like a charm. Great plugin though!

Yeah, the problem was that it was inserting 'NULL' instead of just NULL.. the ' and ' makes it a string whereas it's meant to just be NULL, no value.