MyBB Community Forums

Full Version: (solved)General short advice for Newbie SQL Error on installing the plugin.
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
So I found the answer on how to sort an issue with installing a plugin but I do not know which file/files to put the code in.

I have never done it before and it seems quite easy. Looks like editing bit of code. Could someone send just a general advice on what to do? Which file to look for?

For example one of the solutions below for the same problem looks like editing php file the other like editing mysql.



My problem:

Unable to install a plugin as of the error:


MyBB has experienced an internal SQL error and cannot continue.

SQL Error: 1366 - Incorrect integer value: '' for column 'sid' at row 1 Query: INSERT INTO mybb_settings (sid,name,title,description,optionscode,value,disporder,gid) VALUES ('','myadvertisements_disabled','Advertisements disabled?','Set to yes if you want to disable all advertisements.','yesno',0,1,76)
Please contact the MyBB Group for technical support.



Solution 1:


FInd
PHP Code:
"sid"            => NULL, 




Solution 2:

https://community.mybb.com/post-769848.html

https://mdmonirulislammonir.blogspot.com...error.html

Solution: edit php file of the extension. Smile
For example if the error appears with my advertisement plugin than edit that file plugin php file.

Sorry for taking time. I have been uploading all plugins via Plugin Uploader and it made me lazy. Did not realized in the simplicity of plugin structure.