Execution #282

Log Output

18:00:07 | DEBUG | 序列修复: content_tickeritem_id_seq
18:00:09 | ERROR | 任务 [走马灯通知] 执行失败: (psycopg2.errors.SyntaxError) syntax error at or near ":"
LINE 8: ...- Reconnais Et Épelle Plateau d - 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': 'Orchard Toys - Orch004 - Jeu De Société Éducatif - Reconnais Et Épelle Plateau d - Now 100% OFF!', 'prefix': '$17 DROP', 'url': '/products/orchard-toys-orch004-jeu-de-société-éducatif-reconnais-et-épelle-b00stbqdo4', 'ord': 1, 'product_id': 8478, 'signal': 'price_drop', 'expiry': 24}, {'type': 'drop', 'text': "Vet's Best Dog Finger Cleansing Wipes Soothes and Deodorises - 50 Wipes - Now 100% OFF!", 'prefix': '$7 DROP', 'url': '/products/vets-best-lingettes-nettoyantes-pour-les-doigts-des-chiens-apaisent-et-désodorisent-5-b073hh2z96', 'ord': 2, 'product_id': 7133, 'signal': 'price_drop', 'expiry': 24}, {'type': 'drop', 'text': 'Pampers Fresh Clean, 1200 Lingettes pour Bébé (15x80), Sans Alcool, Aussi Pour L - Now 100% OFF!', 'prefix': '$30 DROP', 'url': '/products/pampers-fresh-clean-1200-lingettes-pour-bébé-15x80-sans-alcool-aussi-pour-les-mains-b07p5h4m8n', 'ord': 3, 'product_id': 8229, 'signal': 'price_drop', 'expiry': 24}, {'type': 'drop', 'text': 'The Spanish Home Kitchen: Simple, Seasonal Recipes and Memories from My Home - Now 100% OFF!', 'prefix': '$36 DROP', 'url': '/products/spanish-home-kitchen-simple-seasonal-recipes-from-my-home-simple-seasonal-recipes-fro-1784884472', 'ord': 4, 'product_id': 8109, 'signal': 'price_drop', 'expiry': 24}, {'type': 'drop', 'text': 'RisoPhy Mechanische Gaming-Tastatur, RGB 104 Tasten, ultraschlanke LED-Hintergru - Now 100% OFF!', 'prefix': '$240 DROP', 'url': '/products/risophy-mechanical-gaming-keyboard-rgb-104-keys-ultra-slim-led-backlit-wired-usb-keyboard-b09tr4y91j', 'ord': 5, 'product_id': 10763, 'signal': 'price_drop', 'expiry': 24}, {'type': 'trending', 'text': 'HP 305 Black/Tri-color Original Ink Printer Cartridges Combo (X4D37AE) - Works w is trending!', 'prefix': 'HOT', 'url': '/products/hp-305-blacktri-color-original-ink-printer-cartridges-combo-x4d37ae-works-with-hp-d-b08t1hr5cs', 'ord': 6, 'product_id': 1338, 'signal': 'trending_hot', 'expiry': 24}, {'type': 'trending', 'text': 'BRITA MAXTRA PRO Pure Performance Water Filter Cartridge - 6 Pack - Original BRI is trending!', 'prefix': 'HOT', 'url': '/products/brita-maxtra-pro-pure-performance-water-filter-cartridge-6-pack-original-brita-refill-b0bsxdvqg7', 'ord': 7, 'product_id': 1384, 'signal': 'trending_hot', 'expiry': 24}, {'type': 'trending', 'text': 'Pritt Glue Stick, Safe & Child-Friendly Craft Glue for Arts & Crafts Activities, is trending!', 'prefix': 'HOT', 'url': '/products/pritt-glue-stick-safe-child-friendly-craft-glue-for-arts-crafts-activities-strong-h-b004qfi99y', 'ord': 8, 'product_id': 1388, 'signal': 'trending_hot', 'expiry': 24}, {'type': 'trending', 'text': 'FrezyDerm Sun Screen Velvet Crema Orotectora Solar Facial SPF 50+ con color Text is trending!', 'prefix': 'HOT', 'url': '/products/frezyderm-sun-screen-velvet-crema-orotectora-solar-facial-spf-50-con-color-textura-aterc-b00uhrotmg', 'ord': 9, 'product_id': 14532, 'signal': 'trending_hot', 'expiry': 24}, {'type': 'trending', 'text': 'Ziploc Sandwich and Snack Bags with EasyGuide Texture, Plastic Storage Bags with is trending!', 'prefix': 'HOT', 'url': '/products/ziploc-sandwich-and-snack-bags-with-easyguide-texture-plastic-storage-bags-with-grip-n-b0dgmy14gn', 'ord': 10, 'product_id': 16108, 'signal': 'trending_hot', 'expiry': 24}]]
(Background on this error at: https://sqlalche.me/e/20/f405)