Announcement

Collapse
No announcement yet.

Search not indexing after upgrade from v5.5.0 to v5.5.2

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

  • #16
    Can you also provide the output for this query?

    Code:
     
     SHOW VARIABLES LIKE 'character\_set\_%';
    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


    • #17
      Originally posted by Wayne Luke View Post
      We think we know where the query is failing. We don't know why the query is failing or how to fix it immediately. The queries work on my implementation of MySQL but failed on a developer's implementation.

      In order to determine the why, we are going to need a backup copy of your database. This is so we can troubleshoot and the developers can add additional debugging tools as needed to determine the problem. If you can make a copy available for us, it would reduce the amount of time we need to invest in fixing the issue and we can provide a solution quicker.
      I will send you a link to the backup via PM
      Admin for hobbysquawk.com
      VB 5.5.4.1
      PHP 7.3.10
      Maria DB 10.2.27

      Comment


      • Wayne Luke
        Wayne Luke commented
        Editing a comment
        Received. Thanks.

    • #18
      Originally posted by Wayne Luke View Post
      Can you also provide the output for this query?

      Code:
      SHOW VARIABLES LIKE 'character\_set\_%';
      Here is the output:

      character_set_client utf8
      character_set_connection utf8
      character_set_database utf8
      character_set_filesystem binary
      character_set_results utf8
      character_set_server latin1
      character_set_system utf8
      Admin for hobbysquawk.com
      VB 5.5.4.1
      PHP 7.3.10
      Maria DB 10.2.27

      Comment


      • Wayne Luke
        Wayne Luke commented
        Editing a comment
        okay. this is pretty close to mine. I just have utf8mb4 where you have utf8.

    • #19
      https://tracker.vbulletin.com/vbulle...sues/VBV-19391 - Will have someone look at your database as soon as possible.
      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


      • #20
        As a temporary solution while waiting for the official fix, why not just replace those curly quotes on the database with the corresponding straight ones?

        GIPHY for vB5 AutoLinker Auto-Create Flag Report Topic Social Icons in Postbit Clear Cache Cron DragDrop Upload Topic AJAX AutoUpdate Custom Avatars Selector Stop Links in Posts...and more!

        Comment


        • #21
          Please update your config.php file to read:

          Code:
          $config['Mysqli']['charset'] = 'utf8mb4';
          Rebuild your search index.
          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


          • #22
            Originally posted by Glenn Vergara View Post
            As a temporary solution while waiting for the official fix, why not just replace those curly quotes on the database with the corresponding straight ones?
            It's an interesting idea. I'm not sure if it would screw up anything else down the line. I'm assuming I can do this via Phpmyadmin with a sql search and replace function. What tables would I need to search and replace the curly quotes? I'm assuming:
            cache
            text
            words
            node

            Is that correct?
            Admin for hobbysquawk.com
            VB 5.5.4.1
            PHP 7.3.10
            Maria DB 10.2.27

            Comment


            • Glenn Vergara
              Glenn Vergara commented
              Editing a comment
              I don't know all the tables off the top of my head. To prevent the curly quotes from being saved in the posts in the future, you'd have to have a mod that does that. I have that mod but you won't need it once this issue is fixed.

          • #23
            Originally posted by Wayne Luke View Post
            Please update your config.php file to read:

            Code:
            $config['Mysqli']['charset'] = 'utf8mb4';
            Rebuild your search index.
            This fixed the issue.. Thank you Wayne
            Admin for hobbysquawk.com
            VB 5.5.4.1
            PHP 7.3.10
            Maria DB 10.2.27

            Comment


            • #24
              I also had the error, "invalid SQL," on building the search index. It occurs with both the command line and web method.

              The fix

              $config['Mysqli']['charset'] = 'utf8mb4'; did not work.

              I ran this query below:

              SHOW VARIABLES LIKE 'character\_set\_%';

              wit this result:

              Variable_name Value

              character_set_client utf8mb4
              character_set_connection utf8mb4
              character_set_database utf8mb4
              character_set_filesystem binary
              character_set_results utf8mb4
              character_set_server utf8mb4
              character_set_system utf8

              I copied the failing SQL query, and it worked in phpMyAdmin on the same server, the same database!

              This was an upgrade from 4.5.2 to 5.5.4, but the failing query was the same as in this post - different words of course, but it started out as below:

              Error Invalid SQL: SELECT * FROM words WHERE `word` IN ('woodshed','reported','posts', ...

              Server info is below. Are there any suggestions on getting this to work?

              Click image for larger version  Name:	server48570.png Views:	0 Size:	56.5 KB ID:	4422547
              Last edited by artlserver; Mon 23rd Sep '19, 1:18pm.

              Comment


              • #25
                Originally posted by artlserver View Post
                Are there any suggestions on getting this to work?
                You will need to open your own topic to receive support. Piggybacking off of someone else's issue will rarely end satisfactorily even if you think you have the exact same problem. We will need to see the entire query and error message returned by MySQL in your topic.

                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


                • #26
                  Originally posted by Wayne Luke View Post

                  You will need to open your own topic to receive support. Piggybacking off of someone else's issue will rarely end satisfactorily even if you think you have the exact same problem. We will need to see the entire query and error message returned by MySQL in your topic.
                  Ok, I opened a topic at https://forum.vbulletin.com/forum/vb...-2-5-to-v5-5-4

                  I added the entire query. Let me know if more info is needed.

                  Thanks for looking into this.

                  Comment

                  Related Topics

                  Collapse

                  Working...
                  X