Results 1 to 3 of 3

Thread: SQL Errors

  1. #1
    Join Date
    Aug 2005

    Default SQL Errors

    I installed 2.0 RC and received tons of SQL errors in fact it did not migrate over my old data. I restored the data and not I'm reciving SQL errors. HELP!

    Database error in vBulletin 3.6.4:

    Invalid SQL:

    SELECT links.linkid
    FROM links AS links

    WHERE suspended = 0 AND valid = 1
    ORDER BY dateline DESC, linkid DESC
    LIMIT 1,3,7,14,30,60;

    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
    '7,14,30,60' at line 6
    Error Number : 1064
    Date : Monday, November 27th 2006 @ 06:32:50 AM
    Script :
    Referrer :
    IP Address :
    Username : Unregistered
    Classname : vb_database

  2. #2
    Join Date
    Jan 2004
    Georgia, USA

    Default Re: SQL Errors

    You would need to also restore your adv_setting table if you're trying to downgrade.

    Also, what were the SQL errors you receiving after the upgrade? Were you getting them from the upgrade script, or the normal links directory files?

  3. #3
    Join Date
    Aug 2005

    Default Re: SQL Errors

    It seeming not to remove the none adv_* links tables. I noticed this when all my 900+ links were gone, however still in the DB. If I restore the adv_setting table now will it upset anything none links related? I mean I've been working on this since Friday and fear full of screwing up again.

    I think I may have and I'm only admiting this because I'm honest selected install instead of upgrade, but I'm not sure anymore.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. A few Errors... Need a little help please
    By web-rocket in forum Troubleshooting & Problems
    Replies: 1
    Last Post: 06-01-2006, 04:04 PM
  2. Errors!
    By mike12345 in forum Troubleshooting & Problems
    Replies: 2
    Last Post: 05-07-2006, 02:26 AM
  3. I can't fix these errors! Please help.
    By konabiker47 in forum Troubleshooting & Problems
    Replies: 1
    Last Post: 01-17-2006, 05:08 PM
  4. Array errors and SQL errors
    By Richard-HH in forum Troubleshooting / "How do I..." Questions
    Replies: 4
    Last Post: 11-14-2004, 01:49 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