Diese Fehlermeldung kommt dann:
Fatal error: Invalid SQL: ( SELECT messageTable.postID AS messageID, 'post' AS messageType , messageTable.time AS time , 0 AS relevance FROM wbb1_1_post messageTable , wbb1_1_thread thread WHERE ((messageTable.userID IN (318)) AND (thread.threadID = messageTable.threadID AND thread.boardID IN (1,2,3,4,5,7,56,55,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,54,47,48,49,50,51,52,53,57,58,61) AND messageTable.isDeleted = 0 AND messageTable.isDisabled = 0)) GROUP BY messageID) UNION ( SELECT messageTable.pmID AS messageID, 'pm' AS messageType , messageTable.time AS time , 0 AS relevance FROM wcf1_pm messageTable WHERE ((messageTable.userID IN (318)) AND ((userID = 318 AND (saveInOutbox = 1 OR isDraft = 1)) OR pmID IN (SELECT pmID FROM wcf1_pm_to_user WHERE recipientID = 318 AND isDeleted < 2))) GROUP BY messageID) UNION ( SELECT messageTable.entryID AS messageID, 'userBlogEntry' AS messageType , messageTable.time AS time , 0 AS relevance FROM wcf1_user_blog messageTable WHERE ((messageTable.userID IN (318))) GROUP BY messageID) UNION ( SELECT messageTable.eventID AS messageID, 'event' AS messageType , messageTable.time AS time , 0 AS relevance FROM wcf1_calendar_event_message messageTable , wcf1_calendar_event calendar_event LEFT JOIN wcf1_calendar_event_date calendar_event_date ON (calendar_event_date.eventID = calendar_event.eventID) WHERE ((calendar_event.userID IN (318)) AND (calendar_event.messageID = messageTable.messageID) AND (calendar_event.calendarID IN (2,3,4,5)) OR ( (calendar_event.userID IN (318)) AND (calendar_event.messageID = messageTable.messageID) AND (calendar_event.calendarID IN (2,3,4,5)) AND ( startTime >= -2145916800 AND startTime < 1313452799 OR ( startTime < -2145916800 AND repeatTime > 0 AND ( repeatEndTime > -2145916800 OR repeatEndTime = 0 ) AND CEIL((-2145916800 - startTime) / repeatTime) <= FLOOR((1313452799 - startTime) / repeatTime) ) ) )) GROUP BY messageID) UNION ( SELECT messageTable.itemID AS messageID, 'lexicon' AS messageType , messageTable.time AS time , 0 AS relevance FROM wcf1_lexicon_item messageTable LEFT JOIN wcf1_lexicon AS `lexicon` ON (lexicon.lexiconID = messageTable.lexiconID) WHERE ((messageTable.author IN (318)) AND (messageTable.active='1' AND lexicon.languageID IN (0,2,3) )) GROUP BY messageID) UNION ( SELECT messageTable.photoID AS messageID, 'userGalleryPhoto' AS messageType , messageTable.uploadTime AS time , 0 AS relevance FROM wcf1_user_gallery messageTable WHERE ((messageTable.ownerID IN (318))) GROUP BY messageID) UNION ( SELECT messageTable.linkID AS messageID, 'linkListLink' AS messageType , messageTable.time AS time , 0 AS relevance FROM wcf1_linkList_link messageTable WHERE ((messageTable.userID IN (318)) AND Array) GROUP BY messageID) ORDER BY time DESC LIMIT 1000
You get more information about the problem in our knowledge base: WoltLab® - Support - Documentations
Information:
error message: Invalid SQL: ( SELECT messageTable.postID AS messageID, 'post' AS messageType , messageTable.time AS time , 0 AS relevance FROM wbb1_1_post messageTable , wbb1_1_thread thread WHERE ((messageTable.userID IN (318)) AND (thread.threadID = messageTable.threadID AND thread.boardID IN (1,2,3,4,5,7,56,55,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,54,47,48,49,50,51,52,53,57,58,61) AND messageTable.isDeleted = 0 AND messageTable.isDisabled = 0)) GROUP BY messageID) UNION ( SELECT messageTable.pmID AS messageID, 'pm' AS messageType , messageTable.time AS time , 0 AS relevance FROM wcf1_pm messageTable WHERE ((messageTable.userID IN (318)) AND ((userID = 318 AND (saveInOutbox = 1 OR isDraft = 1)) OR pmID IN (SELECT pmID FROM wcf1_pm_to_user WHERE recipientID = 318 AND isDeleted < 2))) GROUP BY messageID) UNION ( SELECT messageTable.entryID AS messageID, 'userBlogEntry' AS messageType , messageTable.time AS time , 0 AS relevance FROM wcf1_user_blog messageTable WHERE ((messageTable.userID IN (318))) GROUP BY messageID) UNION ( SELECT messageTable.eventID AS messageID, 'event' AS messageType , messageTable.time AS time , 0 AS relevance FROM wcf1_calendar_event_message messageTable , wcf1_calendar_event calendar_event LEFT JOIN wcf1_calendar_event_date calendar_event_date ON (calendar_event_date.eventID = calendar_event.eventID) WHERE ((calendar_event.userID IN (318)) AND (calendar_event.messageID = messageTable.messageID) AND (calendar_event.calendarID IN (2,3,4,5)) OR ( (calendar_event.userID IN (318)) AND (calendar_event.messageID = messageTable.messageID) AND (calendar_event.calendarID IN (2,3,4,5)) AND ( startTime >= -2145916800 AND startTime < 1313452799 OR ( startTime < -2145916800 AND repeatTime > 0 AND ( repeatEndTime > -2145916800 OR repeatEndTime = 0 ) AND CEIL((-2145916800 - startTime) / repeatTime) <= FLOOR((1313452799 - startTime) / repeatTime) ) ) )) GROUP BY messageID) UNION ( SELECT messageTable.itemID AS messageID, 'lexicon' AS messageType , messageTable.time AS time , 0 AS relevance FROM wcf1_lexicon_item messageTable LEFT JOIN wcf1_lexicon AS `lexicon` ON (lexicon.lexiconID = messageTable.lexiconID) WHERE ((messageTable.author IN (318)) AND (messageTable.active='1' AND lexicon.languageID IN (0,2,3) )) GROUP BY messageID) UNION ( SELECT messageTable.photoID AS messageID, 'userGalleryPhoto' AS messageType , messageTable.uploadTime AS time , 0 AS relevance FROM wcf1_user_gallery messageTable WHERE ((messageTable.ownerID IN (318))) GROUP BY messageID) UNION ( SELECT messageTable.linkID AS messageID, 'linkListLink' AS messageType , messageTable.time AS time , 0 AS relevance FROM wcf1_linkList_link messageTable WHERE ((messageTable.userID IN (318)) AND Array) GROUP BY messageID) ORDER BY time DESC LIMIT 1000
error code: 1054
sql type: MySQLDatabase
sql error: Unknown column 'Array' in 'where clause'
sql error number: 1054
sql version:
file: /var/www/vhosts/xj6-forum.de/httpdocs/wcf/lib/system/database/MySQLDatabase.class.php (118)
php version: 5.3.2-1ubuntu4.7
wcf version: 1.1.7 (Tempest)
date: Mon, 15 Aug 2011 20:26:45 +0000
request: /index.php?form=Search
referer: Suche - Yamaha XJ6-N und Diversion Forum
Stacktrace:
#0 /var/www/vhosts/xj6-forum.de/httpdocs/wcf/lib/data/message/search/SearchEngine.class.php(185): MySQLDatabase->sendQuery('(?SELECT??messa...', 1000)
#1 /var/www/vhosts/xj6-forum.de/httpdocs/wcf/lib/form/SearchForm.class.php(258): SearchEngine->search('', Array, Array, 'time DESC')
#2 /var/www/vhosts/xj6-forum.de/httpdocs/wcf/lib/form/AbstractForm.class.php(43): SearchForm->validate()
#3 /var/www/vhosts/xj6-forum.de/httpdocs/wcf/lib/form/SearchForm.class.php(344): AbstractForm->submit()
#4 /var/www/vhosts/xj6-forum.de/httpdocs/wcf/lib/form/AbstractForm.class.php(90): SearchForm->submit()
#5 /var/www/vhosts/xj6-forum.de/httpdocs/wcf/lib/form/CaptchaForm.class.php(104): AbstractForm->readData()
#6 /var/www/vhosts/xj6-forum.de/httpdocs/wcf/lib/form/SearchForm.class.php(355): CaptchaForm->readData()
#7 /var/www/vhosts/xj6-forum.de/httpdocs/wcf/lib/page/AbstractPage.class.php(90): SearchForm->readData()
#8 /var/www/vhosts/xj6-forum.de/httpdocs/wcf/lib/form/SearchForm.class.php(407): AbstractPage->show()
#9 /var/www/vhosts/xj6-forum.de/httpdocs/wcf/lib/page/AbstractPage.class.php(46): SearchForm->show()
#10 /var/www/vhosts/xj6-forum.de/httpdocs/wcf/lib/util/RequestHandler.class.php(64): AbstractPage->__construct()
#11 /var/www/vhosts/xj6-forum.de/httpdocs/wcf/lib/util/RequestHandler.class.php(95): RequestHandler->__construct('Search', Array, 'form')
#12 /var/www/vhosts/xj6-forum.de/httpdocs/index.php(8): RequestHandler::handle(Array)
#13 {main}
Vielleicht kann ja ein Admin mal kucken was da kaputt ist.
Gruß
Bibi