Error
(psycopg2.errors.SyntaxError) syntax error at or near ":"
LINE 8: ...cipes and Memories from My Home - 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': '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': 1, 'product_id': 8109, 'signal': 'price_drop', 'expiry': 24}]
(Background on this error at: https://sqlalche.me/e/20/f405)
Log Output
11:21:39 | DEBUG | 序列修复: content_tickeritem_id_seq
11:21:41 | ERROR | 任务 [走马灯通知] 执行失败: (psycopg2.errors.SyntaxError) syntax error at or near ":"
LINE 8: ...cipes and Memories from My Home - 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': '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': 1, 'product_id': 8109, 'signal': 'price_drop', 'expiry': 24}]
(Background on this error at: https://sqlalche.me/e/20/f405)