Edit Orders v4.0 Support Thread

[landron]

Zencart 1.51 fresh install (not an upgrade) utizing FTP and run zen_install. Site has been doing business about a year and functioning fine. I never used the edit orders until needing it recently.

Server OS: Linux 3.12.32.1415814620 Database: MySQL 5.5.40-36.1-log
HTTP Server: Apache
PHP Version: 5.4.34 (Zend: 2.4.0)

Plug-ins include Super Orders ver 4.0.2 and Ty Package Tracker (no version # listed) which were installed over a year ago together with Edit Orders 4.10. Many other plug-ins affecting various areas and all work.

As per the posting instructions, I looked for "myDebug-adm-xxxxxxx.log" can't seem to find it. I don't have a folder named "myDebug" anywhere that I can can find when viewing in Filezilla.There is no "logs" folder and the "cache" folde does not have any logs in it.

When viewing "/admin/orders.php" I'm seeing "HEADING_TITLE_ORDERS_LISTING" above my list of orders. There use to be something else there and I can't recall but this doesn't seem right.

When viewing "/admin/edit_orders.php" I get a "HTTP 404" error page from my hosting company

When hitting either "Edit" button (on the orders.php page or on the details page of a specific order), I also get the "HTTP 404" error page from my hosting company and the url that appears is /admin/FILENAME_ORDER_EDIT.php?oID=562

Prior to upgrading Edit Orders this morning, I was running Edit Orders ver 4.10 and it looked right and partially functioned. It allowed me to edit the quantity of a line item but gave me a blank screen as a result. Going back would bring the page back with the new quantity and line item total. It would not allow any editing to the totals or shipping charges nor did they change automatically. When I saw there was a new version, I went through the install as per the readme and this is how I got to the present state.

The site is: http://OnlineWineSale.com

[lhungil]

...
When viewing "/admin/orders.php" I'm seeing "HEADING_TITLE_ORDERS_LISTING" above my list of orders. There use to be something else there and I can't recall but this doesn't seem right.
...

This is not caused by Edit Orders. This indicates either the language file for Super Orders is missing -- or -- something is wrong with the copy of "/admin/orders.php" in your store (on the webserver).

... When viewing "/admin/edit_orders.php" I get a "HTTP 404" error page from my hosting company ... When hitting either "Edit" button (on the orders.php page or on the details page of a specific order), I also get the "HTTP 404" error page from my hosting company ...

This would indicate files may not have been uploaded to the correct location on the server (during step 2 - New Files). During installation step 3 (Installer) of Edit Orders what message was reported in the Zen Cart administrative interface?

... When viewing "/admin/edit_orders.php" I get a "HTTP 404" error page from my hosting company ... and the url that appears is /admin/FILENAME_ORDER_EDIT.php?oID=562 ...

This indicates not all files were uploaded (or uploaded to the wrong location) - in particular missing language files.

... Prior to upgrading Edit Orders this morning, I was running Edit Orders ver 4.10 ... It allowed me to edit the quantity of a line item but gave me a blank screen as a result. ...

When a blank screen is encountered there will be a corresponding debug file. The debug file contains vital information to help determine the cause. In the latest version of Edit Orders, one can optionally enable debugging which will generate files with additional information (such as the installed order total modules - 3rd party order totals are the most common cause). Once everything else is sorted, we can revisit this item if necessary.


Recommendations:
Revert "/admin/orders.php" back to a stock Zen Cart 1.5.1 file.

1. Download the latest version of Ty Package Tracker (TPT).
2. Install TPT and verify installation.
3. Record the installed version somewhere easy to find.
4. Download the latest version of Super Orders (SO).
5. Review the instructions related to compatibility / installation when TPT is installed.
6. Install, Configure, and Verify SO installation.
7. Download the latest version of Edit Orders (EO).
8. Review the instructions related to compatibility / installation when TPT and SO are installed.
9. Install, Configure, and Verify EO installation.

This should result in a working installation of TPT, SO, and EO. Make sure during installation step 2 (New Files) of Edit Orders you upload ALL of the new files to their corresponding locations (overwriting any existing files on the server).

[landron]

Well, I'm extremely frustrated.

I followed your directions and

- Uploaded and overwrote orders.php file in my admin folder with the stock Zencart 1.51 file

- The version of TY is 3.1.1 which is apparently the latest but I uploaded and overwrote all the files anyway. It seems to be OK on its own and the admin screen under configuration kept my previous settings.

- installed the latest version of Super Orders (4.0.9) next although the Super Orders instructions suggest to install Edit Orders first. Installation directions refer to "2_Modified_Core_Files" There are actually folders labeled 2a_Modified_Core_Files and 2b_Modified_Core_Files-COWOA so I uploaded both. I have no idea what the "COWOA" may refer to and I couldn't find the term in the instructions. The resulting screens in my admin looked normal and I got the new buttons. Strange thing is on the bottom of the Super Orders configuration screen it lists the version as 4.0.5

- I now installed Edit Orders (4.1.4) and did not upload the orders.php file in 1_modified_core_files as per the integration instructions for use with Super Orders. I logged into admin prior to uploading the install files and the script apparently ran giving me the light green bar of success after clicking on a link. "Found previous version installed. Upgrading (or re-installing) Edit Orders (old 4.1.4 => new 4.1.4).
Success Edit Orders installation / upgrade completed!"

I did not perform any file mergers as I don't believe that I have any other order related plug-ins

End result:

I still have the "HEADING_TITLE_ORDERS_LISTING" above my orders list
I still have the "HEADING_TITLE_ORDER_DETAILS562" above the details of an individual order

Clicking on either EDIT button now brings me "WARNING: An Error occurred, please refresh the page and try again." on an otherwise blank page. The resulting URL's are: From the orders details page for order number 562: "mysite/myadmin/edit_orders.php?oID=562" and from the orders list: "edit_orders.php?page=1&oID=562&action=edit"

I very much appreciate assistance

[lhungil]

...
- installed the latest version of Super Orders (4.0.9) next ... Installation directions refer to "2_Modified_Core_Files" There are actually folders labeled 2a_Modified_Core_Files and 2b_Modified_Core_Files-COWOA so I uploaded both. ...

If I remember correctly (I think it was a discussion somewhere in the Zen Cart forums), "Super Orders" contains modified files for a stock installation of Zen Cart 1.5.0/1.5.1 in the "2_Modified_Core_Files" folder (these should be applied when installing "Super Orders"). "2b_Modified_Core_Files-COWOA" contains merges for integration with CheckOut WithOut Account (and should only be applied if the COWOA module is installed).

As for the version number being "off", the last person to upload "Super Orders" probably forgot to update the version number. I would not worry about that too much (as long as it reports >= 4.0.5).

...
I still have the "HEADING_TITLE_ORDERS_LISTING" above my orders list
I still have the "HEADING_TITLE_ORDER_DETAILS562" above the details of an individual order
..

This indicates the language files for "Super Orders" were not installed in the correct location, the upload was corrupted, or the administrative interface is not in English. In particular: "/2a_Modified_Core_Files/YOUR_ADMIN/includes/languages/english/orders.php" will need to be uploaded to "/admin/includes/languages/english/orders.php" (or if using Spanish in the Zen Cart administrative interface to "/admin/includes/languages/spanish/orders.php").

This is not something caused by "Edit Orders". I would double check the files uploaded during the installation of "Super Orders" especially the language files.

...
- I now installed Edit Orders (4.1.4) and did not upload the orders.php file in 1_modified_core_files as per the integration instructions for use with Super Orders. I logged into admin prior to uploading the install files and the script apparently ran giving me the light green bar of success after clicking on a link. "Found previous version installed. Upgrading (or re-installing) Edit Orders (old 4.1.4 => new 4.1.4).
Success Edit Orders installation / upgrade completed!"

...

Clicking on either EDIT button now brings me "WARNING: An Error occurred, please refresh the page and try again." on an otherwise blank page. ...

A step in the right direction! Now we are no longer getting a "HTTP 404", so the page exists. And "Super Orders" has the correct link!

When one encounters "WARNING: An Error occurred, please refresh the page and try again.", this indicates an error occurred. Please post the contents of the debug log generated by Zen Cart (needed to further troubleshoot). Use a "code" block when posting (click the # in the editor) so we can more easily read the contents.


NOTE: The most common causes for seeing the above message when loading the "Edit Orders" administrative page are: skipped / incorrect merges to core Zen Cart files during installation step 1 of "Edit Orders", third party "Order Total Modules" installed (which cause errors when loaded from the administrative side of Zen Cart), and corrupt order data (caused by 3rd party access / manipulation of the Zen Cart database).

[landron]

OK; after researching and realizing that the COWOA files in Super Orders didn't apply to me, I deleted them from the server and re-uploaded the base and 2a Modified files in attempting to invoke the install script. No script ran even though I was logged into admin and then clicked a link. Headings all look proper now. Hitting the Edit button now brings me to an edit screen where I can edit most aspects of the order. However, clicking "update" results in "WARNING: An Error occurred, please refresh the page and try again." on an otherwise white page. Hitting back on my browser brings back the edit screen and my changes were saved for all customer info but not the dollar amounts.

Adding products brings me to a product selection screen but after selecting a product and clicking "Add Now", I get a completely white screen; not even an error message. Hitting my back button on my browser a few times brings me back to the edit order screen and the new product is now included although the Sub-Total and Total dollar amounts do not reflect the addition. I certainly wouldn't mind manually entering new dollar amounts as shipping would also change but the new amounts that I entered do not get saved. Some progress but not quite there yet.

[lhungil]

OK; after researching and realizing that the COWOA files in Super Orders didn't apply to me, I deleted them from the server and re-uploaded the base and 2a Modified files ... Headings all look proper now. Hitting the Edit button now brings me to an edit screen where I can edit most aspects of the order. However, clicking "update" results in "WARNING: An Error occurred, please refresh the page and try again." ...

When one encounters "WARNING: An Error occurred, please refresh the page and try again.", this indicates an error occurred. Please post the contents of the debug log generated by Zen Cart (needed to further troubleshoot). Use a "code" block when posting (click the # in the editor) so we can more easily read the contents.


NOTE: The most common causes for seeing the above message when loading the "Edit Orders" administrative page are: skipped / incorrect merges to core Zen Cart files during installation step 1 of "Edit Orders", third party "Order Total Modules" installed (which cause errors when loaded from the administrative side of Zen Cart), and corrupt order data (sometimes caused by 3rd party access / manipulation of the Zen Cart database).

[landron]

Found a switch to turn on debugging in Edit Orders config screen. I can only hope that is is what you mean as it did produce a log file after setting it to "Product" which resulted in a "4" on the config screen. Here's the file:

[05-Dec-2014 16:00:09 America/New_York] PHP Fatal error:  1054:Unknown column 'p.products_quantity' in 'field list' :: SELECT `p`.`products_quantity` FROM `products` WHERE `p`.`products_id` = '1424' in /home2/onlinio3/public_html/includes/classes/db/mysql/query_factory.php on line 120

[landron]

I located the bug and fix in lines 1025 - 1028 of the edit_orders_functions.php in numerous posts here and made the change. Still wind up with blank screens.