1054 Unknown column 'p.products

5 Jan 2009, 7:51 AM

#1

New Zenner

Join Date:: Mar 2007
Posts:: 3
Plugin Contributions:: 0

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

Hi, I am terribly new at this. I was looking at this thread for suggestions (my error message is a bit different though), but in searching my Admin order.php I only find 299 lines. Am I in the wrong file? Your help is appreciated.

5 Jan 2009, 4:40 PM

#2

sawhorse

Zen Follower

Join Date:: Oct 2007
Location:: Kentucky - USA
Posts:: 425
Plugin Contributions:: 0

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

**You may be looking at /admin/includes/languages/english/orders.php

If you need the file we are talking about you should look at ****/admin/orders.php

Sawhorse
**

ZC 1.3.8a; Addons: Admin Profiles, Ty Package Tracker; Swap Images via MouseOver or Click, Smart Backgrounds; Printable Price List; CSS buttons; Contact Us - Add Subject; Template: Self Constructed; Site: http://sawhorsejewelry.com

5 Jan 2009, 7:19 PM

#3

drbyte

Sensei

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

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

I suggest looking at the "Similar Threads" list below, for discussions related to your error message, rather than a different message.

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

5 Jan 2009, 7:36 PM

#4

sawhorse

Zen Follower

Join Date:: Oct 2007
Location:: Kentucky - USA
Posts:: 425
Plugin Contributions:: 0

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

Just a quick search and I found this: http://www.zen-cart.com/forum/showthread.php?p=662097&highlight=p.products_id#post662097 There are also other active threads.

You are not alone with this issue.

Good luck,
Sawhorse

ZC 1.3.8a; Addons: Admin Profiles, Ty Package Tracker; Swap Images via MouseOver or Click, Smart Backgrounds; Printable Price List; CSS buttons; Contact Us - Add Subject; Template: Self Constructed; Site: http://sawhorsejewelry.com