FUDforum: Bug Reports » SQL Error when Updating Profiles

Home » FUDforum Development » Bug Reports » SQL Error when Updating Profiles

Show: Today's Messages :: Polls :: Message Navigator

SQL Error when Updating Profiles [message #4309]

Mon, 22 July 2002 21:27

derekg

Messages: 9
Registered: May 2002

Karma:

Junior Member

With version 2.0 we were having problems updating profiles for members. It was suggested to upgrade to 2.2 and we did so. We are still getting the same error as follows:

query failed: %( UPDATE fud2_users SET name='Derekg, alias='', email='derekg(at)cogeco(dot)ca', display_email='N', notify='Y', notify_method='EMAIL', ignore_admin='N', email_messages='Y', gender='UNSPECIFIED', icq=NULL, aim=NULL, yahoo=NULL, msnm=NULL, jabber=NULL, append_sig='Y', show_sigs='Y', show_avatars='Y', posts_ppg='0', time_zone='America/Montreal', invisible_mode='Y', bday=0000, user_image=NULL, location='', occupation='', interests='', avatar=0, theme=1, avatar_loc=NULL, avatar_approved='NO', sig=NULL, default_view='msg', home_page=NULL, bio=NULL WHERE id=20 )% because %( Duplicate entry '' for key 2 )%

We get the same problem for new and exisiting users (meaning new users since the upgrade and existing ones before the upgrade). Is there something we have done wrong, or a setting we need to check, or is this a bug?

Report message to a moderator

[Message index]

		SQL Error when Updating Profiles By: derekg on Mon, 22 July 2002 21:27
		Re: SQL Error when Updating Profiles By: Ilia on Tue, 23 July 2002 00:35
		Re: SQL Error when Updating Profiles By: derekg on Tue, 23 July 2002 02:40
		Re: SQL Error when Updating Profiles By: Ilia on Tue, 23 July 2002 11:36
		Re: SQL Error when Updating Profiles By: derekg on Tue, 23 July 2002 12:53

Previous Topic:	percent numbers in admin control->forum statistics
Next Topic:	FUDForum Header

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 23:44:41 GMT 2024

Total time taken to generate the page: 0.04014 seconds