Strange ERROR when a user trys to update their profile

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
eb kevin
Registered User
Posts: 53
Joined: Fri Aug 24, 2001 6:00 am
Location: las vegas
Contact:

Strange ERROR when a user trys to update their profile

Post by eb kevin » Wed Apr 03, 2002 1:56 am

If anyone knows why it would say this please tell me, I can update my admin profile fine and I don't think everyone is occuring this error.

Code: Select all

Could not update users table 

DEBUG MODE 

SQL Error : 1064 You have an error in your SQL syntax near ' user_allowhtml = 1, user_allowbbcode = 1, user_allow_viewonline = 1, user_notif' at line 2 

UPDATE phpbb_users SET user_email = 'daysie@hotmail.com', user_icq = '', user_website = 'http://nowhere.cyberdillia.com', user_occ = 'student', user_from = 'N to da C baby!', user_interests = 'dancing, having fun, dorking out, you know... the regular stuff... being a daysie bird. uhmm yeah.', user_sig = '[img:d33f91ab20]http://www.hybridnation.net/graphics/daysieban.jpg[/img:d33f91ab20]', user_sig_bbcode_uid = 'd33f91ab20', user_viewemail = 0, user_aim = 'upsydaysie', user_yim = '', user_msnm = 'daysie@hotmail.com', user_attachsig = 0, user_allowsmile = , user_allowhtml = 1, user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_notify_pm = 1, user_popup_pm = 1, user_timezone = -12, user_dateformat = 'd M Y H:i', user_lang = 'english', user_style = 5, user_active = 1, user_actkey = '' WHERE user_id = 240 

Line : 432 
File : /home/grooveco/public_html/boards/includes/usercp_register.php 

eXplosive
Registered User
Posts: 368
Joined: Mon Mar 04, 2002 4:03 am
Contact:

Re: Strange ERROR when a user trys to update their profile

Post by eXplosive » Wed Apr 03, 2002 3:27 am

eb kevin wrote: If anyone knows why it would say this please tell me, I can update my admin profile fine and I don't think everyone is occuring this error.

Could not update users table

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near ' user_allowhtml = 1, user_allowbbcode = 1, user_allow_viewonline = 1, user_notif' at line 2

UPDATE phpbb_users SET user_email = 'daysie@hotmail.com', user_icq = '', user_website = 'http://nowhere.cyberdillia.com', user_occ = 'student', user_from = 'N to da C baby!', user_interests = 'dancing, having fun, dorking out, you know... the regular stuff... being a daysie bird. uhmm yeah.', user_sig = '[img:d33f91ab20]http://www.hybridnation.net/graphics/daysieban.jpg[/img:d33f91ab20]', user_sig_bbcode_uid = 'd33f91ab20', user_viewemail = 0, user_aim = 'upsydaysie', user_yim = '', user_msnm = 'daysie@hotmail.com', user_attachsig = 0, user_allowsmile = , user_allowhtml = 1, user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_notify_pm = 1, user_popup_pm = 1, user_timezone = -12, user_dateformat = 'd M Y H:i', user_lang = 'english', user_style = 5, user_active = 1, user_actkey = '' WHERE user_id = 240

Line : 432
File : /home/grooveco/public_html/boards/includes/usercp_register.php


I dunno but for some reason the SQL screwed up, the error is in red.
Your should post this at the bug tracker with a little more information.

Locked

Return to “2.0.x Support Forum”