Page 1 of 1
orders are not listed
Posted: Tue Apr 28, 2009 5:38 pm
by deter
Hi,
i have problem with OpenCart. I was editing part of finalizing of order, but suddenly i lost listing of orders in admin: No results! text and also in Orders history in customer account: there i can see listing of items and pages but orders are missing. Orders are stored in database but arent listed. I wasn't changing enigine files, only views and language files, so it is very suprising for me.
thanks for help
Re: orders are not listed
Posted: Tue Apr 28, 2009 6:20 pm
by Daniel
if you add a new language you need to go over every single page that uses multiple languages. Including order statuses, stock statuses and weights.
Re: orders are not listed
Posted: Thu Apr 30, 2009 5:09 pm
by deter
Daniel wrote:if you add a new language you need to go over every single page that uses multiple languages. Including order statuses, stock statuses and weights.
i am not sure if i understand you, i made new language from old one and implemented it. everything goes ok....
as i examined, in catalog->controller->account->history.php
there is $result variable, and this variable is empty, so i think that from some reason "$this->model_account_order->getOrders" returns nothing from database.
but i didnt make any changes in controller or model files......
if you still think that there is problem with language, please write me a details what i did wrong.
thank you very much
Re: orders are not listed
Posted: Sat May 30, 2009 5:22 am
by jbn
I also have problem with this! Anyone knows what the problem is ??
I made a copy of the english Language pack on my harddrive and renamed only english.php and the foldername to my language etc swedish.php and swedish an then uploaded the folder to the server so I had now 2 languagesin my opencart.
Re: orders are not listed
Posted: Sat May 30, 2009 6:08 am
by Daniel
you are not translating all languages!
What do you expect? Ypou change a few language files and expect it all to work!
You need to go over every language page such as products, categories , stock statuses, weights, order statuses etc..
http://wiki.opencart.com/index.php?title=Languages
Re: orders are not listed
Posted: Sat May 30, 2009 11:05 pm
by jbn
I have changed "language words" in all files in catalog/language/swedish/ and /admin/language/swedish/.
Catalog > Products <-- I have created new products
Catalog > Categories <-- I have created new categories
Catalog > Downloads <-- I have created new download products
Catalog > Information <-- I have created new informations pages
Admin > Configuration > Localisation > Stock Statuses <- <-- I have created stock statuses
Admin > Configuration > Localisation > Order Statuses <-- I have created order statuses
Admin > Configuration > Localisation > Weight CLasses <-- I have created new weight classes
Even when I change to english language my order listning doesn´t work.
Re: orders are not listed
Posted: Sun May 31, 2009 4:22 am
by Daniel
you need to first change back to english.
then go over everything translating.
i'm going to havce to add a guide for this sort of stuff.
Re: orders are not listed
Posted: Tue Jun 02, 2009 1:31 am
by b-r-a-v-e
deter wrote:Hi,
i have problem with OpenCart. I was editing part of finalizing of order, but suddenly i lost listing of orders in admin: No results! text and also in Orders history in customer account: there i can see listing of items and pages but orders are missing. Orders are stored in database but arent listed. I wasn't changing enigine files, only views and language files, so it is very suprising for me.
thanks for help
Hi, i am is the same problem with version 1.2.5
fixing problem --->
Open MySQL console and run DB query:
update order set confirm=1;
All its OK.
P.S. Sorry for my BAD English (am speaking russian, czech, bulgarian, serbian).
Re: orders are not listed
Posted: Tue Jun 02, 2009 4:09 am
by fossy
Same problem.
All is translated, I've created 3 new order_status items in my language DE
- order_status_id language_id name
1 1 Pending
2 1 Processing
2 4 Processing
3 1 Shipped
3 4 Shipped
7 1 Cancelled
5 1 Complete
5 4 Complete
8 2 offen
9 2 bezahlt
10 2 verschickt
and when I finished a new order-process the order_status_id in order-table shows 1:
The order_status "Pending" from language EN.
When I update the order_status_id in order-table to 8 (my new status) manually, my account show me the history and in admin I see the orders overview.
Don't know, what to do, I've created several orders but always the same values.

Re: orders are not listed
Posted: Tue Jun 02, 2009 5:32 am
by Daniel
Its just the way you are setting up the languages.
1. Install the language files.
2. Add the new language via admin.
3. Go over every multi-lingual page and translate:
Catalog > Products
Catalog > Categories
Catalog > Downloads
Catalog > Information
Admin > Configuration > Localisation > Stock Statuses
Admin > Configuration > Localisation > Order Statuses
Admin > Configuration > Localisation > Weight Classes
4. Goto the catalog and test each page.
Re: orders are not listed
Posted: Tue Jun 02, 2009 5:40 am
by Daniel
fossy,
What language did you make the order in?
If you made it in english the order status text will be saved in the order history.
It does not record order status id just the text from when the status was changed.
if people can edit the text it will effect all previous orders and could cause problems.
Re: orders are not listed
Posted: Tue Jun 02, 2009 6:04 am
by fossy
Hi,
no orders in english.
I've deactivate other languages and work only with Gernan language.
Latest translation files from here.
I'm not so clear with your statement...
If you made it in english the order status text will be saved in the order history.
In my order_history I can only see order_status_id, not a text!?
Re: orders are not listed
Posted: Wed Jun 10, 2009 1:28 pm
by pee
Hi,
I've got the same problem with the german language. has anybody fixed it?
Thanks for your attention.
Re: orders are not listed
Posted: Wed Jun 10, 2009 2:04 pm
by pee
When I'm in the admin-menu at "customer > orders" so I have the filter-mask there. when I put some values in it and push the filter-button, so I get a white page with the following error:
Error: Unknown column 'o.firstname' in 'where clause'
Error No: 1054
SELECT COUNT(*) AS total FROM `order` WHERE order_status_id > '0' AND CONCAT(o.firstname, ' ', lastname) LIKE '%adfadsf%' AND DATE(date_added) = DATE('2009-06-10') AND total = '9999'
Maybe this helps anybody by giving a good tip..
Additional info:
I've tested that on two servers (managed hosting + root-server) and the bug is everywhere the same. For testing I was copying the english language-files in the german language-folder (without overwritting) to be sure, that there are all files. It wasn't helping.
Re: orders are not listed
Posted: Wed Jun 10, 2009 2:51 pm
by pee
Ok, I fixed it.
The problem was the
order_status_id in the
order-table. But there are needed order-statuses in your language (my is german) at first. they can be done by the admin-menu. I've done a new standard-id with phpMyAdmin: 9 for »not sended«.
Now it's working.

Re: orders are not listed
Posted: Wed Jul 22, 2009 2:07 pm
by cluv
Does anyone know how to fix this problem? On the Customers >> Orders
I use the filter on this page with a Customer Name value. With any Customer Name value it returns this URL:
shop/admin/index.php?route=customer/order&filter_name=Doug
And returns the following statement on a blank white page:
Error: Unknown column 'o.firstname' in 'where clause'
Error No: 1054
SELECT COUNT(*) AS total FROM `order` WHERE order_status_id > '0' AND CONCAT(o.firstname, ' ', lastname) LIKE '%Doug%'
Is there a fix for this?
Also, the Order ID is non-functional, no error, just no response from applying filter with any Order ID values.
However, Status, Date Added, and Total work just fine with any values, the filter works great and returns information.
Any help is greatly appreciated.