Error when signing up as user.

[gary]

Hi

When signing up as a new user the following error message is returned:

"ERROR: Unable to execute query

INSERT INTO `friends` SET `UID`=, `FID`='4', `friends_name`='jimmy', `friends_type`='All|Friends', `invite_date`='2007-12-29', `friends_status`='Confirmed'

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 ' `FID`='4', `friends_name`='jimmy', `friends_type`='All|Friends', `invite_date`=' at line 1"

Even though there is the error message the user is added to the site properly.

Any suggestions on fixing the error?

Thanks

[admin]

Add a default friend in admin area.

Admin > Site Settings > SIGNUP SETTINGS > Default Friend

Or download

http://www.buyscripts.in/vshare/2.6_fix_signup.zip

Unzip and upload signup.php to your server in binary mode.

[gary]

Thank you very much! I uploaded the fix and the error is gone. :D