MyBB Community Forums

Full Version: [HIDE CODE PLUGIN] 1366 - Incorrect integer value: '' for column 'gid' at row 1
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
SQL Error:
1366 - Incorrect integer value: '' for column 'gid' at row 1
Query:
INSERT INTO mybb_settinggroups (`gid`,`name`,`title`,`description`,`disporder`,`isdefault`) VALUES ('','hidecodes','Hide Codes','Hides Code BBcodes From Guests','88','0')

Plugin
https://community.mybb.com/mods.php?action=view&pid=313
and
https://community.mybb.com/mods.php?action=view&pid=616

what should i change?
thank you Blush
(2018-11-11, 08:31 AM)call911 Wrote: [ -> ]
SQL Error:
1366 - Incorrect integer value: '' for column 'gid' at row 1
Query:
INSERT INTO mybb_settinggroups (`gid`,`name`,`title`,`description`,`disporder`,`isdefault`) VALUES ('','hidecodes','Hide Codes','Hides Code BBcodes From Guests','88','0')

Plugin
https://community.mybb.com/mods.php?action=view&pid=313
and
https://community.mybb.com/mods.php?action=view&pid=616

what should i change?
thank you  Blush

I just installed BOTH  and I did NOT  get any errors like you did.


https://community.mybb.com/mods.php?action=view&pid=616 
installs, works to Hides "php" And "code" BBcode From Guest

https://community.mybb.com/mods.php?action=view&pid=313
installs and works*, but,  the first post on subsequent pages still SHOWS if you select option in settings ( hide replies only )
what is your mybb version sir?
mine 1.8.19
(2018-11-11, 02:57 PM)call911 Wrote: [ -> ]what is your mybb version sir?
mine 1.8.19

MyBB version 1.8.19
i have no idea with this Sad
some one help me pls
You list 2 plugins

1: DEACTIVATE both
2: Uninstall BOTH plugins
3: in MAINTENANCE clear the plugin cache.

Install ONE* of the plugin, then ACTIVATE and see if it goes ALL WELL
( to see if you can find which one of the plugin caused that error)

*process of elimination
i was try it sir, but still error Sad both of them
up
help me
see replies here
Quote:you may have to modify code in plugins to replace referred '' value with '0' for gid
(2018-11-14, 02:01 PM).m. Wrote: [ -> ]see replies here
Quote:you may have to modify code in plugins to replace referred '' value with '0' for gid

thank you .m.
you safe my life (again) Heart

for plugin Hide Codes -> https://community.mybb.com/mods.php?action=view&pid=616

fixed with this method

find
"gid" => "",
$setting[] = array("sid" => "",
$setting[] = array('sid'=> "",

and change to
"gid" => "0",
$setting[] = array("sid" => "0",
$setting[] = array('sid'=> "0",