orders report issue after upgrade

General General Questions
1

Hi all,

I’ve just upgraded my estore from version 1.3.1 to 1.3.3 and I noticed that if I create a new orders report, there are missing entries… please check the attached image.







Is this a common problem or do you think that something went wrong with my upgrade? :confused:



Many thanks in advance.

2

You need to execute the following queries to fix this:


INSERT INTO cscart_statistics_element_descriptions (element_id, element_hash, description, lang_code) VALUES ('1', '0', 'Order totals', 'EN');
INSERT INTO cscart_statistics_element_descriptions (element_id, element_hash, description, lang_code) VALUES ('2', '0', 'A number of orders', 'EN');
INSERT INTO cscart_statistics_element_descriptions (element_id, element_hash, description, lang_code) VALUES ('3', '0', 'Orders', 'EN');
INSERT INTO cscart_statistics_element_descriptions (element_id, element_hash, description, lang_code) VALUES ('4', '0', 'Statuses of orders', 'EN');
INSERT INTO cscart_statistics_element_descriptions (element_id, element_hash, description, lang_code) VALUES ('5', '0', 'Payment methods', 'EN');
INSERT INTO cscart_statistics_element_descriptions (element_id, element_hash, description, lang_code) VALUES ('6', '0', 'Locations', 'EN');
INSERT INTO cscart_statistics_element_descriptions (element_id, element_hash, description, lang_code) VALUES ('7', '0', 'Users', 'EN');
INSERT INTO cscart_statistics_element_descriptions (element_id, element_hash, description, lang_code) VALUES ('8', '0', 'Discounts and coupons', 'EN');
INSERT INTO cscart_statistics_element_descriptions (element_id, element_hash, description, lang_code) VALUES ('9', '0', 'Taxes', 'EN');
INSERT INTO cscart_statistics_element_descriptions (element_id, element_hash, description, lang_code) VALUES ('10', '0', 'Shipping costs', 'EN');
INSERT INTO cscart_statistics_element_descriptions (element_id, element_hash, description, lang_code) VALUES ('11', '0', 'Categories', 'EN');
INSERT INTO cscart_statistics_element_descriptions (element_id, element_hash, description, lang_code) VALUES ('12', '0', 'Products', 'EN');
INSERT INTO cscart_statistics_element_descriptions (element_id, element_hash, description, lang_code) VALUES ('13', '0', 'Product costs', 'EN');
INSERT INTO cscart_statistics_element_descriptions (element_id, element_hash, description, lang_code) VALUES ('14', '0', 'A number of products', 'EN');
INSERT INTO cscart_statistics_elements (element_id, code, type, depend_on_it) VALUES ('1', 'order_amount', 'O', 'N');
INSERT INTO cscart_statistics_elements (element_id, code, type, depend_on_it) VALUES ('2', 'order_number', 'O', 'N');
INSERT INTO cscart_statistics_elements (element_id, code, type, depend_on_it) VALUES ('3', 'order', 'O', 'Y');
INSERT INTO cscart_statistics_elements (element_id, code, type, depend_on_it) VALUES ('4', 'status', 'O', 'Y');
INSERT INTO cscart_statistics_elements (element_id, code, type, depend_on_it) VALUES ('5', 'payment', 'O', 'Y');
INSERT INTO cscart_statistics_elements (element_id, code, type, depend_on_it) VALUES ('6', 'location', 'O', 'Y');
INSERT INTO cscart_statistics_elements (element_id, code, type, depend_on_it) VALUES ('7', 'user', 'O', 'Y');
INSERT INTO cscart_statistics_elements (element_id, code, type, depend_on_it) VALUES ('8', 'discount', 'O', 'N');
INSERT INTO cscart_statistics_elements (element_id, code, type, depend_on_it) VALUES ('9', 'tax', 'O', 'N');
INSERT INTO cscart_statistics_elements (element_id, code, type, depend_on_it) VALUES ('10', 'shipping', 'O', 'N');
INSERT INTO cscart_statistics_elements (element_id, code, type, depend_on_it) VALUES ('11', 'category', 'O', 'Y');
INSERT INTO cscart_statistics_elements (element_id, code, type, depend_on_it) VALUES ('12', 'product', 'O', 'Y');
INSERT INTO cscart_statistics_elements (element_id, code, type, depend_on_it) VALUES ('13', 'product_cost', 'O', 'N');
INSERT INTO cscart_statistics_elements (element_id, code, type, depend_on_it) VALUES ('14', 'product_number', 'O', 'N');
INSERT INTO cscart_statistics_interval_descriptions (interval_id, lang_code, description) VALUES ('1', 'EN', 'Total');
INSERT INTO cscart_statistics_interval_descriptions (interval_id, lang_code, description) VALUES ('5', 'EN', 'Week');
INSERT INTO cscart_statistics_interval_descriptions (interval_id, lang_code, description) VALUES ('3', 'EN', 'Day');
INSERT INTO cscart_statistics_interval_descriptions (interval_id, lang_code, description) VALUES ('7', 'EN', 'Month');
INSERT INTO cscart_statistics_interval_descriptions (interval_id, lang_code, description) VALUES ('9', 'EN', 'Year');
INSERT INTO cscart_statistics_intervals (interval_id, value, interval_code) VALUES ('1', '0', 'total');
INSERT INTO cscart_statistics_intervals (interval_id, value, interval_code) VALUES ('7', '2592000', 'month');
INSERT INTO cscart_statistics_intervals (interval_id, value, interval_code) VALUES ('5', '604800', 'week');
INSERT INTO cscart_statistics_intervals (interval_id, value, interval_code) VALUES ('3', '86400', 'day');
INSERT INTO cscart_statistics_intervals (interval_id, value, interval_code) VALUES ('9', '31536000', 'year');

3

thank you very much zeke, now everything is working fine. :cool: