Fatal error: Invalid SQL: SELECT DISTINCT post.userID AS ownPosts,thread_visit.lastVisitTime,IF(thread_subscription.userID IS NOT NULL, 1, 0) AS subscribed,if (thread.ratings>0 AND thread.ratings>=1,thread.rating/thread.ratings,0) AS ratingResult, thread.* FROM wbb1_1_thread thread LEFT JOIN wbb1_1_post post ON (post.threadID = thread.threadID AND post.userID = 591) LEFT JOIN wbb1_1_thread_visit thread_visit ON (thread_visit.threadID = thread.threadID AND thread_visit.userID = 591) LEFT JOIN wbb1_1_thread_subscription thread_subscription ON (thread_subscription.userID = 591 AND thread_subscription.threadID = thread.threadID) WHERE thread.threadID IN (41468,49594,45688,50155,50168,50163,45910,50014,50165,42876,50092,50161,23482,50157,42880,50153,50000,50152,50115,50150) ORDER BY thread.isAnnouncement DESC, thread.isSticky DESC, thread.lastPostTime DESC
You get more information about the problem in our knowledge base:
http://www.woltlab.com/help/?code=1
Information:
error message: Invalid SQL: SELECT DISTINCT post.userID AS ownPosts,thread_visit.lastVisitTime,IF(thread_subscription.userID IS NOT NULL, 1, 0) AS subscribed,if (thread.ratings>0 AND thread.ratings>=1,thread.rating/thread.ratings,0) AS ratingResult, thread.* FROM wbb1_1_thread thread LEFT JOIN wbb1_1_post post ON (post.threadID = thread.threadID AND post.userID = 591) LEFT JOIN wbb1_1_thread_visit thread_visit ON (thread_visit.threadID = thread.threadID AND thread_visit.userID = 591) LEFT JOIN wbb1_1_thread_subscription thread_subscription ON (thread_subscription.userID = 591 AND thread_subscription.threadID = thread.threadID) WHERE thread.threadID IN (41468,49594,45688,50155,50168,50163,45910,50014,50165,42876,50092,50161,23482,50157,42880,50153,50000,50152,50115,50150) ORDER BY thread.isAnnouncement DESC, thread.isSticky DESC, thread.lastPostTime DESC
error code: 1
sql type: MySQLDatabase
sql error: Can't create/write to file '/tmp/#sql_3f83_0.MYD' (Errcode: 17)
sql error number: 1
sql version:
file: /opt/lampp/htdocs/mastersforum.de/public_html/wcf/lib/system/database/MySQLDatabase.class.php (118)
php version: 5.3.8
wcf version: 1.1.9 (Tempest)
date: Thu, 17 Oct 2013 16:01:07 +0000
request: /index.php?page=Board&boardID=5
referer:
Stacktrace:
#0 /opt/lampp/htdocs/mastersforum.de/public_html/lib/data/thread/ThreadList.class.php(110): MySQLDatabase->sendQuery('SELECT??DISTINC...')
#1 /opt/lampp/htdocs/mastersforum.de/public_html/lib/data/thread/BoardThreadList.class.php(153): ThreadList->readThreads()
#2 /opt/lampp/htdocs/mastersforum.de/public_html/lib/page/BoardPage.class.php(163): BoardThreadList->readThreads()
#3 /opt/lampp/htdocs/mastersforum.de/public_html/wcf/lib/page/AbstractPage.class.php(90): BoardPage->readData()
#4 /opt/lampp/htdocs/mastersforum.de/public_html/wcf/lib/page/AbstractPage.class.php(46): AbstractPage->show()
#5 /opt/lampp/htdocs/mastersforum.de/public_html/wcf/lib/util/RequestHandler.class.php(64): AbstractPage->__construct()
#6 /opt/lampp/htdocs/mastersforum.de/public_html/wcf/lib/util/RequestHandler.class.php(92): RequestHandler->__construct('Board', Array, 'page')
#7 /opt/lampp/htdocs/mastersforum.de/public_html/index.php(8): RequestHandler::handle(Array)
#8 {main}