Index: trunk/core/units/visits/visits_config.php =================================================================== diff -u -N -r2910 -r3139 --- trunk/core/units/visits/visits_config.php (.../visits_config.php) (revision 2910) +++ trunk/core/units/visits/visits_config.php (.../visits_config.php) (revision 3139) @@ -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', ), ), Index: trunk/kernel/units/visits/visits_config.php =================================================================== diff -u -N -r2910 -r3139 --- trunk/kernel/units/visits/visits_config.php (.../visits_config.php) (revision 2910) +++ trunk/kernel/units/visits/visits_config.php (.../visits_config.php) (revision 3139) @@ -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', ), ),