Error when signing up as user.
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
Re: Error when signing up as user.
Add a default friend in admin area.
Quote:
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.
Re: Error when signing up as user.
Thank you very much! I uploaded the fix and the error is gone. :D