WoltLab Community Forum

Source code

		Fatal error: Invalid SQL: ( SELECT
messageTable.postID AS messageID, 'post' AS messageType ,
messageTable.subject AS subject ,0 AS relevance FROM wbb1_1_post
messageTable , wbb1_1_thread thread WHERE MATCH (messageTable.subject,
messageTable.message) AGAINST ('+Nützliches +für +das +WBB' IN BOOLEAN
MODE) AND ((thread.threadID = messageTable.threadID AND thread.boardID
IN
(1,2,3,4,5,8,47,83,13,16,20,22,23,24,25,27,28,29,82,84,31,85,72,81,41,74,7,40,63,86,87,88,89)
AND messageTable.isDeleted = 0 AND messageTable.isDisabled = 0)) GROUP
BY messageID)
UNION
( SELECT messageTable.pmID AS messageID, 'pm' AS messageType ,
messageTable.subject AS subject ,0 AS relevance FROM wcf1_pm
messageTable WHERE MATCH (messageTable.subject, messageTable.message)
AGAINST ('+Nützliches +für +das +WBB' IN BOOLEAN MODE) AND (((userID =
3302 AND (saveInOutbox = 1 OR isDraft = 1)) OR pmID IN (SELECT pmID
FROM wcf1_pm_to_user WHERE recipientID = 3302 AND isDeleted < 2)))
GROUP BY messageID)
UNION
( SELECT messageTable.eventID AS messageID, 'event' AS messageType ,
messageTable.subject AS subject ,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 MATCH
(messageTable.subject, messageTable.message) AGAINST ('+Nützliches +für
+das +WBB' IN BOOLEAN MODE) AND ((calendar_event.messageID =
messageTable.messageID) AND (calendar_event.calendarID IN (0)) OR (
(calendar_event.messageID = messageTable.messageID) AND
(calendar_event.calendarID IN (0)) AND ( startTime >= -2145916800
AND startTime < 1226102399 OR ( startTime < -2145916800 AND
repeatTime > 0 AND ( repeatEndTime > -2145916800 OR repeatEndTime
= 0 ) AND CEIL((-2145916800 - startTime) / repeatTime) <=
FLOOR((1226102399 - startTime) / repeatTime) ) ) )) GROUP BY messageID)
ORDER BY subject DESC LIMIT 1000
	
		
			
			You get more information about the problem in our knowledge base: http://www.woltlab.com/help/?code=1271			
			Information:
			
				error message:
Invalid SQL: ( SELECT messageTable.postID AS messageID, 'post' AS
messageType , messageTable.subject AS subject ,0 AS relevance FROM
wbb1_1_post messageTable , wbb1_1_thread thread WHERE MATCH
(messageTable.subject, messageTable.message) AGAINST ('+Nützliches +für
+das +WBB' IN BOOLEAN MODE) AND ((thread.threadID =
messageTable.threadID AND thread.boardID IN
(1,2,3,4,5,8,47,83,13,16,20,22,23,24,25,27,28,29,82,84,31,85,72,81,41,74,7,40,63,86,87,88,89)
AND messageTable.isDeleted = 0 AND messageTable.isDisabled = 0)) GROUP
BY messageID)
UNION
( SELECT messageTable.pmID AS messageID, 'pm' AS messageType ,
messageTable.subject AS subject ,0 AS relevance FROM wcf1_pm
messageTable WHERE MATCH (messageTable.subject, messageTable.message)
AGAINST ('+Nützliches +für +das +WBB' IN BOOLEAN MODE) AND (((userID =
3302 AND (saveInOutbox = 1 OR isDraft = 1)) OR pmID IN (SELECT pmID
FROM wcf1_pm_to_user WHERE recipientID = 3302 AND isDeleted < 2)))
GROUP BY messageID)
UNION
( SELECT messageTable.eventID AS messageID, 'event' AS messageType ,
messageTable.subject AS subject ,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 MATCH
(messageTable.subject, messageTable.message) AGAINST ('+Nützliches +für
+das +WBB' IN BOOLEAN MODE) AND ((calendar_event.messageID =
messageTable.messageID) AND (calendar_event.calendarID IN (0)) OR (
(calendar_event.messageID = messageTable.messageID) AND
(calendar_event.calendarID IN (0)) AND ( startTime >= -2145916800
AND startTime < 1226102399 OR ( startTime < -2145916800 AND
repeatTime > 0 AND ( repeatEndTime > -2145916800 OR repeatEndTime
= 0 ) AND CEIL((-2145916800 - startTime) / repeatTime) <=
FLOOR((1226102399 - startTime) / repeatTime) ) ) )) GROUP BY messageID)
ORDER BY subject DESC LIMIT 1000

				error code: 1271
				
				sql type: MySQLDatabase
sql error: Illegal mix of collations for operation 'UNION'
sql error number: 1271
sql version: 
				file: /var/www/woltlab.de/html/forum/wcf/lib/system/database/MySQLDatabase.class.php (116)

				php version: 5.2.0-8+etch10

				wcf version: 1.0.10 (Horizon)

				date: Fri, 07 Nov 2008 14:59:43 +0000

				request: /forum/index.php?form=Search

				referer: http://www.woltlab.com/forum/index.php?form=Search

			
			
			Stacktrace:
			#0 /var/www/woltlab.de/html/forum/wcf/lib/data/message/search/SearchEngine.class.php(167): MySQLDatabase->sendQuery('(?SELECT??messa...', 1000)
#1 /var/www/woltlab.de/html/forum/wcf/lib/form/SearchForm.class.php(146): SearchEngine->search('N??tzliches f??...', Array, Array, 'subject DESC')
#2 /var/www/woltlab.de/html/forum/wcf/lib/form/AbstractForm.class.php(41): SearchForm->validate()
#3 /var/www/woltlab.de/html/forum/wcf/lib/form/SearchForm.class.php(200): AbstractForm->submit()
#4 /var/www/woltlab.de/html/forum/wcf/lib/form/AbstractForm.class.php(88): SearchForm->submit()
#5 /var/www/woltlab.de/html/forum/wcf/lib/form/CaptchaForm.class.php(78): AbstractForm->readData()
#6 /var/www/woltlab.de/html/forum/wcf/lib/form/SearchForm.class.php(211): CaptchaForm->readData()
#7 /var/www/woltlab.de/html/forum/wcf/lib/page/AbstractPage.class.php(74): SearchForm->readData()
#8 /var/www/woltlab.de/html/forum/wcf/lib/form/SearchForm.class.php(262): AbstractPage->show()
#9 /var/www/woltlab.de/html/forum/wcf/lib/page/AbstractPage.class.php(36): SearchForm->show()
#10 /var/www/woltlab.de/html/forum/wcf/lib/util/RequestHandler.class.php(63): AbstractPage->__construct()
#11 /var/www/woltlab.de/html/forum/wcf/lib/util/RequestHandler.class.php(94): RequestHandler->__construct('Search', Array, 'form')
#12 /var/www/woltlab.de/html/forum/index.php(8): RequestHandler::handle(Array)
#13 {main}