Results 1 to 3 of 3

Thread: Database Error When Searching by Username

  1. #1
    Junior Member
    Join Date
    Jun 2006
    Posts
    9

    Default Database Error When Searching by Username

    Hello again, I have this error:

    Code:
    Database error in vBulletin 3.7.4:
    
    Invalid SQL:
    
    			SELECT links.linkid
    			FROM vb_adv_links AS links
    			 LEFT JOIN vb_adv_links_posts AS posts ON (posts.linkid = links.linkid) LEFT JOIN vb_adv_links_posts AS posts ON (posts.linkid = links.linkid)
    			
    			WHERE  (links.userid IN(79) OR posts.userid IN(79)) AND links.valid IN(0, 1, 2)
    		ORDER BY links.name ASC LIMIT 500;
    
    MySQL Error   : Not unique table/alias: 'posts'
    Error Number  : 1066
    Request Date  : Friday, January 2nd 2009 @ 12:38:22 PM
    Error Date    : Friday, January 2nd 2009 @ 12:38:22 PM
    Script        : http://www.gstrail.es/foro/links/search.php
    Referrer      : http://www.gstrail.es/foro/links/search.php
    IP Address    : 212.15.224.103
    Username      : JOUGS
    Classname     : vB_Database
    MySQL Version : 5.0.45
    Thanks

  2. #2
    Administrator Brian's Avatar
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,460

    Default

    Thank you for pointing this out. I've just applied the fix to the links/search.php file, so if you will download the files from here again and update that one on your server, that should take care of the issue.

  3. #3
    Junior Member
    Join Date
    Jun 2006
    Posts
    9

    Default

    Thanks again!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Invalid SQL When Searching By Username
    By penturners in forum Bugs From 3.0.0
    Replies: 4
    Last Post: 10-24-2008, 05:16 PM
  2. Links Directory - Database Error When Searching
    By grahamsmythe in forum Bugs From 3.0 RC1
    Replies: 2
    Last Post: 08-25-2008, 02:26 PM
  3. Error of Keyword searching....V2.0.1
    By nostalgia in forum Bugs From 2.0.1
    Replies: 5
    Last Post: 03-05-2007, 03:58 PM
  4. Error message when searching keywords
    By Jester in forum Troubleshooting & Problems
    Replies: 1
    Last Post: 12-20-2004, 03:48 PM
  5. mysql error when searching advanced
    By teksigns in forum Bugs From 1.0 RC3
    Replies: 7
    Last Post: 11-07-2004, 11:46 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
  •