Mysql problems since 8.2 update

[got-hosting]

I am not clear if the mysql server got updated or not, but since updating to plesk 8.2, I have a very problematic issue.

The date_format command is not longer formatting teh date. It simply returns all question marks.

?????????

Like that. This worked perfectly before the update. We can of course fix it by rewriting code, but there are a couple hundred sites on this server adn doing it that way is impractical.

Plesk is reporting the mysql version is 4.1.18.

Thanks for any help anyone can provide.

 

[sergius]

Hello got-hosting,

Plesk 8.2.0 contains MySQL 5.0.37, but this version is too complex for upgrade from MySQL 4.1.18. Therefore Plesk does not upgrade MySQL in this case.
It is not clear why MySQL has been broken. It is possible my.ini file has been changed manually or something else.

 

[got-hosting]

We didn't change it on our end, no.

Should we upgrade? Is there a manual upgrade process? I saw the one to upgrade back when plesk 7.5 was out. Is it the same process?

 

[jerry2]

You didn't tell us what scripting language you use. If you use ASP, Plesk updates the myODBC from 3.51.12 to 3.51.14 which is very buggy. I had to revert to 3.51.12. The 3.51.17 is also buggy.

 

[got-hosting]

This is the best lead I have to date. Is it possible to just install the older version over top the newer one? Any pitfalls in that?

 

[jerry2]

It is sometimes hard to deinstall MyODBC from 14 or 17 to .12. You can not install older versions over new ones. I had to rename the myodbc3.dll in windows/system to something else and reboot and then install the 3.51.12 again. 3.51.12 is running my site with 4 milion page views a month. This version is the only 3.51 release that does work correctly on my site.