nevir
02-19-2006, 04:11 AM
Hi guys!! I using the vbulletin 3.0.7 and CMPS vbadvanced 1.0.1 and work fine just a few minutes, when I try to open the cmps page i get this database error
Database error in vBulletin 3.0.7:
Invalid SQL:
SELECT thread.pollid, open, threadid, replycount, forumid, question, poll.dateline, options, votes, active, numberoptions, timeout, multiple, voters, public , pollvoteid
FROM thread AS thread
INNER JOIN poll AS poll USING (pollid)
LEFT JOIN pollvote AS pollvote ON (pollvote.pollid = poll.pollid AND pollvote.userid = 1)
LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE open <> 10 AND thread.pollid != 0 AND visible = 1 AND deletionlog.primaryid IS NULL AND poll.pollid IN(18,18) ORDER BY RAND()
LIMIT 1
mysql error: Can't create/write to file '/tmp/#sql_215f_0.MYI' (Errcode: 13)
mysql error number: 1
the forum index is still working! htpp://www.forosuse.org/forosuse but the portal cmps is down :confused:
Y try to repair the thread, post, forum, and icon tables but not working
help me,plz!!
ps. sorry my english is horrible but I don't speak english
Database error in vBulletin 3.0.7:
Invalid SQL:
SELECT thread.pollid, open, threadid, replycount, forumid, question, poll.dateline, options, votes, active, numberoptions, timeout, multiple, voters, public , pollvoteid
FROM thread AS thread
INNER JOIN poll AS poll USING (pollid)
LEFT JOIN pollvote AS pollvote ON (pollvote.pollid = poll.pollid AND pollvote.userid = 1)
LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
WHERE open <> 10 AND thread.pollid != 0 AND visible = 1 AND deletionlog.primaryid IS NULL AND poll.pollid IN(18,18) ORDER BY RAND()
LIMIT 1
mysql error: Can't create/write to file '/tmp/#sql_215f_0.MYI' (Errcode: 13)
mysql error number: 1
the forum index is still working! htpp://www.forosuse.org/forosuse but the portal cmps is down :confused:
Y try to repair the thread, post, forum, and icon tables but not working
help me,plz!!
ps. sorry my english is horrible but I don't speak english