Results 1 to 3 of 3

Thread: Error when signing up as user.

  1. #1
    Join Date
    Nov 2007
    Posts
    18

    Default 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

  2. #2
    Join Date
    Apr 2007
    Posts
    2,202

    Default Re: Error when signing up as user.

    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.

  3. #3
    Join Date
    Nov 2007
    Posts
    18

    Default Re: Error when signing up as user.

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

Similar Threads

  1. Uplaoding vidoes without signing up
    By james739 in forum Template Modifications
    Replies: 5
    Last Post: 05-16-2008, 05:54 AM
  2. Can I let people comment and rate videos without signing up?
    By tnuriel in forum General Discussions
    Replies: 1
    Last Post: 09-16-2007, 07:10 PM
  3. when I try to register premium user, I get this error, help
    By joako30 in forum General Discussions
    Replies: 2
    Last Post: 08-25-2007, 02:00 PM
  4. SQL error when signing up to package
    By leki in forum Fixed Bugs
    Replies: 2
    Last Post: 08-11-2007, 11:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •