Update profile information bug.

[Kherani]

Whenever I try to update my profile, I get the following bug:





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_xfire = '', '', user_google_talk = '', user_attachsig = 1, user_allowsm' at line 2

UPDATE nuke_users SET user_email = 'kherani@mail.com', user_birthday = 00000000, user_birthday2 = NULL, birthday_display = 0, birthday_greeting = 0, user_icq = '', user_myspace = '', user_website = '', user_paypal = '', user_occ = 'Student', user_from = 'Toronto, Ontario, Canada',user_from_flag = 'canada.gif', user_interests = 'Computers and Cars', user_glance_show = '1', user_viewemail = '0', user_aim = '', user_yim = '', user_msnm = 'Khaos_11@hotmail.com', '', user_xfire = '', '', user_google_talk = '', user_attachsig = 1, user_allowsmile = '1', user_showavatars = '1', user_showsignatures = '1', user_allowhtml = '1', user_allowbbcode = '1', user_allow_viewonline = '1', user_notify = '0', user_notify_pm = '1', user_allow_mass_pm = '4', user_popup_pm = '1', user_timezone = '-5', user_time_mode = 6, user_dst_time_lag = 60, user_dateformat = 'D M d, Y g:i a', user_show_quickreply = '1', user_quickreply_mode = '1', user_wordwrap = '70', user_open_quickreply = 1, user_lang = 'english', theme = '', user_active = '1', user_actkey = '', user_gender = '0', name = 'Adam', newsletter = '1', bio = '', user_hide_images = '0' WHERE user_id = '1777'

Line : 984
File : usercp_register.php

 

[Irish]

Yeah, I got it the other day when I tried to update it here at work.

 

[CoZmicShReddeR]

Ok I am sorry I didn't check that after I added a few things... It's all working now! Please varify it and I am also working on a few other errors...

Once again thanks for the heads up!