Zen Cart Logo
Forums / General Questions / Zen cart error : 1054 Unknown column 'p.products_id' in 'on clause'

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

Locked

Started by scorpio on 10 Jun 2008, 10:24 AM · Views: 1,477

Results 1 to 6 of 6
This thread is locked. New replies are disabled.
10 Jun 2008, 10:24 AM
#1
scorpio avatar

scorpio

New Zenner

Join Date:
Jun 2008
Posts:
2
Plugin Contributions:
0

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

Hello,

We have recently upgraded mysql in the server to 5.0.5 and the zen cart is having version 3.8a. Accessing the zen cart is giving the following error as:

1054 Unknown column 'p.products_id' in 'on clause'
in:
[select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, p.products_date_added, p.products_price, p.products_type, p.master_categories_id, pov.products_options_values_name from products p, products_description pd LEFT JOIN products_attributes pa ON pa.products_id = p.products_id AND pa.products_options_sort_order = 0 LEFT JOIN products_options_values pov ON pov.products_options_values_id = pa.options_values_id where p.products_id = pd.products_id and pd.language_id = '1' and p.products_status = 1 ]

We have tried all the optins in the post http://www.zen-cart.com/forum/showthread.php?t=73662 . Please assist.

Thanks,
Scorpio.

10 Jun 2008, 2:13 PM
#2
drbyte avatar

drbyte

Sensei

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

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

What addons do you have installed?
Can you go to Admin->Tools->Server Info, and copy/paste all the info from above the "PHP Info" section here.

Seems to me that you don't really have 1.3.8 on your site, or that error wouldn't be showing.

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

10 Jun 2008, 6:53 PM
#3
scorpio avatar

scorpio

New Zenner

Join Date:
Jun 2008
Posts:
2
Plugin Contributions:
0

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

Thanks :smile:

The server info is pasted below:

Server Host: craftaroo.com (203.194.220.67)
PHP Version: 4.4.8 (Zend: 1.3.0) PHP Memory Limit: 80M
PHP File Uploads: On Max Size: 8M
Database Data Size: 869 kB
Database: MySQL 5.0.51-log
HTTP Server: Apache
PHP Safe Mode: Off
POST Max Size: 40M
Database Index Size: 481 kB

10 Jun 2008, 7:25 PM
#4
drbyte avatar

drbyte

Sensei

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

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

How about the version history below that?

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

1 Jul 2008, 8:03 PM
#5
photographicwarranty avatar

photographicwarranty

New Zenner

Join Date:
Mar 2008
Posts:
4
Plugin Contributions:
0

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

I am receiving the same "1054 Unknown column 'p.zen_order_id' in 'on clause'" error.

I am receiving PayPal payments but the orders are not being processed.

Server Host: marth (67.205.15.118)
Server OS: Linux 2.4.32-grsec+f6b+gr217+nfs+a32+fuse23+tg+++opt+c8+gr2b-v6.194
PHP Version: 4.4.8 (Zend: 1.3.0)
Database: MySQL 5.0.45-log
HTTP Server: Apache/2.0.61 (Unix) PHP/4.4.7 mod_ssl/2.0.61 OpenSSL/0.9.7e mod_fastcgi/2.4.2 DAV/2 SVN/1.4.2

Zen Cart 1.3.7
Database Patch Level: 1.3.8

2 Jul 2008, 7:49 PM
#6
drbyte avatar

drbyte

Sensei

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

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

PhotographicWarranty:

Zen Cart 1.3.7
Database Patch Level: 1.3.8
You'll need to fix your version-mismatch problem first.

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