error 1054 Unknown column 'p.products

25 Oct 2007, 3:32 AM

New Zenner

Join Date:: Jan 2006
Posts:: 14
Plugin Contributions:: 0

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

Hello, i'm using version 1.2.5 and my hosting company just upgraded to SQL 5 and now i'm getting an error in my categories page 1054 Unknown column 'p.products_id' in 'on clause'. I know I need to upgrade to the newest version but is there a quick fix to get my store back up and running in the meantime and then I can have someone work on migrating everything over?

thanks in advance for any help!!
,Jason
https://www.locarbu.com

25 Oct 2007, 3:34 AM

drbyte

Sensei

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

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

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

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