New Zenner
- Join Date:
- Feb 2007
- Posts:
- 2
- Plugin Contributions:
- 0
Sales report 2.0
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.
New Zenner
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.
New Zenner
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.:blush:
New Zenner
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.
Totally Zenned
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&payment_method=¤t_status=&manufacturer=&timeframe=day&timeframe_sort=asc&detail_level=product&li_sort_a=model&li_sort_order_a=asc&li_sort_b=name&li_sort_order_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
Oba-san
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?
Linda McGrath
If you have to think ... you haven't been zenned ...
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
Totally Zenned
Ajeh,
Unfortunately not still getting the error.
Regards
MG
Oba-san
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
Linda McGrath
If you have to think ... you haven't been zenned ...
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
Totally Zenned
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
Oba-san
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=¤ 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
Linda McGrath
If you have to think ... you haven't been zenned ...
Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here
Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!
New Zenner
Mikey G
I sometimes get this same error on my test machine using mysql 5.24 but not on my domain which runs mysql 5.27. What version of db are you running?
New Zenner
Hello,
Thanks for this awesome Sales Report system. I'm only having one problem when I try to export my CSV files. I keep getting consistent and unsightly errors in my sheet. It's probably something simple, hopefully someone can help.
Here are my settings.
Custom Date Range
Order Purchased
+Product Line Items
CSV Export
Column Titles in First Row
And I keep getting this error every few Rows..
<b>Warning</b>: Invalid argument supplied for foreach() in <b>/home/.cara/davestra/strandland.com/digitalstore/admin/includes/classes/sales_report.php</b> on line <b>908</b><br />
or this one...
<b>Warning</b>: array_multisort() [<a href='function.array-multisort?zenAdminID=4baf46482870f18dcf2411f16f568494'>function.array-multisort</a>]: Argument #1 is expected to be an array or a sort flag in <b>/home/.cara/davestra/strandland.com/digitalstore/admin/includes/classes/sales_report.php</b> on line <b>915</b><br />
or this one...
<b>Warning</b>: Invalid argument supplied for foreach() in <b>/home/.cara/davestra/strandland.com/digitalstore/admin/includes/classes/sales_report.php</b> on line <b>908</b><br />
Sorry, I'm new to this stuff, so I dunno what it means.
THanks,
-Dave
Here's my store if you need that...
http://www.strandland.com/digitalstore
New Zenner
I am having trouble using this sales report tool. I am trying to use it and it doesn't generate any reports. I have double checked to make sure everything is in its proper location. So I am not sure what I am doing wrong...
Totally Zenned
Might need to add a filter:
State
to pull out sales data on a per-state basis.
Any suggestions on how to do this?
Many thanks :smile:
Totally Zenned
**@davestrand:**What version fo PHP are you using? Your errors typically happen when an older version of PHP is being used. You need to be running at least 4.2.2.
@linuxw00t: That tells me nothing, so it's pretty hard for me to help you. Does the search come up at all? When you submit a search, does the screen refresh, or just hang? Does a new page come up totally blank? Give me details about exactly what behavior you are experiencing.
@DogTags: Off-hand I'd say that a per state filter would require some serious adjustments to the report, as that kind of filtering happens in the core of the data mining process. You'll need to know what's happening in the sales_report class.
Frank Koehl
"Cleverly Disguised as a Responsible Adult"
frankkoehl.com
New Zenner
Blindside, like @linuxw00t: the search screen appears and then does nothing when you click Show me the money! No screen refresh. It just hangs.
Zen version 1.3.7
Sales Report 2.0
Totally Zenned
Does the progress indicator on your browser move at all (it should)? What browser and version are you using?
Frank Koehl
"Cleverly Disguised as a Responsible Adult"
frankkoehl.com
New Zenner
I try using it using the different options and then I click the 'show me the money' button and it doesn't do anything its just as if I made a button just to click. The browser progress doesn't do anything. Just like if I said 'click here' and you tried to click it. I have the correct software and everything is in its proper place.
New Zenner
I'm using Firefox 2.0 and Safari. No, the progress bar does not move or even show for that matter.
Thanks for the help.
J
Totally Zenned
Sounds like Safari doesn't like the JavaScript being used with the submit button. Can you try it with Firefox to confirm?
Frank Koehl
"Cleverly Disguised as a Responsible Adult"
frankkoehl.com
New Zenner
does this work with the latest 1.3.7?
Tell staff why this post should be reviewed.