I'm not sure if anyone else has experienced this but this morning out of the clear blue I started getting a mysql error on the following code in myvbindex.php. I've been using myvbindex for about 2 weeks.
----------------------------------------------
SELECT thread.threadid,thread.title,thread.replycount,thr ead.postusername,thread.postuserid,thread.dateline ,thread.views,thread.iconid,thread.votenum,thread. votetotal,post.postid,post.pagetext,post.allowsmil ie,post.showsignature,user.signature FROM thread LEFT JOIN post USING (threadid) LEFT JOIN user ON (user.userid=post.userid)
WHERE thread.forumid=81 AND isnews='Y'
GROUP BY thread.threadid ORDER BY thread.threadid DESC LIMIT 1
so I pasted the query into mysqladmin and ran it and got the following error...
Quote:
Got error 28 from table handler
|
When I removed the GROUP BY clause it ran fine...
I checked the integrity of the data in the thread tables and post table and everything checks out just fine.
Like I said - this just started happening after two weeks of running fine.
ideas?