error line 1054 after upgrading database, why??

[tlyczko]

I have tried to find what causes this error 1054, which seems pretty common.

My error code is this:

1054 Unknown column 'o.orders_status' in 'where clause'
in:
[select count(*) as total from (orders s, orders_status o ) 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') ]

This is different than all the other forum posts I found on this topic.

This was a 1.2.x database upgraded to 1.3.8, using 1.3.8a code with all security patches plus additional bug patches as explained in the forums.

It occurs in admin when I click 'Orders' on the 'Customers' menu.

All the data upgraded/transferred properly, and a files search within the admin folder produced no results.

How can I fix this??

Thank you, Tom

[DrByte]

Probably this: http://www.zen-cart.com/forum/showth...457#post518457

[tlyczko]

I had already applied this bugfix before importing and upgrading the database.

The above-mentioned bugfixes that I applied are the ones listed in the forum thread provided.

This error is related to orders_status somehow.

My bug is not the exact same as described in that forum thread.

Specific step to reproduce is click the 'Orders' menu item under the word 'Customers,' the error message instantly appears.

Thank you, Tom

[DrByte]

Then that indicates that your "orders_status" table structure has been damaged.
Or, you or someone has altered the code which draws the admin orders page, perhaps orders.php or one of its dependencies.

[tlyczko]

I can try:

1) double-checking that I did the "s and o" bugfix correctly within orders.php
2) re-importing the orders_status table
3) trying out a new unpatched orders.php, then applying the patches etc.

However, I would really like to know where within the ZC code this select statement is created!! :)

Thank you, Tom

[DrByte]

However, I would really like to know where within the ZC code this select statement is created!! :)

It's built from those exact same lines as indicated in the bugfix I pointed you to: from 715-750 of /admin/orders.php.

You're probably confused by the "select count ..." difference in the beginning of the query -- that's done by the split-page class which hacks off the front list of field names from the query in order to get a count of applicable records so it can give you pagination links. There's nothing wrong with the way it's doing that. Your problem is with whatever's after the word "from" in whatever alterations you've done to it.

Or, you've got bad database content. If that's the case, you'll have a number of odd problems even on the storefront, too.


I hope you did this on a *test* area, and not directly on your live site ... right?