[Ted S]

Originally Posted by TimberFloorAu

Just checking error logs, we are getting hundreds of error messages:

Such as:

Database error in vBulletin 4.0.1:
 
Invalid SQL:
 
               SELECT post.postid,post.title as posttile,helpfulpost.goodrank,helpfulpost.totalrank,helpfulpost.lastvote,
                       thread.threadid,thread.title as title,thread.postusername as postusername,forum.title as ftitle ,goodrank as avgrank
 
               FROM yobromofhelpfulpost as helpfulpost
               INNER JOIN yobromofpost AS post ON(helpfulpost.postid = post.postid)
               INNER JOIN yobromofthread AS thread ON(post.threadid = thread.threadid)
               INNER JOIN yobromofforum AS forum ON(thread.forumid = forum.forumid)
               WHERE goodrank > 0
 
 
               ORDER BY avgrank desc
               LIMIT 0, 25;
 
MySQL Error   : Column 'goodrank' in field list is ambiguous
Error Number  : 1052
Request Date  : Friday, February 5th 2010 @ 10:04:32 AM
Error Date    : Friday, February 5th 2010 @ 10:04:32 AM
Script        : http://www.yobromofo.com/forum/helpfulanswers.php
Referrer      :
IP Address    : 67.195.112.247
Username      : Unregistered
Classname     : vB_Database
MySQL Version :

Disable this page, I will have this bug resolved this weekend.