It is likely you got this error because you ran this SQL file when you installed Super Orders: super_orders_ty_tracker_upgrade.sql and set the value to the Ty Package Tracker switch to TRUE.. This would enable the tracker fields and without having Ty Package Tracker installed you would have gotten the error you reported.. Installing Ty Package Tracker only solves the issue because you activated the Ty Package Tracker fields when you did NOT have Ty Package Tracker installed (which the readme CLEARLY states is required to use the Ty Package Tracker integration options)
SafetySam:
Hoping someone can please help.....
I upgraded to Zen Cart 1.3.9h and Super Orders (v??) stopped working so I downloaded Super Orders 3.0.
I followed the installation directions to the letter and, at first, it seemed that everything was back to normal.
But, now I notice that, when I print the order detail, I get the following error message near the bottom, near where the Order Status History table should appear:
ORDER STATUS HISTORY & COMMENTS 1054 Unknown column 'track_id1' in 'field list'
in:
[select orders_status_id, date_added, customer_notified, track_id1, track_id2, track_id3, track_id4, track_id5, comments from orders_status_history where orders_id = '3402' order by date_added]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
I found some threads that referred to what appears to be a similar error, but quite honestly don't understand what is being said. I think I am pretty good with Zen Cart, but I'm certainly not a professional web designer, so please make your responses on the "idiot" side and help me find and fix the error.
Also, I have reinstalled Super Orders twice just in case I had a corrupt file, but that also didn't help.
Thanks in advance!!
SafetySam:
Reinstalled SO 3.0 several times and, yes, installed the SQL upgrade. None of this helped.
Finally, I installed ty_package_tracker and now everything works fine.
Let me reiterate what is posted on page on of this thread and repeated several times in the readme files for Super Orders:
DivaVocals:
- If you have Edit Orders installed, you can enable Edit Order in the Super Orders admin to enable Edit Orders buttons in Super Orders (No code merging required.. Simply install Edit Orders and "turn on" Edit Orders in the Super Orders admin!!)
- If you have Ty Package Tracker v3.0 installed, you can enable the Ty Package Tracker fields for Super Orders (No code merging required..) Simply install Ty Package Tracker and "turn on" Super Orders from the Ty Package Tracker admin!!)
- If you have USPS Click-N-Ship installed, you can enable USPS Click-N-Ship in the Super Orders admin to enable USPS Click-N-Ship fields/buttons in Super Orders (No code merging required.. Simply install USPS Click-N-Ship and "turn on" USPS Click-N-Ship in the Super Orders admin!!)
- If you have FedEx Automated Labels installed, you can enable FedEx Automated Labels in the Super Orders admin to enable FedEx Automated Labels buttons in Super Orders (No code merging required.. Simply install FedEx Automated Labels and "turn on" FedEx Automated Labels in the Super Orders admin!!)
Let me stress something here so that it's CLEAR.. With regards to the mod integration options: You are NOT required to install ANY Edit Orders, Ty Package Tracker, FedEx Automated Labels or USPS Click-N Ship to use Super Orders.. You can use Super Orders even if you don’t use these other modules. That said turning on the admin flags for mods you DO NOT have installed WILL CAUSE ERRORS IN YOUR STORE!!
BUT...
If you are running any of these mods, you don't have to tear your hair out trying to get the correct Super Orders code merged into the Super Orders files to use these mods.. Install them as normal and TURN IT ON in the Super Orders admin (Ty Package Tracker will need to be turned on in the Ty Package Tracker admin)
In support of this new release there are updates to Edit Order and Ty Package Tracker that are now available in the downloads.. (See the Ty Package Tracker and Edit Orders respective support threads for details on those updates -- PLEASE do not post non Super Orders related questions here..)
Finally we are also supplying the properly merged files needed for those running FEC and COWOA. (no admin flags for these mods.. simply use the provided pre-merged files for these mods)
My Site - Zen Cart & WordPress integration specialist
I don't answer support questions via PM. Post add-on support questions in the support thread. The question & the answer will benefit others with similar issues.