Execution #340

Log Output

15:00:00 | DEBUG | 序列修复: content_tickeritem_id_seq
15:00:00 | ERROR | 任务 [走马灯通知] 执行失败: (psycopg2.errors.SyntaxError) syntax error at or near ":"
LINE 8: ...PS5, Xbox Series X|S, DTS, Mous - Now 100% OFF!', :txt_trans...
                                                             ^

[SQL: 
                INSERT INTO content_tickeritem (
                    ticker_type, text, text_translations, prefix, prefix_translations,
                    target_url, display_order, is_active,
                    is_auto_generated, source_product_id, source_signal, expired_at,
                    created_at, updated_at
                ) VALUES (
                    %(type)s, %(text)s, :txt_trans::jsonb, %(prefix)s, :pfx_trans::jsonb,
                    %(url)s, %(ord)s, true,
                    true, %(product_id)s, %(signal)s,
                    now() + %(expiry)s * interval '1 hour',
                    now(), now()
                )
            ]
[parameters: [{'type': 'drop', 'text': 'HyperX Cloud III – Casque de Gaming Filaire, PC, PS5, Xbox Series X|S, DTS, Mous - Now 100% OFF!', 'prefix': '$58 DROP', 'url': '/products/hyperx-cloud-iii-casque-de-gaming-filaire-pc-ps5-xbox-series-xs-dts-mousse-à-mémo-b0c3bv19q3', 'ord': 1, 'product_id': 2264, 'signal': 'price_drop', 'expiry': 24}, {'type': 'drop', 'text': 'LeadsaiL Wireless Keyboard and Mouse Set, 2.4GHz USB Computer Keyboards and Mous - Now 100% OFF!', 'prefix': '$17 DROP', 'url': '/products/leadsail-wireless-keyboard-and-mouse-set-24ghz-usb-computer-keyboards-and-mouse-combo-b0cr5jqp6s', 'ord': 2, 'product_id': 10524, 'signal': 'price_drop', 'expiry': 24}, {'type': 'drop', 'text': 'UGREEN Adattatore USB C USB A 3.1 10Gbps 3 Pezzi Convertitore Maschio a Femmina  - Now 100% OFF!', 'prefix': '$9 DROP', 'url': '/products/ugreen-usb-c-adapter-usb-a-31-10gbps-3-pieces-male-to-female-converter-type-c-portable-c-b0cy1y3tsq', 'ord': 3, 'product_id': 1818, 'signal': 'price_drop', 'expiry': 24}, {'type': 'drop', 'text': 'PopSockets : PopGrip Basic - Base et poignée extensibles pour smartphones et tab - Now 100% OFF!', 'prefix': '$12 DROP', 'url': '/products/popsockets-popgrip-basic-base-et-poignée-extensibles-pour-smartphones-et-tablettes-t-b08qw5q5tp', 'ord': 4, 'product_id': 8820, 'signal': 'price_drop', 'expiry': 24}, {'type': 'drop', 'text': 'CeraVe - Gel Moussant Anti-Imperfections - Purifie la Peau en douceur et Réduit  - Now 100% OFF!', 'prefix': '$12 DROP', 'url': '/products/cerave-gel-moussant-anti-imperfections-purifie-la-peau-en-douceur-et-réduit-les-imper-b0b7rq46ld', 'ord': 5, 'product_id': 1788, 'signal': 'price_drop', 'expiry': 24}, {'type': 'trending', 'text': 'Muchfun 3Pcs Durable Honeycomb Mesh Laundry Bags for Delicates 12 x 16 Inches (3 is trending!', 'prefix': 'HOT', 'url': '/products/muchfun-3pcs-durable-honeycomb-mesh-laundry-bags-for-delicates-12-x-16-inches-3-medium-b083scj8g8', 'ord': 6, 'product_id': 16347, 'signal': 'trending_hot', 'expiry': 24}, {'type': 'trending', 'text': '8" 3D Printed Dragon Eggs, Easter Basket Stuffers for Kids and Teens, Unique Eas is trending!', 'prefix': 'HOT', 'url': '/products/rapean-8-3d-printed-dragon-eggs-mystery-crystal-dragon-egg-for-easter-basket-stuffers-b0dtjd9939', 'ord': 7, 'product_id': 12217, 'signal': 'trending_hot', 'expiry': 24}, {'type': 'trending', 'text': 'Medela Harmony Manual Breast Pump, Compact Swiss Design with PersonalFit Flex Sh is trending!', 'prefix': 'HOT', 'url': '/products/medela-harmony-manual-breast-pump-compact-swiss-design-with-personalfit-flex-shields-and-b08h9qjvnz', 'ord': 8, 'product_id': 16607, 'signal': 'trending_hot', 'expiry': 24}, {'type': 'trending', 'text': 'Indasbed Bed Protector, 60 x 90 cm – Pack of 20 is trending!', 'prefix': 'HOT', 'url': '/products/indasbed-bed-protector-60-x-90-cm-pack-of-20-b01ago1dri', 'ord': 9, 'product_id': 14998, 'signal': 'trending_hot', 'expiry': 24}, {'type': 'trending', 'text': 'Affresh Dishwasher Cleaner, Helps Power Away Odor Causing Bacteria, Limescale, M is trending!', 'prefix': 'HOT', 'url': '/products/affresh-dishwasher-cleaner-helps-power-away-odor-causing-bacteria-limescale-mineral-de-b00sxc85iq', 'ord': 10, 'product_id': 15858, 'signal': 'trending_hot', 'expiry': 24}]]
(Background on this error at: https://sqlalche.me/e/20/f405)