[Skip to main content](#vessel-content) # Orders export not working ## - **[DuFFi\_SK](/forum/user/28465-duffi-sk "View DuFFi_SK's Profile")** - [![DuFFi_SK's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar28465.jpg)](/forum/user/28465-duffi-sk "View DuFFi_SK's Profile") Topic Author - [ Offline](/forum/user/28465-duffi-sk) Less More - Posts: 29 - Thank you received: 0 - - [](http://www.lienocka.sk) - 11 years 6 months ago [\#197166](#197166) by [DuFFi\_SK](/forum/user/28465-duffi-sk "View DuFFi_SK's Profile") *[Orders export not working](/forum/37-import-export-csv-xls/876146-orders-export-not-working#197166 "-- url of the page with the problem -- : www.lienocka.sk -- HikaShop version -- : 2.2.1 -- Joomla version -- : 2.5.14 Hello, we have problem with exporting orders from HikaShop. Last week it worked without problems and suddenly today it stopped. When I click on the icon "Export", after 2 seconds I receive blank screen and nothing happen. Another export (users) is working without problems. Do you have any idea what went wrong? Thank you.")* was created by *[DuFFi\_SK](/forum/user/28465-duffi-sk "View DuFFi_SK's Profile")* -- url of the page with the problem -- : [ www.lienocka.sk](http://www.lienocka.sk) -- HikaShop version -- : 2.2.1 -- Joomla version -- : 2.5.14 Hello, we have problem with exporting orders from HikaShop. Last week it worked without problems and suddenly today it stopped. When I click on the icon "Export", after 2 seconds I receive blank screen and nothing happen. Another export (users) is working without problems. Do you have any idea what went wrong? Thank you. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzYxNDYtb3JkZXJzLWV4cG9ydC1ub3Qtd29ya2luZz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 11 years 6 months ago [\#197168](#197168) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Orders export not working](/forum/37-import-export-csv-xls/876146-orders-export-not-working#197168 "-- url of the page with the problem -- : www.lienocka.sk -- HikaShop version -- : 2.2.1 -- Joomla version -- : 2.5.14 Hello, we have problem with exporting orders from HikaShop. Last week it worked without problems and suddenly today it stopped. When I click on the icon "Export", after 2 seconds I receive blank screen and nothing happen. Another export (users) is working without problems. Do you have any idea what went wrong? Thank you.")* Hi, You should check your PHP error log in order to see if you got a PHP fatal error. Setting the "error report level" to "maximum" in the Joomla global configuration might also help you to display the error in the page directly. You might also see to update HikaShop to a more recent version, the 2.2.1 has been release more than one year and an half. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. The following user(s) said Thank You: [DuFFi\_SK](/forum/user/28465-duffi-sk "View DuFFi_SK's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzYxNDYtb3JkZXJzLWV4cG9ydC1ub3Qtd29ya2luZz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[DuFFi\_SK](/forum/user/28465-duffi-sk "View DuFFi_SK's Profile")** - [![DuFFi_SK's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar28465.jpg)](/forum/user/28465-duffi-sk "View DuFFi_SK's Profile") Topic Author - [ Offline](/forum/user/28465-duffi-sk) Less More - Posts: 29 - Thank you received: 0 - - [](http://www.lienocka.sk) - 11 years 6 months ago - 11 years 6 months ago [\#197228](#197228) by [DuFFi\_SK](/forum/user/28465-duffi-sk "View DuFFi_SK's Profile") Replied by *[DuFFi\_SK](/forum/user/28465-duffi-sk "View DuFFi_SK's Profile")* on topic *[Orders export not working](/forum/37-import-export-csv-xls/876146-orders-export-not-working#197228 "-- url of the page with the problem -- : www.lienocka.sk -- HikaShop version -- : 2.2.1 -- Joomla version -- : 2.5.14 Hello, we have problem with exporting orders from HikaShop. Last week it worked without problems and suddenly today it stopped. When I click on the icon "Export", after 2 seconds I receive blank screen and nothing happen. Another export (users) is working without problems. Do you have any idea what went wrong? Thank you.")* Hello Jerome, thanks for your reply. With maximum report level I received message: Fatal error: Allowed memory size of 50331648 bytes exhausted (tried to allocate 1372340 bytes) in /nfsmnt/hosting2_2/2/2/2262dca1-c3ae-4aaf-94e3-1bf96b3c1e9d/lienocka.sk/web/administrator/components/com_hikashop/helpers/spreadsheet.php on line 104 With debug mode enabled I received: 500 - An error has occurred. JDatabaseMySQLi::query: 1054 - Unknown column 'a.all' in 'where clause' SQL=SELECT * FROM galiva932_hikashop_field as a WHERE a.`field_published` = 1 AND a.`all`=1 AND a.field_table='order' ORDER BY a.`field_ordering` ASC I will upgrade to more recent version ASAP, but I am affraid about consequences of upgrade in my hikashop settings... Right now I need to solve this error, because we are using orders export frequently. Thank you very much. Last edit: 11 years 6 months ago by [DuFFi\_SK](/forum/user/28465-duffi-sk "View DuFFi_SK's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzYxNDYtb3JkZXJzLWV4cG9ydC1ub3Qtd29ya2luZz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 11 years 6 months ago [\#197229](#197229) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Orders export not working](/forum/37-import-export-csv-xls/876146-orders-export-not-working#197229 "-- url of the page with the problem -- : www.lienocka.sk -- HikaShop version -- : 2.2.1 -- Joomla version -- : 2.5.14 Hello, we have problem with exporting orders from HikaShop. Last week it worked without problems and suddenly today it stopped. When I click on the icon "Export", after 2 seconds I receive blank screen and nothing happen. Another export (users) is working without problems. Do you have any idea what went wrong? Thank you.")* Hi, It looks like a memory limit issue. Try to increase the memory limit parameter of your php.ini and try again. The following user(s) said Thank You: [DuFFi\_SK](/forum/user/28465-duffi-sk "View DuFFi_SK's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzYxNDYtb3JkZXJzLWV4cG9ydC1ub3Qtd29ya2luZz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[DuFFi\_SK](/forum/user/28465-duffi-sk "View DuFFi_SK's Profile")** - [![DuFFi_SK's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar28465.jpg)](/forum/user/28465-duffi-sk "View DuFFi_SK's Profile") Topic Author - [ Offline](/forum/user/28465-duffi-sk) Less More - Posts: 29 - Thank you received: 0 - - [](http://www.lienocka.sk) - 11 years 6 months ago [\#197330](#197330) by [DuFFi\_SK](/forum/user/28465-duffi-sk "View DuFFi_SK's Profile") Replied by *[DuFFi\_SK](/forum/user/28465-duffi-sk "View DuFFi_SK's Profile")* on topic *[Orders export not working](/forum/37-import-export-csv-xls/876146-orders-export-not-working#197330 "-- url of the page with the problem -- : www.lienocka.sk -- HikaShop version -- : 2.2.1 -- Joomla version -- : 2.5.14 Hello, we have problem with exporting orders from HikaShop. Last week it worked without problems and suddenly today it stopped. When I click on the icon "Export", after 2 seconds I receive blank screen and nothing happen. Another export (users) is working without problems. Do you have any idea what went wrong? Thank you.")* Thank you Nicolas, I increased the memory from 48MB to 128MB and the export is working again. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM3LWltcG9ydC1leHBvcnQtY3N2LXhscy84NzYxNDYtb3JkZXJzLWV4cG9ydC1ub3Qtd29ya2luZz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) 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.187 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)