Index: branches/5.2.x/units/coupons/coupons_config.php =================================================================== diff -u -N -r15009 -r15560 --- branches/5.2.x/units/coupons/coupons_config.php (.../coupons_config.php) (revision 15009) +++ branches/5.2.x/units/coupons/coupons_config.php (.../coupons_config.php) (revision 15560) @@ -1,6 +1,6 @@ Array ('type' => 'double', 'default' => null), 'LastUsedBy' => Array ( - 'type' => 'int', 'formatter' => 'kLEFTFormatter', + 'type' => 'int', + 'formatter' => 'kLEFTFormatter', 'error_msgs' => Array ('invalid_option' => '!la_error_UserNotFound!'), 'options' => Array (USER_ROOT => 'root', USER_GUEST => 'Guest'), - 'left_sql' => 'SELECT %s FROM ' . TABLE_PREFIX . 'Users - WHERE `%s` = \'%s\'','left_key_field'=>'PortalUserId', - 'left_title_field' => 'Username', 'required' => 0, 'default' => null, + 'left_sql' => 'SELECT %s FROM ' . TABLE_PREFIX . 'Users WHERE %s', + 'left_key_field' => 'PortalUserId', 'left_title_field' => USER_TITLE_FIELD, + 'required' => 0, 'default' => null, ), 'LastUsedOn' => Array ('type' => 'int', 'formatter' => 'kDateFormatter', 'default' => NULL), 'NumberOfUses' => Array ('type' => 'int', 'default' => 1),