My Server Upgraded And It Affected My Site!!!

HELP!!!

My server upgraded from php 4.4.4 to php 5 and it has adversely affected my site.

When you click on any of the products, you get an error message that reads as follows...

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

The store address is https://www.onebadsuperbird.com .

I really don't have any computer skills.

I really appreciate any help y'all can provide.

What Zen Cart version do you have?

I remember reading a post a few minutes ago saying that 1.2.6 won't be compatible with PHP 5. So if you have 1.2.6 or below, you will most likely need to upgrade to the newest version, 1.3.8a.

http://www.zen-cart.com/forum/showthread.php?t=37460

Steven300:

What Zen Cart version do you have?

I remember reading a post a few minutes ago saying that 1.2.6 won't be compatible with PHP 5. So if you have 1.2.6 or below, you will most likely need to upgrade to the newest version, 1.3.8a.

If you are hosed from even being able to log into admin -- how do you find the version?

Also do all previous versions upgrade to the most current version? I remember reading something that about the newer version was rewritten and the entire look and feel templates would need to be redone new style.

Thanks for the quick replies!

It looks like I need to upgrade my ZenCart.

How do I do this? Keep in mind that I am a total computer dummy.

Thanks again!!!

OneBadSuperbird:

Thanks for the quick replies!

It looks like I need to upgrade my ZenCart.

How do I do this? Keep in mind that I am a total computer dummy.

Thanks again!!!

https://www.zen-cart.com/tutorials/index.php?article=108

Let us know if you need any additional help!

Hey Dave (Big Kahuna) thanks for posting here.

I just went and looked at the link and my head started spinning. This technical stuff definitely ain't for me.

superprg:

https://www.zen-cart.com/tutorials/index.php?article=108

Let us know if you need any additional help!

What's the quickest wast to see what version you are at -- if you are hosed and can't log into the admin.

Are any of the php programs going to have the exact version in it -- or is there a field in the database I can go to for the version being run? You can't upgrade without know in the starting points.

Also -- do the upgrade scripts have any problem making the upgrade is MYSQL5 is what the server uses?

superprg:

https://www.zen-cart.com/tutorials/index.php?article=108

Let us know if you need any additional help!

OneBadSuperbird:

Hey Dave (Big Kahuna) thanks for posting here.

I just went and looked at the link and my head started spinning. This technical stuff definitely ain't for me.

I might have a fix for this to work with MYSQL5 -- until you get someone to upgrade for you.

Big Kahuna:

I might have a fix for this to work with MYSQL5 -- until you get someone to upgrade for you.That would be awesome!

I'm ready to do the upgrade but I don't want to screw anytihng up or lose anything I already had in the database. It took me forever to get all the stuff in the database!

OneBadSuperbird:

I'm ready to do the upgrade but I don't want to screw anytihng up or lose anything I already had in the database. It took me forever to get all the stuff in the database!

Regardless how much pressure you're under, you should always upgrade in a test area ... ie: another folder+database.

If you follow the upgrade instructions, you'll see that they talk about the fact that your actual database data will be preserved during the upgrade, and gives instructions how to do the database step after you've upgraded all your templates and other customized files.

But, no matter which method you choose, it's always up to YOU to make good BACKUPS of your files and database content just in case something doesn't go according to plan.