Results 1 to 3 of 3

Thread: ORDER BY links.name ASC db error

  1. #1
    Join Date
    Apr 2004
    Posts
    18

    Default ORDER BY links.name ASC db error

    vBa Links v3.0 RC1


    Code:
    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 links.name 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 links.name 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        : http://www.www.com/links/showlink.php?do=showdetails&l=94&goto=next&catid=
    Referrer      :

  2. #2
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,466

    Default

    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))
                {
                    
    define('SF_ERROR''nolinkid');
                } 

  3. #3
    Join Date
    Apr 2004
    Posts
    18

    Default

    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, 04:49 PM
  2. Unknown column 'links.rating' in 'order clause'
    By Shelby in forum Troubleshooting & Problems
    Replies: 4
    Last Post: 01-09-2007, 07: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, 05:55 PM
  4. Fatal Error: Cannot redeclare order
    By Primeval in forum Troubleshooting / "How do I..." Questions
    Replies: 5
    Last Post: 10-10-2005, 11:17 PM
  5. Replies: 3
    Last Post: 08-12-2005, 05: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
  •