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
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
i am not sure if i understand you, i made new language from old one and implemented it. everything goes ok....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.
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.
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
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.
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.
Hi, i am is the same problem with version 1.2.5deter 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
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
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.
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
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.
Dirk
--
...it' never too late!
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.
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.
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...
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...
In my order_history I can only see order_status_id, not a text!?If you made it in english the order status text will be saved in the order history.
Dirk
--
...it' never too late!
Hi,
I've got the same problem with the german language. has anybody fixed it?
Thanks for your attention.
I've got the same problem with the german language. has anybody fixed it?
Thanks for your attention.
Professionelles Onlineshop-Design & -Programmierung: http://netzor.de
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:
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.
Maybe this helps anybody by giving a good tip..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'
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.
Professionelles Onlineshop-Design & -Programmierung: http://netzor.de
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.
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.
Professionelles Onlineshop-Design & -Programmierung: http://netzor.de
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.
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.
Who is online
Users browsing this forum: No registered users and 147 guests