Monthly Sales and Tax Summary Report [support thread]

I don't have a SQL 5.7 environment to solve this right now

dbltoe:

Environment: A new 1.5.4 site with display logs, encrypted master password, inventory report, and monthly sales installed in the admin.

When I select a state and then click on Filter, everything works well. If I then select a status other than all orders, I get the following debug.Possibly 1.5.4?

OK I would guess that in stats_monthly_sales.php" line 292 you should remove the appending of $zone_only_sql to the query. This references fields in the orders table, and the query on line 192 is only against the orders status table.

Version 1.5.4.

Have been using this for a while and love it. Now I need to add something to it. I have a field in my products table called products_vendor_code. I need to add this to the report. I know the report comes from the orders table. How do I add this new info from the products table?

Speak394:

Version 1.5.4.

Have been using this for a while and love it. Now I need to add something to it. I have a field in my products table called products_vendor_code. I need to add this to the report. I know the report comes from the orders table. How do I add this new info from the products table?

If the ** products_vendor_code** is stored in the orders table already you can simply add it to the lookup and publish the data the way the report publishes data. If you need to make a new column be certain to add the heading row and data row separately.

This data is product based I assume, right? Since Monthly Sales and Tax Summary Report is order based, you might want to look at Sales Report or another mod that does product based breakdown. (Unless you can aggregate the vendor data in a way that makes sense per order.)

I seem to have done something stupid.
This plugin has been working well for years but last week I no longer had the Admin->Reports>Monthly Sales.

I uploaded the plugin files again, no change.

There is nothing in my logs.

The entry in DB table admin_pages looks OK, see screenshot.

I must have changed something but I have no idea what? I test changes in my test site before uploading and my test site monthly sales is still working OK.

The only recent change is I added an EAN coumn to the DB table products.

Admin menu options don't show if the language-defines are missing.
Check whether you've deleted its language file. Or, for that matter, check that you haven't deleted a bunch of other stuff too.

DrByte:

Admin menu options don't show if the language-defines are missing.
Check whether you've deleted its language file. Or, for that matter, check that you haven't deleted a bunch of other stuff too.

Thanks.
I deleted this plugin in my live site including deleting the entry in DB table admin_pages and reloaded the plugin.
It recreated the entry in DB table admin_pages OK but still not showing up Admin->Reports>Monthly Sales.
Language defines are there for both languages on my site.

Other plugin admin options are showing up OK like "Recovered Sales Results".

Is there anything else obvious that blocks admin options showing up?

Just noticed I have the Admin->Reports>Monthly Sales on my smartphone and tablet but not in my computer.
I can live with that but it would be nice to fix.

marton_1:

Just noticed I have the Admin->Reports>Monthly Sales on my smartphone and tablet but not in my computer.
Are you logged in as a different Admin user, which uses an admin profile with different privileges?

DrByte:

Are you logged in as a different Admin user, which uses an admin profile with different privileges?

Ah, you are truly a Sensei.

I will go and stand in the corner (again)!

I am using 157b, responsive classic template, PHP 7.4

When I click on "save CSV" I do not get any CSV file, I just get redirected to my Home Page.
Nothing in my log files, I have display debug logs files turned on.

There is a server error message but it may not be relevant as it is just a warning and I only got it once despite several CSV trials.

Broken pipe: mod_fcgid: ap_pass_brigade failed in handle_request_ipc function, referer: https://www.simmar.ch/catalog/MyAdmin/index.php?cmd=stats_monthly_sales

Are you hosting on PLESK? It includes Linux and a windows-based system. Make sure your are on Linux then check with PLESK. Seems to be a recurring problem.

https://docs.zen-cart.com/user/first_steps/server_requirements/#windows-servers--iis-are-not-supported

Serverinformationen
Linux 3.10.0-1160.11.1.el7.x86_64

This might help

https://tinyurl.com/yy3uczco

Interesting article:
https://talk.plesk.com/threads/ap_pass_brigade-failed-in-handle_request_ipc-function.345955/

On further testing, I found the help button just directs me to my home page.

If you are following the drop-down directions for Solutin for one Particular Domain, it does have you log in to your account but gives you details for fixing the problem.

I'm gonna make a WAG here and say you're not going to get it fixed till you click on that instruction or contact Plesk.

The only server error message I have received about mod_fcgid is a single warning during multiple tests so why do you believe it is the cause of my problems?

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 claimed> On further testing, I found the help button just directs me to my home page.I 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.