Hello,
We just upgraded our production sites forum from 5.2.5 to 5.3.2, and noticed that Sphinx has changed, so followed the instructions and stopped it, updated the file in /usr/local/sphinx/etc/ and put the path back to where it should be. Then followed the instructions here https://www.vbulletin.com/forum/arti...e-sphinx-index as per the prompt in cpanel of the forum.
But after running 'php searchindex.php' all it did was ask for the path to the forum/core, which is the default in our case. It then quits back to prompt. It didnt ask to clear cache or anything.
Search however is not working. Comes up blank.
So I go into cpanel and clear cache. No change
Go into Maintenance and rebuild the search index, and while its doing it, I get constant errors coming into email:
and
every few seconds a new email like these come in.
By the time the indexing finishes, the emails finish, but the search still doesnt work.
I even tried clicking the hot URL links above the rebuilt index button in Maintenance, to clear the index, and rebuild the index. Clear didnt seem to do anything, and rebuilt resulted in an error.
The forum is working, we can see content
Sphinx is running, however its not returning anything at all.
Indexing Sphinx results in constant error emails.
Please please help
We just upgraded our production sites forum from 5.2.5 to 5.3.2, and noticed that Sphinx has changed, so followed the instructions and stopped it, updated the file in /usr/local/sphinx/etc/ and put the path back to where it should be. Then followed the instructions here https://www.vbulletin.com/forum/arti...e-sphinx-index as per the prompt in cpanel of the forum.
But after running 'php searchindex.php' all it did was ask for the path to the forum/core, which is the default in our case. It then quits back to prompt. It didnt ask to clear cache or anything.
Search however is not working. Comes up blank.
So I go into cpanel and clear cache. No change
Go into Maintenance and rebuild the search index, and while its doing it, I get constant errors coming into email:
A database error occured, please check the database settings in the config file or enable debug mode for additional information.
Database error in vBulletin 5.3.2:
Invalid SQL:
INSERT INTO admin4d_forum(
id, title, content, contenttypeid, lastcontentid, parentid, starter, starterparent, starteruser, closure, depth, userid, authorname, setfor, sentto, showpublished, approved, showapproved, viewperms, featured, inlist, protected, votes, lastcontent, created, publishdate, unpublishdate, prefixid, tagid, textcount, eventstartdate, eventenddate
)
VALUES (
40216, '', ' that is why i asked you about your environment.\n\nyou write to the sound object for genie.\n\nfor designer, visi and serial you \'playwav\'.', 25, 40216, 40203, 40203, 28, 3872, (40216,40203,28,38011,2,1), '{"n40216":0,"n40203":1,"n28":2,"n38011":3,"n2":4,"n1":5}', 472, 'ESPsupport', 0, (), 1, 1, 1, 2, 0, 1, 0, 0, 1408225197, 1408225197, 1408225197, 0, 0, (), 0, 0, 0
);
MySQL Error : sphinxql: syntax error, unexpected $end, expecting FROM or ',' near 'version'
Error Number : 1064
Request Date : Sunday, August 13th 2017 @ 09:48:44 PM
Error Date : Sunday, August 13th 2017 @ 09:48:44 PM
Script : http://forum.oursitenamehere.com.au/...0&indextypes=0
Referrer : http://forum.oursitenamehere.au/admi...0&indextypes=0
IP Address : 121.xx.xx.xx
Username : usernamehere
Classname : vBSphinxSearch_Connection
MySQL Version :
Stack Trace:
#0 vB_Database->getErrorData() called in [path]/vb/database.php on line 1188
#1 vB_Database->halt() called in [path]/vb/database/mysqli.php on line 201
#2 vB_Database_MySQLi->execute_query() called in [path]/vb/database.php on line 542
#3 vB_Database->query_write() called in [path]/packages/vbsphinxsearch/core.php on line 148
#4 vBSphinxSearch_Core->indexText() called in [path]/vb/search/core.php on line 114
#5 vB_Search_Core->index() called in [path]/vb/library/search.php on line 42
#6 vB_Library_Search->index() called in [path]/vb/library/search.php on line 102
#7 vB_Library_Search->indexRange() called in [path]/admincp/misc.php on line 229
#8 require_once([path]/admincp/misc.php) called in /home/admin4d/public_html/forum/includes/api/interface/collapsed.php on line 127
#9 Api_Interface_Collapsed->relay() called in /home/admin4d/public_html/forum/includes/vb5/frontend/controller/relay.php on line 39
#10 vB5_Frontend_Controller_Relay->admincp() called in on line
#11 call_user_func_array() called in /home/admin4d/public_html/forum/index.php on line 74
Invalid SQL:
INSERT INTO admin4d_forum(
id, title, content, contenttypeid, lastcontentid, parentid, starter, starterparent, starteruser, closure, depth, userid, authorname, setfor, sentto, showpublished, approved, showapproved, viewperms, featured, inlist, protected, votes, lastcontent, created, publishdate, unpublishdate, prefixid, tagid, textcount, eventstartdate, eventenddate
)
VALUES (
40216, '', ' that is why i asked you about your environment.\n\nyou write to the sound object for genie.\n\nfor designer, visi and serial you \'playwav\'.', 25, 40216, 40203, 40203, 28, 3872, (40216,40203,28,38011,2,1), '{"n40216":0,"n40203":1,"n28":2,"n38011":3,"n2":4,"n1":5}', 472, 'ESPsupport', 0, (), 1, 1, 1, 2, 0, 1, 0, 0, 1408225197, 1408225197, 1408225197, 0, 0, (), 0, 0, 0
);
MySQL Error : sphinxql: syntax error, unexpected $end, expecting FROM or ',' near 'version'
Error Number : 1064
Request Date : Sunday, August 13th 2017 @ 09:48:44 PM
Error Date : Sunday, August 13th 2017 @ 09:48:44 PM
Script : http://forum.oursitenamehere.com.au/...0&indextypes=0
Referrer : http://forum.oursitenamehere.au/admi...0&indextypes=0
IP Address : 121.xx.xx.xx
Username : usernamehere
Classname : vBSphinxSearch_Connection
MySQL Version :
Stack Trace:
#0 vB_Database->getErrorData() called in [path]/vb/database.php on line 1188
#1 vB_Database->halt() called in [path]/vb/database/mysqli.php on line 201
#2 vB_Database_MySQLi->execute_query() called in [path]/vb/database.php on line 542
#3 vB_Database->query_write() called in [path]/packages/vbsphinxsearch/core.php on line 148
#4 vBSphinxSearch_Core->indexText() called in [path]/vb/search/core.php on line 114
#5 vB_Search_Core->index() called in [path]/vb/library/search.php on line 42
#6 vB_Library_Search->index() called in [path]/vb/library/search.php on line 102
#7 vB_Library_Search->indexRange() called in [path]/admincp/misc.php on line 229
#8 require_once([path]/admincp/misc.php) called in /home/admin4d/public_html/forum/includes/api/interface/collapsed.php on line 127
#9 Api_Interface_Collapsed->relay() called in /home/admin4d/public_html/forum/includes/vb5/frontend/controller/relay.php on line 39
#10 vB5_Frontend_Controller_Relay->admincp() called in on line
#11 call_user_func_array() called in /home/admin4d/public_html/forum/index.php on line 74
By the time the indexing finishes, the emails finish, but the search still doesnt work.
I even tried clicking the hot URL links above the rebuilt index button in Maintenance, to clear the index, and rebuild the index. Clear didnt seem to do anything, and rebuilt resulted in an error.
The forum is working, we can see content
Sphinx is running, however its not returning anything at all.
Indexing Sphinx results in constant error emails.
Please please help
Comment