Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
DivaVocals
Perhaps.. do you get a similar behavior with the default orders??
nope. just super orders
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
samar777
nope. just super orders
What version of Zen Cart are you running??
Re: Super Orders v3.0 Support Thread
Is there any way to change the PDF packing list? I want to remove the prices on it and change the layout a bit...
Re: Super Orders v3.0 Support Thread
Re: Super Orders v3.0 Support Thread
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:
PHP 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 Code:
if (TY_TRACKER == 'True')
correct? or did i miss something?
Re: Super Orders v3.0 Support Thread
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..
Quote:
Originally Posted by
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:
PHP 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 Code:
if (TY_TRACKER == 'True')
correct? or did i miss something?
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
ericvanwenkop
Is there any way to change the PDF packing list? I want to remove the prices on it and change the layout a bit...
Short answer is it's software.. It can all be modified to do whatever you wish.. That said, as I have said here previously, it's a PITA to do. So I personally will not be able to help with this.. (got too much on my plate with paid and personal projects)
The PDF packingslip code was generously donated to the community for free, and apart from a few minor changes to align them functionally with the default packinglists/invoices they are as we got the code from the author.
I suppose it could be made a LOT more flexible so that everyone could have everything they might want, with admin controlled options, etc.. However, I will leave that to someone else to develop and contribute.. :smile:
Feel free to search through this thread.. There's 1 or 2 people who've posted some of their modifications to the Super Orders PDF packing list..
Good luck..
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
DivaVocals
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..
did you read what i said about the boolean part at all?
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
nagelkruid
did you read what i said about the boolean part at all?
I did.. and I didn't see this was in reference to the super_data_sheet.php file..
A search of this thread would have turned up this post: http://www.zen-cart.com/forum/showpo...6&postcount=55
Re: Super Orders v3.0 Support Thread
Quote:
Originally Posted by
DivaVocals
thanks, that is indeed what i was referring to.
funny, i did search the thread and that post didn't come up in my results, and it is even a relative small thread yet....mmm