Results 1 to 3 of 3

Thread: Links Directory - Database Error When Searching

  1. #1
    Join Date
    Apr 2007
    Posts
    160

    Default Links Directory - Database Error When Searching

    Any idea what this error means?

    ---------------------------------------------------

    Database error in vBulletin 3.7.2:

    Invalid SQL:

    SELECT links.linkid
    FROM adv_links AS links


    WHERE (links.name LIKE '%norvin %' OR keywords LIKE '%norvin %' OR description LIKE '%norvin %' OR posts.pagetext LIKE '%norvin %' AND links.name LIKE '%centre %' OR keywords LIKE '%centre %' OR description LIKE '%centre %' OR posts.pagetext LIKE '%centre %') AND valid = 1
    LIMIT 500;

    MySQL Error : Unknown column 'posts.pagetext' in 'where clause'
    Error Number : 1054
    Request Date : Monday, August 25th 2008 @ 08:02:19 AM
    Error Date : Monday, August 25th 2008 @ 08:02:19 AM
    Script : http://www.vincentownersclub.co.uk/links/search.php
    Referrer : http://www.vincentownersclub.co.uk/links/search.php
    IP Address : 89.243.157.85
    Username : Unregistered
    Classname : vB_Database
    MySQL Version :

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

    Default

    Thank you for pointing this out. Looks like there was an issue with the post table not being joined if you do not have vB's fulltext search options enabled. I've just applied the fix to the links/search.php file in the download package here, so if you will download the files again and update that one on your server, that should take care of the issue.
    Or if you would rather apply the fix manually, just look in the file for this code:
    PHP Code:
                            case 'pagetext':
                                
    $fieldname 'posts.pagetext';
                            break; 
    And replace with this:
    PHP Code:
                            case 'pagetext':
                                
    $fieldname 'posts.pagetext';
                                
    $searchjoin .= ' LEFT JOIN ' TABLE_PREFIX 'adv_links_posts AS posts ON (posts.linkid = links.linkid)';
                            break; 

  3. #3
    Join Date
    Apr 2007
    Posts
    160

    Default

    Hi Brian

    I replaced the code, and will let you know if I get a repeat of the message.

    Best regards.

    Graham

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Added links directly, now get database error.
    By JamesCybert in forum Feedback & Suggestions
    Replies: 2
    Last Post: 09-28-2007, 01:52 PM
  2. vBulletin database error that is links directory related
    By GamingVidz.com in forum Bugs From 2.0.1
    Replies: 3
    Last Post: 03-13-2007, 03:08 PM
  3. Links Directory error
    By OTTIX in forum Modifications
    Replies: 3
    Last Post: 12-05-2006, 10:37 AM
  4. vBadvanced Links Directory vs Andrew's Links and Files Database
    By Lizard King in forum Pre-Sale Questions
    Replies: 4
    Last Post: 11-14-2005, 08:48 PM
  5. Links Directory Error Message?
    By Billy in forum Troubleshooting & Problems
    Replies: 5
    Last Post: 07-31-2005, 10:52 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •