Sales report 2.0

[MB1]

anyword on how i can get the quantity discount to show as default?

[candywrap]

Does anyone have this mod working on 1.3.7?
I have installed it on my fresh install of 1.3.7, but no "Sales Report" comes up under "Reports" in the Admin.

[candywrap]

Does anyone have this mod working on 1.3.7?
I have installed it on my fresh install of 1.3.7, but no "Sales Report" comes up under "Reports" in the Admin.

Doh! Never mind. Forgot I re-named my admin folder for security reasons.

[FullUp]

I just installed Sales Report (rev 104) on a fresh copy of Zen-cart 1.3.7. When I click on Sales Report from the admin/reports/ menu I get a blank screen. Any thoughts or help would be appreciated.

[MikeyG]

BlindSide.

I have just installed Sales report an on running a report get the foll0wing error.

1406 Data too long for column 'page_parameters' at row 1
in:
[insert into fmadmin_activity_log (access_date, admin_id, page_accessed, page_parameters, ip_address) values (now(), '1', 'stats_sales_report.php', 'date_preset=yesterday&start_date=&end_date=&date_target=status&date_status=2&pa yment_method=&current_status=&manufacturer=&timeframe=day&timeframe_sort=asc&det ail_level=product&li_sort_a=model&li_sort_order_a=asc&li_sort_b=name&li_sort_ord er_b=asc&output_format=print&', '192.168.30.21')]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Any thoughts

Thanks

Mikey G

[Ajeh]

Go to the Tools ... Install SQL Patches ...

ALTER TABLE admin_activity_log CHANGE page_parameters page_parameters TINYTEXT NULL DEFAULT NULL; 

Does this correct the problem?

[MikeyG]

Ajeh,

Unfortunately not still getting the error.

Regards

MG

[Ajeh]

Check your database table via phpMyAdmin ...

How many tables do you see?

On the table:
admin_activity_log

did it update the field?

Check that your admin and catalog are both using the same server, database, username, password in the files:
/includes/configure.php
/admin/includes/configure.php

[MikeyG]

Ajeh

It appears to have recorded this activity in the log and certainly that field data type when you look at the table structure appears to say tinytext.

If I have understood this right then it appears to have run okay

Cheers

MG

[Ajeh]

If I go to the Tools ... Install SQL Patches and enter:

insert into fmadmin_activity_log (access_date, admin_id, page_accessed, page_parameters, ip_address) values (now(), '1', 'stats_sales_report.php', 'date_preset=yesterday&start_date=&end_date=&date_ target=status&date_status=2&payment_method=&curren t_status=&manufacturer=&timeframe=day&timeframe_so rt=asc&detail_level=product&li_sort_a=model&li_sor t_order_a=asc&li_sort_b=name&li_sort_order_b=asc&o utput_format=print&', '192.168.30.21'); 

I cannot reproduce the error ...

NOTE: I did adjust mine for the table name as mine is admin_activity_log and not fmadmin_activity_log