Jump to the post that solved this thread.
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Solved: 2 Months ago myBB Plugins Not Working
#1
Solved: 2 Months ago Exclamation 
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!
Reply
#2
Solved: 2 Months ago
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
Reply
#3
Solved: 2 Months ago
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= '';
[Image: logo.svg.svg]
Reply
#4
Solved: 2 Months ago
Thanks will ask my provider!
Reply
Jump to the post that solved this thread.


Forum Jump:


Users browsing this thread: 1 Guest(s)