Edit Orders v4.0 Support Thread

[lat9]

I just uploaded v4.1.5 of Edit Orders to the plugins for review: https://www.zen-cart.com/downloads.php?do=file&id=1513

The following changes are included:

• BUGFIX: Correct "Unknown column 'p.products_quantity' in 'field list".
• BUGFIX: Corrections for coupons with category / product restrictions.
• CHANGE: Account for order-total modules that have been removed.
• CHANGE: Mimic storefront sort-order for attributes' display.
• BUGFIX: Correct incorrect tax-calculations after editing an order.
• BUGFIX: Correct multi-line comments display with \r\n.
• CHANGE: Include a "Miscellaneous Cost" order-total that's Edit Orders specific.
• BUGFIX: Correct interaction with stores that use the "Split Tax Lines" configuration.
• CHANGE: Remove reliance on the built-in currency initialization scripts.
• CHANGE: Add support for the "admin sanitization" introduced in Zen Cart 1.5.5.

Please note: This distribution includes a core-file change to the admin's /orders.php script, using the Zen Cart 1.5.4 version of the file as the change-basis. If you are installing on Zen Cart 1.5.5 or later, you'll need to merge the five (5) marked EO-related changes into your version of that file.

[MikeyG]

I have a strange problem, I could not see anyone else with this issue but I might have missed it in this thread.
I am using ZC 1.5.4 and EO 4.1.4. When I go to edit an order where the product has attributes the order changes from having a size of 0-3months to having a size: please select...

This cannot be edited.

If I go to add a product to the order from the edit product page, I cannot choose the options for the product I just get size: please select...

Have I got a setting wrong or is there a bug.

If I go back to the order without updating the order is as per the order when put on the system. If I update without making any changes then the product option changes to the size: please select. This is set as my display only option for the front of the site.

I have tired to follow the error log and which has confused my as to which table it is using for the product information. I have two tables orders_products_attributes and orders_products_attributes_stock and I am not sure which one is being used when to pull the attributes for the order from.

At one point I was missing the second table and getting an error when placing an order. That now seems to be fixed as I have generated the table but i am now wondering if this is linked to the error I am now getting.

Yes I have stock_by_attributes module as well.

thank you in advance for some advice on how to cure.

[mc12345678]

I have a strange problem, I could not see anyone else with this issue but I might have missed it in this thread.
I am using ZC 1.5.4 and EO 4.1.4. When I go to edit an order where the product has attributes the order changes from having a size of 0-3months to having a size: please select...

This cannot be edited.

If I go to add a product to the order from the edit product page, I cannot choose the options for the product I just get size: please select...

Have I got a setting wrong or is there a bug.

If I go back to the order without updating the order is as per the order when put on the system. If I update without making any changes then the product option changes to the size: please select. This is set as my display only option for the front of the site.

I have tired to follow the error log and which has confused my as to which table it is using for the product information. I have two tables orders_products_attributes and orders_products_attributes_stock and I am not sure which one is being used when to pull the attributes for the order from.

At one point I was missing the second table and getting an error when placing an order. That now seems to be fixed as I have generated the table but i am now wondering if this is linked to the error I am now getting.

Yes I have stock_by_attributes module as well.

thank you in advance for some advice on how to cure.

The second table: orders_products_attributes_stock is not accessed by SBA (yet) but is used to store data with an expectation that in the future it will be used. It should have no effect on EO unless other code has been incorporated to access a similar named table possibly having a different configuration. Otherwise the only change(s) made to the admin orders.php file in SBA are to support pulling the customid which still at this time uses live data rather than the order history data stored in the above referenced table. I therefore would say that the issue is related to something else though there could also be something going on if there are observers that are interacting with default ZC notifiers.

[lat9]

@MikeyG: Have you, by any chance, installed the Trustwave Security Patch on your ZC1.5.4 site?

[MikeyG]

Lat9,

Could this cause issues if it has been installed?

[MikeyG]

mc12345678

Thanks for the reply, I have been through carefully to see what I might have tried to merge with these files, My mods are Superorders and edit orders, Stock by attributes, and then the tableau template by numinix which seems to incorporate Image handler 4. I have the google merchant feeder as well. No other mods so one of these must be causing the interference with edit orders. The only file in the admin/includes/classes/observers folder is the stock by attributes file. Not full understanding the classes system I am assuming that the problem could lie in any of the class files not just in the observer folder.

[lat9]

Lat9,

Could this cause issues if it has been installed?

Yes. That's the same admin-level code change, introduced in Zen Cart 1.5.5, that led to the release of EO 4.1.5. That version of EO should be available real-soon-now from the Zen Cart plugins; you can get it now from EO's GitHub repository: https://github.com/lat9/edit_orders/releases/tag/v4.1.5

[lat9]

Edit Orders v4.1.5 is now available for download from the Plugins section.

[henry3]

Installing the latest Trustwave Security Patch from the Announcements broke Edit Orders 4.1.5. Replacing the files from the Zencart 1.5.5a distribution fixed it. Is someone looking at it ?

[swguy]

Could you be more specific about what you mean when you say the latest Trustwave broke EO?