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.2
      PHP 7.3.5
      Maria DB 10.2.24

      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.2
      PHP 7.3.5
      Maria DB 10.2.24

      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.2
            PHP 7.3.5
            Maria DB 10.2.24

            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.2
            PHP 7.3.5
            Maria DB 10.2.24

            Comment

            Related Topics

            Collapse

            Working...
            X