[Skip to main content](#vessel-content) # Orders at the back end ## - **[Remko](/forum/user/7328-remko "View Remko's Profile")** - [![Remko's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar7328.jpg)](/forum/user/7328-remko "View Remko's Profile") Topic Author - [ Offline](/forum/user/7328-remko) - Like HikaShop very much Less More - Posts: 46 - Thank you received: 0 - - - - [](http://www.edsmusic.nl/) - 14 years 1 month ago [\#67563](#67563) by [Remko](/forum/user/7328-remko "View Remko's Profile") *[Orders at the back end](/forum/3-bug-report/67563-orders-at-the-back-end#67563 "Hi, For me it's not possible to Add a non existing product at the back end when I create a new order or edit an existing order. It's also not possible to delete a product from an order in the back end. In both situations the "pop-up"/overlay screen appears, where I can confirm that I want to delete that item of where I can fill in the information of the product. But when I click on OK, the form gets blank, but futhermore nothing happens. I'm using the business version of 1.6.0. Kind Regards Remko Rijpkema")* was created by *[Remko](/forum/user/7328-remko "View Remko's Profile")* Hi, For me it's not possible to Add a non existing product at the back end when I create a new order or edit an existing order. It's also not possible to delete a product from an order in the back end. In both situations the "pop-up"/overlay screen appears, where I can confirm that I want to delete that item of where I can fill in the information of the product. But when I click on OK, the form gets blank, but futhermore nothing happens. I'm using the business version of 1.6.0. Kind Regards Remko Rijpkema Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC82NzU2My1vcmRlcnMtYXQtdGhlLWJhY2stZW5kP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 14 years 1 month ago [\#67584](#67584) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[Re: Orders at the back end](/forum/3-bug-report/67563-orders-at-the-back-end#67584 "Hi, For me it's not possible to Add a non existing product at the back end when I create a new order or edit an existing order. It's also not possible to delete a product from an order in the back end. In both situations the "pop-up"/overlay screen appears, where I can confirm that I want to delete that item of where I can fill in the information of the product. But when I click on OK, the form gets blank, but futhermore nothing happens. I'm using the business version of 1.6.0. Kind Regards Remko Rijpkema")* Hi, I would recommend to turn on the debug mode and the error reporting options of the joomla configuration and try again. That should display an error message instead of a blank page and help us understand what is going on. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC82NzU2My1vcmRlcnMtYXQtdGhlLWJhY2stZW5kP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[Remko](/forum/user/7328-remko "View Remko's Profile")** - [![Remko's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar7328.jpg)](/forum/user/7328-remko "View Remko's Profile") Topic Author - [ Offline](/forum/user/7328-remko) - Like HikaShop very much Less More - Posts: 46 - Thank you received: 0 - - - - [](http://www.edsmusic.nl/) - 14 years 1 month ago [\#68016](#68016) by [Remko](/forum/user/7328-remko "View Remko's Profile") Replied by *[Remko](/forum/user/7328-remko "View Remko's Profile")* on topic *[Re: Orders at the back end](/forum/3-bug-report/67563-orders-at-the-back-end#68016 "Hi, For me it's not possible to Add a non existing product at the back end when I create a new order or edit an existing order. It's also not possible to delete a product from an order in the back end. In both situations the "pop-up"/overlay screen appears, where I can confirm that I want to delete that item of where I can fill in the information of the product. But when I click on OK, the form gets blank, but futhermore nothing happens. I'm using the business version of 1.6.0. Kind Regards Remko Rijpkema")* Hi, When I try to delete a product form an order at the back end, the following message appears in debug mode: 500 - An error has occurred. JDatabaseMySQL::query: 1054 - Unknown column 'product' in 'field list' SQL=UPDATE `jos_hikashop_order` SET `product`='',`order_modified`='1349078740' WHERE order_id='96' Call stack \# Function Location 1 JAdministrator->dispatch() /home/edsmusic/domains/edsmusic.nl/public_html/administrator/index.php:67 2 JComponentHelper->renderComponent() /home/edsmusic/domains/edsmusic.nl/public_html/administrator/includes/application.php:136 3 require_once() /home/edsmusic/domains/edsmusic.nl/public_html/libraries/joomla/application/component/helper.php:162 4 hikashopController->execute() /home/edsmusic/domains/edsmusic.nl/public_html/administrator/components/com_hikashop/admin.hikashop.php:43 5 JController->execute() /home/edsmusic/domains/edsmusic.nl/public_html/administrator/components/com_hikashop/helpers/helper.php:1005 6 OrderController->saveproduct() /home/edsmusic/domains/edsmusic.nl/public_html/libraries/joomla/application/component/controller.php:236 7 OrderController->_save() /home/edsmusic/domains/edsmusic.nl/public_html/administrator/components/com_hikashop/controllers/order.php:273 8 hikashopOrderClass->save() /home/edsmusic/domains/edsmusic.nl/public_html/administrator/components/com_hikashop/controllers/order.php:367 9 hikashopClass->save() /home/edsmusic/domains/edsmusic.nl/public_html/administrator/components/com_hikashop/classes/order.php:114 10 JDatabaseMySQL->updateObject() /home/edsmusic/domains/edsmusic.nl/public_html/administrator/components/com_hikashop/helpers/helper.php:1100 11 JDatabaseMySQL->query() /home/edsmusic/domains/edsmusic.nl/public_html/libraries/joomla/database/database/mysql.php:583 12 JError->raiseError() /home/edsmusic/domains/edsmusic.nl/public_html/libraries/joomla/database/database/mysql.php:231 13 JError->raise() /home/edsmusic/domains/edsmusic.nl/public_html/libraries/joomla/error/error.php:171 14 JException->__construct() /home/edsmusic/domains/edsmusic.nl/public_html/libraries/joomla/error/error.php:136 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC82NzU2My1vcmRlcnMtYXQtdGhlLWJhY2stZW5kP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[Remko](/forum/user/7328-remko "View Remko's Profile")** - [![Remko's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar7328.jpg)](/forum/user/7328-remko "View Remko's Profile") Topic Author - [ Offline](/forum/user/7328-remko) - Like HikaShop very much Less More - Posts: 46 - Thank you received: 0 - - - - [](http://www.edsmusic.nl/) - 14 years 1 month ago [\#68017](#68017) by [Remko](/forum/user/7328-remko "View Remko's Profile") Replied by *[Remko](/forum/user/7328-remko "View Remko's Profile")* on topic *[Re: Orders at the back end](/forum/3-bug-report/67563-orders-at-the-back-end#68017 "Hi, For me it's not possible to Add a non existing product at the back end when I create a new order or edit an existing order. It's also not possible to delete a product from an order in the back end. In both situations the "pop-up"/overlay screen appears, where I can confirm that I want to delete that item of where I can fill in the information of the product. But when I click on OK, the form gets blank, but futhermore nothing happens. I'm using the business version of 1.6.0. Kind Regards Remko Rijpkema")* This is the error message when I try to add a product to an order (With "Add", **not** with "Add an existing product"). 500 - An error has occurred. JDatabaseMySQL::query: 1054 - Unknown column 'product' in 'field list' SQL=UPDATE `jos_hikashop_order` SET `product`='',`order_modified`='1349078954' WHERE order_id='96' Call stack \# Function Location 1 JAdministrator->dispatch() /home/edsmusic/domains/edsmusic.nl/public_html/administrator/index.php:67 2 JComponentHelper->renderComponent() /home/edsmusic/domains/edsmusic.nl/public_html/administrator/includes/application.php:136 3 require_once() /home/edsmusic/domains/edsmusic.nl/public_html/libraries/joomla/application/component/helper.php:162 4 hikashopController->execute() /home/edsmusic/domains/edsmusic.nl/public_html/administrator/components/com_hikashop/admin.hikashop.php:43 5 JController->execute() /home/edsmusic/domains/edsmusic.nl/public_html/administrator/components/com_hikashop/helpers/helper.php:1005 6 OrderController->saveproduct() /home/edsmusic/domains/edsmusic.nl/public_html/libraries/joomla/application/component/controller.php:236 7 OrderController->_save() /home/edsmusic/domains/edsmusic.nl/public_html/administrator/components/com_hikashop/controllers/order.php:273 8 hikashopOrderClass->save() /home/edsmusic/domains/edsmusic.nl/public_html/administrator/components/com_hikashop/controllers/order.php:367 9 hikashopClass->save() /home/edsmusic/domains/edsmusic.nl/public_html/administrator/components/com_hikashop/classes/order.php:114 10 JDatabaseMySQL->updateObject() /home/edsmusic/domains/edsmusic.nl/public_html/administrator/components/com_hikashop/helpers/helper.php:1100 11 JDatabaseMySQL->query() /home/edsmusic/domains/edsmusic.nl/public_html/libraries/joomla/database/database/mysql.php:583 12 JError->raiseError() /home/edsmusic/domains/edsmusic.nl/public_html/libraries/joomla/database/database/mysql.php:231 13 JError->raise() /home/edsmusic/domains/edsmusic.nl/public_html/libraries/joomla/error/error.php:171 14 JException->__construct() /home/edsmusic/domains/edsmusic.nl/public_html/libraries/joomla/error/error.php:136 Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC82NzU2My1vcmRlcnMtYXQtdGhlLWJhY2stZW5kP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86323 - Thank you received: 14283 - - 14 years 1 month ago [\#68154](#68154) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Orders at the back end](/forum/3-bug-report/67563-orders-at-the-back-end#68154 "Hi, For me it's not possible to Add a non existing product at the back end when I create a new order or edit an existing order. It's also not possible to delete a product from an order in the back end. In both situations the "pop-up"/overlay screen appears, where I can confirm that I want to delete that item of where I can fill in the information of the product. But when I click on OK, the form gets blank, but futhermore nothing happens. I'm using the business version of 1.6.0. Kind Regards Remko Rijpkema")* Hi, That comes from an update problem. Try to follow that: Change the "version" entry of the table "hikashop_config" to the previous version of HikaShop you had via phpmyadmin. Rename the folder administrator/components/com_hikashop to something else via FTP. Install again the latest version. That should hopefully fix the problem. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC82NzU2My1vcmRlcnMtYXQtdGhlLWJhY2stZW5kP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[Remko](/forum/user/7328-remko "View Remko's Profile")** - [![Remko's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar7328.jpg)](/forum/user/7328-remko "View Remko's Profile") Topic Author - [ Offline](/forum/user/7328-remko) - Like HikaShop very much Less More - Posts: 46 - Thank you received: 0 - - - - [](http://www.edsmusic.nl/) - 14 years 1 month ago [\#68354](#68354) by [Remko](/forum/user/7328-remko "View Remko's Profile") Replied by *[Remko](/forum/user/7328-remko "View Remko's Profile")* on topic *[Re: Orders at the back end](/forum/3-bug-report/67563-orders-at-the-back-end#68354 "Hi, For me it's not possible to Add a non existing product at the back end when I create a new order or edit an existing order. It's also not possible to delete a product from an order in the back end. In both situations the "pop-up"/overlay screen appears, where I can confirm that I want to delete that item of where I can fill in the information of the product. But when I click on OK, the form gets blank, but futhermore nothing happens. I'm using the business version of 1.6.0. Kind Regards Remko Rijpkema")* I was very hopefull, but it did not work. ![:(](/media/kunena/emoticons/22.png ":(") In MyPhpAdmin I've set the version to 1.5.7, renamed the administrator/components/com_hikashop map and installed 1.6.0 again. The version number was automaticly updated to 1.6.0 again (of course) and the new administrator/components/com_hikashop map was created. So everything as planned, but not with the result I hoped for. You can see whats happening in a video on YouTube: [ www.youtube.com/watch?v=oHoDDLUXbqA](http://www.youtube.com/watch?v=oHoDDLUXbqA) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC82NzU2My1vcmRlcnMtYXQtdGhlLWJhY2stZW5kP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86323 - Thank you received: 14283 - - 14 years 1 month ago [\#68553](#68553) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Orders at the back end](/forum/3-bug-report/67563-orders-at-the-back-end#68553 "Hi, For me it's not possible to Add a non existing product at the back end when I create a new order or edit an existing order. It's also not possible to delete a product from an order in the back end. In both situations the "pop-up"/overlay screen appears, where I can confirm that I want to delete that item of where I can fill in the information of the product. But when I click on OK, the form gets blank, but futhermore nothing happens. I'm using the business version of 1.6.0. Kind Regards Remko Rijpkema")* Well, I don't know why you still have that problem, but you can remove the query error by simply creating a custom field of the table "order" with the column name "product" via the menu Display->Custom fields. Just leave it unpublished after creating it. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC82NzU2My1vcmRlcnMtYXQtdGhlLWJhY2stZW5kP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[Remko](/forum/user/7328-remko "View Remko's Profile")** - [![Remko's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar7328.jpg)](/forum/user/7328-remko "View Remko's Profile") Topic Author - [ Offline](/forum/user/7328-remko) - Like HikaShop very much Less More - Posts: 46 - Thank you received: 0 - - - - [](http://www.edsmusic.nl/) - 14 years 1 month ago - 14 years 1 month ago [\#68598](#68598) by [Remko](/forum/user/7328-remko "View Remko's Profile") Replied by *[Remko](/forum/user/7328-remko "View Remko's Profile")* on topic *[Re: Orders at the back end](/forum/3-bug-report/67563-orders-at-the-back-end#68598 "Hi, For me it's not possible to Add a non existing product at the back end when I create a new order or edit an existing order. It's also not possible to delete a product from an order in the back end. In both situations the "pop-up"/overlay screen appears, where I can confirm that I want to delete that item of where I can fill in the information of the product. But when I click on OK, the form gets blank, but futhermore nothing happens. I'm using the business version of 1.6.0. Kind Regards Remko Rijpkema")* Thanks for you reply. ![:)](/media/kunena/emoticons/3.png ":)") I added the the custom column name and yes, the error disappeared. (Errot was only displayed in debug mode.) But still it's not possible for me to delete any products from an order and I can not add new products (both at back end). ![:(](/media/kunena/emoticons/22.png ":(") When uprading for the first time from 1.5.7 to 1.6.0 there were some problems (I do not remember the details). The second attempt to upgrade seemed to be more succesfull. Some settings at the custom CSS file were gone and some other lay out things were changed, but I was able to repair these things. So I was not surprised that you gave me the advice to upgrade again. Unfortunately it did not work. If needed, I can also send you the messages that appear in Debug Mode before I click OK. I hope you have other options to try. Last edit: 14 years 1 month ago by [Remko](/forum/user/7328-remko "View Remko's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC82NzU2My1vcmRlcnMtYXQtdGhlLWJhY2stZW5kP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86323 - Thank you received: 14283 - - 14 years 4 weeks ago [\#68796](#68796) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Orders at the back end](/forum/3-bug-report/67563-orders-at-the-back-end#68796 "Hi, For me it's not possible to Add a non existing product at the back end when I create a new order or edit an existing order. It's also not possible to delete a product from an order in the back end. In both situations the "pop-up"/overlay screen appears, where I can confirm that I want to delete that item of where I can fill in the information of the product. But when I click on OK, the form gets blank, but futhermore nothing happens. I'm using the business version of 1.6.0. Kind Regards Remko Rijpkema")* The reinstallation had worked for someone else with the same problem and so it would be logical that it would solve the problem for you too. I'm out of ideas on this one. If there is no error, I don't see why it wouldn't work. Especially that it works fine on the 1.6.0 test websites we have, be it a fresh install or an update. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC82NzU2My1vcmRlcnMtYXQtdGhlLWJhY2stZW5kP3RtcGw9bWFya2Rvd24=) or [Create an account](/register) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.066 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)