If this is your first visit, check our documentation. To post, register or login.
Forums / General Questions / error message: 1054 Unknown column 'p.products_id' in 'on clause'

error message: 1054 Unknown column 'p.products_id' in 'on clause'

Locked

Started by elnaraniall on 4 Jan 2008, 2:33 AM · Views: 2,331

Results 1 to 16 of 16
This thread is locked. New replies are disabled.
4 Jan 2008, 2:33 AM
#1
elnaraniall avatar

elnaraniall

New Zenner

Join Date:
Feb 2006
Posts:
23
Plugin Contributions:
0

error message: 1054 Unknown column 'p.products_id' in 'on clause'

Hi guys!

I use ZEn Cart for my online catalog. It was working fine until 2 hours ago. Suddenly when browsing the catalog, the categories and the products do not display anymore, instead there is an error message:

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

What do I do to fix that?

Thank you so much in advance!

4 Jan 2008, 2:46 AM
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: error message: 1054 Unknown column 'p.products_id' in 'on clause'

There are some "related posts" at the bottom of this page which should help you sort it out.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

4 Jan 2008, 2:56 AM
#3
elnaraniall avatar

elnaraniall

New Zenner

Join Date:
Feb 2006
Posts:
23
Plugin Contributions:
0

Re: error message: 1054 Unknown column 'p.products_id' in 'on clause'

Thank you! I read those, but am a bit confused.

So, do I upgrade the Zen Cart version and then somehow import the databases containing my current information?

4 Jan 2008, 2:59 AM
#4
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: error message: 1054 Unknown column 'p.products_id' in 'on clause'

Did your hosting company recently tell you that they were upgrading their PHP or MySQL software?
What version of PHP and MySQL is your site using?

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

4 Jan 2008, 3:02 AM
#5
elnaraniall avatar

elnaraniall

New Zenner

Join Date:
Feb 2006
Posts:
23
Plugin Contributions:
0

Re: error message: 1054 Unknown column 'p.products_id' in 'on clause'

no, they didn't!

The MySQL is : Database: MySQL 5.0.27-standard-log
the PHP is : PHP Version 4.4.7

4 Jan 2008, 3:14 AM
#6
merlinpa1969 avatar

merlinpa1969

Totally Zenned

Join Date:
Mar 2004
Posts:
13,031
Plugin Contributions:
4

Re: error message: 1054 Unknown column 'p.products_id' in 'on clause'

you will need to upgrade your zen cart to a 1.3.x
1.3.7 or higher are the best,

Zen cart PCI compliant Hosting

4 Jan 2008, 3:20 AM
#7
elnaraniall avatar

elnaraniall

New Zenner

Join Date:
Feb 2006
Posts:
23
Plugin Contributions:
0

Re: error message: 1054 Unknown column 'p.products_id' in 'on clause'

Thanks! I just got off the phone with my hosting, they said the same. They also said I did not have to download the full new version, that there were scripts I could run to do the upgrade?

4 Jan 2008, 3:30 AM
#8
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: error message: 1054 Unknown column 'p.products_id' in 'on clause'

elnaraniall:

Thanks! I just got off the phone with my hosting, they said the same. They also said I did not have to download the full new version, that there were scripts I could run to do the upgrade?

Well, if they believe they are experts in that area, perhaps they can coach you in the process, and help you when their advice fails to work properly.

Here are the normal upgrade instructions:
https://www.zen-cart.com/tutorials/index.php?article=108

Upgrading is not a task to be taken lightly. Especially if you have a lot of customizations or have a lot of versions to upgrade from.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

4 Jan 2008, 3:57 AM
#9
elnaraniall avatar

elnaraniall

New Zenner

Join Date:
Feb 2006
Posts:
23
Plugin Contributions:
0

Re: error message: 1054 Unknown column 'p.products_id' in 'on clause'

I will probably have to do a lot of customizations, my previous version is 1.2.6

4 Jan 2008, 4:00 AM
#10
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,512
Plugin Contributions:
176

Re: error message: 1054 Unknown column 'p.products_id' in 'on clause'

When upgrading from v1.2.x to v1.3.x, it is best to plan to rebuild your template and your customizations. There were significant template changes. It'll likely be less work to rebuild than to try to simply convert each file.

A script is supplied to handle your database data.

Follow the tutorial mentioned above. It'll take you through the process.
It's not something you'll likely complete overnight though.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

4 Jan 2008, 5:19 PM
#11
elnaraniall avatar

elnaraniall

New Zenner

Join Date:
Feb 2006
Posts:
23
Plugin Contributions:
0

Re: error message: 1054 Unknown column 'p.products_id' in 'on clause'

OK, so here is what happens:

I was able to ssuccessfully carry all mys ettings to the new version

The problem is with the database.

The information from the old database does not want to carry on to the new one

What do I do?

4 Jan 2008, 5:21 PM
#12
merlinpa1969 avatar

merlinpa1969

Totally Zenned

Join Date:
Mar 2004
Posts:
13,031
Plugin Contributions:
4

Re: error message: 1054 Unknown column 'p.products_id' in 'on clause'

you should have made a backup copy of the old database,
then using the zc_install run the upgrade on the database,

it will make all the changes needed

Zen cart PCI compliant Hosting

4 Jan 2008, 5:27 PM
#13
elnaraniall avatar

elnaraniall

New Zenner

Join Date:
Feb 2006
Posts:
23
Plugin Contributions:
0

Re: error message: 1054 Unknown column 'p.products_id' in 'on clause'

Oh! I do have a copy of the old database!

But I am not really a wizard concerning this, so sorry if I seem a bit stupid.

So, after I carry on all my canges form the settings, I try to run the script for database upgrade? Is that it?

4 Jan 2008, 5:54 PM
#14
elnaraniall avatar

elnaraniall

New Zenner

Join Date:
Feb 2006
Posts:
23
Plugin Contributions:
0

Re: error message: 1054 Unknown column 'p.products_id' in 'on clause'

I never get prompted for a database upgrade, I am getting so confused

4 Jan 2008, 6:39 PM
#15
elnaraniall avatar

elnaraniall

New Zenner

Join Date:
Feb 2006
Posts:
23
Plugin Contributions:
0

Re: error message: 1054 Unknown column 'p.products_id' in 'on clause'

Here is what I found out so far:

  1. Do the new install of ZenCart 1.3.8., in a new folder with a new database - did that

  2. Seems I need to upgrade the existing database using the scripts in the zc_install folder - did that, but it only upgraded to from 1.2.6 (current version) to 1.2.7. When upgrading from 1.2.7 up, get error messages

  3. Then I import the old database into the new one

I think the logic is correct - but how do I deal with the errors when upgrading the database?