Sphinx problem after upgrade from 5.3.0 to 5.3.4

[pmquist]

After upgrading and doing all the Sphinx things that is mentioned in the file in the do not upload folder and also on the web page here: I still get one error.

It is when creating a new post, the program halts and presents an error (Error loading post) instead of showing the saved post. When manually looking in the channel, the post is saved and everything looks fine, but the post is not indexed and is not searchable.

If I do the same thing again but in a different channel I get this error message. I dont know if it is an error related to the above, first posting or if it is the same error just more clarified:

Error Database error in vBulletin 5.3.4: Invalid SQL: INSERT INTO vbulletin( id, title, content, contenttypeid, lastcontentid, parentid, starter, starterparent, starteruser, starterlastcontent, starterpublishdate, startercreated, startertextcount, starterdisplayorder, startervotes, startertitlesort, starterauthorname, closure, depth, userid, authorname, setfor, sentto, showpublished, approved, showapproved, viewperms, featured, inlist, protected, votes, lastcontent, created, publishdate, unpublishdate, prefixid, tagid, textcount, trendingweight, eventstartdate, eventenddate, titlesort ) VALUES ( 47243, 'test 13', 'qwertyhn', 30, 47243, 174, 47243, 174, 1, 1515072710, 1515072710, 1515072710, 0, 0, 0, 'Test 13', 'PO', (47243,174,38,19,2,1), '{"n47243":0,"n174":1,"n38":2,"n19":3,"n2":4,"n1":5}', 1, 'PO', 0, (), 1, 1, 1, 2, 0, 1, 0, 0, 1515072710, 1515072710, 1515072710, 0, 0, (), 0, 0, 0, 0, 'Test 13' ); MySQL Error : sphinxql: syntax error, unexpected $end, expecting FROM or ',' near 'version' Error Number : 1064 Request Date : Thursday, January 4th 2018 @ 02:31:50 PM Error Date : Thursday, January 4th 2018 @ 02:31:50 PM Script : http://utv.utkiken.net/create-content/text/ Referrer : http://utv.utkiken.net/new-content/174 IP Address : xx.xxx.xxx.xx Username : PO Classname : vBSphinxSearch_Connection MySQL Version :

## /var/www/core/vb/database.php(1189) Exception Thrown
#0 /var/www/core/vb/database/mysqli.php(201): vB_Database->halt()
#1 /var/www/core/vb/database.php(542): vB_Database_MySQLi->execute_query(true, Object(mysqli))
#2 /var/www/core/packages/vbsphinxsearch/core.php(233): vB_Database->query_write('INSERT INTO vbu...')
#3 /var/www/core/vb/search/core.php(116): vBSphinxSearch_Core->indexText(Array, 'test 13', 'qwertyhn')
#4 /var/www/core/vb/library/search.php(42): vB_Search_Core->index(47243, true)
#5 /var/www/core/vb/library/content.php(843): vB_Library_Search->index(47243)
#6 /var/www/core/vb/library/content/text.php(777): vB_Library_Content->afterAdd(47243, Array, Array, Array, Array)
#7 /var/www/core/vb/api/content/text.php(205): vB_Library_Content_Text->add(Array, Array, true)
#8 [internal function]: vB_Api_Content_Text->add(Array, Array)
#9 /var/www/core/vb/api/wrapper.php(199): call_user_func_array(Array, Array)
#10 [internal function]: vB_Api_Wrapper->__call('add', Array)
#11 [internal function]: vB_Api_Wrapper->add(Array, Array)
#12 /var/www/includes/api/interface/collapsed.php(101): call_user_func_array(Array, Array)
#13 /var/www/includes/vb5/frontend/controller/createcontent.php(419): Api_Interface_Collapsed->callApi('content_text', 'add', Array)
#14 /var/www/includes/vb5/frontend/controller/createcontent.php(298): vB5_Frontend_Controller_CreateContent->createNewNode('content_text', Array, Array, Array)
#15 /var/www/includes/vb5/frontend/controller/createcontent.php(177): vB5_Frontend_Controller_CreateContent->actionTextNodeInternal('content_text')
#16 [internal function]: vB5_Frontend_Controller_CreateContent->index()
#17 /var/www/index.php(74): call_user_func_array(Array, Array)
#18 {main}

{"errors":["Error \n\t\t\tDatabase error in vBulletin 5.3.4:\n\n\t\t\tInvalid SQL:\r\nINSERT INTO vbulletin(\n\t\t\t\tid, title, content, contenttypeid, lastcontentid, parentid, starter, starterparent, starteruser, starterlastcontent, starterpublishdate, startercreated, startertextcount, starterdisplayorder, startervotes, startertitlesort, starterauthorname, closure, depth, userid, authorname, setfor, sentto, showpublished, approved, showapproved, viewperms, featured, inlist, protected, votes, lastcontent, created, publishdate, unpublishdate, prefixid, tagid, textcount, trendingweight, eventstartdate, eventenddate, titlesort\n\t\t\t)\n\t\t\tVALUES (\n\t\t\t\t47243, 'test 13', 'qwertyhn', 30, 47243, 174, 47243, 174, 1, 1515072710, 1515072710, 1515072710, 0, 0, 0, 'Test 13', 'PO', (47243,174,38,19,2,1), '{"n47243":0,"n174":1,"n38":2,"n19":3,"n2":4,"n1":5}', 1, 'PO', 0, (), 1, 1, 1, 2, 0, 1, 0, 0, 1515072710, 1515072710, 1515072710, 0, 0, (), 0, 0, 0, 0, 'Test 13'\n\t\t\t);\n\n\t\t\tMySQL Error : sphinxql: syntax error, unexpected $end, expecting FROM or ',' near 'version'\n\t\t\tError Number : 1064\n\t\t\tRequest Date : Thursday, January 4th 2018 @ 02:31:50 PM\n\t\t\tError Date : Thursday, January 4th 2018 @ 02:31:50 PM\n\t\t\tScript : http://utv.utkiken.net/create-conten...\t\t\tReferrer : http://utv.utkiken.net/new-content/174\n\t\t\tIP Address : xx.xxx.xxx.xxx\n\t\t\tUsername : PO\n\t\t\tClassname : vBSphinxSearch_Connection\n\t\t\tMySQL Version : \n\t\t"]}

I have seen something similar in this post, but I have not changed any filenames in my installation. Any suggestions about what to do is most appreciated.

[Wayne Luke]

You will need to delete your Sphinx index and rebuild it with the new sphinx files provided in the upgrade. Changes have been made to Sphinx search in several versions that you skipped. Please review the release notes for all versions when you try to skip versions.

[Wayne Luke]

You need to manually delete your old index from Sphinx before you can rebuild. http://sphinxsearch.com/forum/view.html?id=7747

Also, make sure you are using Sphinx 2.2.4 or higher.

[pmquist]

Thanks, just to make sure I am right: 2.2.10 is higher than 2.2.4? :-)

then I will get on with the delete index.

[Wayne Luke]

2.2.10 should be higher than 2.2.4