1054 Unknown column 'o.orders_id' in 'on clause'

[fergusmacdonald]

Has anyone found a solution to this problem yet? I've tried the code changes outlined and it still doesn't work.

Thanks,
Fergus

[michaelhl]

Hi,
There is no solution until now. It seems that not everybody has this problem and so it is hard for the developers to solve this mistake.
I can live without using this feature.

[DrByte]

If you're having this problem, please post the following information:

- version of Zen Cart
- list of addons/contributions installed
- version of PHP
- version of MySQL
- whether hosted on linux vs windows
- example search-term which triggers the error
- and please confirm that you're *only* getting this error when doing a search using the "Search by Product Name or ID:XX or Model" field. If there are other places, that information is important as well.

[fergusmacdonald]

Details:

Zen Cart Version: 1.3.8a
Add-ons installed: Super Orders 2.0, Admin Notes file, Big Royal Mail 2.2.1a1, Capitalize Signup Fields 1.0b, Categories Menu Yahoo Tree Menu with Ajax, Fual Slimbox v0.1.5, Ultimate SEO URL's 2.106.
PHP Version: 5.1.6 (Zend: 2.1.0)
MySQL Version: 5.0.54
Hosted On: Linux
Example: Royal

Error: 1054 Unknown column 'o.orders_id' in 'on clause'
in:
[select count(distinct o.orders_id) as total from (orders o, orders_status s left join orders_products op on (op.orders_id = o.orders_id) ) left join 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 '%Royal%' or op.products_name like 'Royal%')]

I've tried a number of searches and get this error every time, only from the "Search by Product Name or ID:XX or Model" box, the standard "Search" box and Order ID searches work fine.

[DrByte]

Add-ons installed: Super Orders 2.0

And is this happening when using the Super Orders interface?

[fergusmacdonald]

And is this happening when using the Super Orders interface?

No, the Super Orders interface does not have a "Search by Product Name or ID:XX or Model" field.

On the regular Customers>Orders page.

[DrByte]

In the /admin/orders.php, from lines 715 thru 750 there are three places where the following is found:

                          from (" . TABLE_ORDERS . " o, " .
                          TABLE_ORDERS_STATUS . " s " .

change each of those to this instead:

                            from (" . TABLE_ORDERS_STATUS . " s, " .
                            TABLE_ORDERS . " o " .

[fergusmacdonald]

Fantastic, thank you very much - the problem is solved. Search box working properly.

[dbrewster]

Rock on, Dr. Byte!

Works like a charm, thank you!!

[helpme]

That works great, but as soon as I did that now I can not view an order from customers>customers>orders I get this error:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select o.orders_id, o.customers_id, o.customers_name, o.payment_method, o.shippi' at line 1
in:
[select count(*) as total select o.orders_id, o.customers_id, o.customers_name, o.payment_method, o.shipping_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, o.fedex_tracking, ot.text as order_total, o.customers_company, o.customers_email_address, o.customers_street_address, o.delivery_company, o.delivery_name, o.delivery_street_address, o.billing_company, o.billing_name, o.billing_street_address, o.payment_module_code, o.shipping_module_code, o.ip_address from (orders_status s, orders o ) left join orders_total ot on (o.orders_id = ot.orders_id) where o.customers_id = '1310' and o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total']
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.

any ideas?? thanks!