Wenn ich Beiträge meines Nick suche kommt diese Fehlermeldung:
ZitatAlles anzeigenFatal 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 (466)) AND (thread.threadID = messageTable.threadID AND thread.boardID IN (2,132,188,40,24,41,46,44,45,200,201,20,47,173,182,43,59,21,23,26,183,30,42,60,58,190,191,11,14,12,5,6,53,31,54,7,55,8,56,52,57,67,68,64,10,48,177,192,178,15,16,174,17,50,18,112,49,76,111,34,75,19,35,36,37,38,39,61,62,63,205,206,207,208,209) 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 (466)) AND ((userID = 466 AND (saveInOutbox = 1 OR isDraft = 1)) OR pmID IN (SELECT pmID FROM wcf1_pm_to_user WHERE recipientID = 466 AND isDeleted < 2))) 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 (466)) AND Array) 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 (466))) 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 (466)) AND (thread.threadID = messageTable.threadID AND thread.boardID IN (2,132,188,40,24,41,46,44,45,200,201,20,47,173,182,43,59,21,23,26,183,30,42,60,58,190,191,11,14,12,5,6,53,31,54,7,55,8,56,52,57,67,68,64,10,48,177,192,178,15,16,174,17,50,18,112,49,76,111,34,75,19,35,36,37,38,39,61,62,63,205,206,207,208,209) 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 (466)) AND ((userID = 466 AND (saveInOutbox = 1 OR isDraft = 1)) OR pmID IN (SELECT pmID FROM wcf1_pm_to_user WHERE recipientID = 466 AND isDeleted < 2))) 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 (466)) AND Array) 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 (466))) 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/web9/html/entwicklung/wcf/lib/system/database/MySQLDatabase.class.php (118)
php version: 5.2.6-1+lenny10
wcf version: 1.1.7 (Tempest)
date: Sun, 07 Aug 2011 10:17:24 +0000
request: /index.php?form=Search
referer: Suche - Jackys Grafikschuppen
Stacktrace:#0 /var/www/web9/html/entwicklung/wcf/lib/data/message/search/SearchEngine.class.php(185): MySQLDatabase->sendQuery('(?SELECT??messa...', 1000)
#1 /var/www/web9/html/entwicklung/wcf/lib/form/SearchForm.class.php(258): SearchEngine->search('', Array, Array, 'time DESC')
#2 /var/www/web9/html/entwicklung/wcf/lib/form/AbstractForm.class.php(43): SearchForm->validate()
#3 /var/www/web9/html/entwicklung/wcf/lib/form/SearchForm.class.php(344): AbstractForm->submit()
#4 /var/www/web9/html/entwicklung/wcf/lib/form/AbstractForm.class.php(90): SearchForm->submit()
#5 /var/www/web9/html/entwicklung/wcf/lib/form/CaptchaForm.class.php(104): AbstractForm->readData()
#6 /var/www/web9/html/entwicklung/wcf/lib/form/SearchForm.class.php(355): CaptchaForm->readData()
#7 /var/www/web9/html/entwicklung/wcf/lib/page/AbstractPage.class.php(90): SearchForm->readData()
#8 /var/www/web9/html/entwicklung/wcf/lib/form/SearchForm.class.php(407): AbstractPage->show()
#9 /var/www/web9/html/entwicklung/wcf/lib/page/AbstractPage.class.php(46): SearchForm->show()
#10 /var/www/web9/html/entwicklung/wcf/lib/util/RequestHandler.class.php(64): AbstractPage->__construct()
#11 /var/www/web9/html/entwicklung/wcf/lib/util/RequestHandler.class.php(95): RequestHandler->__construct('Search', Array, 'form')
#12 /var/www/web9/html/entwicklung/index.php(8): RequestHandler::handle(Array)
#13 {main}