GX-Bug #66226
geschlossenGift Voucher Queue throws SQL error / Gutschein Queue wirft SQL error
100%
Die Gutschein Freigabe Warteschlange zeigt keinen SQL-Fehler mehr
Beschreibung
After Update from 4.0beta1 to 4.1.1beta1 Vouchers > Gift Voucher Queue throw an SQL error
Query error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-20, 20' at line 6 - Invalid query: SELECT `coupon_gv_queue`.`unique_id`, `coupon_gv_queue`.`amount`, `coupon_gv_queue`.`date_created`, `orders`.`orders_id`, `orders`.`customers_firstname`, `orders`.`customers_lastname`, `orders_status`.`orders_status_name`, `orders_status`.`color` FROM `coupon_gv_queue` JOIN `orders` ON `orders`.`orders_id` = `coupon_gv_queue`.`order_id` JOIN `orders_status` ON `orders_status`.`orders_status_id` = `orders`.`orders_status` AND `orders_status`.`language_id` = 2 WHERE `coupon_gv_queue`.`release_flag` = 'N' LIMIT -20, 20
Zugehörige Tickets