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

  • 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, 7:07am.

  • #2
    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.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud customization and demonstration site.
    vBulletin 5 Documentation - Updated every Friday. Report issues here.
    vBulletin 5 API - Full / Mobile
    I am not currently available for vB Messenger Chats.

    Comment


    • Wayne Luke
      Wayne Luke commented
      Editing a comment
      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
      pmquist commented
      Editing a comment
      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
      Wayne Luke commented
      Editing a comment
      2.2.10 should be higher than 2.2.4

Related Topics

Collapse

Working...
X