MyBB Community Forums

Full Version: "Store Fake IP's" Plugin SQL Error?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I am getting this error when trying to install & activate this plugin:


http://community.mybb.com/mods.php?action=view&pid=384


SQL Error:1366 - Incorrect integer value: '' for column 'gid' at row 1


Forum link: www.altarrs.com/forum


I am running this website via windows server 2012



Thanks guys! Smile
EDIT: nvm, see post below.

Some questions:
1. Can you install/activate other plugins which use settings?
2. Did you try activating it multiple times and did the error appear each time?
3. Do you run MySQL in strict mode?
1. I have DVZ Shoutbox installed which I believe has a configuration option
2. Yeah I tried around 4-5 times each time returned the same error
3. I am not sure what that means so it is quite possible... I basically just did a default SQL database setup in windows server 2012
Weird. Please check your MySQL version and whether it runs in the strict mode.

Try changing NULL to 'NULL' in this line : https://github.com/Destroy666x/MyBB-Stor...ps.php#L80

EDIT: but that most likely won't work in strict mode either because the column is NOT NULL. If that's the case, remove that line completely and check if that helps (it should work since the column is autoincremented anyways, so no idea why many plugins have that line and why I copypasted it to all my plugins too - I'll remove them in next releases).
EDIT2: and do the same with this line: https://github.com/Destroy666x/MyBB-Stor...ps.php#L96
Was messing around with what you said to do and it looks as if I got it installed. Now there is another issue being that theres is no configuration options:

"No settings were found for the specified search phrase."

EDIT: Looks as if your EDIT2 solved the issue with no configuration - there is now 1 configuration option to set the IP.

Now regarding all current users logged IP addresses... How can I overwrite them with this plugin?
EDIT: nvm, post above edited and I'm sure it's in strict mode.

Anyways, after setting up the IP you can go back to the Plugins page and click the link to change all IPs.
I'm on MySQL 5.1 and have changed it from strict to traditional mode.

I have removed both those lines which allowed me to activate the plugin & have the configuration option available.

The only issue left now is that my current registered users IP addresses still show.

EDIT: To clarify I'm referring to the "Registration IP"
All non-plugin (and plugin if $mybb->binary_fields is modified) IPs should be spoofed after clicking that link as long as you're using MyBB 1.8 (otherwise an error should be thrown). You can PM me an admin account to check if the process goes well.
PM'ed.