Icy Phoenix

Hi all. First to mention that I am writing from my friend's account - we are both admins of our little site www.omarska.net. He was an active member of IP comunity a few years ago, but now he is very bussy with other stuff.

---

When I found about IP 2.0 I was very pleased to read about it. Therefore I have created a copy of our site (both DB and files) and performed an upgrade. Everything is done, but final result contains some errors.

Tehnical data:
Old version: 1.3.0.53b - avaiable at www.omarska.net
New (upgraded) version: 2.0.0.86 - avaiable at www.omarska.net/icyphoenix/
Use following credentials to access it

PHP version: 5.2.17
MySQL version: 5.1.65-cll

The problem:
After DB conversion to UTF-8 some serbian latin characters with diacritics have been lost and now are unreadable. Here is the outcome both for lower case and upper case:


Serbian cyrilic characters all survived.

I have found similar topic by Costa, and solution by TheSteffen but I'm not sure if I can use it in my case.

Second problem:
After clicking on ACP link, nothing happens except sid is added at the end of the URL. The only way I have discovered how to login to ACP is to click on CMS link, and after logging into CMS, I can switch to ACP.

Can anybody help with my problems? No rush, of course :)
Any help will be appreciated.

Regards,
M.

can you please check your NEW , upgraded database Collation



BTW affter i saw your topic i checked my databases .

Results :

Upgradet databases : was on utf8_bin
Fresh databases 2.0 : one base utf8_bin
and one base was on latin_swedish :shock:

i found for me a solution to convert al to utf8_general_ci

result :



so if you want i can attach my edited "convert_utf8_nodbal.php"

Thank you for your reply.

MySQL connection collation: utf8_general_ci

Upgraded database collation utf8_bin.

Collation of tables inside my upgraded DB utf8_bin.


There are some tables with prefix _old and collation of those tabels is different. I guess they are not used after the conversion process.


So, you have modified "convert_utf8_nodbal.php" to create utf8_unicode_ci tables? Sure, I would like to try it.

M.

yep and here it is

BTW backup your database before

let me know if you solved problem with characters

then will see about ACP

omarska,
You still have problems?

What is the collation of the old (IP 1.3) database?
And what letters are there, what language? Serbian?

omarska, did you solve your issue?