Error Checkout Success

[Renz]

Hi Reader,

I am getting the following error in checkout sucess:

Thanks for shopping with us online!
1146 Table 'csi_zencart.zen_orders_total' doesn't exist
in:
[select value FROM zen_orders_total WHERE class='ot_subtotal' AND orders_id = 487]

Any ideas what's causing it.

Thanks

RR

Zen 1.3.8a

PS (I don't kow if this error was there or is due to) could it be the following code I was asked to put into the tpl_checkout_success_default.php

<div id="checkoutSuccessOrderLink"><?php echo TEXT_SEE_ORDERS;?></div>

<div id="checkoutSuccessContactLink"><?php echo TEXT_CONTACT_STORE_OWNER;?></div>

<h3 id="checkoutSuccessThanks" class="centeredContent"><?php echo TEXT_THANKS_FOR_SHOPPING; ?></h3>
</div>
<?php

$gv_query1= "select value FROM zen_orders_total WHERE class='ot_subtotal' AND orders_id = " . (int)$orders->fields['orders_id'] ;

$gv_result1 = $db->Execute($gv_query1);

if (!$gv_result1->EOF) {

if ($gv_result1->fields['value'] > 0) {

?>

<img src="https://www.clixGalore.com/AdvTransaction.aspx?AdID=12479&SV=<?php echo $gv_result1->fields['value']; ?>&OID=<?php echo (int)$orders->fields['orders_id']; ?>" height="0" width="0" border="0">

<?php
}
}
?>