Not Solved SQL error with Welcome PM plugin!
#1
Not Solved
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."
Reply
#2
Not Solved
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.
Reply
#3
Not Solved
(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')
Reply
#4
Not Solved
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.
Reply
#5
Not Solved
What do you mean exactly, just remove that whole line of code? I'm having same problem
Reply
#6
Not Solved
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.
[MyBB 1.8 mods] - Offer me a coffee
Do not ask me help through PM or Discord
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)