threads
Page 1 of 1
General Discussion \  Cant delete my avatar

Cant delete my avatar

General Discussion
views 771
replies 5
following 4
 
watt   +1y
When I try to delete my avatar it just says there is and error and this nonsense comes up...

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 'WHERE user_id = 907' at line 3

UPDATE phpbb_users SET user_email = ', user_icq = '', user_website = '', user_occ = '', user_from = '', user_interests = '', user_sig = '[][/]', user_sig_bbcode_uid = 'd8e894a8dd', user_viewemail = 0, user_aim = '', user_yim = '', user_msnm = '', user_attachsig = 1, user_allowsmile = 1, user_allowhtml = 1, user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_notify_pm = 1, user_popup_pm = 0, user_timezone = -2, user_dateformat = 'D M d, Y g:i a', user_lang = 'english', user_style = 2, user_active = 1, user_actkey = '', user_avatar = '', user_avatar_type = 0, user_allowavatar = WHERE user_id = 907

Line : 590
File : usercp_register.php
thetornado   +1y
that looks scary! haha
im guessing it has something to do with the picture your trying to upload. make sure the pic is under all the right requirements.
i keep getting emails to approve your avatar, but when i log in to do it theres no new picture. so you must be using an invalid file format or size.
let me know if you need help with that.
phatkix   +1y
i cant change my pic either ive tried numerous times...
thetornado   +1y
are you getting the same debug error?
baha   +1y
Hey Watt I deleted your avatar through the admin panel, the only thing I can think of right now is the sytax error is coming up since there is no image in the database for it to remove but it still shows there is something to read. You should be able to upload one now.

As soon as May is done I'll have alot more time to fix these errors
watt   +1y
Thanks man. I dont want to upload one I just wanted to delete it. I made a signature instead
Page 1 of 1