Edit Orders v4.0 Support Thread

[lat9]

Oh it's an old dinosaur getting a transfusion now and then!



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

Nope, I'm guessing that one of your now-obsolete plugins made that change to the database, but I'm having a hard time determining where the issue was sourced.

[jacobsh]

Hello,

I'm trying to understand what is the reason behind edit orders removing the product and attributes from the database and assigning new ids? what is the reason for this behaver, is it to maintain sort order?

[carlwhat]

Hello,

I'm trying to understand what is the reason behind edit orders removing the product and attributes from the database and assigning new ids? what is the reason for this behaver, is it to maintain sort order?

wow. 1 post and already jumping into some nitty-gritty....

i have no good answers on that one; the current maintainer of the plugin has done an excellent job of straightening this plugin and making it workable. why the original author choose to do it that way is another question.... but addressing that issue seems to be a massive amount of refactoring and the potential for bugs is great...

there is a plugin to address some extra fields you may have added to the orders_products table here:

https://www.zen-cart.com/downloads.php?do=file&id=2292

i do not remember if i did something as well to address the attributes for products.

best.

[lat9]

I'd asked the previous maintainer the same question and, unfortunately, didn't bookmark his response.

As @carlwhat indicated, the re-structuring of EO to not regenerate those orders_products_id is going to be a fairly complicated exercise, since there are plugins that currently 'plug into' EO to manage the product variants ... and keeping downward compatibility is one of my 'hot buttons'.

[jacobsh]

thank you both of you! @carlwhat i'm working with zencart the whole day

[lat9]

I've just submitted v4.5.6 of Edit Orders for the Zen Cart moderators' review; I'll post back here when it's available for download.

This release contains changes associated with the following GitHub issues:

#182: Refactor to ensure that the price-calculation method is defined.
#183: Use foreach instead of for (where possible) in loops processing the updated order-totals.
#186: Correct missing constants in HTML email messages when updating orders (zc157+ interoperation).


Note: Subsequent releases of Edit Orders will support Zen Cart v1.5.7 (with applied bugfixes) and later only.

[lat9]

I've just submitted v4.5.6 of Edit Orders for the Zen Cart moderators' review; I'll post back here when it's available for download.

This release contains changes associated with the following GitHub issues:

#182: Refactor to ensure that the price-calculation method is defined.
#183: Use foreach instead of for (where possible) in loops processing the updated order-totals.
#186: Correct missing constants in HTML email messages when updating orders (zc157+ interoperation).


Note: Subsequent releases of Edit Orders will support Zen Cart v1.5.7 (with applied bugfixes) and later only.

Now available for download: https://www.zen-cart.com/downloads.php?do=file&id=1513

[lat9]

Sorry for the churn, but I've just submitted v4.5.7 of EO for the Zen Cart moderators' review and will post back here when it's available for download.

This release corrects GitHub issue #188 (Adding a product with a TEXT attribute causes a MySQL error).

[wsworx]

"Sorry for the churn"...lol.

Your the last individual here who has to apologize for anything lat9. While some of the options with SuperOrders were nice to have, and a couple needed, most of us could not do without EditOrders which you have graciously stepped in and kept up for us. We need a link to donate to you.

[swguy]

Approved.