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
- 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,
"sid" => 0,
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.