Results 1 to 3 of 3

Thread: ORDER BY ASC db error

  1. #1
    Join Date
    Apr 2004

    Default ORDER BY ASC db error

    vBa Links v3.0 RC1

    Database error in vBulletin 3.7.2:
    Invalid SQL:
                    SELECT  links.linkid
                    FROM adv_links AS links
                    WHERE links.valid = 1
                        AND catid = 
                    ORDER BY ASC;
    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 'ORDER BY ASC' at line 6
    Error Number  : 1064
    Request Date  : Friday, August 8th 2008 @ 04:57:34 AM
    Error Date    : Friday, August 8th 2008 @ 04:57:34 AM
    Script        :
    Referrer      :

  2. #2
    Join Date
    Jan 2004
    Georgia, USA


    Thank you for pointing this out. Looks like that error can be generated when trying to click the "Next Link" text on a link that's been deleted... Not entirely sure how you would have done that, but you can correct the issue by looking in your forum/includes/vba_links_plugin_sf.php file for this line:
    PHP Code:
    $checkcat $db->query_first("SELECT catid FROM " TABLE_PREFIX "adv_links WHERE linkid = $linkid"); 
    And adding this just below it:
    PHP Code:
                if (empty($checkcat))

  3. #3
    Join Date
    Apr 2004


    Fixed. Thanks... Some how I have users who found it... LOL

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. News Module - Thread Display Order Error
    By Jitsu in forum Bugs From 3.0.0
    Replies: 1
    Last Post: 02-12-2008, 03:49 PM
  2. Unknown column 'links.rating' in 'order clause'
    By Shelby in forum Troubleshooting & Problems
    Replies: 4
    Last Post: 01-09-2007, 06:01 PM
  3. MySQL Error: 1052 : Column 'dateline' in order clause is ambiguous
    By Bailx in forum Troubleshooting & Problems
    Replies: 8
    Last Post: 08-23-2006, 04:55 PM
  4. Fatal Error: Cannot redeclare order
    By Primeval in forum Troubleshooting / "How do I..." Questions
    Replies: 5
    Last Post: 10-10-2005, 10:17 PM
  5. Replies: 3
    Last Post: 08-12-2005, 04:18 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