Index: branches/unlabeled/unlabeled-1.12.2/core/units/visits/visits_config.php =================================================================== diff -u -r3051 -r4572 --- branches/unlabeled/unlabeled-1.12.2/core/units/visits/visits_config.php (.../visits_config.php) (revision 3051) +++ branches/unlabeled/unlabeled-1.12.2/core/units/visits/visits_config.php (.../visits_config.php) (revision 4572) @@ -32,7 +32,7 @@ 'AffiliatePortalUserId' => 'af.PortalUserId', 'OrderTotalAmount' => 'IF(ord.Status = 4, ord.SubTotal+ord.ShippingCost+ord.VAT, 0)', 'OrderAffiliateCommission' => 'IF(ord.Status = 4, ord.AffiliateCommission, 0)', - 'OrderNumber' => 'CONCAT(LPAD(Number,6,0),\'-\',LPAD(SubNumber,3,0) )', + 'OrderNumber' => 'CONCAT(LPAD(Number,6,"0"),\'-\',LPAD(SubNumber,3,"0") )', 'OrderId' => 'ord.OrderId', ), ),