PROBLEME mit dem H-L Froum
Verfasst: Sonntag 9. November 2014, 13:03
hallo
ich weis nicht wer von euch im H-L forum angemeldet ist
ich bekomme diese komisch meldung immer :
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, board.title as title, board.enableMarkingAsDone as enableMarkingAsDone, thread.time as startTime, thread.* FROM wbb1_1_thread thread LEFT JOIN wbb1_1_post post ON (post.threadID = thread.threadID AND post.userID = 109) LEFT JOIN wbb1_1_thread_visit thread_visit ON (thread_visit.threadID = thread.threadID AND thread_visit.userID = 109) LEFT JOIN wbb1_1_thread_subscription thread_subscription ON (thread_subscription.userID = 109 AND thread_subscription.threadID = thread.threadID)LEFT JOIN wbb1_1_board board ON (board.boardID = thread.boardID) WHERE thread.threadID IN (16686,16683,16400,16674,16684,16685,16470,15286,16679,16664,16681,15203,16680,15081,16678) ORDER BY thread.lastPostTime DESC, thread.time DESC
You get more information about the problem in our knowledge base: http://www.woltlab.com/help/?code=144
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, board.title as title, board.enableMarkingAsDone as enableMarkingAsDone, thread.time as startTime, thread.* FROM wbb1_1_thread thread LEFT JOIN wbb1_1_post post ON (post.threadID = thread.threadID AND post.userID = 109) LEFT JOIN wbb1_1_thread_visit thread_visit ON (thread_visit.threadID = thread.threadID AND thread_visit.userID = 109) LEFT JOIN wbb1_1_thread_subscription thread_subscription ON (thread_subscription.userID = 109 AND thread_subscription.threadID = thread.threadID)LEFT JOIN wbb1_1_board board ON (board.boardID = thread.boardID) WHERE thread.threadID IN (16686,16683,16400,16674,16684,16685,16470,15286,16679,16664,16681,15203,16680,15081,16678) ORDER BY thread.lastPostTime DESC, thread.time DESC
error code: 144
sql type: MySQLDatabase
sql error: Table './db10473604@002dforum/wbb1_1_post' is marked as crashed and last (automatic?) repair failed
sql error number: 144
sql version:
file: /is/htdocs/wp10473604_9SDWV87OKW/www/Forum-alt/wcf/lib/system/database/MySQLDatabase.class.php (118)
php version: 5.3.29
wcf version: 1.1.10 pl 2 (Tempest)
date: Sun, 09 Nov 2014 11:39:22 +0000
request: /index.php?page=Portal
referer:
Stacktrace:
#0 /is/htdocs/wp10473604_9SDWV87OKW/www/Forum-alt/lib/data/thread/ThreadList.class.php(110): MySQLDatabase->sendQuery('SELECT??DISTINC...')
#1 /is/htdocs/wp10473604_9SDWV87OKW/www/Forum-alt/lib/data/boxes/LastThreadsBox.class.php(91): ThreadList->readThreads()
#2 /is/htdocs/wp10473604_9SDWV87OKW/www/Forum-alt/lib/system/portalbox/PortalBoxFactory.class.php(106): LastThreadsBox->readData()
#3 /is/htdocs/wp10473604_9SDWV87OKW/www/Forum-alt/lib/system/portalbox/PortalBoxFactory.class.php(44): PortalBoxFactory->initializeBoxes(false)
#4 /is/htdocs/wp10473604_9SDWV87OKW/www/Forum-alt/lib/page/PortalPage.class.php(120): PortalBoxFactory->__construct(true, false, true, true, true)
#5 /is/htdocs/wp10473604_9SDWV87OKW/www/Forum-alt/lib/page/PortalPage.class.php(105): PortalPage::getPortalBoxes()
#6 /is/htdocs/wp10473604_9SDWV87OKW/www/Forum-alt/wcf/lib/page/AbstractPage.class.php(90): PortalPage->readData()
#7 /is/htdocs/wp10473604_9SDWV87OKW/www/Forum-alt/lib/page/PortalPage.class.php(147): AbstractPage->show()
#8 /is/htdocs/wp10473604_9SDWV87OKW/www/Forum-alt/wcf/lib/page/AbstractPage.class.php(46): PortalPage->show()
#9 /is/htdocs/wp10473604_9SDWV87OKW/www/Forum-alt/wcf/lib/util/RequestHandler.class.php(64): AbstractPage->__construct()
#10 /is/htdocs/wp10473604_9SDWV87OKW/www/Forum-alt/wcf/lib/util/RequestHandler.class.php(92): RequestHandler->__construct('Portal', Array, 'page')
#11 /is/htdocs/wp10473604_9SDWV87OKW/www/Forum-alt/index.php(8): RequestHandler::handle(Array)
#12 {main}
beim googeln kam ich auf die Start Seite und das wars weite kam ich nicht hatte keine rechte da was zu lesen
die letzten ein träge die mir angezeigt werden sind vom 7. Nov
hat einer da auch das problem ?
Gruß Andy
ich weis nicht wer von euch im H-L forum angemeldet ist
ich bekomme diese komisch meldung immer :
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, board.title as title, board.enableMarkingAsDone as enableMarkingAsDone, thread.time as startTime, thread.* FROM wbb1_1_thread thread LEFT JOIN wbb1_1_post post ON (post.threadID = thread.threadID AND post.userID = 109) LEFT JOIN wbb1_1_thread_visit thread_visit ON (thread_visit.threadID = thread.threadID AND thread_visit.userID = 109) LEFT JOIN wbb1_1_thread_subscription thread_subscription ON (thread_subscription.userID = 109 AND thread_subscription.threadID = thread.threadID)LEFT JOIN wbb1_1_board board ON (board.boardID = thread.boardID) WHERE thread.threadID IN (16686,16683,16400,16674,16684,16685,16470,15286,16679,16664,16681,15203,16680,15081,16678) ORDER BY thread.lastPostTime DESC, thread.time DESC
You get more information about the problem in our knowledge base: http://www.woltlab.com/help/?code=144
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, board.title as title, board.enableMarkingAsDone as enableMarkingAsDone, thread.time as startTime, thread.* FROM wbb1_1_thread thread LEFT JOIN wbb1_1_post post ON (post.threadID = thread.threadID AND post.userID = 109) LEFT JOIN wbb1_1_thread_visit thread_visit ON (thread_visit.threadID = thread.threadID AND thread_visit.userID = 109) LEFT JOIN wbb1_1_thread_subscription thread_subscription ON (thread_subscription.userID = 109 AND thread_subscription.threadID = thread.threadID)LEFT JOIN wbb1_1_board board ON (board.boardID = thread.boardID) WHERE thread.threadID IN (16686,16683,16400,16674,16684,16685,16470,15286,16679,16664,16681,15203,16680,15081,16678) ORDER BY thread.lastPostTime DESC, thread.time DESC
error code: 144
sql type: MySQLDatabase
sql error: Table './db10473604@002dforum/wbb1_1_post' is marked as crashed and last (automatic?) repair failed
sql error number: 144
sql version:
file: /is/htdocs/wp10473604_9SDWV87OKW/www/Forum-alt/wcf/lib/system/database/MySQLDatabase.class.php (118)
php version: 5.3.29
wcf version: 1.1.10 pl 2 (Tempest)
date: Sun, 09 Nov 2014 11:39:22 +0000
request: /index.php?page=Portal
referer:
Stacktrace:
#0 /is/htdocs/wp10473604_9SDWV87OKW/www/Forum-alt/lib/data/thread/ThreadList.class.php(110): MySQLDatabase->sendQuery('SELECT??DISTINC...')
#1 /is/htdocs/wp10473604_9SDWV87OKW/www/Forum-alt/lib/data/boxes/LastThreadsBox.class.php(91): ThreadList->readThreads()
#2 /is/htdocs/wp10473604_9SDWV87OKW/www/Forum-alt/lib/system/portalbox/PortalBoxFactory.class.php(106): LastThreadsBox->readData()
#3 /is/htdocs/wp10473604_9SDWV87OKW/www/Forum-alt/lib/system/portalbox/PortalBoxFactory.class.php(44): PortalBoxFactory->initializeBoxes(false)
#4 /is/htdocs/wp10473604_9SDWV87OKW/www/Forum-alt/lib/page/PortalPage.class.php(120): PortalBoxFactory->__construct(true, false, true, true, true)
#5 /is/htdocs/wp10473604_9SDWV87OKW/www/Forum-alt/lib/page/PortalPage.class.php(105): PortalPage::getPortalBoxes()
#6 /is/htdocs/wp10473604_9SDWV87OKW/www/Forum-alt/wcf/lib/page/AbstractPage.class.php(90): PortalPage->readData()
#7 /is/htdocs/wp10473604_9SDWV87OKW/www/Forum-alt/lib/page/PortalPage.class.php(147): AbstractPage->show()
#8 /is/htdocs/wp10473604_9SDWV87OKW/www/Forum-alt/wcf/lib/page/AbstractPage.class.php(46): PortalPage->show()
#9 /is/htdocs/wp10473604_9SDWV87OKW/www/Forum-alt/wcf/lib/util/RequestHandler.class.php(64): AbstractPage->__construct()
#10 /is/htdocs/wp10473604_9SDWV87OKW/www/Forum-alt/wcf/lib/util/RequestHandler.class.php(92): RequestHandler->__construct('Portal', Array, 'page')
#11 /is/htdocs/wp10473604_9SDWV87OKW/www/Forum-alt/index.php(8): RequestHandler::handle(Array)
#12 {main}
beim googeln kam ich auf die Start Seite und das wars weite kam ich nicht hatte keine rechte da was zu lesen
die letzten ein träge die mir angezeigt werden sind vom 7. Nov
hat einer da auch das problem ?
Gruß Andy