We have been running OSCMAX 2.0 for the last several months with zero problem. Out of nowhere we are getting the following error when the Confirm Order button is clicked
2006 - MySQL server has gone away
select affiliate_commission_percent from affiliate_affiliate where affiliate_id = ''
[TEP STOP]
The code in the affiliate_checkout_process.php file is below. Can anyone tell if there is something amiss?? Any help would be greatly appreciated.
// Check for individual commission
$affiliate_percentage = 0;
if (AFFILATE_INDIVIDUAL_PERCENTAGE == 'true') {
$affiliate_commission_query = tep_db_query ("select affiliate_commission_percent from " . TABLE_AFFILIATE . " where affiliate_id = '" . $affiliate_ref . "'");
$affiliate_commission = tep_db_fetch_array($affiliate_commission_query);
$affiliate_percent = $affiliate_commission['affiliate_commission_percent'];
}
if ($affiliate_percent < AFFILIATE_PERCENT) $affiliate_percent = AFFILIATE_PERCENT;
$affiliate_payment = tep_round(($affiliate_total * $affiliate_percent / 100), 2);
Thank you!!!





LinkBack URL
About LinkBacks










Bookmarks