Execution #312

Log Output

12:00:00 | DEBUG | 序列修复: content_tickeritem_id_seq
12:00:00 | ERROR | 任务 [走马灯通知] 执行失败: (psycopg2.errors.SyntaxError) syntax error at or near ":"
LINE 8: ... Classic Retro Interactive Toy, - 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': 'Basic Fun Retro | Speak & Spell Electronic Game | Classic Retro Interactive Toy, - Now 100% OFF!', 'prefix': '$478 DROP', 'url': '/products/basic-fun-retro-speak-spell-electronic-game-classic-retro-interactive-toy-educatio-b07pqt8dmb', 'ord': 1, 'product_id': 9301, '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': 2, 'product_id': 10763, 'signal': 'price_drop', 'expiry': 24}, {'type': 'drop', 'text': 'Baby Einstein Sea Dreams Soother, Veilleuse Bébé Musicale et Lumineuse avec Brui - Now 100% OFF!', 'prefix': '$50 DROP', 'url': '/products/baby-einstein-sea-dreams-soother-veilleuse-bébé-musicale-et-lumineuse-avec-bruit-blanc-b07dm86z43', 'ord': 3, 'product_id': 8251, 'signal': 'price_drop', 'expiry': 24}, {'type': 'drop', 'text': 'Big Potato Chicken vs Hotdog: The Ultimate Challenge Party Game for Flipping-Fun - Now 100% OFF!', 'prefix': '$25 DROP', 'url': '/products/big-potato-chicken-vs-hotdog-the-ultimate-challenge-party-game-for-flipping-fun-families-b0d9hm75pp', 'ord': 4, 'product_id': 9250, 'signal': 'price_drop', 'expiry': 24}, {'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': 5, 'product_id': 8478, 'signal': 'price_drop', 'expiry': 24}, {'type': 'trending', 'text': 'Biomed Superwhite Natural Coconut Toothpaste for Gentle Whitening, Tropical flav is trending!', 'prefix': 'HOT', 'url': '/products/biomed-superwhite-natural-coconut-toothpaste-for-gentle-whitening-tropical-flavour-100-b084kpjkt1', 'ord': 6, 'product_id': 4018, 'signal': 'trending_hot', 'expiry': 24}, {'type': 'trending', 'text': "L'Oréal Paris Accord Parfait, Color Filler Serum, with Pure Hyaluronic Acid 1% a is trending!", 'prefix': 'HOT', 'url': '/products/loréal-paris-accord-parfait-color-filler-serum-with-pure-hyaluronic-acid-1-and-7-gly-b097wl6qwt', 'ord': 7, 'product_id': 14681, 'signal': 'trending_hot', 'expiry': 24}, {'type': 'trending', 'text': 'Q-tips Cotton Swabs, Original, For Home, First Aid and Beauty, 100% Cotton, 500  is trending!', 'prefix': 'HOT', 'url': '/products/q-tips-cotton-swabs-original-for-home-first-aid-and-beauty-100-cotton-500-count-b0014cz16q', 'ord': 8, 'product_id': 15728, 'signal': 'trending_hot', 'expiry': 24}, {'type': 'trending', 'text': 'CENTELLIAN 24 Madeca Crema Time Reverse (50 ml) - Nutritiva y de rápida absorció is trending!', 'prefix': 'HOT', 'url': '/products/centellian-24-madeca-time-reverse-cream-50ml-nourishing-and-fast-absorption-hydrates-b0dfy92ndb', 'ord': 9, 'product_id': 6017, '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': 10, 'product_id': 1388, 'signal': 'trending_hot', 'expiry': 24}]]
(Background on this error at: https://sqlalche.me/e/20/f405)