Hello everyone,
I am running a website with Oxwall and all is fine except for the search function (Standard Forum Module). When someone uses the search function, the page displays the following error:
Error details:
Type:
Exception
Message:
SQLSTATE[42000]: Syntax error or
access violation: 1064 You have an error in your SQL syntax; check the
manual that corresponds to your MariaDB server version for the right
syntax to use near 'rows' at line 23
File:
/home/npccneta/public_html/portal/ow_core/database.php
Line:
723
Trace:
#0
/home/npccneta/public_html/portal/ow_core/database.php(723):
PDOStatement->execute()
#1 /home/npccneta/public_html/portal/ow_core/database.php(385):
OW_Database->execute('\r\n S...', Array)
#2
/home/npccneta/public_html/portal/ow_system_plugins/base/bol/search_entity_dao.php(387):
OW_Database->queryForRow('\r\n S...', Array)
#3
/home/npccneta/public_html/portal/ow_system_plugins/base/classes/mysql_search_storage.php(277):
BOL_SearchEntityDao->findEntitiesCountByText('photos', Array, 0, 0)
#4
/home/npccneta/public_html/portal/ow_core/text_search_manager.php(303):
BASE_CLASS_MysqlSearchStorage->searchEntitiesCount('photos', Array,
0, 0)
#5
/home/npccneta/public_html/portal/ow_plugins/forum/bol/text_search_service.php(285):
OW_TextSearchManager->searchEntitiesCount('photos', Array)
#6
/home/npccneta/public_html/portal/ow_plugins/forum/bol/forum_service.php(1924):
FORUM_BOL_TextSearchService->countGlobalTopics('photos', NULL)
#7
/home/npccneta/public_html/portal/ow_plugins/forum/controllers/search.php(472):
FORUM_BOL_ForumService->countGlobalTopics('photos', NULL)
#8
/home/npccneta/public_html/portal/ow_plugins/forum/controllers/search.php(66):
FORUM_CTRL_Search->searchEntities(Array, 'global')
#9 [internal function]: FORUM_CTRL_Search->inForums(Array)
#10 /home/npccneta/public_html/portal/ow_core/request_handler.php(250):
ReflectionMethod->invokeArgs(Object(FORUM_CTRL_Search), Array)
#11 /home/npccneta/public_html/portal/ow_core/request_handler.php(226):
OW_RequestHandler->processControllerAction(Object(ReflectionMethod),
Object(FORUM_CTRL_Search))
#12 /home/npccneta/public_html/portal/ow_core/application.php(346):
OW_RequestHandler->dispatch()
#13 /home/npccneta/public_html/portal/index.php(76):
OW_Application->handleRequest()
#14 {main}
I am running a couple of other websites with Oxwall and never experienced this problem. Grateful for any suggestions people might have.
Thank you.
