MyBB Community Forums

Full Version: MySQL: Can't change location/gender/etc
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
My members are getting the following:

Quote:mySQL error: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' fid1='Twilight Town', fid2='' WHERE ufid='40'' at line 1
Query: UPDATE pokejung_userfields SET ufid='40' , fid3='Male', fid4=, fid1='Twilight Town', fid2='' WHERE ufid='40'

That happens every time they try and change their gender/location and stuff. I'm stumped. One member said its because of this:

fid4=

But I'm not sure what would go there. Persumably it's supposted to have a 'value' thing.
Yes. KeyStorm found this problem many months ago and provided a fix. I think its fixed in gold! I'll see if I can find the fix here though.......done

Simple search for fid4= and the bottom thread is the one:
http://www.mybboard.com/community/showth...hp?tid=888
Thanks you! I'm hoping this will solve the problem xD