mySQL 5 and PHP 5 problems

**damnedpig** · 05-31-2006, 08:00 PM

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** · 06-01-2006, 07:07 AM

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** · 06-01-2006, 07:12 AM

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** · 06-03-2006, 11:08 AM

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

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

**red_fraggle** · 12-30-2006, 08:17 PM

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".