Search engine problem

[Lynne]

You have a mix of latin1 and utf8. I'd suggest setting up a test site and reading George's reply in this thread regarding how to go about fixing the issue - http://www.vbulletin.com/forum/forum...ng-up-properly Do that first on your test site before doing it to your live site!!!

[webmastersun]

When you create a new database for the restoration from previous backups, you need to set your database as utf8_unicode_ci

[ozzy47]

@sergarch, did you ever get this sorted out?

[sergarch]

Dear friends!

Thank you all for your advises! :up:

First of all Marry Christmas (or Happy Hanukkah) and Happy New Year!!!

Second - I have found a solution for this problem.

Here are my steps for it:

• 1. Create an empty test DB (data base)
  2. Download notepad++
  3. Download your current DB via Sypex Dumper and force encoding to latin-1 (otherwise on utf8 or auto encoding it will be unreadable abracadabra in Russian)
  4. Open DB in Notepad++ (DB is now readable with proper Russian letters) and manually change latin-1 to utf8 (it is in the first line) and save it
  5. Upload your edited DB to the test DB on your server.
  6. If you need to change collation_server latin1_swedish_ci (or any other) to utf8_general_ci here the simple query for SQL:
  ALTER DATABASE db_name DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
  7. Change your config.php with new DB's name and password and uncommette // $config['Mysqli']['charset'] = 'utf8';
  8. If you need to zip-unzip with *.gz , please use editor like 7-Zip

That's all

Now vBulletin's search engine works perfectly without bugs

[ozzy47]

Glad to hear you got it sorted. Also thanks for sharing what you did to fix it, in case others run into the same situation.