"Last Seven Days" report suddenly quit

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

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