OpenCart Community

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

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.

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

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.

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

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.

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.

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

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.

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.

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.

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!?

Hi,

I've got the same problem with the german language. has anybody fixed it?

Thanks for your attention.

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.

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.

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.