MyBB Community Forums

Hey myBB members,

I have been having a hard time creating a forum and is a pain in the lime because I have been getting errors many times.

Problem: Having many issues installing plugins.

---

What I have done: Changed myBB version, change hosting providers,try different themes, change to another forum software but I keep getting the same error.

---

Plugins that do not work: These plugins were downloaded straight from this website.
WelcomePM (2.0)

MyBB SQL Error
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 mybbpm_settinggroups (`gid`,`name`,`title`,`description`,`disporder`,`isdefault`) VALUES ('NULL','welcomepm','Welcome PM Settings','Settings For Plugin','1','0')
Please contact the MyBB Group for technical support.

EC - Mention User (1.0)

MyBB SQL Error
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 mybbpm_settinggroups (`gid`,`name`,`title`,`description`,`disporder`,`isdefault`) VALUES ('NULL','user_tagging','User Tagging','Settings for User Tagging.','1','no')
Please contact the MyBB Group for technical support.

Hide content from guest (4.0)

MyBB SQL Error
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 mybbpm_settinggroups (`gid`,`name`,`title`,`description`,`disporder`,`isdefault`) VALUES ('NULL','hidecontent','Hide content from guests','Hide your thread content from guests','1','0')
Please contact the MyBB Group for technical support.

MyProfile (1.2)

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

SQL Error:
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'rows FROM mybbpm_settinggroups' at line 1
Query:
SELECT COUNT(*) as rows FROM mybbpm_settinggroups
Please contact the MyBB Group for technical support.

Style Your Nickname (1)

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 mybbpm_settinggroups (`gid`,`name`,`title`,`description`,`disporder`,`isdefault`) VALUES ('','style_your_nick','Style Your Nick','Settings for the Style Your Nick plugin.',666,0)
Please contact the MyBB Group for technical support.

Even tried inserting the query in SQL but gives me

MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1

Thanks!

basically, it would be better to contact your web host
& request to remove strict mode for the database server

workaround : Incorrect integer value ...

other issue related to field rows : see replies here

Smells like your MySQL Server is running in strict mode.
You need to contact your hosting provider for a troubleshoot.

Sometimes this also works if it allows you to run:

SET @@global.sql_mode= '';

Thanks will ask my provider!