Monthly Sales and Tax Summary Report [support thread]

[persion]

I meet a problem
1054 Unknown column 'sort_order' in 'order clause'
in:
[SELECT orders_status_id, orders_status_name FROM orders_status WHERE language_id = 3 ORDER BY sort_order, orders_status_id]
Fatal error: 1054:Unknown column 'sort_order' in 'order clause' :: SELECT orders_status_id, orders_status_name FROM orders_status WHERE language_id = 3 ORDER BY sort_order, orders_status_id
Any one can help me?

[lat9]

I meet a problem
1054 Unknown column 'sort_order' in 'order clause'
in:
[SELECT orders_status_id, orders_status_name FROM orders_status WHERE language_id = 3 ORDER BY sort_order, orders_status_id]
Fatal error: 1054:Unknown column 'sort_order' in 'order clause' :: SELECT orders_status_id, orders_status_name FROM orders_status WHERE language_id = 3 ORDER BY sort_order, orders_status_id
Any one can help me?

That field (orders_status :: sort_order) was added in zc157, which is the only Zen Cart version currently supported by the report. What version of Zen Cart are you using?

[lat9]

Just submitted v2.0.2 for the Zen Cart moderators' review; I'll post back here when it's available for download.

This release contains the (previously missing) /YOUR_ADMIN/includes/modules/sms/tpl_stats_monthly_sales_taxes.php and modifies its data-gathering so that a report's generation doesn't take 'centuries'!