Tweet
Hello,
Since a long time I get sporadic errors emails indicating "Database Error".
I finally have time to investigate, and it seems to happen when a user is writting an answer to a topic.
The message is well stored but the error is displayed to the user with next content (and a warning email is sent)
It seems to be related to Sphinx that I'm using for Search purpose.
I googled this kind of error without succeeding to solve the issue.
Perhaps someone has an idea.
Thanks for any help.
Greetings
Since a long time I get sporadic errors emails indicating "Database Error".
I finally have time to investigate, and it seems to happen when a user is writting an answer to a topic.
The message is well stored but the error is displayed to the user with next content (and a warning email is sent)
Error Database error in vBulletin 5.1.9: Invalid SQL: UPDATE vt_new SET lastcontentid = 0, textcount = 2, lastcontent = 0, prefixid = 2408688624, tagid = (1077,2387,3034) WHERE id = 695503; MySQL Error : sphinxql: syntax error, unexpected $end, expecting FROM or ',' near 'version' Error Number : 1064 Request Date : Sunday, October 25th 2015 @ 08:44:14 AM Error Date : Sunday, October 25th 2015 @ 08:44:15 AM Script : http:///create-content/text/ Referrer : http://www.vag-technique.fr/forum/eq...ooth-installer IP Address : xx.xx.xx.xx Username : slinouille Classname : vB_Database_MySQLi MySQL Version : Stack Trace: #line vB_Database->halt() called in [path]/vb/database/mysqli.php on line 176 #line vB_Database_MySQLi->execute_query() called in [path]/vb/database.php on line 504 #line vB_Database->query_write() called in [path]/packages/vbsphinxsearch/core.php on line 223 #line vBSphinxSearch_Core->attributeChanged() called in [path]/vb/api/search.php on line 565 #line vB_Api_Search->attributeChanged() called in [path]/vb/library/node.php on line 5298 #line vB_Library_Node->updateParentCountsList() called in [path]/vb/library/node.php on line 5251 #line vB_Library_Node->updateParentCounts() called in [path]/vb/library/content.php on line 759 #line vB_Library_Content->afterAdd() called in [path]/vb/library/content/text.php on line 676 #line vB_Library_Content_Text->add() called in [path]/vb/api/content/text.php on line 226 #line vB_Api_Content_Text->add() called in on line #line call_user_func_array() called in [path]/vb/api/wrapper.php on line 121 #line vB_Api_Wrapper->__call() called in on line #line vB_Api_Wrapper->add() called in on line #line call_user_func_array() called in /var/www/html/vt_vb5_prod/includes/api/interface/collapsed.php on line 189 #line Api_Interface_Collapsed->callApi() called in /var/www/html/vt_vb5_prod/includes/vb5/frontend/controller/createcontent.php on line 332 #line vB5_Frontend_Controller_CreateContent->createNewNode() called in /var/www/html/vt_vb5_prod/includes/vb5/frontend/controller/createcontent.php on line 270 #line vB5_Frontend_Controller_CreateContent->index() called in on line #line call_user_func_array() called in /var/www/html/vt_vb5_prod/index.php on line 82
I googled this kind of error without succeeding to solve the issue.
Perhaps someone has an idea.
Thanks for any help.
Greetings
Comment