If this is your first visit, check our documentation. To post, register or login.
Forums / Bug Reports / [Duplicate] Search Error: "1054 Unknown column 'o.orders_id' in 'on clause' " - Admin

[Duplicate] Search Error: "1054 Unknown column 'o.orders_id' in 'on clause' " - Admin

Locked

Started by winterfun on 15 Nov 2010, 1:57 AM · Views: 1,506

Results 1 to 5 of 5
This thread is locked. New replies are disabled.
15 Nov 2010, 1:57 AM
#1
winterfun avatar

winterfun

New Zenner

Join Date:
Nov 2009
Posts:
2
Plugin Contributions:
0

[Duplicate] Search Error: "1054 Unknown column 'o.orders_id' in 'on clause' " - Admin

PHP Version: 5.2.9 (Zend: 2.2.0)

Login
Click first New Order
Enter any text into field: Search by Product Name or ID:XX or Model

  • partial or full model name
    Hit Enter
    Receive this msg:

1054 Unknown column 'o.orders_id' in 'on clause'
in:
[select count(distinct o.orders_id) as total from (zen_orders o, zen_orders_status s left join zen_orders_products op on (op.orders_id = o.orders_id) ) left join zen_orders_total ot on (o.orders_id = ot.orders_id) where (o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total') and (op.products_model like '%S1%' or op.products_name like 'S1%')]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

15 Nov 2010, 4:39 AM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: [Duplicate] Search Error: "1054 Unknown column 'o.orders_id' in 'on clause' " - Admin

What ver of mysql
What ver of ZenCart

Zen-Venom Get Bitten

15 Nov 2010, 12:11 PM
#3
winterfun avatar

winterfun

New Zenner

Join Date:
Nov 2009
Posts:
2
Plugin Contributions:
0

Re: [Duplicate] Search Error: "1054 Unknown column 'o.orders_id' in 'on clause' " - Admin

Database: MySQL 5.1.51
Zen Cart 1.3.8a
Patch: 1::
Database Patch Level: 1.3.8
Build Date: Jul 1 2010 00:43:22

15 Nov 2010, 4:59 PM
#4
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: [Duplicate] Search Error: "1054 Unknown column 'o.orders_id' in 'on clause' " - Admin

PHP Version: 5.2.9
Zen Cart 1.3.8a
Using the older 1.3.8a suggest you upgrade to 1.3.9h

Zen-Venom Get Bitten

15 Nov 2010, 5:33 PM
#5
drbyte avatar

drbyte

Sensei

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

Re: [Duplicate] Search Error: "1054 Unknown column 'o.orders_id' in 'on clause' " - Admin

That's a known bug in the very old version you're running.
Discussed here: http://www.zen-cart.com/forum/showthread.php?p=518457#post518457
And as kobra mentioned, was fixed in v1.3.9.

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