stryka
06-24-2009, 01:43 AM
Hi... i am getting the following error msg from my server.... and this usually indicates a temp space or harddrive space issue... but i checked all my drives/partitions and i have plenty of space... its complaining about this query:
SELECT a.title, a.lastpost, a.firstpostid, a.replycount, a.postuserid, a.forumid, a.postusername, b.title as forumname FROM vb_thread as a LEFT JOIN vb_forum as b ON a.forumid = b.forumid WHERE a.forumid != '24' ORDER BY a.threadid DESC LIMIT 7
The error is coming when i do a query to "show latest trheads"... i have 3million posts so maybe its just timing out there? Any suggestions on how i should do the query for "latest threads"
Error writing file '/tmp/MYQCnpT2' (Errcode: 28)
Error Number : 3
Request Date : Tuesday, June 23rd 2009 @ 10:09:51 AM
Error Date : Tuesday, June 23rd 2009 @ 10:10:40 AM
SELECT a.title, a.lastpost, a.firstpostid, a.replycount, a.postuserid, a.forumid, a.postusername, b.title as forumname FROM vb_thread as a LEFT JOIN vb_forum as b ON a.forumid = b.forumid WHERE a.forumid != '24' ORDER BY a.threadid DESC LIMIT 7
The error is coming when i do a query to "show latest trheads"... i have 3million posts so maybe its just timing out there? Any suggestions on how i should do the query for "latest threads"
Error writing file '/tmp/MYQCnpT2' (Errcode: 28)
Error Number : 3
Request Date : Tuesday, June 23rd 2009 @ 10:09:51 AM
Error Date : Tuesday, June 23rd 2009 @ 10:10:40 AM