Page 22 of 24 FirstFirst ... 122021222324 LastLast
Results 211 to 220 of 237
  1. #211
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,401
    Plugin Contributions
    87

    Default Re: Monthly Sales and Tax Summary Report [support thread]

    Quote Originally Posted by lat9 View Post
    Well ; let me get a point-release going. Thanks for the update.
    Just submitted v2.0.1 to include that missing class file. See https://github.com/lat9/monthly_sales_and_tax for a quick update, too.

  2. #212
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    9,623
    Plugin Contributions
    123

    Default Re: Monthly Sales and Tax Summary Report [support thread]

    Approved; removed v2.0.0.
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

  3. #213
    Join Date
    Jan 2007
    Location
    Illinois, USA
    Posts
    312
    Plugin Contributions
    0

    Default Re: Monthly Sales and Tax Summary Report [support thread]

    Downloaded the new file... ran the report in Reports>Monthly Sales and it took about 5 minutes to render all of my data from as far back as 2004... is this normal?
    NTO: building a better network thru collaboration
    www.needtoorder.com | www.coffeewitheinstein.com

  4. #214
    Join Date
    Mar 2006
    Location
    Auckland, New Zealand
    Posts
    229
    Plugin Contributions
    0

    Default Re: Monthly Sales and Tax Summary Report [support thread]

    Quote Originally Posted by lat9 View Post
    HTTP 500 error => Check your /logs sub-directory (or view using the Display Logs plugin) to find the debug-log that caused that error return.
    [28-Dec-2021 11:51:20 Pacific/Auckland] PHP Fatal error: require(): Failed opening required 'includes/classes/MonthlySalesAndTax.php' (include_path='.:/opt/cpanel/ea-php73/root/usr/share/pear') in /home/amoraromatherapy/public_html/admin/stats_monthly_sales.php on line 138
    Elemi

    The Art of Bespoke Aromatherapy
    www.AmorAromatherapy.co.nz

  5. #215
    Join Date
    Mar 2006
    Location
    Auckland, New Zealand
    Posts
    229
    Plugin Contributions
    0

    Default Re: Monthly Sales and Tax Summary Report [support thread]

    Quote Originally Posted by Elemi View Post
    [28-Dec-2021 11:51:20 Pacific/Auckland] PHP Fatal error: require(): Failed opening required 'includes/classes/MonthlySalesAndTax.php' (include_path='.:/opt/cpanel/ea-php73/root/usr/share/pear') in /home/amoraromatherapy/public_html/admin/stats_monthly_sales.php on line 138
    Working now thanks to the missing file. :)

    And I really like it! <3 <3
    Elemi

    The Art of Bespoke Aromatherapy
    www.AmorAromatherapy.co.nz

  6. #216
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,401
    Plugin Contributions
    87

    Default Re: Monthly Sales and Tax Summary Report [support thread]

    Quote Originally Posted by Carbonless View Post
    Downloaded the new file... ran the report in Reports>Monthly Sales and it took about 5 minutes to render all of my data from as far back as 2004... is this normal?
    It might be. Due to strict MySQL installations having hissy fits about fields missing from the GROUP BY and the erroneous results returned when they were added, I had to pull the MySQL SUM()'s from the queries and do the summing in PHP.

    I'll look at the code (again) to see if that can be handled differently.

  7. #217
    Join Date
    Apr 2012
    Posts
    5
    Plugin Contributions
    0

    Default Re: Monthly Sales and Tax Summary Report [support thread]

    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?

  8. #218
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,401
    Plugin Contributions
    87

    Default Re: Monthly Sales and Tax Summary Report [support thread]

    Quote Originally Posted by persion View Post
    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?
    That field (orders_status :: sort_order) was added in zc157, which is the only Zen Cart version currently supported by the report. What version of Zen Cart are you using?

  9. #219
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,401
    Plugin Contributions
    87

    Default Re: Monthly Sales and Tax Summary Report [support thread]

    Just submitted v2.0.2 for the Zen Cart moderators' review; I'll post back here when it's available for download.

    This release contains the (previously missing) /YOUR_ADMIN/includes/modules/sms/tpl_stats_monthly_sales_taxes.php and modifies its data-gathering so that a report's generation doesn't take 'centuries'!

  10. #220
    Join Date
    Nov 2008
    Posts
    196
    Plugin Contributions
    0

    Default Re: Monthly Sales and Tax Summary Report [support thread]

    I have zen cart version info:
    Zen Cart 1.5.5d
    Database Patch Level: 1.5.5
    v1.5.5a [2016-05-30 17:05:28] (Version Update 1.5.4->1.5.5a)
    v1.5.4 [2015-02-18 04:55:48] (New Installation)
    v1.5.4 [2015-02-18 04:55:48] (New Installation)

    PHP Version: 5.6.40 (Zend: 2.6.0)
    Database: MySQL 5.5.62-cll

    And I wanted to know if I can install the newest version of this plug in, or if I need to install the one that is for 1.5.5? Please let me know, thank you.

 

 
Page 22 of 24 FirstFirst ... 122021222324 LastLast

Similar Threads

  1. Local Sales Tax Mod - Support Thread
    By LadyHLG in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 634
    Last Post: 8 Dec 2023, 06:59 PM
  2. v151 codeTrio Sales Summary Graph v1.0 [Support Thread]
    By imranulh in forum All Other Contributions/Addons
    Replies: 15
    Last Post: 25 Jul 2020, 04:00 AM
  3. v151 Sales Report with Graphs support thread
    By JacobBushnell in forum Addon Admin Tools
    Replies: 17
    Last Post: 25 Jul 2019, 02:27 PM
  4. Monthly Sales Report
    By Bruce1952 in forum General Questions
    Replies: 3
    Last Post: 10 Aug 2010, 01:06 PM
  5. Sales Tax Summary Report
    By fred_artemis in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 25 Mar 2008, 02:54 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR