Topic: downgrade mysql

[jameswilson]

hi
My sme has been fantastic but i recently upgraded from 7.2 to 7.3 and this broke my zen cart that i run in an ibay.

Upgrading zen is the thing to do but this isnt something i can 'just do' and i need to plan etc.
Im wondering if as a stop gap i can down grade mysql back to whatever it was and maybe php too.

If this is impossibly hard or i risk other problems ill just have to rush through the zen upgrade but im hoping....

Thanks for any insight

James

[byte]

Upgrading zen is the thing to do but this isnt something i can 'just do' and i need to plan etc.
Im wondering if as a stop gap i can down grade mysql back to whatever it was and maybe php too.

What makes you say it's either mysql and/or php ? Theres not much difference between the 7.3 mysql version 4.1.20-3 and 7.2 mysql version of 4.1.20-2 and the php in 7.3 is 4.3.9-3.22.9 and the 7.2 php version is 4.3.9-3.22.5

I'll move this to the contribs forum.

[jameswilson]

oh right well i get

1054 Unknown column 'U' in 'where clause'
in:
[ SELECT zone_id FROM dbzen_zones_to_geo_zones WHERE geo_zone_id = 10 AND zone_country_id = U ORDER BY zone_id ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

but only happens sometimes but always on the same queries. These worked 15 mins before the 7.3 upgrade as i was checking some accounts. Maybe its a setting then that has been changed as part of the upgrade in the config? I have chnaged nothing in zen. I hoped a restart woud fix it as i noticed this after the upgrade but before the reconfigure (thats how often im in that part lol)

James

[jameswilson]

ok then seen as it appears impossible to do this, how about a rollback to 7.2? I know that worked ok?

Is there an easy way to roll back? Or a hard way?

James

[byte]

Is there an easy way to roll back? Or a hard way?

There is no roll back feature (NFR ?) Unfortunately it looks like the hard way.  There is one other option but I have no idea how this will affect your system in long run, you could download the packages that worked in 7.2 and use the --oldpackage parameter when using rpm to install.

Again I don't know how this will leave your system; affect your system when doing updates. (That's my disclaimer ') )

[warren]

Quote
1054 Unknown column 'U' in 'where clause'
in:
[ SELECT zone_id FROM dbzen_zones_to_geo_zones WHERE geo_zone_id = 10 AND zone_country_id = U ORDER BY zone_id ]

This seems like purely a mysql error in that the select statement is not finding a column called 'U' in the table;

Logon as root , from console or via putty:

Code: [Select]

[root@whatever ~]# mysql dbname
Where dbname is the name of the zen database;

Then check the columns in the table : dbzen_zones_to_geo_zones

Code: [Select]

mysql>SHOW COLUMNS FROM dbzen_zones_to_geo_zones ;
Check  the columns reported against what you have in your select statement.


Is the select statement generated / saved / created by yourself, or is this called from an existing script within the zen suite ?

Did you inadvertently update zen at some stage ?

warren

[jameswilson]

Thanks
I have run the query and the names are correct but the county code is an integer data type, im guessing thats why the U fails, and no i havnt updated anything in zen. It was working before the upgrade and stopped during the upgrade. I hoped the reconfigure would fix it but alas no. What i cant understand is if that is the query being asked for then its bound to fail, or does the U mean something else. The query is part of the admin on stock zen. There are issues like this when using mysql 5 appertly if that helps.
Obvioulsy the rollback / downgrade would be the idea but there were loads of packages.
Im thinking of downloading a 7.2 cd and building a new server and restoring from a backup.

[byte]

Sorry mysql is not my bag, have you asked in a mysql specific forum ?

[jameswilson]

im assuming its a mysql thing i suppose i could be completly in the wrong area. Im wondering also if any of the configs would have been altered between 7.2 and 7.3?

[byte]

im assuming its a mysql thing i suppose i could be completly in the wrong area. Im wondering also if any of the configs would have been altered between 7.2 and 7.3?

Nothing I can think of, is it possible to do a test install on a clean 7.3 and see if zen still persists with the issue your seeing ? Don't suppose any of your logs gives you any clues ?

I would normally say raise a bug but because you have a third party package its difficult as first thing we would ask is do you have an issue with webmail which also uses mysql.

[jameswilson]

To be honest i havnt looked at the logs, for 2 reasons. 1 Im unsure what to look for, and also where would it log?

I have checked webmail and it seems fine but everything is fine apart from certain payment types in admin of zen.

Id assume a new version of zen wouldnt have this problem...maybe lol

I cant see its worth logging a bug report as im only assuming with my limited knowledge its the update but it has already been said that the chnages between shouldnt affect anything so im now thinking it must be something else.

[warren]

what version of zen are u running ?

[william_syd]

broke my zen cart

Did you follow a how-to for the Zen cart install?

[jameswilson]

it was an error in the cart, not a sme thing at all. I assumed it was a sql error but i forgot i updated something else (a credit card payment module) just before the move to sme 7.3. Shows you i should trust sme as it has never ever been at fault.

Many thanks again and sorry for wasting everyones time

James

[byte]

Glad you got it sorted