Page 164 of 179 FirstFirst ... 64114154162163164165166174 ... LastLast
Results 1,631 to 1,640 of 1784
  1. #1631
    Join Date
    Oct 2020
    Location
    australia
    Posts
    31
    Plugin Contributions
    0

    Default Re: Edit Orders - Total Price column is Total Net

    Just installed today on my zen cart 1.5.7 (1.5.7, not 1.5.7a or 1.5.7b). I found that the subtotal does not change at all no matter how I add or remove products. But after I removed all the products, and then add new products to the order, all the calculation becomes right. It seems that the products already in the order are ignored in calculation

    Another problem is: when I use "reset totals prior to update", subtotal becomes 0, and does not change anymore, no matter how I add/remove products

    Really strange...

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

    Default Re: Edit Orders - Total Price column is Total Net

    Quote Originally Posted by markau View Post
    Just installed today on my zen cart 1.5.7 (1.5.7, not 1.5.7a or 1.5.7b). I found that the subtotal does not change at all no matter how I add or remove products. But after I removed all the products, and then add new products to the order, all the calculation becomes right. It seems that the products already in the order are ignored in calculation

    Another problem is: when I use "reset totals prior to update", subtotal becomes 0, and does not change anymore, no matter how I add/remove products

    Really strange...
    Not so strange ... zc157 (no alpha-suffix) has a critical flaw for any plugin that makes use of the notify/observe infrastructure of Zen Cart (like Edit Orders). Update your zc157 code base to zc157b or, at a minimum, update to use the known bugs in the zc157 series (https://www.zen-cart.com/showthread....v1-5-7-series).

  3. #1633
    Join Date
    Oct 2020
    Location
    australia
    Posts
    31
    Plugin Contributions
    0

    Default Re: Edit Orders - Total Price column is Total Net

    Quote Originally Posted by lat9 View Post
    Not so strange ... zc157 (no alpha-suffix) has a critical flaw for any plugin that makes use of the notify/observe infrastructure of Zen Cart (like Edit Orders). Update your zc157 code base to zc157b or, at a minimum, update to use the known bugs in the zc157 series (https://www.zen-cart.com/showthread....v1-5-7-series).
    Many thanks for your instructions. I updated the minimum, no effect. I already installed too many plugins so full update would be too painful. I give up.

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

    Default Re: Edit Orders - Total Price column is Total Net

    Quote Originally Posted by markau View Post
    Many thanks for your instructions. I updated the minimum, no effect. I already installed too many plugins so full update would be too painful. I give up.
    Any clues as to those 'other' plugins would certainly help in diagnosing your issue.

  5. #1635
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    9,625
    Plugin Contributions
    123

    Default Re: Edit Orders - Total Price column is Total Net

    Would it be possible to permit negative quantities to be used with the "Add Product" button, as a way of doing returns and exchanges?
    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.

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

    Default Re: Edit Orders - Total Price column is Total Net

    Quote Originally Posted by swguy View Post
    Would it be possible to permit negative quantities to be used with the "Add Product" button, as a way of doing returns and exchanges?
    You could create a change request on EO's GitHub repo (https://github.com/lat9/edit_orders), but since that's not a 'mainstream' usage it'll be a while before that change is incorporated into the EO distribution.

  7. #1637
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    9,625
    Plugin Contributions
    123

    Default Re: Edit Orders - Total Price column is Total Net

    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.

  8. #1638
    Join Date
    Sep 2011
    Location
    Tokyo
    Posts
    18
    Plugin Contributions
    1

    Default Re: Edit Orders - Total Price column is Total Net

    Hello!

    I tried to Google to find something relevant in this thread but I didn't... so please let me ask here.

    I finally updated my ZC to 1.5.6c with EO v4.5.5 + MariaDB 10.3.23.
    I also updated to utf8mb4 to fix the problems with Emojis.

    But when editing an order (just a comment + email sent) I got this:

    Field 'updated_by' doesn't have a default value

    Indeed orders_status_history.updated_by doesn't accept NULL (or default) in the Datase and EO SQL statement doesn't seem to populate 'updated_by' when making updates.

    Code:
    #5 zen_db_perform() called at [/var/www/XXX/admin-XXX/edit_orders.php:310]
    --> PHP Fatal error: 1364:Field 'updated_by' doesn't have a default value :: insert into orders_status_history (orders_id, orders_status_id, date_added, customer_notified, comments) values ('2477', '4', now(), '1', 'FOOBARFOOBAR') ==> (as called by) /var/www/XXX/admin-XXX/includes/functions/database.php on line 51 <== in /var/www/lespoisplumes.fr_v1.5.6c/includes/classes/db/mysql/query_factory.php on line 171.
    Did I forget to update an important file or is it the expected behavior, and it only worked so far because MySQL (before MariaDB) was less strict?

    I just did this to allow empty/NULL values and it works again.

    Code:
    ALTER TABLE `orders_status_history` CHANGE `updated_by` `updated_by` VARCHAR(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL;
    Julien

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

    Default Re: Edit Orders - Total Price column is Total Net

    Quote Originally Posted by generikz View Post
    Hello!

    I tried to Google to find something relevant in this thread but I didn't... so please let me ask here.

    I finally updated my ZC to 1.5.6c with EO v4.5.5 + MariaDB 10.3.23.
    I also updated to utf8mb4 to fix the problems with Emojis.

    But when editing an order (just a comment + email sent) I got this:

    Field 'updated_by' doesn't have a default value

    Indeed orders_status_history.updated_by doesn't accept NULL (or default) in the Datase and EO SQL statement doesn't seem to populate 'updated_by' when making updates.

    Code:
    #5 zen_db_perform() called at [/var/www/XXX/admin-XXX/edit_orders.php:310]
    --> PHP Fatal error: 1364:Field 'updated_by' doesn't have a default value :: insert into orders_status_history (orders_id, orders_status_id, date_added, customer_notified, comments) values ('2477', '4', now(), '1', 'FOOBARFOOBAR') ==> (as called by) /var/www/XXX/admin-XXX/includes/functions/database.php on line 51 <== in /var/www/lespoisplumes.fr_v1.5.6c/includes/classes/db/mysql/query_factory.php on line 171.
    Did I forget to update an important file or is it the expected behavior, and it only worked so far because MySQL (before MariaDB) was less strict?

    I just did this to allow empty/NULL values and it works again.

    Code:
    ALTER TABLE `orders_status_history` CHANGE `updated_by` `updated_by` VARCHAR(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL;
    Julien
    What's the site's history? In the 'original' osh_updated_by plugin and for the zc156+ upgrade, the SQL used to create the updated_by field has a default value:
    Code:
    ALTER TABLE orders_status_history ADD updated_by varchar(45) NOT NULL default '';

  10. #1640
    Join Date
    Sep 2011
    Location
    Tokyo
    Posts
    18
    Plugin Contributions
    1

    Default Re: Edit Orders - Total Price column is Total Net

    Quote Originally Posted by lat9 View Post
    What's the site's history?
    Oh it's an old dinosaur getting a transfusion now and then!

    v1.5.6c [2021-01-07 15:05:13] (Version Update 1.5.5->1.5.6c)
    v1.5.5e [2017-03-19 17:11:48] (Version Update 1.5.4->1.5.5e)
    v1.5.4 [2017-03-19 17:11:44] (Version Update 1.5.3->1.5.4)
    v1.5.3 [2017-03-19 17:11:40] (Version Update 1.5.2->1.5.3)
    v1.5.2 [2017-03-19 17:11:34] (Version Update 1.5.1->1.5.2)
    v1.5.1 [2017-03-19 17:11:28] (Version Update 1.5.0->1.5.1)
    v1.5.0 [2017-03-19 17:11:20] (Version Update 1.3.9->1.5.0)
    v1.3.9h [2010-11-04 22:35:18] (Version Update 1.3.9g->1.3.9h)
    v1.3.9g [2010-10-01 12:17:54] (Version Update 1.3.9f->1.3.9g)
    v1.3.9f [2010-09-10 23:38:40] (Version Update 1.3.8->1.3.9f)
    v1.3.8 [2009-07-04 20:22:05] (Fresh Installation)
    I guess the database structure is obsolete and somehow ZC SQL updates missed that one while MySQL would fail gracefully when MariaDB just won't now?

    Julien

 

 

Similar Threads

  1. v150 Super Orders v4.0 Support Thread for ZC v1.5.x
    By DivaVocals in forum Addon Admin Tools
    Replies: 797
    Last Post: 23 Mar 2024, 06:51 AM
  2. v150 Orders Status History -- Updated By [Support Thread]
    By lat9 in forum Addon Admin Tools
    Replies: 34
    Last Post: 29 Jul 2019, 07:05 PM
  3. Edit Orders v3.0 for ZC 1.3.9 [Support Thread]
    By DivaVocals in forum All Other Contributions/Addons
    Replies: 656
    Last Post: 18 Apr 2016, 06:28 PM
  4. v139h Super Orders v3.0 Support Thread (for ZC v1.3.9)
    By DivaVocals in forum All Other Contributions/Addons
    Replies: 1018
    Last Post: 28 Apr 2014, 11:38 PM
  5. RE: Super Orders v3.0 Support Thread
    By Johnnyd in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 22 Jun 2011, 09:28 AM

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