Just submitted v2.0.1 to include that missing class file. See https://github.com/lat9/monthly_sales_and_tax for a quick update, too.
Printable View
Just submitted v2.0.1 to include that missing class file. See https://github.com/lat9/monthly_sales_and_tax for a quick update, too.
Approved; removed v2.0.0.
Downloaded the new file... ran the report in Reports>Monthly Sales and it took about 5 minutes to render all of my data from as far back as 2004... is this normal?
[28-Dec-2021 11:51:20 Pacific/Auckland] PHP Fatal error: require(): Failed opening required 'includes/classes/MonthlySalesAndTax.php' (include_path='.:/opt/cpanel/ea-php73/root/usr/share/pear') in /home/amoraromatherapy/public_html/admin/stats_monthly_sales.php on line 138
It might be. :unsure: Due to strict MySQL installations having hissy fits about fields missing from the GROUP BY and the erroneous results returned when they were added, I had to pull the MySQL SUM()'s from the queries and do the summing in PHP.
I'll look at the code (again) to see if that can be handled differently.
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?
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'!
I have zen cart version info:
Zen Cart 1.5.5d
Database Patch Level: 1.5.5
v1.5.5a [2016-05-30 17:05:28] (Version Update 1.5.4->1.5.5a)
v1.5.4 [2015-02-18 04:55:48] (New Installation)
v1.5.4 [2015-02-18 04:55:48] (New Installation)
PHP Version: 5.6.40 (Zend: 2.6.0)
Database: MySQL 5.5.62-cll
And I wanted to know if I can install the newest version of this plug in, or if I need to install the one that is for 1.5.5? Please let me know, thank you.