Reciprocal Links - Status Report

[simsnet]

Just tried to run the Status Report for reciprocal links in the moderation panel and i get the following sql error.

Database error in vBulletin 3.7.1:

Invalid SQL:

SELECT COUNT(*) AS count, MAX(linkid) AS linkid
FROM adv_links
WHERE 1 = 1 linkrecipurl != '';

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 'linkrecipurl != ''' at line 3
Error Number : 1064
Request Date : Sunday, June 1st 2008 @ 09:31:42 AM
Error Date : Sunday, June 1st 2008 @ 09:31:42 AM
Script : http://www.mydomaindotcom/links/moderate.php?do=checkstatus&repid=20&perpage=25&type=linkrecipurl
Referrer : http://www.mydomaindotcom/links/moderate.php
IP Address : ***.***.***.***
Username : Adminusername
Classname : vB_Database
MySQL Version : 5.0.27

[simsnet]

Please move this to the troubleshooting and Problems forums. (Should learn to read the forum description before posting! :eek:)

[Brian]

Thank you for pointing this out. If you will look in your links/moderate.php file for this line:
$wherequery .= "linkrecipurl != ''";

And replace with this:
[php$wherequery .= " AND linkrecipurl != ''";[/php]
Then that should take care of the issue.

Please move this to the troubleshooting and Problems forums. (Should learn to read the forum description before posting! :eek:)
Actually it looks like I had the forum permissions set wrong, or never changed them when I created the v3.0 bugs forum as it shouldn't be possible to start new threads here. That should be corrected now though. ;)