Monthly Sales and Tax Summary Report [support thread]

[DrByte]

1054:Unknown column 'o.delivery_state' in 'where clause'

There's no 'delivery_state' field in the orders_status table in any version of Zen Cart, so this isn't a v1.5.4 issue.
Looks more like a failed/not-completed SQL schema change during installation of the related addon.

[dbltoe]

This is in the installed file.

  //Zone Only SQL appendage
    $zone_only_sql = '';
    $zone_selected = false;
    if ($_POST['zone_only'] != '' && !in_array('all', $_POST['zone_only'])) {
        $get_zone_only = $_POST['zone_only'];
        $zone_selected = true;
        $zoned_sql = '';
        foreach ($get_zone_only as $selectedZone) {
            $zoned_sql .= "o.delivery_state LIKE '" . $selectedZone . "' OR ";
        }
        $zoned_sql = rtrim($zoned_sql, "OR ");
        $zone_only_sql = " AND (" . $zoned_sql . ") ";
    } 

Everything works just fine as long as the filter is left on All

[lat9]

FWIW, that state filter is part of the v1.5.3 update for the plugin (which pretty much wiped out the changes that I made for v1.5.0 of the plugin). Hopefully, the plugin updater will chime in and correct the issue that's been created.

[Thannaree]

I am translating the module. The months remains in English. Where does the module pull the months from?

[Thannaree]

The plugin works well but it's generating the following error every time I access the admin:

PHP Warning:  unlink(/admin/includes/functions/extra_functions/stats_monthly_sales.php): Permission denied in /admin/includes/functions/extra_functions/stats_monthly_sales.php on line 27

That's what I read on line 27:

unlink(__FILE__);

Any idea?

[swguy]

Yes. Delete that line.

[Thannaree]

Yes. Delete that line.

Thank you!

[evosmash]

Getting an "illegal Access" after clicking on Monthly Sales link under admin-reports. This seemed pretty straight forward. Any Ideas?

[tronage]

I am using 1.54, and thought the installation was quite straight forward and simple, upload into admin folder... But when I go to reports>monthly Sales the list is "blank". Meaning it shows the headings, the filters and the print/invert/help, but there is no data displayed. If I select a status that none of my orders have ("pending" for example, then I get a report of "No income for this date/status selection" But if I select ones I do have status of (or all) then I just get blank below the column headings (even the zencart footer that is normally on all the admin pages is gone. The footer only displays when it also reports "No income for this date/status selection" as mentioned above).

Any thoughts to get it to display something, even an error message would be helpful I guess? the print button "works" in that it opens a new tab with the blank columns, the help button brings up the help popup... But it just doesn't display anything.

Any help is very much appreciated!!!

[lhungil]

Blank Page or Partial Blank Page

The debug logs (if present) should help identify the cause.