1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
|
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 (ratings>0 AND ratings>=10,rating/ratings,0) AS ratingResult, thread.* FROM wbb2_1_thread thread LEFT JOIN wbb2_1_post post ON (post.threadID = thread.threadID AND post.userID = 19) LEFT JOIN wbb2_1_thread_visit thread_visit ON (thread_visit.threadID = thread.threadID AND thread_visit.userID = 19) LEFT JOIN wbb2_1_thread_subscription thread_subscription ON (thread_subscription.userID = 19 AND thread_subscription.threadID = thread.threadID) WHERE thread.threadID IN (12324,7670,10443,12164,8599,8111,12322,7021,8852,12313,12312,12309,12305,8334,10818,12221,10686,4966,10685,10781,4879,9482,10839,10332,9569,11974,12008,12213,10687,4331) ORDER BY isAnnouncement DESC, isSticky DESC, lastPostTime DESC
You get more information about the problem in our knowledge base: [URL]http://www.woltlab.com/help/?code=1[/URL]
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 (ratings>0 AND ratings>=10,rating/ratings,0) AS ratingResult, thread.* FROM wbb2_1_thread thread LEFT JOIN wbb2_1_post post ON (post.threadID = thread.threadID AND post.userID = 19) LEFT JOIN wbb2_1_thread_visit thread_visit ON (thread_visit.threadID = thread.threadID AND thread_visit.userID = 19) LEFT JOIN wbb2_1_thread_subscription thread_subscription ON (thread_subscription.userID = 19 AND thread_subscription.threadID = thread.threadID) WHERE thread.threadID IN (12324,7670,10443,12164,8599,8111,12322,7021,8852,12313,12312,12309,12305,8334,10818,12221,10686,4966,10685,10781,4879,9482,10839,10332,9569,11974,12008,12213,10687,4331) ORDER BY isAnnouncement DESC, isSticky DESC, lastPostTime DESC
error code: 1
sql type: MySQLDatabase
sql error: Can't create/write to file '/tmp/#sql_4fac_1.MYD' (Errcode: 17)
sql error number: 1
sql version:
file: /var/www/vhosts/ra-forum.com/httpdocs/wcf/lib/system/database/MySQLDatabase.class.php (116)
php version: 5.2.4-2ubuntu5.10
wcf version: 1.0.11 pl 3 (Horizon)
date: Sat, 12 Jun 2010 13:07:06 +0000
request: /index.php?page=Board&boardID=46&s=41713f2ba5ef1d17db6c5d8811f7d6e063ba7ec9
referer: [URL]http://www.ra-forum.com/[/URL]
Stacktrace:
#0 /var/www/vhosts/ra-forum.com/httpdocs/lib/data/thread/ThreadList.class.php(107): MySQLDatabase->sendQuery('SELECT??DISTINC...')
#1 /var/www/vhosts/ra-forum.com/httpdocs/lib/data/thread/BoardThreadList.class.php(138): ThreadList->readThreads()
#2 /var/www/vhosts/ra-forum.com/httpdocs/lib/page/BoardPage.class.php(127): BoardThreadList->readThreads()
#3 /var/www/vhosts/ra-forum.com/httpdocs/wcf/lib/page/AbstractPage.class.php(74): BoardPage->readData()
#4 /var/www/vhosts/ra-forum.com/httpdocs/wcf/lib/page/AbstractPage.class.php(36): AbstractPage->show()
#5 /var/www/vhosts/ra-forum.com/httpdocs/wcf/lib/util/RequestHandler.class.php(63): AbstractPage->__construct()
#6 /var/www/vhosts/ra-forum.com/httpdocs/wcf/lib/util/RequestHandler.class.php(91): RequestHandler->__construct('Board', Array, 'page')
#7 /var/www/vhosts/ra-forum.com/httpdocs/index.php(8): RequestHandler::handle(Array)
#8 {main} |
