Not Solved Mysql error in Inline Ads
#1
Not Solved
Hi,
I have had problems on having activated the plugin "Inline Ads". On having wanted to activate it the following mistake error:
Quote:MySQL error: 1366
Incorrect integer value: 'NULL' for column 'gid' at row 1
Query: INSERT INTO mybb_settinggroups (gid, name, title, description, disporder, isdefault) VALUES ('NULL', 'Inline Ads', 'Inline Ads', 'Setup your inline ads for your forums.', '20', 'no')

The server use mysql 5 and php 4. I would like to be able solve it like

Thank you for your support. Big Grin


PD: I´m sorry my bad english Sad
[Image: 8ee07f5c00.gif]
In most online communities, 90% of users are lurkers who never contribute, 9% of users contribute a little, and 1% of users account for almost all the action.
Reply
#2
Not Solved
Moved to Code Mods.

Please be sure and read any and all stickies before posting, the MyBB Group does not provide support for third party scripts.
[Need Smilies? Get Me Smileys!
Reply
#3
Not Solved
Try changing the line in the plugin where it says 'NULL' to just ''.

This is my mod and if you want support you can hit my forums for it (in my sig).
Reply
#4
Not Solved
You need to supply a INT. not a empty string. '' is empty string. 'NULL' is NULL. 0 is a integer. Although, as gid is auto auto_incremented it shouldn't be in the query at all.
Reply
#5
Not Solved
Thank you for your answers Wink, I have eliminated the variable $gid and $sid and the error has disappeared. The plugin works 100 %. Was some function affecting escencial the erased the variable $gid and $sid?

Regards!
[Image: 8ee07f5c00.gif]
In most online communities, 90% of users are lurkers who never contribute, 9% of users contribute a little, and 1% of users account for almost all the action.
Reply
#6
Not Solved
No it should be fine...GID is auto_incremented as Crakter said.
Reply
#7
Not Solved
Ok, thank you Big Grin. It is to say that the variable $gid shouldn't be in the query at all.
[Image: 8ee07f5c00.gif]
In most online communities, 90% of users are lurkers who never contribute, 9% of users contribute a little, and 1% of users account for almost all the action.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)