Announcement

Collapse
No announcement yet.

Sphinx problem after upgrade from 5.3.0 to 5.3.4

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Wayne Luke
    commented on 's reply
    2.2.10 should be higher than 2.2.4

  • pmquist
    commented on 's reply
    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
    commented on 's reply
    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
    commented on 's reply
    I hear what you are saying, but dont understand completely. I did the following:
    - Took the new vbulletin-sphinx.php from the do not upload and put it in the right place
    - i ran the new searchindex.php
    - I have tried rebuild the index in admincp
    - I have rotated the sphinx searchd manually using vbulletin-sphinx.php as config

    Are you saying there is something else I should have done? Do I have to run each searchindex.php from the versions I skipped?

  • Wayne Luke
    replied
    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.

    Leave a comment:


  • pmquist
    started a topic Sphinx problem after upgrade from 5.3.0 to 5.3.4

    Sphinx problem after upgrade from 5.3.0 to 5.3.4

    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.
    Last edited by pmquist; Thu 4th Jan '18, 8:07am.

Related Topics

Collapse

Working...
X