The answer is even simpler.. If you turned on the Ty Tracker fields and do not have Ty Package Tracker installed (or installed correctly), you would get this error.. The flag to turn off Ty Package SHOULD be in Admin > Ty Package Tracker..
nagelkruid:
Hello,
When i click the "print" button in an order the super_data_sheet.php is invoked which generates error:
STATUS HISTORY 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 = '12696' order by date_added]
Looking at the code:
<!-- TY TRACKER 1 BEGIN, DISPLAY TRACKING ID IN COMMENTS TABLE------------------------------->
<td class="dataTableHeadingContent smallText" align="left" valign="top" width="23%"><strong><?php echo TABLE_HEADING_TRACKING_ID; ?></strong></td>
<!-- END TY TRACKER 1 ------------------------------------------------------------>
<td class="dataTableHeadingContent smallText" align="left" valign="top" width="40%"><strong><?php echo TABLE_HEADING_COMMENTS; ?></strong></td>
</tr>
<?php // TY TRACKER 2 BEGIN, INCLUDE DATABASE FIELDS ------------------------------
$orders_history = $db->Execute("select orders_status_id, date_added, customer_notified, track_id1, track_id2, track_id3, track_id4, track_id5, comments
from " . TABLE_ORDERS_STATUS_HISTORY . "
where orders_id = '" . zen_db_input($oID) . "'
order by date_added");
// END TY TRACKER 2 -----------------------------------------------------------
if ($orders_history->RecordCount() > 0) {
while (!$orders_history->EOF) {
echo ' <tr>' . "\n" .
' <td class="smal<etcetera_snip>
```
>
> I think all of this code regarding to TY_tracker (which i do not have installed) should be evaluated through boolean TY_TRACKER first before it is executed like so:
> ```php
if (TY_TRACKER == 'True')
```
>
> correct? or did i miss something?
