Monthly Sales and Tax Summary Report [support thread]

[marton_1]

You posted a problem. Admittedly after drByte fixed the other problem by realizing you were using the wrong admin.
Then, you posted the "can't get a CSV" problem. It was great that you posted the code for the error.
This (and one other) volunteer took the time to look up a solution. It was a very simple cut and paste of the problem into google that led us to a solution.
You claimedI pointed out that the dropdown had a specific fix for your failure to get a CSV.
In the time you've spent trying to avoid your host or the fix, it could have been done.
Won't bother you again.

Both the link you posted and the link by Haredo in the following post stated that these warnings continued after applying this fix.

<IfModule mod_fcgid.c>
FcgidMaxRequestsPerProcess 500
</IfModule>

Consequently, I was reluctant to adopt your advice.

In order to be collegiate, I decide to try your solution anyway.
My supplier does not give me access to this configuration.

I gave my supplier full details and asked them to make the change. I got the following reply

no, this is a shared hosting system.
We don't think this setting is the problem here.

I do agree that Dr. Byte is a very competent resource.

[lat9]

I've just submitted v2.0.0 of the Monthly Sales and Tax Report for the Zen Cart moderators' review; I'll post back here when it's available for download (https://www.zen-cart.com/index.php?ma...oducts_id=1043).

Many changes needed to support now-current PHP versions and strict MySQL installations!

- Remove use of to-be-deprecated `strftime`.
- Modify SQL queries to support strict MySQL installations; correcting fields missing from `GROUP BY`.
- Correcting various PHP notices, deprecations and warnings.
- Use Bootstrap modals for popup displays.

Note: This report's GitHub repository is https://github.com/lat9/https://gith..._sales_and_tax

[lat9]

I've just submitted v2.0.0 of the Monthly Sales and Tax Report for the Zen Cart moderators' review; I'll post back here when it's available for download (https://www.zen-cart.com/index.php?ma...oducts_id=1043).

Many changes needed to support now-current PHP versions and strict MySQL installations!

- Remove use of to-be-deprecated `strftime`.
- Modify SQL queries to support strict MySQL installations; correcting fields missing from `GROUP BY`.
- Correcting various PHP notices, deprecations and warnings.
- Use Bootstrap modals for popup displays.

Note: This report's GitHub repository is https://github.com/lat9/https://gith..._sales_and_tax

Now available for download.

[Elemi]

Now available for download.

Okay I'm feeling dumb this morning... downloaded and uploaded, tried to run the script file in tools and got an error, and when I load it directly into file manager it doesn't work either.

It's been a while since I've done one of these so what step am I missing when activating the js file?

[lat9]

Okay I'm feeling dumb this morning... downloaded and uploaded, tried to run the script file in tools and got an error, and when I load it directly into file manager it doesn't work either.

It's been a while since I've done one of these so what step am I missing when activating the js file?

That script file (.js) is a jQuery file used by the report; it's not a SQL script. The installation's handled by the report's initialization file.

[Elemi]

That script file (.js) is a jQuery file used by the report; it's not a SQL script. The installation's handled by the report's initialization file.

That's what I thought it should be... it doesn't appear to be working in that case... I'm getting an HTP Error 500 when I click on it in reports. Could I have something interfering with it even though no core files have changed?

[lat9]

That's what I thought it should be... it doesn't appear to be working in that case... I'm getting an HTP Error 500 when I click on it in reports. Could I have something interfering with it even though no core files have changed?

HTTP 500 error => Check your /logs sub-directory (or view using the Display Logs plugin) to find the debug-log that caused that error return.

[Carbonless]

HTTP 500 error => Check your /logs sub-directory (or view using the Display Logs plugin) to find the debug-log that caused that error return.

I downloaded the plugin and it appears the file includes/classes/MonthlySalesAndTax.php is missing from the download.

[lat9]

I downloaded the plugin and it appears the file includes/classes/MonthlySalesAndTax.php is missing from the download.

Well ; let me get a point-release going. Thanks for the update.

[Carbonless]

The missing file IS available on the git repository... stats_monthly_sales.php