My Server Upgraded And It Affected My Site!!!

[OneBadSuperbird]

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 www.onebadsuperbird.com .

I really don't have any computer skills.

I really appreciate any help y'all can provide.

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

[superprg]

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

[Big Kahuna]

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.

[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!!!

[superprg]

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/i...hp?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.

[Big Kahuna]

https://www.zen-cart.com/tutorials/i...hp?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?

[Big Kahuna]

https://www.zen-cart.com/tutorials/i...hp?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.

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

[OneBadSuperbird]

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!