Monthly Sales and Tax Summary Report [support thread]

[skipwater]

A quick answer would be a bad upload of the files. Try reloading the files and see if that fixes it. If not what version of zen-cart, mysql, php are you running.

Skip

[KMK Enterprises]

I honestly can't remember if it was this MOD or another that I recently installed in my latest ZC adventure, but one of them had an extra / in the URL it was using. I'm inclinded to think it might have been this one, because fixing it solved the problem I was having with the unintuative IE, if I remember correctly (I also believe this memory loss come-down is what they refer to as having been ZENNED after working on a big e-commerce site with too many customizations ).

View the source on the page, and see if that's what's happening to you as well.

~KMK

[nosnappyname]

Skip, I deleted the code and reinstalled: same thing happened. I'm running:
ZenCart 1.3.8a
MySQL 5.0.18
PHP Version: 5.2.6 (Zend: 2.2.0)

The data presented is all correct so it is getting at the database ok.
I thought a php variable may need changing but no idea what.

[skipwater]

Skip, I deleted the code and reinstalled: same thing happened. I'm running:
ZenCart 1.3.8a
MySQL 5.0.18
PHP Version: 5.2.6 (Zend: 2.2.0)

The data presented is all correct so it is getting at the database ok.
I thought a php variable may need changing but no idea what.

Looked at the code and did find a typo for the print option.

I also noticed that a lot of the coding used an old time way of ending a if statement.
So I fix that but I am running
ZenCart 1.3.8a
MySQL 5.0.33
PHP Version: 5.2.5 (Zend: 2.2.0)
And it works so I have attached stats_monthly_sales.zip unzip and then replace /admin/stats_monthly_sales.php with this file.
Let me know if this fixed it, If so I will build a new mod file for download.

Skip

[nosnappyname]

Skip, that second version acted the same as the first, but..... I found a number of notes that said: "$HTTP_GET_VARS[] Is IDENTICAL to $_GET, however, it is depreciated, and no longer in use in php 5 + (correct me if I am wrong). PHP advises you use $_GET, $_POST, $REQUEST.. etc for all your super global needs."

So I changed $HTTP_GET_VARS to $_GET and $HTTP_POST_VARS to $_POST everywhere in stats_monthly_sales.php and everything seemed to work fine. I guess something in my ISP's settings are tighter than yours.

Anyway, thanks and it really looks like a useful contribution.

[skipwater]

Skip, that second version acted the same as the first, but..... I found a number of notes that said: "$HTTP_GET_VARS[] Is IDENTICAL to $_GET, however, it is depreciated, and no longer in use in php 5 + (correct me if I am wrong). PHP advises you use $_GET, $_POST, $REQUEST.. etc for all your super global needs."

So I changed $HTTP_GET_VARS to $_GET and $HTTP_POST_VARS to $_POST everywhere in stats_monthly_sales.php and everything seemed to work fine. I guess something in my ISP's settings are tighter than yours.

Anyway, thanks and it really looks like a useful contribution.

Thanks nosnappyname for PHP 5.0 fix. I was asleep on that one.
I up loaded a new version 1.2 it should show up in a day or two.

Thanks again for the help

Skip

[barco57]

has anyone had an issue with the status dropdown only having All Orders in it and none of the other statuses.

[goldiegao]

HI, I've upload the folder to my server, however, there is always a Internal server problem 500 shows up when I click the" monthly sales report" in ZenCart admin site. Please HELP ME!!!

[skipwater]

HI, I've upload the folder to my server, however, there is always a Internal server problem 500 shows up when I click the" monthly sales report" in ZenCart admin site. Please HELP ME!!!

After unzipping the mods zip file to a temp area on your local computer and then renaming the admin folder to match the name of the admin folder that you are using on your web server.

That is when you then uploaded the files?

Skip

[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?