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

FATAL ERROR on initial install of Ty Pkg Tracker:

Getting this in logs:

[27-Nov-2013 08:27:42 UTC] PHP Fatal error: 1136:Column count doesn't match value count at row 1 :: INSERT INTO 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.', '37', 90, now(), now(), NULL, 'zen_cfg_select_option(array(\'True\', \'False\'), ') in /includes/classes/db/mysql/query_factory.php on line 120

It's getting late, gotta sleep and letting this issue perk a bit for a response from all you Uber Zenners... lol

Until I return much rested, have a Good Night!

Quote:

---

Originally Posted by Mega Moonshine

I'm installing Ty Pkg Tracker (version 3.1.3) for the first time and have some questions for the following files:

(1) 2_Required_Core_Edits\includes\languages\english\YOUR_TEMPLATE\account_history_i nfo.php -- This appears under "Your Template", which is fine as the template overrides allow for it there. So is it really a CORE file at this location? The DEFAULT location is actually under: includes\languages\english\account_history_info.php

---

Semantics.. huh.. well okay..:blink:

YES..

Core file = not a NEW Zen Cart file... so YES when I put together the install package, I included OVERRIDE files in the core files folder including "includes\languages\english\YOUR_TEMPLATE\account_history_info.php" & "includes\languages\YOUR_TEMPLATE\english.php" is.. Hence the folder name "2_Required_Core_Edits".

Quote:

---

Originally Posted by Mega Moonshine

(2) 2_Required_Core_Edits\includes\languages\YOUR_TEMPLATE\english.php -- My concern here is that the contents of the mod's file "english.php" at this location appears to be much the same as the CORE english.php file located at: includes\languages\english.php -- Is this intended? Just seems a bit overkill...

---

Overkill?? Is it intended??

well it's an OVERRIDE file and this is the way the Zen Cart OVERRIDE system is supposed to work... You don't modify the DEFAULT core file, you create an OVERRIDE for it.. and YES you can (and should) create an override for a language file even if it's a SMALL change..

Now that said you certainly can opt to modify the default file, and hope you don't forget at the next Zen Cart upgrade.. It's not recommended, but it's your site.. so that is entirely up to you..

Quote:

---

Originally Posted by Mega Moonshine

I'm no expert here, but I've peeked and poked around Zen Cart code long enough to think something is a bit odd. And if the wrong file was grabbed by mistake for making the mod package zip file, no worries! I've done it a time or two myself.

---

Suggest reviewing the override system FAQ. Your understanding of how the override system works is a tad incomplete..: http://www.zen-cart.com/content.php?...verride-system

Quote:

---

The Override System includes:
Language Files: includes/languages
Module Files: includes/modules
Template Files: includes/templates/template_default
Extra Definitions: includes/languages/ENGLISH/extra_definitions
Extra Data Files: includes/extra_datafiles

---

Quote:

---

Originally Posted by Mega Moonshine

FATAL ERROR on initial install of Ty Pkg Tracker:

Getting this in logs:

[27-Nov-2013 08:27:42 UTC] PHP Fatal error: 1136:Column count doesn't match value count at row 1 :: INSERT INTO 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.', '37', 90, now(), now(), NULL, 'zen_cfg_select_option(array(\'True\', \'False\'), ') in /includes/classes/db/mysql/query_factory.php on line 120

It's getting late, gotta sleep and letting this issue perk a bit for a response from all you Uber Zenners... lol

Until I return much rested, have a Good Night!

---

Dunno why you are getting this error.. it's never been reported before. There are 11 columns in the configuration table and 11 columns the script attempts to update.. Suggest running the uninstall script and try re-doing your install..

Thanks for getting back, DivaVocals.

It was just a couple of questions based on past observations with my limited experience with Zen Cart. I've seen where the main file includes/languages/english.php exists but the includes/languages/Your_Template/english.php file is used to extend the main without having to touch it. At least that is my understanding. I thought that both are read during execution and that redundancy of DEFINE's is just wasted cycles. You're probably right in that I could brush up on ZC with some light pleasure reading... lol

I didn't mean to raise any ire. Just had some questions. It was late, I was tired and not all cylinders were firing.

As for the FATAL error (which also prevented Admin Login's with a blank page and a simple Warning: yada, yada, yada), I did try the following:

1. Ran the uninstall SQL script. No change.
2. In the init_includes file, uncommented out the Uninstall line of code. Still no change.

I'll mention that I'm trying to install all three packages (Edit Orders, Ty Pkg Tracker, Super Orders) individually in that order. I'm installing each as a standalone and doing careful WinMerge's on all modified core files, keeping copies such as "orders (DEFAULT).php" and "orders (EDIT ORDER).php" as backups.

My understanding is that EO and TPT need to be installed first and functioning before Super Orders is installed and over-layed on top.

It would be sweet if there was an install with all three rolled into one package for installing, rather than 3 individual ones, as it seems the three are often installed together. Or at least state (if it can be done) to install all three at once (copy files to server) then login into Admin to trigger the install, etc. :^)

The EO, TPT and now I'm guessing the latest Super Orders mod (I've installed earlier versions of SO, but not this one yet) are using an auto-install script for SQL database updates rather than what I'm used to doing manual SQL updates (or Cut and Paste's).

Chris

Quote:

---

Originally Posted by Mega Moonshine

Thanks for getting back, DivaVocals.

It was just a couple of questions based on past observations with my limited experience with Zen Cart. I've seen where the main file includes/languages/english.php exists but the includes/languages/Your_Template/english.php file is used to extend the main without having to touch it. At least that is my understanding. I thought that both are read during execution and that redundancy of DEFINE's is just wasted cycles. You're probably right in that I could brush up on ZC with some light pleasure reading... lol

I didn't mean to raise any ire. Just had some questions. It was late, I was tired and not all cylinders were firing.

---

extra definition, and extra configuration files work the way you describe.. override files do not.. (please look at the override system to get clarity on this) I suppose if I had wanted, I could have done something similar.. I didn't so they are override files..

No ire.. just answering your question..

Quote:

---

Originally Posted by Mega Moonshine

As for the FATAL error (which also prevented Admin Login's with a blank page and a simple Warning: yada, yada, yada), I did try the following:

1. Ran the uninstall SQL script. No change.
2. In the init_includes file, uncommented out the Uninstall line of code. Still no change.

I'll mention that I'm trying to install all three packages (Edit Orders, Ty Pkg Tracker, Super Orders) individually in that order. I'm installing each as a standalone and doing careful WinMerge's on all modified core files, keeping copies such as "orders (DEFAULT).php" and "orders (EDIT ORDER).php" as backups.

---

Suggest rolling back to a state you were before installing Ty Package Tracker and starting over.. I really don't know how to help as I cannot reproduce this error, and no one has reported it before..

Quote:

---

Originally Posted by Mega Moonshine

My understanding is that EO and TPT need to be installed first and functioning before Super Orders is installed and over-layed on top.

---

This is correct

Quote:

---

Originally Posted by Mega Moonshine

It would be sweet if there was an install with all three rolled into one package for installing, rather than 3 individual ones, as it seems the three are often installed together. Or at least state (if it can be done) to install all three at once (copy files to server) then login into Admin to trigger the install, etc. :^)

---

Except not everyone uses all three so why make folks install mods they don't need/want.. Speaking on behalf of those of us who volunteer our time to maintain these modules, I can say we are busy and don't have to the to maitain such a super mod.. However, it's open source.. ANYONE can contribute and maintain such a super mod if they so desire..

Quote:

---

Originally Posted by Mega Moonshine

The EO, TPT and now I'm guessing the latest Super Orders mod (I've installed earlier versions of SO, but not this one yet) are using an auto-install script for SQL database updates rather than what I'm used to doing manual SQL updates (or Cut and Paste's).

Chris

---

Yes all have auto-installers..

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):

Code:

---

$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:

Quote:

---

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

Quote:

---

Originally Posted by Mega Moonshine

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..

Quote:

---

Originally Posted by Mega Moonshine

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..

Quote:

---

Originally Posted by Mega Moonshine

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..

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?