Result Summary
{'details': {'ca': {'assign': 0, 'curate': 0, 'errors': ["summer-essentials: (psycopg2.errors.UndefinedColumn) column p.current_price does not exist\nLINE 14: p.current_price,\n ^\n\n[SQL: \n SELECT\n tp.id AS tp_id,\n tp.product_id,\n p.name,\n p.ags_score,\n p.rating,\n p.review_count,\n p.discount_rate,\n p.is_amazon_choice,\n p.is_best_seller,\n p.is_prime,\n p.primary_image,\n p.current_price,\n tp.created_at AS tp_created_at\n FROM content_topicproduct tp\n JOIN content_product p ON p.id = tp.product_id\n WHERE tp.topic_id = %(topic_id)s\n AND p.is_active = true\n AND p.has_detail_fetched = true\n ORDER BY tp.display_order, tp.created_at DESC\n ]\n[parameters: {'topic_id': 3}]\n(Background on this error at: https://sqlalche.me/e/20/f405)", "world-cup-2026: (psycopg2.errors.UndefinedColumn) column p.current_price does not exist\nLINE 14: p.current_price,\n ^\n\n[SQL: \n SELECT\n tp.id AS tp_id,\n tp.product_id,\n p.name,\n p.ags_score,\n p.rating,\n p.review_count,\n p.discount_rate,\n p.is_amazon_choice,\n p.is_best_seller,\n p.is_prime,\n p.primary_image,\n p.current_price,\n tp.created_at AS tp_created_at\n FROM content_topicproduct tp\n JOIN content_product p ON p.id = tp.product_id\n WHERE tp.topic_id = %(topic_id)s\n AND p.is_active = true\n AND p.has_detail_fetched = true\n ORDER BY tp.display_order, tp.created_at DESC\n ]\n[parameters: {'topic_id': 11}]\n(Background on this error at: https://sqlalche.me/e/20/f405)"]}, 'de': {'assign': 0, 'curate': 0, 'errors': ["summer-essentials: (psycopg2.errors.UndefinedColumn) column p.current_price does not exist\nLINE 14: p.current_price,\n ^\n\n[SQL: \n SELECT\n tp.id AS tp_id,\n tp.product_id,\n p.name,\n p.ags_score,\n p.rating,\n p.review_count,\n p.discount_rate,\n p.is_amazon_choice,\n p.is_best_seller,\n p.is_prime,\n p.primary_image,\n p.current_price,\n tp.created_at AS tp_created_at\n FROM content_topicproduct tp\n JOIN content_product p ON p.id = tp.product_id\n WHERE tp.topic_id = %(topic_id)s\n AND p.is_active = true\n AND p.has_detail_fetched = true\n ORDER BY tp.display_order, tp.created_at DESC\n ]\n[parameters: {'topic_id': 4}]\n(Background on this error at: https://sqlalche.me/e/20/f405)", "world-cup-2026: (psycopg2.errors.UndefinedColumn) column p.current_price does not exist\nLINE 14: p.current_price,\n ^\n\n[SQL: \n SELECT\n tp.id AS tp_id,\n tp.product_id,\n p.name,\n p.ags_score,\n p.rating,\n p.review_count,\n p.discount_rate,\n p.is_amazon_choice,\n p.is_best_seller,\n p.is_prime,\n p.primary_image,\n p.current_price,\n tp.created_at AS tp_created_at\n FROM content_topicproduct tp\n JOIN content_product p ON p.id = tp.product_id\n WHERE tp.topic_id = %(topic_id)s\n AND p.is_active = true\n AND p.has_detail_fetched = true\n ORDER BY tp.display_order, tp.created_at DESC\n ]\n[parameters: {'topic_id': 12}]\n(Background on this error at: https://sqlalche.me/e/20/f405)"]}, 'es': {'assign': 0, 'curate': 0, 'errors': ["summer-essentials: (psycopg2.errors.UndefinedColumn) column p.current_price does not exist\nLINE 14: p.current_price,\n ^\n\n[SQL: \n SELECT\n tp.id AS tp_id,\n tp.product_id,\n p.name,\n p.ags_score,\n p.rating,\n p.review_count,\n p.discount_rate,\n p.is_amazon_choice,\n p.is_best_seller,\n p.is_prime,\n p.primary_image,\n p.current_price,\n tp.created_at AS tp_created_at\n FROM content_topicproduct tp\n JOIN content_product p ON p.id = tp.product_id\n WHERE tp.topic_id = %(topic_id)s\n AND p.is_active = true\n AND p.has_detail_fetched = true\n ORDER BY tp.display_order, tp.created_at DESC\n ]\n[parameters: {'topic_id': 7}]\n(Background on this error at: https://sqlalche.me/e/20/f405)", "world-cup-2026: (psycopg2.errors.UndefinedColumn) column p.current_price does not exist\nLINE 14: p.current_price,\n ^\n\n[SQL: \n SELECT\n tp.id AS tp_id,\n tp.product_id,\n p.name,\n p.ags_score,\n p.rating,\n p.review_count,\n p.discount_rate,\n p.is_amazon_choice,\n p.is_best_seller,\n p.is_prime,\n p.primary_image,\n p.current_price,\n tp.created_at AS tp_created_at\n FROM content_topicproduct tp\n JOIN content_product p ON p.id = tp.product_id\n WHERE tp.topic_id = %(topic_id)s\n AND p.is_active = true\n AND p.has_detail_fetched = true\n ORDER BY tp.display_order, tp.created_at DESC\n ]\n[parameters: {'topic_id': 15}]\n(Background on this error at: https://sqlalche.me/e/20/f405)"]}, 'fr': {'assign': 0, 'curate': 0, 'errors': ["summer-essentials: (psycopg2.errors.UndefinedColumn) column p.current_price does not exist\nLINE 14: p.current_price,\n ^\n\n[SQL: \n SELECT\n tp.id AS tp_id,\n tp.product_id,\n p.name,\n p.ags_score,\n p.rating,\n p.review_count,\n p.discount_rate,\n p.is_amazon_choice,\n p.is_best_seller,\n p.is_prime,\n p.primary_image,\n p.current_price,\n tp.created_at AS tp_created_at\n FROM content_topicproduct tp\n JOIN content_product p ON p.id = tp.product_id\n WHERE tp.topic_id = %(topic_id)s\n AND p.is_active = true\n AND p.has_detail_fetched = true\n ORDER BY tp.display_order, tp.created_at DESC\n ]\n[parameters: {'topic_id': 5}]\n(Background on this error at: https://sqlalche.me/e/20/f405)", "world-cup-2026: (psycopg2.errors.UndefinedColumn) column p.current_price does not exist\nLINE 14: p.current_price,\n ^\n\n[SQL: \n SELECT\n tp.id AS tp_id,\n tp.product_id,\n p.name,\n p.ags_score,\n p.rating,\n p.review_count,\n p.discount_rate,\n p.is_amazon_choice,\n p.is_best_seller,\n p.is_prime,\n p.primary_image,\n p.current_price,\n tp.created_at AS tp_created_at\n FROM content_topicproduct tp\n JOIN content_product p ON p.id = tp.product_id\n WHERE tp.topic_id = %(topic_id)s\n AND p.is_active = true\n AND p.has_detail_fetched = true\n ORDER BY tp.display_order, tp.created_at DESC\n ]\n[parameters: {'topic_id': 13}]\n(Background on this error at: https://sqlalche.me/e/20/f405)"]}, 'it': {'assign': 0, 'curate': 0, 'errors': ["summer-essentials: (psycopg2.errors.UndefinedColumn) column p.current_price does not exist\nLINE 14: p.current_price,\n ^\n\n[SQL: \n SELECT\n tp.id AS tp_id,\n tp.product_id,\n p.name,\n p.ags_score,\n p.rating,\n p.review_count,\n p.discount_rate,\n p.is_amazon_choice,\n p.is_best_seller,\n p.is_prime,\n p.primary_image,\n p.current_price,\n tp.created_at AS tp_created_at\n FROM content_topicproduct tp\n JOIN content_product p ON p.id = tp.product_id\n WHERE tp.topic_id = %(topic_id)s\n AND p.is_active = true\n AND p.has_detail_fetched = true\n ORDER BY tp.display_order, tp.created_at DESC\n ]\n[parameters: {'topic_id': 6}]\n(Background on this error at: https://sqlalche.me/e/20/f405)", "world-cup-2026: (psycopg2.errors.UndefinedColumn) column p.current_price does not exist\nLINE 14: p.current_price,\n ^\n\n[SQL: \n SELECT\n tp.id AS tp_id,\n tp.product_id,\n p.name,\n p.ags_score,\n p.rating,\n p.review_count,\n p.discount_rate,\n p.is_amazon_choice,\n p.is_best_seller,\n p.is_prime,\n p.primary_image,\n p.current_price,\n tp.created_at AS tp_created_at\n FROM content_topicproduct tp\n JOIN content_product p ON p.id = tp.product_id\n WHERE tp.topic_id = %(topic_id)s\n AND p.is_active = true\n AND p.has_detail_fetched = true\n ORDER BY tp.display_order, tp.created_at DESC\n ]\n[parameters: {'topic_id': 14}]\n(Background on this error at: https://sqlalche.me/e/20/f405)"]}, 'jp': {'assign': 0, 'curate': 0, 'errors': ["summer-essentials: (psycopg2.errors.UndefinedColumn) column p.current_price does not exist\nLINE 14: p.current_price,\n ^\n\n[SQL: \n SELECT\n tp.id AS tp_id,\n tp.product_id,\n p.name,\n p.ags_score,\n p.rating,\n p.review_count,\n p.discount_rate,\n p.is_amazon_choice,\n p.is_best_seller,\n p.is_prime,\n p.primary_image,\n p.current_price,\n tp.created_at AS tp_created_at\n FROM content_topicproduct tp\n JOIN content_product p ON p.id = tp.product_id\n WHERE tp.topic_id = %(topic_id)s\n AND p.is_active = true\n AND p.has_detail_fetched = true\n ORDER BY tp.display_order, tp.created_at DESC\n ]\n[parameters: {'topic_id': 8}]\n(Background on this error at: https://sqlalche.me/e/20/f405)", "world-cup-2026: (psycopg2.errors.UndefinedColumn) column p.current_price does not exist\nLINE 14: p.current_price,\n ^\n\n[SQL: \n SELECT\n tp.id AS tp_id,\n tp.product_id,\n p.name,\n p.ags_score,\n p.rating,\n p.review_count,\n p.discount_rate,\n p.is_amazon_choice,\n p.is_best_seller,\n p.is_prime,\n p.primary_image,\n p.current_price,\n tp.created_at AS tp_created_at\n FROM content_topicproduct tp\n JOIN content_product p ON p.id = tp.product_id\n WHERE tp.topic_id = %(topic_id)s\n AND p.is_active = true\n AND p.has_detail_fetched = true\n ORDER BY tp.display_order, tp.created_at DESC\n ]\n[parameters: {'topic_id': 16}]\n(Background on this error at: https://sqlalche.me/e/20/f405)"]}, 'uk': {'assign': 0, 'curate': 0, 'errors': ["summer-essentials: (psycopg2.errors.UndefinedColumn) column p.current_price does not exist\nLINE 14: p.current_price,\n ^\n\n[SQL: \n SELECT\n tp.id AS tp_id,\n tp.product_id,\n p.name,\n p.ags_score,\n p.rating,\n p.review_count,\n p.discount_rate,\n p.is_amazon_choice,\n p.is_best_seller,\n p.is_prime,\n p.primary_image,\n p.current_price,\n tp.created_at AS tp_created_at\n FROM content_topicproduct tp\n JOIN content_product p ON p.id = tp.product_id\n WHERE tp.topic_id = %(topic_id)s\n AND p.is_active = true\n AND p.has_detail_fetched = true\n ORDER BY tp.display_order, tp.created_at DESC\n ]\n[parameters: {'topic_id': 2}]\n(Background on this error at: https://sqlalche.me/e/20/f405)", "world-cup-2026: (psycopg2.errors.UndefinedColumn) column p.current_price does not exist\nLINE 14: p.current_price,\n ^\n\n[SQL: \n SELECT\n tp.id AS tp_id,\n tp.product_id,\n p.name,\n p.ags_score,\n p.rating,\n p.review_count,\n p.discount_rate,\n p.is_amazon_choice,\n p.is_best_seller,\n p.is_prime,\n p.primary_image,\n p.current_price,\n tp.created_at AS tp_created_at\n FROM content_topicproduct tp\n JOIN content_product p ON p.id = tp.product_id\n WHERE tp.topic_id = %(topic_id)s\n AND p.is_active = true\n AND p.has_detail_fetched = true\n ORDER BY tp.display_order, tp.created_at DESC\n ]\n[parameters: {'topic_id': 10}]\n(Background on this error at: https://sqlalche.me/e/20/f405)"]}, 'us': {'assign': 0, 'curate': 0, 'errors': ["summer-essentials: (psycopg2.errors.UndefinedColumn) column p.current_price does not exist\nLINE 14: p.current_price,\n ^\n\n[SQL: \n SELECT\n tp.id AS tp_id,\n tp.product_id,\n p.name,\n p.ags_score,\n p.rating,\n p.review_count,\n p.discount_rate,\n p.is_amazon_choice,\n p.is_best_seller,\n p.is_prime,\n p.primary_image,\n p.current_price,\n tp.created_at AS tp_created_at\n FROM content_topicproduct tp\n JOIN content_product p ON p.id = tp.product_id\n WHERE tp.topic_id = %(topic_id)s\n AND p.is_active = true\n AND p.has_detail_fetched = true\n ORDER BY tp.display_order, tp.created_at DESC\n ]\n[parameters: {'topic_id': 1}]\n(Background on this error at: https://sqlalche.me/e/20/f405)", "world-cup-2026: (psycopg2.errors.UndefinedColumn) column p.current_price does not exist\nLINE 14: p.current_price,\n ^\n\n[SQL: \n SELECT\n tp.id AS tp_id,\n tp.product_id,\n p.name,\n p.ags_score,\n p.rating,\n p.review_count,\n p.discount_rate,\n p.is_amazon_choice,\n p.is_best_seller,\n p.is_prime,\n p.primary_image,\n p.current_price,\n tp.created_at AS tp_created_at\n FROM content_topicproduct tp\n JOIN content_product p ON p.id = tp.product_id\n WHERE tp.topic_id = %(topic_id)s\n AND p.is_active = true\n AND p.has_detail_fetched = true\n ORDER BY tp.display_order, tp.created_at DESC\n ]\n[parameters: {'topic_id': 9}]\n(Background on this error at: https://sqlalche.me/e/20/f405)"]}}, 'total_curated': 0, 'total_assigned': 0, 'regions_processed': 8}
Log Output
scount_rate,
p.is_amazon_choice,
p.is_best_seller,
p.is_prime,
p.primary_image,
p.current_price,
tp.created_at AS tp_created_at
FROM content_topicproduct tp
JOIN content_product p ON p.id = tp.product_id
WHERE tp.topic_id = %(topic_id)s
AND p.is_active = true
AND p.has_detail_fetched = true
ORDER BY tp.display_order, tp.created_at DESC
]
[parameters: {'topic_id': 3}]
(Background on this error at: https://sqlalche.me/e/20/f405)
18:30:14 | INFO | [Topic Assign] world-cup-2026@ca: no matching products
18:30:14 | WARNING | [topic_refresh] ca/world-cup-2026 failed: (psycopg2.errors.UndefinedColumn) column p.current_price does not exist
LINE 14: p.current_price,
^
[SQL:
SELECT
tp.id AS tp_id,
tp.product_id,
p.name,
p.ags_score,
p.rating,
p.review_count,
p.discount_rate,
p.is_amazon_choice,
p.is_best_seller,
p.is_prime,
p.primary_image,
p.current_price,
tp.created_at AS tp_created_at
FROM content_topicproduct tp
JOIN content_product p ON p.id = tp.product_id
WHERE tp.topic_id = %(topic_id)s
AND p.is_active = true
AND p.has_detail_fetched = true
ORDER BY tp.display_order, tp.created_at DESC
]
[parameters: {'topic_id': 11}]
(Background on this error at: https://sqlalche.me/e/20/f405)
18:30:14 | WARNING | Frontend revalidation returned 401 (attempt 1/3): {"error":"Unauthorized"}
18:30:14 | WARNING | Frontend revalidation returned 401 (attempt 2/3): {"error":"Unauthorized"}
18:30:14 | WARNING | Frontend revalidation returned 401 (attempt 3/3): {"error":"Unauthorized"}
18:30:14 | WARNING | Frontend revalidation exhausted 3 retries. ISR timers will handle eventual consistency.
18:30:15 | INFO | IndexNow: submitted 2 URLs (status=200)
18:30:15 | INFO | [topic_refresh] IndexNow notified 2 topic URLs for ca
18:30:16 | INFO | [Topic Assign] summer-essentials@jp: no matching products
18:30:16 | WARNING | [topic_refresh] jp/summer-essentials failed: (psycopg2.errors.UndefinedColumn) column p.current_price does not exist
LINE 14: p.current_price,
^
[SQL:
SELECT
tp.id AS tp_id,
tp.product_id,
p.name,
p.ags_score,
p.rating,
p.review_count,
p.discount_rate,
p.is_amazon_choice,
p.is_best_seller,
p.is_prime,
p.primary_image,
p.current_price,
tp.created_at AS tp_created_at
FROM content_topicproduct tp
JOIN content_product p ON p.id = tp.product_id
WHERE tp.topic_id = %(topic_id)s
AND p.is_active = true
AND p.has_detail_fetched = true
ORDER BY tp.display_order, tp.created_at DESC
]
[parameters: {'topic_id': 8}]
(Background on this error at: https://sqlalche.me/e/20/f405)
18:30:16 | INFO | [Topic Assign] world-cup-2026@jp: no matching products
18:30:16 | WARNING | [topic_refresh] jp/world-cup-2026 failed: (psycopg2.errors.UndefinedColumn) column p.current_price does not exist
LINE 14: p.current_price,
^
[SQL:
SELECT
tp.id AS tp_id,
tp.product_id,
p.name,
p.ags_score,
p.rating,
p.review_count,
p.discount_rate,
p.is_amazon_choice,
p.is_best_seller,
p.is_prime,
p.primary_image,
p.current_price,
tp.created_at AS tp_created_at
FROM content_topicproduct tp
JOIN content_product p ON p.id = tp.product_id
WHERE tp.topic_id = %(topic_id)s
AND p.is_active = true
AND p.has_detail_fetched = true
ORDER BY tp.display_order, tp.created_at DESC
]
[parameters: {'topic_id': 16}]
(Background on this error at: https://sqlalche.me/e/20/f405)
18:30:16 | WARNING | Frontend revalidation returned 401 (attempt 1/3): {"error":"Unauthorized"}
18:30:16 | WARNING | Frontend revalidation returned 401 (attempt 2/3): {"error":"Unauthorized"}
18:30:16 | WARNING | Frontend revalidation returned 401 (attempt 3/3): {"error":"Unauthorized"}
18:30:16 | WARNING | Frontend revalidation exhausted 3 retries. ISR timers will handle eventual consistency.
18:30:17 | INFO | IndexNow: submitted 2 URLs (status=200)
18:30:17 | INFO | [topic_refresh] IndexNow notified 2 topic URLs for jp