You get more information about the problem in our knowledge base: http://www.woltlab.com/help/?code=1055
error message: Invalid SQL: ( SELECT thread.threadID 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 (1)) AND (thread.threadID = messageTable.threadID AND thread.userID IN (1) AND messageTable.isDeleted = 0 AND messageTable.isDisabled = 0)/* findThreads *//* findUserThreads */)
GROUP BY messageID) ORDER BY time DESC LIMIT 1000
error code: 1055
sql type: MySQLDatabase
sql error: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'chamaeleon.messageTable.time' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
sql error number: 1055
sql version:
file: /var/www/vhosts/chamaeleons.com/httpdocs/wcf/lib/system/database/MySQLDatabase.class.php (118)
php version: 5.3.29
wcf version: 1.1.10 (Tempest)
date: Sat, 30 Mar 2024 03:27:13 +0000
request: /index.php?form=Search&types[]=post&userID=1&findUserThreads=1&s=f0f0428de91ea06a05ad534de6a7d67f329e720f
referer:
#0 /var/www/vhosts/chamaeleons.com/httpdocs/wcf/lib/data/message/search/SearchEngine.class.php(185): MySQLDatabase->sendQuery('(?SELECT??threa...', 1000) #1 /var/www/vhosts/chamaeleons.com/httpdocs/wcf/lib/form/SearchForm.class.php(258): SearchEngine->search('', Array, Array, 'time DESC') #2 /var/www/vhosts/chamaeleons.com/httpdocs/wcf/lib/form/AbstractForm.class.php(43): SearchForm->validate() #3 /var/www/vhosts/chamaeleons.com/httpdocs/wcf/lib/form/SearchForm.class.php(344): AbstractForm->submit() #4 /var/www/vhosts/chamaeleons.com/httpdocs/wcf/lib/form/SearchForm.class.php(404): SearchForm->submit() #5 /var/www/vhosts/chamaeleons.com/httpdocs/wcf/lib/page/AbstractPage.class.php(46): SearchForm->show() #6 /var/www/vhosts/chamaeleons.com/httpdocs/wcf/lib/util/RequestHandler.class.php(64): AbstractPage->__construct() #7 /var/www/vhosts/chamaeleons.com/httpdocs/wcf/lib/util/RequestHandler.class.php(95): RequestHandler->__construct('Search', Array, 'form') #8 /var/www/vhosts/chamaeleons.com/httpdocs/index.php(8): RequestHandler::handle(Array) #9 {main}