SQL error with Welcome PM plugin!

[CallMeSir]

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."

[nixer55]

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.

[CallMeSir]

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')

[dragonexpert]

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.

[phorumws]

What do you mean exactly, just remove that whole line of code? I'm having same problem

[Crazycat]

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.