HELP! Can't update user's settings in the Admin Panel anymore!!

[KuraFire]

Okay, I added a new profile field to my board (called Aravillian Status) which was only editable in the Admin Panel, and wouldn't show up on Profile pages either. Now, as I wanted to input the field for one of my users it suddenly gave me the error that is cut&pasted in the attached file.

I tried several times, in several ways. Nothing worked. Then I tried it on my own account (userid=1) and that worked! Then I tried on another account of mine (I have three on my board, don't ask, it's necessary) and there it worked too! Then I made a new user (non-Admin), and tried to add it there but then I got the error again!

So it seems to me that it only works on Admins, not on non-Admins. Does anyone have ANY idea why this is??

My board is pretty hacked which is why I'm not requesting this on the regular vBulletin forum, it seems this is because of a hack (look at the attached error file) somehow. I just can't figure it out, though!

Thanks in advance. :)

[Lesane]

Invalid SQL: UPDATE user SET away=0,awaydate=,returndate='0000-00-00'

mysql error: You have an error in your SQL syntax near 'returndate='0000-00-00'

You c that "awaydate" is empty? So it try's to update the user with awaydate as empty.. that dont works. This is the "Away Hack". Maybe there is a solution for this in the thread.

[bira]

the fix is at post #62 of the Away hack thread

https://vborg.vbsupport.ru/showthread.php?postid=206284#post206284

:)

[KuraFire]

Thanks you guys! :) https://vborg.vbsupport.ru/external/2011/01/19.gif

Bira tell the admins here to change :up: into a smilie that shows the thumbs up icon. Soooo much easier than cutting&pasting the icon's URL into a post and adding [img] tags! *sob*

[Admin]

:up: :down:

[Lesane]

:up:

[KuraFire]

[QUOTE]Originally posted by FireFly
:up: :down: