Avatar Problems, help..

[princess_m]

hey im wondering if anyone can help me with this.. cause whenever i try to change something in User control panel- the profile thingy this comes up and it doesnt change the information or my avatar


Could not update users table

DEBUG MODE

SQL 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 ' user_realname = '' WHERE user_id = 1366' at line 2

UPDATE phpbb_users SET user_email = 'sweet_mario0oniii@hotmail.com', user_icq = '', user_website = '', user_occ = '', user_from = '', user_from_flag = 'blank.gif', user_interests = '', user_popup_notes = 0, user_profile_view_popup = 0, user_birthday = '7376', user_next_birthday_greeting = '2006', user_sig = '', user_sig_bbcode_uid = '', user_viewemail = 0, user_aim = '', user_yim = '', user_msnm = '', user_attachsig = 1, user_allowsmile = 1, user_allowswearywords = 0, user_allowhtml = 0, user_allowbbcode = 1, user_allow_viewonline = 1, user_showavatars = 1, user_showsigs = 1, user_notify = 0, user_notify_pm = 1, user_notify_donation = 1, user_allow_mass_pm = 2, user_popup_pm = 1, user_sound_pm = 1, user_timezone = -4, user_dateformat = 'D M d, Y g:i a', user_clockformat = 'Clock 1', user_lang = 'english', user_style = 1, user_active = user_active, user_actkey = 'user_actkey', user_avatar = '', user_avatar_type = 0, user_gender = '2', user_zipcode = '', avatar_sticky = 0, irc_commands = '', user_allowavatar = , user_realname = '' WHERE user_id = 1366

Line : 715
File : usercp_register.php

What is that?

[JerkFace]

it means your just not meant to be here...click the little red X in the top right corner of your screen..that should fix everything....yw :alright:

[Teffo]

oh lord not this again danny!

[SamIAM™]

Changing avatars is down for the moment thats why. *I'm working on fixing it. *Thanks for the notice :thumbsup:

I'll update here when its fixed.

[princess_m]

thank you SamIAM * :mrgreen:

[SamIAM™]

if you dont select the box that said to delete the avatar , and just click on "browse" it will update your avatar with no error. Its only the delete i believe thats screwy

[SamIAM™]

i think i fixed it

[princess_m]

yep it works now, thanx :)