Error
(psycopg2.errors.SyntaxError) syntax error at or near ":"
LINE 8: ...Output, 20,000 mAh, Simultaneous - Now 99% 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': 'Mobile Battery, Large Capacity, Supports 22.5 W Output, 20,000 mAh, Simultaneous - Now 99% OFF!', 'prefix': '$32781 DROP', 'url': '/products/mobile-battery-large-capacity-supports-225-w-output-20000-mah-simultaneous-charging-b0gc5hpvj5', 'ord': 1, 'product_id': 15246, '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:40 | ERROR | 任务 [走马灯通知] 执行失败: (psycopg2.errors.SyntaxError) syntax error at or near ":"
LINE 8: ...Output, 20,000 mAh, Simultaneous - Now 99% 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': 'Mobile Battery, Large Capacity, Supports 22.5 W Output, 20,000 mAh, Simultaneous - Now 99% OFF!', 'prefix': '$32781 DROP', 'url': '/products/mobile-battery-large-capacity-supports-225-w-output-20000-mah-simultaneous-charging-b0gc5hpvj5', 'ord': 1, 'product_id': 15246, 'signal': 'price_drop', 'expiry': 24}]
(Background on this error at: https://sqlalche.me/e/20/f405)