Problem by installing a Plugin even on 1.610 and 1.6.12

[f7n]

Problem by installing a Plugin even on 1.610 and 1.6.12


MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1366 - Incorrect integer value: '' for column 'gid' at row 1
Query:
INSERT INTO mybb_settinggroups (gid,name,title,description,disporder,isdefault) VALUES ('','fa_hsc','Forum Age','What is your forum age?','35','no')


Ive try to reinstall and still the same message what I need to do please help! any mod that I try to install.


http://gyazo.com/7d6e566cd4fb2e885f101b196c5bddc7

[Devilshakerz]

Truly speaking it is the plugins' fault, because they don't seem to be compatible with the database software configuration. However, you could ask your server's administrator to disable MySQL's STRICT mode and they should work fine.

[f7n]

If you installed MyBB and you are able to login then you would have utilized a database to do so however it sounds like it is a problem of the plugin as we do not run STRICT mode in MySQL in your environment.
I get this message from him

---

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','forum_on_off','Forum Online & Offline','Settings for the plugin.','1','no')


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','newpoints_edit','Newpoints Edit','Settings for the plugin.','1','no')


MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1101 - BLOB/TEXT column 'groups' can't have a default value
Query:
CREATE TABLE mybb_ougc_customrep ( rid bigint(30) UNSIGNED NOT NULL AUTO_INCREMENT, name varchar(100) NOT NULL DEFAULT '', image varchar(255) NOT NULL DEFAULT '', groups text NOT NULL DEFAULT '', forums text NOT NULL DEFAULT '', disporder smallint(5) NOT NULL DEFAULT '0', visible smallint(1) NOT NULL DEFAULT '1', reptype varchar(3) NOT NULL DEFAULT '', PRIMARY KEY (rid) ) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci;
Please contact the MyBB Group for support.



All of that orange plugins! Reinstalling doesn't help!

[laie_techie]

The value should be NULL; MySQL will parse 'NULL' and '' as varchar values.