[Skip to main content](#vessel-content) # "Last Seven Days" report suddenly quit ## - **[jgribble](/forum/user/4695-jgribble "View jgribble's Profile")** - [![jgribble's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4695-jgribble "View jgribble's Profile") Topic Author - [ Offline](/forum/user/4695-jgribble) Less More - Posts: 318 - Thank you received: 20 - - 11 years 9 months ago [\#187371](#187371) by [jgribble](/forum/user/4695-jgribble "View jgribble's Profile") *["Last Seven Days" report suddenly quit](/forum/36-reports-statistics/874368-last-seven-days-report-suddenly-quit#187371 "-- url of the page with the problem -- : newssyc.org/ -- HikaShop version -- : HikaShop [1411161808] -- Joomla version -- : 3.34 -- Browser(s) name and version -- : All major, latest versions -- Error-message(debug-mod must be tuned on) -- : An error has occurred. 1054 Unknown column 'prod.product_id' in 'where clause' SQL=SELECT *, SUM( case when o.order_currency_id = '1' then o.order_full_price/0.8144 when o.order_currency_id = '2' then o.order_full_price end ) AS Total, COUNT(o.order_id) AS order_number FROM j3xssyc_hikashop_order as o LEFT JOIN j3xssyc_hikashop_user as a ON o.order_user_id=a.user_id LEFT JOIN j3xssyc_users as u ON u.id=a.user_cms_id WHERE a.user_partner_activated=0 AND prod.product_id IN ('2','3','4','5','6','7','8','9','10','11','12','13','15','14709','14728','14747','14766','14785','14804','14815','14816','14827','14838','14849','14860','14861','14863','14864','14866','14867','14868','14869','14870','14871','15493','15561','15647') AND a.user_created > 1419099248 AND a.user_created I was configuring the "last seven days" report screen when the above error suddenly occurred and I can no longer access the report. This happened after I added all products to the CSV output. Please advise on how to fix? I can't make any sense of the error message myself. Thanks! Jim Gribble")* was created by *[jgribble](/forum/user/4695-jgribble "View jgribble's Profile")* -- url of the page with the problem -- : [ newssyc.org/](http://newssyc.org/) -- HikaShop version -- : HikaShop [1411161808] -- Joomla version -- : 3.34 -- Browser(s) name and version -- : All major, latest versions -- Error-message(debug-mod must be tuned on) -- : An error has occurred. 1054 Unknown column 'prod.product_id' in 'where clause' SQL=SELECT *, SUM( case when o.order_currency_id = '1' then o.order_full_price/0.8144 when o.order_currency_id = '2' then o.order_full_price end ) AS Total, COUNT(o.order_id) AS order_number FROM j3xssyc_hikashop_order as o LEFT JOIN j3xssyc_hikashop_user as a ON o.order_user_id=a.user_id LEFT JOIN j3xssyc_users as u ON u.id=a.user_cms_id WHERE a.user_partner_activated=0 AND prod.product_id IN ('2','3','4','5','6','7','8','9','10','11','12','13','15','14709','14728','14747','14766','14785','14804','14815','14816','14827','14838','14849','14860','14861','14863','14864','14866','14867','14868','14869','14870','14871','15493','15561','15647') AND a.user_created > 1419099248 AND a.user_created I was configuring the "last seven days" report screen when the above error suddenly occurred and I can no longer access the report. This happened after I added all products to the CSV output. Please advise on how to fix? I can't make any sense of the error message myself. Thanks! Jim Gribble Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NzQzNjgtbGFzdC1zZXZlbi1kYXlzLXJlcG9ydC1zdWRkZW5seS1xdWl0P3RtcGw9bWFya2Rvd24=) 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: 26400 - Thank you received: 4080 - - [](http://obsi.dev) - 11 years 9 months ago [\#187372](#187372) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *["Last Seven Days" report suddenly quit](/forum/36-reports-statistics/874368-last-seven-days-report-suddenly-quit#187372 "-- url of the page with the problem -- : newssyc.org/ -- HikaShop version -- : HikaShop [1411161808] -- Joomla version -- : 3.34 -- Browser(s) name and version -- : All major, latest versions -- Error-message(debug-mod must be tuned on) -- : An error has occurred. 1054 Unknown column 'prod.product_id' in 'where clause' SQL=SELECT *, SUM( case when o.order_currency_id = '1' then o.order_full_price/0.8144 when o.order_currency_id = '2' then o.order_full_price end ) AS Total, COUNT(o.order_id) AS order_number FROM j3xssyc_hikashop_order as o LEFT JOIN j3xssyc_hikashop_user as a ON o.order_user_id=a.user_id LEFT JOIN j3xssyc_users as u ON u.id=a.user_cms_id WHERE a.user_partner_activated=0 AND prod.product_id IN ('2','3','4','5','6','7','8','9','10','11','12','13','15','14709','14728','14747','14766','14785','14804','14815','14816','14827','14838','14849','14860','14861','14863','14864','14866','14867','14868','14869','14870','14871','15493','15561','15647') AND a.user_created > 1419099248 AND a.user_created I was configuring the "last seven days" report screen when the above error suddenly occurred and I can no longer access the report. This happened after I added all products to the CSV output. Please advise on how to fix? I can't make any sense of the error message myself. Thanks! Jim Gribble")* Hi, Can you please provide us the content of the column "widget_params" for the row with the "widget_name" set to "Last Seven days" ? Thanks to "phpmyadmin", you can access to the table "hikashop_widget" and see the raw configuration of your widgets. Using that configuration we will be able to have the same result as you and provide a fix. I fix that you changed something in your configuration and now the query is wrong. If you want to regain the access of the HikaShop dashboard, you can also change the value of the column "widget_published" in order to unpublish the widget. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NzQzNjgtbGFzdC1zZXZlbi1kYXlzLXJlcG9ydC1zdWRkZW5seS1xdWl0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[jgribble](/forum/user/4695-jgribble "View jgribble's Profile")** - [![jgribble's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4695-jgribble "View jgribble's Profile") Topic Author - [ Offline](/forum/user/4695-jgribble) Less More - Posts: 318 - Thank you received: 20 - - 11 years 9 months ago [\#187396](#187396) by [jgribble](/forum/user/4695-jgribble "View jgribble's Profile") Replied by *[jgribble](/forum/user/4695-jgribble "View jgribble's Profile")* on topic *["Last Seven Days" report suddenly quit](/forum/36-reports-statistics/874368-last-seven-days-report-suddenly-quit#187396 "-- url of the page with the problem -- : newssyc.org/ -- HikaShop version -- : HikaShop [1411161808] -- Joomla version -- : 3.34 -- Browser(s) name and version -- : All major, latest versions -- Error-message(debug-mod must be tuned on) -- : An error has occurred. 1054 Unknown column 'prod.product_id' in 'where clause' SQL=SELECT *, SUM( case when o.order_currency_id = '1' then o.order_full_price/0.8144 when o.order_currency_id = '2' then o.order_full_price end ) AS Total, COUNT(o.order_id) AS order_number FROM j3xssyc_hikashop_order as o LEFT JOIN j3xssyc_hikashop_user as a ON o.order_user_id=a.user_id LEFT JOIN j3xssyc_users as u ON u.id=a.user_cms_id WHERE a.user_partner_activated=0 AND prod.product_id IN ('2','3','4','5','6','7','8','9','10','11','12','13','15','14709','14728','14747','14766','14785','14804','14815','14816','14827','14838','14849','14860','14861','14863','14864','14866','14867','14868','14869','14870','14871','15493','15561','15647') AND a.user_created > 1419099248 AND a.user_created I was configuring the "last seven days" report screen when the above error suddenly occurred and I can no longer access the report. This happened after I added all products to the CSV output. Please advise on how to fix? I can't make any sense of the error message myself. Thanks! Jim Gribble")* Hello Jerome, No I didn't change anything. I was exploring options under Reports. I opened the report set up as "last seven days." I set it to tabulate by customer. Then I added all my products, thinking that when the report was downloaded to CSV we also would have a column showing the products which have been purchased AND their purchasers. That's when this happened. I didn't touch any php. The rest of the control panel is accessible and working. It's just that I can no longer use the report "last seven days." I'm, sure we'll get it fixed. Can you also answer a related question regarding authorize.net SIM method? There's a nice option in the plugin put in the "url for your logo." But the documentation doesn't explain how that url should be configured. Is it going to be an image url from the back end? Or a public url from the front end? I'm thinking it's going to be the first; I simply upload my image, copy its internal url and paste that in at the designated spot in the authorize plugin. Thanks, -Jim G. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NzQzNjgtbGFzdC1zZXZlbi1kYXlzLXJlcG9ydC1zdWRkZW5seS1xdWl0P3RtcGw9bWFya2Rvd24=) 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: 26400 - Thank you received: 4080 - - [](http://obsi.dev) - 11 years 9 months ago [\#187399](#187399) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *["Last Seven Days" report suddenly quit](/forum/36-reports-statistics/874368-last-seven-days-report-suddenly-quit#187399 "-- url of the page with the problem -- : newssyc.org/ -- HikaShop version -- : HikaShop [1411161808] -- Joomla version -- : 3.34 -- Browser(s) name and version -- : All major, latest versions -- Error-message(debug-mod must be tuned on) -- : An error has occurred. 1054 Unknown column 'prod.product_id' in 'where clause' SQL=SELECT *, SUM( case when o.order_currency_id = '1' then o.order_full_price/0.8144 when o.order_currency_id = '2' then o.order_full_price end ) AS Total, COUNT(o.order_id) AS order_number FROM j3xssyc_hikashop_order as o LEFT JOIN j3xssyc_hikashop_user as a ON o.order_user_id=a.user_id LEFT JOIN j3xssyc_users as u ON u.id=a.user_cms_id WHERE a.user_partner_activated=0 AND prod.product_id IN ('2','3','4','5','6','7','8','9','10','11','12','13','15','14709','14728','14747','14766','14785','14804','14815','14816','14827','14838','14849','14860','14861','14863','14864','14866','14867','14868','14869','14870','14871','15493','15561','15647') AND a.user_created > 1419099248 AND a.user_created I was configuring the "last seven days" report screen when the above error suddenly occurred and I can no longer access the report. This happened after I added all products to the CSV output. Please advise on how to fix? I can't make any sense of the error message myself. Thanks! Jim Gribble")* Hi, They are thousand of combinations in the report system ; we do not have the possibility to test them all so it happen that some specific configuration had unwanted side effect ; and you totally have the right to change the configuration. I hope that point is clear enough. If you read my message, what I am asking you is the configuration you now have ; so I can reproduce it and fix it. So, please answer to that request so we will be able to move in the right direction. About your second question ; I will ask you to create a new topic for that. We will try to resolve one single question at the time and don't handle multiple and totaly different issues in the same thread. Thank you for your understanding. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NzQzNjgtbGFzdC1zZXZlbi1kYXlzLXJlcG9ydC1zdWRkZW5seS1xdWl0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[jgribble](/forum/user/4695-jgribble "View jgribble's Profile")** - [![jgribble's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4695-jgribble "View jgribble's Profile") Topic Author - [ Offline](/forum/user/4695-jgribble) Less More - Posts: 318 - Thank you received: 20 - - 11 years 9 months ago [\#187523](#187523) by [jgribble](/forum/user/4695-jgribble "View jgribble's Profile") Replied by *[jgribble](/forum/user/4695-jgribble "View jgribble's Profile")* on topic *["Last Seven Days" report suddenly quit](/forum/36-reports-statistics/874368-last-seven-days-report-suddenly-quit#187523 "-- url of the page with the problem -- : newssyc.org/ -- HikaShop version -- : HikaShop [1411161808] -- Joomla version -- : 3.34 -- Browser(s) name and version -- : All major, latest versions -- Error-message(debug-mod must be tuned on) -- : An error has occurred. 1054 Unknown column 'prod.product_id' in 'where clause' SQL=SELECT *, SUM( case when o.order_currency_id = '1' then o.order_full_price/0.8144 when o.order_currency_id = '2' then o.order_full_price end ) AS Total, COUNT(o.order_id) AS order_number FROM j3xssyc_hikashop_order as o LEFT JOIN j3xssyc_hikashop_user as a ON o.order_user_id=a.user_id LEFT JOIN j3xssyc_users as u ON u.id=a.user_cms_id WHERE a.user_partner_activated=0 AND prod.product_id IN ('2','3','4','5','6','7','8','9','10','11','12','13','15','14709','14728','14747','14766','14785','14804','14815','14816','14827','14838','14849','14860','14861','14863','14864','14866','14867','14868','14869','14870','14871','15493','15561','15647') AND a.user_created > 1419099248 AND a.user_created I was configuring the "last seven days" report screen when the above error suddenly occurred and I can no longer access the report. This happened after I added all products to the CSV output. Please advise on how to fix? I can't make any sense of the error message myself. Thanks! Jim Gribble")* Not sure what happened here but for now I simply deleted the broken report and created a new custom report which works and which I like better. So there is no need to investigate this particular issue any further. I think I asked this one report to do too much. Better to have multiple reports with simple view options. -Jim Gribble Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NzQzNjgtbGFzdC1zZXZlbi1kYXlzLXJlcG9ydC1zdWRkZW5seS1xdWl0P3RtcGw9bWFya2Rvd24=) 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: 26400 - Thank you received: 4080 - - [](http://obsi.dev) - 11 years 9 months ago [\#187526](#187526) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *["Last Seven Days" report suddenly quit](/forum/36-reports-statistics/874368-last-seven-days-report-suddenly-quit#187526 "-- url of the page with the problem -- : newssyc.org/ -- HikaShop version -- : HikaShop [1411161808] -- Joomla version -- : 3.34 -- Browser(s) name and version -- : All major, latest versions -- Error-message(debug-mod must be tuned on) -- : An error has occurred. 1054 Unknown column 'prod.product_id' in 'where clause' SQL=SELECT *, SUM( case when o.order_currency_id = '1' then o.order_full_price/0.8144 when o.order_currency_id = '2' then o.order_full_price end ) AS Total, COUNT(o.order_id) AS order_number FROM j3xssyc_hikashop_order as o LEFT JOIN j3xssyc_hikashop_user as a ON o.order_user_id=a.user_id LEFT JOIN j3xssyc_users as u ON u.id=a.user_cms_id WHERE a.user_partner_activated=0 AND prod.product_id IN ('2','3','4','5','6','7','8','9','10','11','12','13','15','14709','14728','14747','14766','14785','14804','14815','14816','14827','14838','14849','14860','14861','14863','14864','14866','14867','14868','14869','14870','14871','15493','15561','15647') AND a.user_created > 1419099248 AND a.user_created I was configuring the "last seven days" report screen when the above error suddenly occurred and I can no longer access the report. This happened after I added all products to the CSV output. Please advise on how to fix? I can't make any sense of the error message myself. Thanks! Jim Gribble")* Hi, Okay. Thanks for the report ; we will see to reproduce your SQL issue by testing some configurations. With your indications in your previous post it will help us to know what kind of element to change. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzM2LXJlcG9ydHMtc3RhdGlzdGljcy84NzQzNjgtbGFzdC1zZXZlbi1kYXlzLXJlcG9ydC1zdWRkZW5seS1xdWl0P3RtcGw9bWFya2Rvd24=) 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.058 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)