Log in

View Full Version : Invalid SQL when updating user settings


taheri6
04-27-2008, 03:30 AM
In Arcade, clicked on "Your Settings" ( forums/arcade.php?&act=Arcade&module=settings )

Even leaving all fields at "default" and just clicking submit has the same error.

Got MySQL Error

mySQL query error: UPDATE user SET user_sort='added',user_order='DESC',user_g_pp='0', user_s_pp='5',def_g_cat='1',game_skin='0',arcade_p mactive='' WHERE userid=4

mySQL error: Incorrect integer value: '' for column 'arcade_pmactive' at row 1
mySQL error code:
Date: Saturday 26th 2008f April 2008 09:37:52 PM


Please advise

MrZeropage
04-30-2008, 07:04 PM
which version of ibProArcade are you using ?

taheri6
05-03-2008, 08:50 PM
Hi,

Thanks for your reply, I am using ibProArcade v2.6.6+ with the vbcredits v1.4 add-on on 3.7 gold.

MrZeropage
05-03-2008, 08:54 PM
this error does not appear here on two different sites.

Please re-upload

/admincp/arcade.php
/arcade/modules/mod_settings.php
/arcade/skins/skin_Arcade.php
/arcade/skins/skin_v3Arcade.php

and try again :)