Edit Orders v3.0 for ZC 1.3.9 [Support Thread]

[GumboStandards]

As I have indicated in my posts and on my site, there is an auto-installer with edit Orders. NO external SQL file needed..

Right, thank you, I understood that the first go-around and have made several installation attempts thereafter. Yet the blank config menu remains when navigating to Admin Panel > Configuration > Edit Orders after each installation attempt. 1. Might this have something to do with the following SQL holdover from Edit Orders v1.5.3?

INSERT INTO `xzen_admin_files` (`id`, `page`, `header`, `submenu`) VALUES (93, 'edit_orders', 2, 0);

2.Or am I missing some SQL (see below)? 3.Or what is needed to get the config menu installed or to display properly? Using a freshly installed, clean database on top of already clean, no-modded Zen Cart 1.5.0 files is not an option.

If I have to massage a database entry or two hundred, fine, but installing it again won't work any better than the four previous times. Here is all the SQL I could find in my database relating to "edit order" and "edit_order" (let me know if I should try another keyphrase, thanks):

INSERT INTO `xzen_admin_activity_log` (`log_id`, `access_date`, `admin_id`, `page_accessed`, `page_parameters`, `ip_address`, `flagged`, `attention`, `gzpost`) VALUES (2308, '2012-07-09 08:38:25', 1, 'edit_orders.php', 'oID=122832&', '63.169.106.0', 0, '', '');

INSERT INTO `xzen_admin_files` (`id`, `page`, `header`, `submenu`) VALUES (93, 'edit_orders', 2, 0);

INSERT INTO `xzen_admin_pages` (`page_key`, `language_key`, `main_page`, `page_params`, `menu_key`, `display_on_menu`, `sort_order`) VALUES ('configEditOrders', 'BOX_CONFIGURATION_EDIT_ORDERS', 'FILENAME_CONFIGURATION', 'gID=51', 'configuration', 'Y', 55);

INSERT INTO `xzen_configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES (900, 'Ty Package Tracker Module Switch for Edit Orders v3.0 or Super Orders v3.0', 'TY_TRACKER', 'True', 'If you have the either Edit Orders v3.0 or Super Orders v3.0 installed, set this option to TRUE so that the Ty Package Tracker fields will display in Edit Orders or Super Orders<br><br><strong><font color=red>YOU MUST HAVE EDIT ORDERS v3.0 OR SUPER ORDERS v3.0 INSTALLED TO USE THIS FEATURE!!</font></strong><br><br>(Activating this flag without the required mod(s) installed <strong>WILL CAUSE ERRORS IN YOUR STORE!!!!</strong>)', 49, 175, '2012-07-09 07:50:32', '2012-07-09 07:48:22', NULL, 'zen_cfg_select_option(array(''True'', ''False''),'),

INSERT INTO `xzen_configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES (908, 'Edit Orders Version', 'EO_VERSION', '4.0', 'Installed Version', 52, 1, '2012-07-09 08:31:16', '2012-07-09 08:31:16', NULL, 'trim(');

INSERT INTO `xzen_configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES (909, 'Shipping Tax', 'SHIPPING_TAX', '0.0', 'Shipping tax is not stored in the database, but Edit Orders will use the value entered here to calculate the shipping tax and add it to the shipping totals', 52, 185, '2012-07-09 08:31:16', '2012-07-09 08:31:16', NULL, NULL);

INSERT INTO `xzen_configuration_group` (`configuration_group_id`, `configuration_group_title`, `configuration_group_description`, `sort_order`, `visible`) VALUES (52, 'Edit Orders', 'Settings for Edit Orders features', 52, 1);

[DivaVocals]

Right, thank you, I understood that the first go-around and have made several installation attempts thereafter. Yet the blank config menu remains when navigating to Admin Panel > Configuration > Edit Orders after each installation attempt. 1. Might this have something to do with the following SQL holdover from Edit Orders v1.5.3?

It would have nothing at all to do with this since there was no SQL file in the 1.5.3 flavor of Edit Orders that I remember..

2.Or am I missing some SQL (see below)? 3.Or what is needed to get the config menu installed or to display properly? Using a freshly installed, clean database on top of already clean, no-modded Zen Cart 1.5.0 files is not an option.

If I have to massage a database entry or two hundred, fine, but installing it again won't work any better than the four previous times. Here is all the SQL I could find in my database relating to "edit order" and "edit_order" (let me know if I should try another keyphrase, thanks):

Based on ALL of your previous posts it appears you do not have the same installer that is currently available on my site. (see my response to your previous post)

Installing on a clean non-modded Zen Cart isn't necessary. However, the lowest hanging fruit and the shortest path to resolving your issues in my opinion is for you to roll back your store to where it was BEFORE you installed Edit Orders (files and DB). Download the fileset again from my website and start over.. This makes more sense than spending a whole lot of time trying to figure out how to fix what appears to be a fileset that doesn't behave/look like the one available on my website should behave, my suggestion

[GumboStandards]

My signature appears in EVERY ONE of my forum posts -- including the post where I announced that Edit Orders v4.0 is available on my site.. Are you saying you STILL haven't found it??

Sprry, yes, I did find it tonight and the other night by clicking the Profile link. BTW, signatures do fail to appear on occasion in the auto-updating version of my Chrome now up to date at 20.0.01132.47. Sometimes I see them, sometimes I don't. I typically try to browse with an automatic cache-cleaned, latest version of Firefox but I don't always manage to do so. Like now and earlier tonight. See attached screenshot.

[GumboStandards]

It would have nothing at all to do with this since there was no SQL file in the 1.5.3 flavor of Edit Orders that I remember..



Based on ALL of your previous posts it appears you do not have the same installer that is currently available on my site. (see my response to your previous post)

Installing on a clean non-modded Zen Cart isn't necessary. However, the lowest hanging fruit and the shortest path to resolving your issues in my opinion is for you to roll back your store to where it was BEFORE you installed Edit Orders (files and DB). Download the fileset again from my website and start over.. This makes more sense than spending a whole lot of time trying to figure out how to fix what appears to be a fileset that doesn't behave/look like the one available on my website should behave, my suggestion

Trust me, the shortest path is for me to figure out WHY your mod is failing in my environment by tracking down what it takes to manually fix this. At least that's been my experience with many, many, many mods when repeated downloads/installs fail. FWIW, the only difference between the zip I downloaded ~45hrs ago from http://overthehillweb.com/free-downloads?did=12 and the zip I downloaded about an hour ago is the messageStack difference in init_eo_config.php.

And installation still fails. I'll figure it out by doing a WinMerge of what I hope is a successful Edit Orders install on a clean Zen install on an empty DB against the before and after copies of my dirty test DB and files reflecting the impact of an Edit Orders' installation attempt. At least I hope that reveals something as to what might be going wrong. Anyway, I was just hoping someone else had had experienced what I am going through and there was a quick solution. If I can't even get a successful install on clean Zen files/DB, I'll look at my server. I'll try to remember to post an update when I get this resolved.

[DivaVocals]

According to your earlier post you do indeed have files that are not part of the version of final version of Edit Orders tha I have on my site..

Here is the list of files I uploaded while logged into ap150:

[COLOR=#d########3]ap150\edit_orders.php
ap150\edit_orders.xphp
ap150\orders.php
ap150\images\icon_billing.png
ap150\images\icon_comment_add.png
ap150\images\icon_customers.png
ap150\images\icon_details.gif
ap150\images\icon_edit.gif
ap150\images\icon_invoice.gif
ap150\images\icon_shipping.png
ap150\images\icon_track_add.png
ap150\images\Thumbs.db[/COLOR]
ap150\includes\auto_loaders\config.edit_orders.php
[COLOR=#d########3]ap150\includes\auto_loaders\config.eo.php
ap150\includes\edit_orders.css
ap150\includes\extra_configures\edit_orders.php
ap150\includes\extra_datafiles\edit_orders_defines.php
ap150\includes\extra_datafiles\edit_orders_extra_datafiles.php
ap150\includes\functions\extra_functions\edit_orders_functions.php[/COLOR]
ap150\includes\init_includes\edit_orders\new_install.php
ap150\includes\init_includes\init_edit_orders_config.php
[COLOR=#d########3]ap150\includes\init_includes\init_eo_config.php
ap150\includes\languages\english\edit_orders.php
ap150\includes\languages\english\images\buttons\button_add_product.gif
ap150\includes\languages\english\images\buttons\Thumbs.db
ap150\includes\languages\french
ap150\includes\languages\french\edit_orders.php
ap150\includes\languages\french\images
ap150\includes\languages\french\images\buttons
ap150\includes\languages\french\images\buttons\button_add_product.gif[/COLOR]

I do not know where you acquired this particular version of Edit Orders, but it is a version that I did NOT post on my site nor give out to many individuals. I only gave this version out to those volunteers who were offering to help with with testing/development.. These files were EARLY versions of the current auto-installer and it's more than likely that these files being a part of your environment is one of the chief reasons why your Edit Orders install went awry. Some of the Edit Orders SQL you posted in your earlier posts comes straight from these errant/deprecated/unused files. It is NOT the SQL that is in the FINAL version.

If you do not want to or cannot rollback to your pre Edit Orders state, then you need to remove ALL the Edit Orders entries from your tables. (admin_pages, configuration, and configuration_group tables) Then, you must remove those files from your environment that DO NOT belong to the final Edit Orders codebase that's on my site and try again..

Trust me, the shortest path is for me to figure out WHY your mod is failing in my environment by tracking down what it takes to manually fix this. At least that's been my experience with many, many, many mods when repeated downloads/installs fail. FWIW, the only difference between the zip I downloaded ~45hrs ago from [link redacted] and the zip I downloaded about an hour ago is the messageStack difference in init_eo_config.php.

And installation still fails. I'll figure it out by doing a WinMerge of what I hope is a successful Edit Orders install on a clean Zen install on an empty DB against the before and after copies of my dirty test DB and files reflecting the impact of an Edit Orders' installation attempt. At least I hope that reveals something as to what might be going wrong. Anyway, I was just hoping someone else had had experienced what I am going through and there was a quick solution. If I can't even get a successful install on clean Zen files/DB, I'll look at my server. I'll try to remember to post an update when I get this resolved.

[GumboStandards]

According to your earlier post you do indeed have files that are not part of the version of final version of Edit Orders tha I have on my site..


I do not know where you acquired this particular version of Edit Orders, but it is a version that I did NOT post on my site nor give out to many individuals. I only gave this version out to those volunteers who were offering to help with with testing/development.. These files were EARLY versions of the current auto-installer and it's more than likely that these files being a part of your environment is one of the chief reasons why your Edit Orders install went awry. Some of the Edit Orders SQL you posted in your earlier posts comes straight from these errant/deprecated/unused files. It is NOT the SQL that is in the FINAL version.

If you do not want to or cannot rollback to your pre Edit Orders state, then you need to remove ALL the Edit Orders entries from your tables. (admin_pages, configuration, and configuration_group tables) Then, you must remove those files from your environment that DO NOT belong to the final Edit Orders codebase that's on my site and try again..

Now we're getting somewhere. Please provide a DIRECT LINK to the CORRECT zip file. And please DOUBLE CHECK it. Because I just downloaded it, again, for the third time, FROM YOUR SITE, http://overthehillweb.com/wp-content...load.php?id=12, and those files you're telling me that are not part of the zip are indeed part of the zip I am downloading from your site. Thank you!

[GumboStandards]

Oops, I tried to attach the zip file I downloaded from your site but when it failed, I had intended to include the file listing of edit_orders_v4.0.1.zip. Here it is with the three files in question in bold red:

edit_orders_v4.0.1\LICENSE.TXT
edit_orders_v4.0.1\1_Base_Files\YOUR_ADMIN_FOLDER\edit_orders.php
edit_orders_v4.0.1\1_Base_Files\YOUR_ADMIN_FOLDER\edit_orders.xphp
edit_orders_v4.0.1\1_Base_Files\YOUR_ADMIN_FOLDER\images\icon_billing.png
edit_orders_v4.0.1\1_Base_Files\YOUR_ADMIN_FOLDER\images\icon_comment_add.png
edit_orders_v4.0.1\1_Base_Files\YOUR_ADMIN_FOLDER\images\icon_customers.png
edit_orders_v4.0.1\1_Base_Files\YOUR_ADMIN_FOLDER\images\icon_details.gif
edit_orders_v4.0.1\1_Base_Files\YOUR_ADMIN_FOLDER\images\icon_edit.gif
edit_orders_v4.0.1\1_Base_Files\YOUR_ADMIN_FOLDER\images\icon_invoice.gif
edit_orders_v4.0.1\1_Base_Files\YOUR_ADMIN_FOLDER\images\icon_shipping.png
edit_orders_v4.0.1\1_Base_Files\YOUR_ADMIN_FOLDER\images\icon_track_add.png
edit_orders_v4.0.1\1_Base_Files\YOUR_ADMIN_FOLDER\includes\edit_orders.css
edit_orders_v4.0.1\1_Base_Files\YOUR_ADMIN_FOLDER\includes\auto_loaders\config.e o.php
edit_orders_v4.0.1\1_Base_Files\YOUR_ADMIN_FOLDER\includes\extra_configures\edit _orders.php
edit_orders_v4.0.1\1_Base_Files\YOUR_ADMIN_FOLDER\includes\extra_datafiles\edit_ orders_defines.php
edit_orders_v4.0.1\1_Base_Files\YOUR_ADMIN_FOLDER\includes\functions\extra_funct ions\edit_orders_functions.php
edit_orders_v4.0.1\1_Base_Files\YOUR_ADMIN_FOLDER\includes\init_includes\init_eo _config.php
edit_orders_v4.0.1\1_Base_Files\YOUR_ADMIN_FOLDER\includes\languages\english\edi t_orders.php
edit_orders_v4.0.1\1_Base_Files\YOUR_ADMIN_FOLDER\includes\languages\english\ima ges\buttons\button_add_product.gif
edit_orders_v4.0.1\1_Base_Files\YOUR_ADMIN_FOLDER\includes\languages\english\ima ges\buttons\Thumbs.db
edit_orders_v4.0.1\2_Modified_Core_Files\YOUR_ADMIN_FOLDER\orders.php
edit_orders_v4.0.1\3_SQL\edit_orders_uninstall.sql
edit_orders_v4.0.1\4_Language_Packs\YOUR_ADMIN_FOLDER\includes\languages\french\ edit_orders.php
edit_orders_v4.0.1\4_Language_Packs\YOUR_ADMIN_FOLDER\includes\languages\french\ images\buttons\button_add_product.gif
edit_orders_v4.0.1\readme\edit_orders_readme.html
edit_orders_v4.0.1\readme\images\blank.gif
edit_orders_v4.0.1\readme\images\bw2_tab_left.gif
edit_orders_v4.0.1\readme\images\bw2_tab_right.gif
edit_orders_v4.0.1\readme\images\index.html
edit_orders_v4.0.1\readme\images\spacer.gif
edit_orders_v4.0.1\readme\images\Thumbs.db
edit_orders_v4.0.1\readme\includes\css\stylesheet.css
edit_orders_v4.0.1\readme\includes\jscript\jscript_tabs.js
edit_orders_v4.0.1\YOUR_ADMIN\includes\auto_loaders\config.edit_orders.php
edit_orders_v4.0.1\YOUR_ADMIN\includes\extra_datafiles\edit_orders_extra_datafil es.php
edit_orders_v4.0.1\YOUR_ADMIN\includes\init_includes\init_edit_orders_config.php
edit_orders_v4.0.1\YOUR_ADMIN\includes\init_includes\edit_orders\new_install.php

[GumboStandards]

Ah, crap, I hadn't read your post to the end. Well, I sort of had, I skimmed it and meant to go back but I got ahead of myself, got interrupted and... Anyhow, I'll remove the files in red, rollback and give this a try in the morning. BTW, I had been rolling back with every Edit Orders installation I've tried. That's Troubleshooting 101, right?! I'd just been unwilling to rollback to pre-Edit Orders 1.5 files and database, which is why I was jus trying to get it working with a default install of Zen Cart 1.5.0. Cuz that was four years ago and 1.3.7 IIRC! Although I do still have the backup zip files for that development stage. :)

[GumboStandards]

Glad this is over with. I couldn't sleep with this awaiting. :)

Thank you!

And all I really needed to do was add the SQL below and ensure continuity on configuration_group_id. Oh, well, live and learn (to not get so frustrated as it affects communication).

INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES
(950, 'Shipping Tax', 'SHIPPING_TAX', '0.0', 'Shipping tax is not stored in the database, but Edit Orders will use the value entered here to calculate the shipping tax and add it to the shipping totals', 55, 185, '2012-07-10 01:26:49', '2012-07-10 01:26:49', NULL, NULL);

[DivaVocals]

Don't need the zip.. just some information.. which you provided..

edit_orders_v4.0.1\YOUR_ADMIN\includes\auto_loaders\config.edit_orders.php
edit_orders_v4.0.1\YOUR_ADMIN\includes\extra_datafiles\edit_orders_extra_datafil es.php
edit_orders_v4.0.1\YOUR_ADMIN\includes\init_includes\init_edit_orders_config.php
edit_orders_v4.0.1\YOUR_ADMIN\includes\init_includes\edit_orders\new_install.php

These files were included in the zip file inadvertently.. Didn't realize they were left in the the zip file.. Delete these files as they do not work. (which is why they were not supposed to be part of the final install package) I'll fix that this morning..

Ah, crap, I hadn't read your post to the end. Well, I sort of had, I skimmed it and meant to go back but I got ahead of myself, got interrupted and... Anyhow, I'll remove the files in red, rollback and give this a try in the morning. BTW, I had been rolling back with every Edit Orders installation I've tried. That's Troubleshooting 101, right?! I'd just been unwilling to rollback to pre-Edit Orders 1.5 files and database, which is why I was jus trying to get it working with a default install of Zen Cart 1.5.0. Cuz that was four years ago and 1.3.7 IIRC! Although I do still have the backup zip files for that development stage. :)

Part of troubleshooting is also trying to recreate a problem from start to finish.. which is why I was advocating rolling back.. I was unaware that those four files were inadvertently included in the fileset, and I could not recreate the issue. So rolling back and starting over is the best way to see what is occurring..

Glad this is over with. I couldn't sleep with this awaiting. :)

Thank you!

And all I really needed to do was add the SQL below and ensure continuity on configuration_group_id. Oh, well, live and learn (to not get so frustrated as it affects communication).

INSERT INTO `configuration` (`configuration_id`, `configuration_title`, `configuration_key`, `configuration_value`, `configuration_description`, `configuration_group_id`, `sort_order`, `last_modified`, `date_added`, `use_function`, `set_function`) VALUES
(950, 'Shipping Tax', 'SHIPPING_TAX', '0.0', 'Shipping tax is not stored in the database, but Edit Orders will use the value entered here to calculate the shipping tax and add it to the shipping totals', 55, 185, '2012-07-10 01:26:49', '2012-07-10 01:26:49', NULL, NULL);

Actually if you have any of the SQL generated by those four files, you really do need to remove ALL of the Edit Orders DB entries, remove those four files, log into your store, re-upload the edit_orders_v4.0.1\1_Base_Files\YOUR_ADMIN_FOLDER\includes\auto_loaders\config.e o.php file and then click any link to properly re-run the install..