Index: branches/RC/admin/install/upgrades/inportal_upgrade_v4.3.0.php =================================================================== diff -u -r10304 -r10373 --- branches/RC/admin/install/upgrades/inportal_upgrade_v4.3.0.php (.../inportal_upgrade_v4.3.0.php) (revision 10304) +++ branches/RC/admin/install/upgrades/inportal_upgrade_v4.3.0.php (.../inportal_upgrade_v4.3.0.php) (revision 10373) @@ -8,4 +8,21 @@ ); $application->Conn->doInsert($fields_hash, TABLE_PREFIX.'ConfigurationValues'); } + + if ($application->TableFound(TABLE_PREFIX.'Orders')) { + $sql = 'SELECT OrderId + FROM '.TABLE_PREFIX.'Orders + WHERE (Status = '.ORDER_STATUS_INCOMPLETE.') AND (OrderDate < '.strtotime('-1 day').')'; + $order_ids = $application->Conn->GetCol($sql); + + if ($order_ids) { + $sql = 'DELETE FROM '.TABLE_PREFIX.'Orders + WHERE OrderId IN ('.implode(',', $order_ids).')'; + $application->Conn->Query($sql); + + $sql = 'DELETE FROM '.TABLE_PREFIX.'OrderItems + WHERE OrderId IN ('.implode(',', $order_ids).')'; + $application->Conn->Query($sql); + } + } ?> \ No newline at end of file