MyBB has experienced an internal SQL error and cannot continue. 1366 - Incorrect integer value: 'NULL' for column 'gid' at row 1

Posted by Monirul on
If you are facing problem like me on MyBB My Advertisements Plugin :

MyBB has experienced an internal SQL error and cannot continue.  1366 - Incorrect integer value: 'NULL' for column 'gid' at row 1


MyBB SQL 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,49)



Please follow the very simple steps :

First if after getting error you completely remove the plugin files than I request you to download it again My Advertisements latest version from the provided link.

Now download and install plugin.

Go to your public_html folder from your cPanel.

Find : inc/plugins/myadvertisements.php from your mybb installation directory.

Right click or select edit :



Search and find "sid" :

Now change all :
"sid" => NULL, 

to 
"sid" => 0,


to


Now save and exit and go to your mybb plugins and click install and active.

I think you have done it successfully. But if can't don't heisted to knock me.