MyBB Community Forums

Full Version: SQL error with Welcome PM plugin!
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I am attempting to use this plugin but am receiving a SQL error - https://community.mybb.com/mods.php?acti...w&pid=1117

"MyBB has experienced an internal SQL error and cannot continue."
Too generic an error to even guess.  You need to turn on MyBB error reporting:

ACP - configuration - settings - Server and Optimization Options - Error Logging Medium and Error Type Medium.
(2021-02-03, 06:20 PM)nixer55 Wrote: [ -> ]Too generic an error to even guess.  You need to turn on MyBB error reporting:

ACP - configuration - settings - Server and Optimization Options - Error Logging Medium and Error Type Medium.

1366 - Incorrect integer value: 'NULL' for column database name (replaced for privacy).database name.gid at row 1

INSERT INTO dbname_settinggroups (gid,name,title,description,disporder,isdefault) VALUES ('NULL','welcomepm','Welcome PM Settings','Settings For Plugin','1','0')
This happens in some enviornments when trying to assign a null value to a primary key. Just get rid of the part that says "gid" => NULL if they used the $db->insert_query method. If they used the lazy method and did $db->query, just remove where it says gid and NULL.
What do you mean exactly, just remove that whole line of code? I'm having same problem
I guess you use https://community.mybb.com/mods.php?acti...w&pid=1117

Remove the line 27 of the file ('gid' => 'NULL',) and you'll be able to install it.