mySQL 5 and PHP 5 problems

[damnedpig]

Hi guys
The hosting company told me they upgraded mySQL and PHP to version 5 branches.

Now, I'm getting some SQL errors in the shop site:

http://www.alipogroup.com/catalogo/i...38a2fd8c2461f0

Does any1 know how to fix these ?

Thanks a lot in advance.

[michael_s]

You will need to backport and apply the patch that jpf put together. It should fix compatibility issues with php and mysql 5. I am running a patched version on php 5.1.4 and mysql 5 without any errors.

http://oscdox.com/index.php?name=Dow...tit&lid=45

Note that the patch is for v2.0RC2 and will need to be massaged a bit to get it to work on v1.7... You will have to manually compare files and merge the appropriate changes one by one, adapting them for v1.7. I suggest working on a backup copy of your site so that you don't trash your original install should you make a mistake.

[damnedpig]

oh sh...
this will be a pain in the a**

thanks michael for helping

i think I will have to try everything manually until I get products showing...

[jpf]

The PATCH should work fine as I have not run into any major problems myself.


Coming soon: RC3..... With the patch included....

[red_fraggle]

Got a download link for the patch?

On oscmax RC 2 shops we are having LOADS of problems with clients not being able to click a category after the upgrade to PHP 5. Well technically they can click the category links, but they go to "page not found".