WebHost upgrade to mySQL 5

my webhost has upgraded their system to mySQL 5 and now my ZenCart running v1.2.6d does not work. I am not a programmer, but not a total idiot either. My cart is currently down, I am losing sales and I need to recover as quick as I can.

Any and all advice, suggestions and encouragement will be appreciated.

here is the error message you get when you try to look at products in my cart...

1054 Unknown column 'p.products_id' in 'on clause'

cart is located here: http://seasidestampin.com/zencart/index.php?main_page=

thank you very much in advance....

...joe
seaside stampin' ink

Version 1.2.6d is a year and a half or so old, and the real solution to your problem is to update to the current v1.3.7.1... however, this in not an instant fix because your template will have to be completely rebuilt to fit the v1.3 tableless configuration.

Actually, a look at your site shows that you have essentially no customization beyond the logo, so there is nothing to lose in a template switch. The only difference in appearance will be that the current version of the stock template is green instead of brown; you can easily re-add the brown background images and borders if you want.

Look at the FAQs on upgrading for instructions.
You also need to do some serious image optimization - I have a relatively fast connection and your site took forever to load. You have bunches of 50-135k thumbnails, when they should be no more than 2-5k.

The same thing happened to me. My host upgraded to MySQL 5 and now whenever I click on a product, I get this error:

1054 Unknown column 'p.products_id' in 'on clause'

I'm running version 1.2.7 and can't afford to upgrade right now. It takes too much time, practically a full site rebuild. Is there anyway to make it work with MySQL 5?

Any help would be greatly appreciated. Otherwise, I guess I'm going to have to find a host that supports MySQL version 4.

Thanks