[jGas]

sure ted

Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT post.postid,post.title as posttile,helpfulpost.goodrank,helpfulpost.totalran k,helpfulpost.lastvote,
thread.threadid,thread.title as title,thread.postusername as postusername,forum.title as ftitle ,helpfulpost.goodrank as avgrank

FROM vb_helpfulpost as helpfulpost
INNER JOIN vb_post AS post ON(helpfulpost.postid = post.postid)
INNER JOIN vb_thread AS thread ON(post.threadid = thread.threadid)
INNER JOIN vb_forum AS forum ON(thread.forumid = forum.forumid)
WHERE goodrank > 0


ORDER BY avgrank desc
LIMIT 0, 25;

MySQL Error : Column 'goodrank' in where clause is ambiguous
Error Number : 1052
Request Date : Sunday, February 7th 2010 @ 06:53:15 AM
Error Date : Sunday, February 7th 2010 @ 06:53:15 AM
Script : http://www.musicadigitale.net/forum/helpfulanswers.php
Referrer :
IP Address : xxxxxxxxxxxx
Username : Mr Gas
Classname : vB_Database_MySQLi
MySQL Version : 5.0.89-community

thanks to you