Announcement

Collapse
No announcement yet.

Search function only patially delivering even after search indexing and updating to 5.5.2

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

  • #16
    Previously you were connecting to the database with a latin1 character set. Did you change that? What is the result of this query now:

    Code:
     
     show variables like 'character_set%'
    Your local prevents UTF-8. It should be de_DE.UTF8. Though you'll have to verify with your hosting provider that it is installed on the server.
    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
      character_set_client latin1
      character_set_connection latin1
      character_set_database latin1
      character_set_filesystem binary
      character_set_results latin1
      character_set_server latin1
      character_set_system utf8
      character_sets_dir /usr/share/mysql/charsets/
      check_proxy_users OFF
      collation_connection latin1_swedish_ci
      collation_database latin1_swedish_ci
      collation_server latin1_swedish_ci
      I haven't changed anything here, i only executed the scripts from the utf8_db_tools readme.md. I thought that was enough. These tools only convert the tables of the db to utf8, am i right?

      As soon as i change the charset in vbulletin to de_DE.UTF8 and logout of the admincp i can't login anymore. It shows "Invalid Charset: de_de.utf8".


      locale -a:
      Code:
      C
      C.UTF-8
      de_DE
      de_DE.iso88591
      de_DE.utf8
      deutsch
      german
      POSIX

      Comment


      • #18
        I never said set the character set to de_de.utf8. The character set should be UTF-8. The Locale should be de_DE.UTF8. These are CASE Sensitive.

        You'll have to edit the Language table in the database to change this.
        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


        • #19
          I changed it back to UTF-8 and still have the problems that the umlauts are not shown correctly. Then i was executing this command in the linux shell:

          Code:
           show variables like 'character_set%'
          and got the following result:

          +--------------------------+----------------------------+
          | Variable_name | Value |
          +--------------------------+----------------------------+
          | character_set_client | utf8 |
          | character_set_connection | utf8 |
          | character_set_database | latin1 |
          | character_set_filesystem | binary |
          | character_set_results | utf8 |
          | character_set_server | latin1 |
          | character_set_system | utf8 |
          | character_sets_dir | /usr/share/mysql/charsets/ |
          +--------------------------+----------------------------+
          +----------------------+-------------------+
          | Variable_name | Value |
          +----------------------+-------------------+
          | collation_connection | utf8_general_ci |
          | collation_database | latin1_swedish_ci |
          | collation_server | latin1_swedish_ci |
          +----------------------+-------------------+


          vBulletin, Maintenance, Diagnostic show different results:
          character_set_client latin1
          character_set_connection latin1
          character_set_database latin1
          character_set_filesystem binary
          character_set_results latin1
          character_set_server latin1
          character_set_system utf8
          character_sets_dir /usr/share/mysql/charsets/
          collation_connection latin1_swedish_ci
          collation_database latin1_swedish_ci
          collation_server latin1_swedish_ci
          Could this be the problem?

          Comment

          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
          Working...
          X