Results 1 to 4 of 4

Thread: i cant add links and Database error

  1. #1
    Junior Member
    Join Date
    May 2006
    Posts
    6

    Default i cant add links and Database error

    (Sorry, i don't speak english).

    Change server after I can not add new links from the website form, nor I, nor the users. When I send the form with the data takes too long to respond and finally said that the URL is invalid.

    I as an Administrator I can add links from the Admin CP, but not from website form.

    Another mistake is when I use the following tool from Admin CP: "This tool will allow you to update your counters category". I get the following error:

    Database error in vBulletin XXXXX:

    Invalid SQL:

    UPDATE adv_links_categories SET ,
    lastlinkid = '',
    lastlinkdateline = '',
    lastlinktitle = '',
    lastlinkusername = '',
    lastlinkuserid = '' WHERE catid = '1' AND haslinks = 1;

    MySQL Error : 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 '
    lastlinkid = '',
    lastlinkdateline = '',
    lastlinktitle = ''' at line 1
    Error Number : 1064
    Date : Tuesday, April 20th 2010 @ 01:24:53 AM
    Script : http://www.xxxxxxxxxxxxxx
    Referrer : http://www.xxxxxxxxxxxxxx
    IP Address : 91.39.190.234
    Username : xxxxxxx
    Classname : vB_Database
    I repeat that this problem occurs since I changed to a new server, before changing the server worked perfectly.

    My version of vBadvanced Links Directory is v2.0.1
    Last edited by servando; 04-20-2010 at 07:11 PM.

  2. #2
    Administrator Brian's Avatar
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,467

    Default

    v2.0.1 is well over 3 years old now, so I would highly suggest upgrading to v3.2.0.
    Frequently Asked Questions
    CMPS Users Manual

    For vBadvanced software assistance, please use the support forums.
    Unsolicted PMs, IMs, and email will not be responded to.
    If you have a non-software related question or problem with your account, please submit a support ticket.

  3. #3
    Junior Member
    Join Date
    May 2006
    Posts
    6

    Default

    Hi, Brian

    I know it's an older version but I would like to solve this problem first and then upgrade the Links Directory and the forum, which is also old. Before i changed the server five days ago it worked perfectly.


    Please, can you tell me what you think is the cause of this problem to find a solution now?
    Last edited by servando; 04-20-2010 at 03:37 PM.

  4. #4
    Administrator Brian's Avatar
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,467

    Default

    It's hard to say what the error is at this point considering the version you're running is so old. You can check the v2.0.1 bugs forum here to see if anything was posted in there. Or, once you upgrade to 3.2.0, the issue should be solved.
    Frequently Asked Questions
    CMPS Users Manual

    For vBadvanced software assistance, please use the support forums.
    Unsolicted PMs, IMs, and email will not be responded to.
    If you have a non-software related question or problem with your account, please submit a support ticket.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Database Error: Unknown column 'links.rating'
    By Peter Walker in forum Bugs From 3.1.0
    Replies: 2
    Last Post: 03-20-2009, 01:38 PM
  2. Links Directory - Database Error When Searching
    By grahamsmythe in forum Bugs From 3.0 RC1
    Replies: 2
    Last Post: 08-25-2008, 02:26 PM
  3. Added links directly, now get database error.
    By JamesCybert in forum Feedback & Suggestions
    Replies: 2
    Last Post: 09-28-2007, 01:52 PM
  4. vBulletin database error that is links directory related
    By GamingVidz.com in forum Bugs From 2.0.1
    Replies: 3
    Last Post: 03-13-2007, 03:08 PM
  5. vBadvanced Links Directory vs Andrew's Links and Files Database
    By Lizard King in forum Pre-Sale Questions
    Replies: 4
    Last Post: 11-14-2005, 09:48 PM

Posting Permissions

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