Error
(psycopg2.errors.SyntaxError) syntax error at or near ":"
LINE 8: ...Ilumina Tu Rostro| Serum Facial - 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': 'Babaria - Serum Vitamina C | Vitamina C Cara Que Ilumina Tu Rostro| Serum Facial - Now 100% OFF!', 'prefix': '$7 DROP', 'url': '/products/17-b07k6xhdb5', 'ord': 1, 'product_id': 9852, 'signal': 'price_drop', 'expiry': 24}]
(Background on this error at: https://sqlalche.me/e/20/f405)
Log Output
03:21:38 | DEBUG | 序列修复: content_tickeritem_id_seq
03:21:39 | ERROR | 任务 [走马灯通知] 执行失败: (psycopg2.errors.SyntaxError) syntax error at or near ":"
LINE 8: ...Ilumina Tu Rostro| Serum Facial - 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': 'Babaria - Serum Vitamina C | Vitamina C Cara Que Ilumina Tu Rostro| Serum Facial - Now 100% OFF!', 'prefix': '$7 DROP', 'url': '/products/17-b07k6xhdb5', 'ord': 1, 'product_id': 9852, 'signal': 'price_drop', 'expiry': 24}]
(Background on this error at: https://sqlalche.me/e/20/f405)