Mysql error in Inline Ads

[CR15714N]

Hi,
I have had problems on having activated the plugin "Inline Ads". On having wanted to activate it the following mistake error:

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.


PD: I´m sorry my bad english

[Christian]

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.

[labrocca]

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).

[Martin M.]

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.

[CR15714N]

Thank you for your answers , 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!

[labrocca]

No it should be fine...GID is auto_incremented as Crakter said.

[CR15714N]

Ok, thank you . It is to say that the variable $gid shouldn't be in the query at all.