Results 1 to 3 of 3

Thread: Reciprocal Links - Status Report

  1. #1
    Join Date
    Nov 2006
    Location
    Italy
    Posts
    37

    Default Reciprocal Links - Status Report

    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/mode...e=linkrecipurl
    Referrer : http://www.mydomaindotcom/links/moderate.php
    IP Address : ***.***.***.***
    Username : Adminusername
    Classname : vB_Database
    MySQL Version : 5.0.27
    Last edited by simsnet; 06-01-2008 at 03:40 AM.

  2. #2
    Join Date
    Nov 2006
    Location
    Italy
    Posts
    37

    Default Re: Reciprocal Links - Status Report

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

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

    Default Re: Reciprocal Links - Status Report

    Thank you for pointing this out. If you will look in your links/moderate.php file for this line:
    PHP Code:
    $wherequery .= "linkrecipurl != ''"
    And replace with this:
    [php$wherequery .= " AND linkrecipurl != ''";[/php]
    Then that should take care of the issue.

    Quote Originally Posted by simsnet View Post
    Please move this to the troubleshooting and Problems forums. (Should learn to read the forum description before posting! )
    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.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to remove: user title. on-line status, report post
    By Marvin Hlavac in forum "How Do I..." Questions
    Replies: 8
    Last Post: 09-28-2007, 06:02 PM
  2. Reciprocal links
    By GSPFAN in forum "How Do I..." Questions
    Replies: 1
    Last Post: 12-28-2006, 02:11 PM
  3. Warnings/Errors in Status Report
    By rik123 in forum Troubleshooting & Problems
    Replies: 3
    Last Post: 11-01-2006, 11:19 AM
  4. Reciprocal links and reciprocal link manager
    By rik123 in forum Pre-Sale Questions
    Replies: 4
    Last Post: 10-31-2006, 02:00 PM
  5. reciprocal links
    By GTeam in forum Feedback & Suggestions
    Replies: 2
    Last Post: 03-21-2005, 07:58 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
  •