PDA


View Full Version : database error


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

nevir
02-19-2006, 06:03 AM
I contact to SSH provider and a few minutes solve the mysql problem database ;)