ORDER BY links.name ASC db error

[diettalk]

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 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      :

[Brian]

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');
            } 


[diettalk]

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