[Saviour]

Originally Posted by Ted S

Please use this file which will print out the query on both pages and then revert to the stable version.

Let me know the queries and I should be able to figure out why this is happening on your site.

Uploaded that file...overwriting the current file. Using 1.9.5 of your mod and got the following error on the first page:

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 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, 10

This was printed on the second page:

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 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 10, 10

Reverting to my previous file...

Should I update to 2.0? Has it been fixed?