PromptBase
Upgrade
Close icon
General
Home
Marketplace
Create
Hire
Login
Chat
Sell
Explore

Prompt Details

Model
(claude-5-sonnet)
Token size
391
Example input
[ERROR_MESSAGE]: Got this in production: Traceback (most recent call last): File "/app/src/api/handlers.py", line 42, in process_order: order = await db.execute(query, params); File "/usr/local/lib/python3.11/site-packages/asyncpg/connection.py", line 318, in execute: return await self._protocol.query(query, timeout); asyncpg.exceptions.UndefinedColumnError: column "user_id" of relation "orders" does not exist
Example output
**Plain reading:** You're running a SQL query that references a column "user_id" on the "orders" table, but that column isn't in the table. **Most likely cause:** A database migration that adds the user_id column hasn't been applied in this environment. The code was deployed with the assumption that the column exists. **First thing to check:** Compare the schema of orders in this environment against your migrations directory. Run \d orders in psql against the production database; check whether user_id is listed. **Second thing to check (if the first was inconclusive):** Look at the migration log table (whatever your migration tool uses — alembic_version for Alembic, schema_migrations for Rails-style tools). The expected migration should be present. If it's not, the deploy didn't run migrations. **Less likely possibilities:** 1. The column was added but with a different name (userId, user, customer_id). Check the migration file for the actual column name. Distinguishes from cause #1 by the migration table showing the migration ran but the column being named something else. 2. You're connected to the wrong database. Distinguishes by SELECT current_database() returning something unexpected. **Common false leads:** - ORM cache: asyncpg doesn't cache schema in a way that would cause this. Ignore. - Permission issues: a permission issue would produce a different error class. Ignore.
🌀 Claude

Error Decoder

Add to Cart
Instant accessInstant access
Usage rightsCommercial use
Money-back guaranteeMoney‑back
By purchasing this prompt, you agree to our terms of service
CLAUDE-5-SONNET
Tested icon
Guide icon
4 examples icon
Free credits icon
Decodes a cryptic error message or stack trace into what it actually means, where the cause likely is, and what to check first — not five generic possible causes with no ranking. Names the single most efficient first diagnostic step, a fallback second step, and less-likely alternatives with what would distinguish them. Won't pattern-match to a similar-sounding error, won't suggest "google it," and says so honestly when it doesn't recognize the error. One of 40 in the Pemway Power User Pack.
...more
Added 2 days ago
Report
Browse Marketplace