MySql 4 Upgrade to MySql 5

[Andy_GS]

Hey all i just wanted to check if there were any known issues from upgrading MySql from:

MySql - 4.1.22

to:

MySql - 5

Zen Cart Version: 1.3.8a

Basically i want to know if this upgrade is liable to knock something out in zencart and if so what and also how i can either prevent or protect from this happening.

regards

Andy.

[stevesh]

Far as I know, as long as you're using 1.3.8a, you're good. It's the earlier Zencart versions that had issues with PHP5.

[Andy_GS]

Might i need to apply a mysql patch?

regards

Andy.

[DrByte]

Zen Cart 1.3.8a should be fine with MySQL 5.

Be sure to have good backups before upgrading, just in case something goes amuck during the mysql upgrade.

[Andy_GS]

Hey guys, well we tried to upgrade over the weekend, a nice early wakeup of 4:00am *yawn*

and like most things it broke .

although the update was successful it would appear some of the modules we have installed still use the old way of doing Left Joins.

an example of the code (this is not the exact code because at 4am i wasn't thinking and forgot to nab the error message, but it gives you an idea):

mysql> select * from categories c, categories_description cd left join categories_description cd2 ON (c.parent_id = cd2.categories_id and cd2.language_id = '1') where c.categories_id = cd.categories_id and cd.language_id = '1';

ERROR 1054 (42S22): Unknown column 'c.parent_id' in 'on clause'

So i guess the only thing to do is update all of the left join code so that it works on the newer syntax and then upgrade?

or has anyone got any other suggestions.

Andy.

[DrByte]

So i guess the only thing to do is update all of the left join code so that it works on the newer syntax and then upgrade?

As far as your addons go, yes, that's probably the best approach.

[MikeG1969]

It would be nice if they could update the installation pop-up for this issue:

http://localhost/zencart/zc_install/...?error_code=90

for future newbies who have a conniption regarding this issue like I did. It's hard enough to install without knowing if things like these are an issue or not.

Furthermore, would it not hurt for the php.ini file to be modified (for the curl line to be activated) on a localhost installation? That one was a real bugger too.

I also hated the fact that I had to install XAMPP 1.7.2, only to find out I had to start over with XAMPP 1.7.1

OK. I'm done ranting.