Track Package from FedEx, UPS, Postal, DHL, etc..

[Mega Moonshine]

DivaVocals,

Thanks for your time, suggestions and feedback. I am happy to say I found the source of the problem and it has NOTHING to do with any of the mods (EO, TPT or SO) which you graciously tweak and maintain on your own for the benefit of all.

The PROBLEM is with another mod that I installed earlier that changed the CONFIGURATION table by adding another column. It is from NUMINIX and the mod is FEAC (Fast and Easy Ajax Checkout - version 2.27.2). The mod apparently added the additional column "configuration_tab" and it is used to sort and present a tabbed interface for it's own mod's and could be used by others (if they know how).

While the FEAC table change provides a cool interface and grouping of admin tasks, I was not aware (or remembered) the change to one of the main core tables for admin when I installed FEAC. It wasn't until now that I discovered/realized this.

This means with the FEAC mod installed, all future 3rd party admin mods may fail installation because the SQL code is not aware of the added (12th) column in the table. But if you know about it (and need to remember this...) one can easily add the 12th column value (the default value should be: 'General').

But that requires a bit of Zen Cart, PHP and SQL skills to do so, along with determining where in the mod (to be installed) the changes or edits should be made. Simple install SQL file edits is easy enough, but mods that have auto-installers make it a bit harder to figure out.

I'm disappointed that NUMINIX has chosen to do it this way, as it affects future mod installations from any other mod provider. I think the tabbed interface could have been done differently to provide the same affect, but without having to modify the table to do so, thus not cause issues with other mods from other sources.

But it is what it is. I like the Numinix FEAC mod btw, but the table change came as a bit of a surprise and what it means for ease of installation for other mods (harder, more complicated). But Numinix does offer 3rd Party Mod Installation Services for a fee. Not that I've had to use it as I have usually been able to figure things out eventually. But still...

The proceeding posts were a result of frustration from not being aware of the source of the problem when I knew I was doing everything correctly, but it wasn't working!

Okay, here is what I did to fix the problem exactly:

In the file, init_typt_config.php where it starts inserting into the CONFIGURATION table, I added in RED (in every $sql line):

$sql = "INSERT INTO ".DB_PREFIX."configuration VALUES (val 1, val 2, val 3, val 4, val 5, val 6, val 7, val 8, val 9, val 10, val 11, 'General')";

Once I did that, the install went smoothly and without a hitch. Whew!

Which makes me wonder if the EDIT ORDERS mod I installed just before is actually "Okay", as it appeared to have installed successfully, but I only get this option in the Admin's Edit Orders menu and nothing else:

Edit Orders Version Indicates the currently installed version of Edit Orders. [blank]

I looked and searched in the EO mod's code to see where it too might insert into the configuration table, but didn't find anything...

Does the Edit Orders look to be installed correctly? (Only one option, albeit a blank for "Version"?) Since this is a new Zen Cart install, there are no actual orders in the database, etc., if that has any impact for what is or isn't displayed...

Chris

[DivaVocals]

I'm disappointed that NUMINIX has chosen to do it this way, as it affects future mod installations from any other mod provider. I think the tabbed interface could have been done differently to provide the same affect, but without having to modify the table to do so, thus not cause issues with other mods from other sources.

But it is what it is. I like the Numinix FEAC mod btw, but the table change came as a bit of a surprise and what it means for ease of installation for other mods (harder, more complicated). But Numinix does offer 3rd Party Mod Installation Services for a fee. Not that I've had to use it as I have usually been able to figure things out eventually. But still...

Disappointing indeed as it will cause issues with a few modules.. I suppose I could update the install script to call out the specific fields to prevent the mis-match errors.. Don't know when I'll have time to make that change,ut I can update the readme to make note of this issue..

The proceeding posts were a result of frustration from not being aware of the source of the problem when I knew I was doing everything correctly, but it wasn't working!

Right, and I can't really assist with issues I can't recreate..

Which makes me wonder if the EDIT ORDERS mod I installed just before is actually "Okay", as it appeared to have installed successfully, but I only get this option in the Admin's Edit Orders menu and nothing else:



I looked and searched in the EO mod's code to see where it too might insert into the configuration table, but didn't find anything...

Does the Edit Orders look to be installed correctly? (Only one option, albeit a blank for "Version"?) Since this is a new Zen Cart install, there are no actual orders in the database, etc., if that has any impact for what is or isn't displayed...

Chris

You'll need to ask on the Edit Orders thread.. been a VERY long time since I looked at the install files..

[vlowrance84]

I just finished reading 76 pages of this thread and I still can't find the answer to my question. I can see my side box show up on the left hand side of my website but I'm not sure how to change the side box title? Inside the side box it display's correctly track your orders but I want to change the column Box name. Please see attached file. Any suggestion?

[twitchtoo]

vlowrance84, your language file is not loading this:
includes/languages/YOUR_TEMPLATE/english.php
Line 688 - 689
//text for Ty Package Tracker sidebox heading
define('BOX_HEADING_TRACK_ORDERS', 'Previous Orders');

Be sure the file exists on the server with the additional define text within your template override.

[DivaVocals]

Working on finalizing v3.1.4 of Ty Package Tracker.. I've created a Github repository for TYPT: https://github.com/DivaVocals/zen_TyPackageTracker

For those familiar with how Github works, the master branch is current version available in the downloads (v3.1.3). See the v3.1.4 branch for the upcoming release. Any version in development should be considered BETA and NOT for use in a live shop. There is NO SUPPORT on this forum for any BETA versions of TYPT..

Ty Package Tracker for Zen Cart v3.1.4

Changelog

Version 3.1.4 - 09/17/2013

• Updated tracking entry code (lhungil)
• Another fix to the sidebox code to HTML fix validation errors (colosports)
• Moved sidebox defines from includes/languages/YOUR_TEMPLATE/english.php into a new extra_definition file (includes/languages/english/extra_definitions/YOUR_TEMPLATE/track_orders.php)

[MyCoolHats]

Okay, here is what I did to fix the problem exactly:

In the file, init_typt_config.php where it starts inserting into the CONFIGURATION table, I added in RED (in every $sql line):

$sql = "INSERT INTO ".DB_PREFIX."configuration VALUES (val 1, val 2, val 3, val 4, val 5, val 6, val 7, val 8, val 9, val 10, val 11, 'General')";

Once I did that, the install went smoothly and without a hitch. Whew!

I had this exact thing happen to me and I am so mad. I tried to follow your instructions, but can you show me exactly what you did. I tried inserting the , 'General' as you instructed, but I still cannot login to my admin. I know that add on FEC is to blame and I need some help fixing it. Any advise would be fantastic. Thank you!

[MyCoolHats]

I had this exact thing happen to me and I am so mad. I tried to follow your instructions, but can you show me exactly what you did. I tried inserting the , 'General' as you instructed, but I still cannot login to my admin. I know that add on FEC is to blame and I need some help fixing it. Any advise would be fantastic. Thank you!

Actually I figured it out, I was just putting them in the wrong space. Your suggestion does work. For an example, I started the editing on line 41 of the ty tracker files/install_files/YOUR_ADMIN/includes/init_includes/init_typt_config.php. I added , 'General' at the very end of the line but before )";

$sql = "INSERT INTO ".DB_PREFIX."configuration VALUES (NULL, 'Package Tracking - Carrier 1 Status', 'CARRIER_STATUS_1', 'True', 'Enable Tracking for Carrier 1<br /><br />Set to false if you do NOT want Carrier 1 to be displayed on Admin and Customer page.', '".$typt_configuration_id."', 90, now(), now(), NULL, 'zen_cfg_select_option(array(\'True\', \'False\'), ', 'General')";
    $db->Execute($sql); 

I am just noting this for any future person who had the same problem. This is all resulting from installing Fast & Easy Checkout module - grrrr.

[DivaVocals]

Actually this one is on me for using a "blind" add to the config table.. because Numinix modules like FEC and Google Product Search add a column to the config table my "blind" add doesn't account for the additional column.. Will be fixed in the next release (avail on Github)

Actually I figured it out, I was just putting them in the wrong space. Your suggestion does work. For an example, I started the editing on line 41 of the ty tracker files/install_files/YOUR_ADMIN/includes/init_includes/init_typt_config.php. I added , 'General' at the very end of the line but before )";

$sql = "INSERT INTO ".DB_PREFIX."configuration VALUES (NULL, 'Package Tracking - Carrier 1 Status', 'CARRIER_STATUS_1', 'True', 'Enable Tracking for Carrier 1<br /><br />Set to false if you do NOT want Carrier 1 to be displayed on Admin and Customer page.', '".$typt_configuration_id."', 90, now(), now(), NULL, 'zen_cfg_select_option(array(\'True\', \'False\'), ', 'General')";
    $db->Execute($sql); 

I am just noting this for any future person who had the same problem. This is all resulting from installing Fast & Easy Checkout module - grrrr.

[tnjon]

will it work on zen-cart-v1.5.3

[[email protected]]

will it work on zen-cart-v1.5.3

with some tweaks yes :)