U132: There is no parameter $1 / $n
Category: Application / User Errors
SQLSTATE: 42P02 (Class 42 — Syntax Error or Access Rule Violation: undefined_parameter)
Urgency: low
SQLSTATE: 42P02 (Class 42 — Syntax Error or Access Rule Violation: undefined_parameter)
Urgency: low
Example Postgres Log Output:
ERROR: there is no parameter $1 at character 8
STATEMENT: SELECT $1;
Explanation:
You've used a parameterized query, usually by using PREPARE and EXECUTE, but did
not pass in a value for the parameter referenced (e.g. $1
).
This may occur when you have a problem in your application with how you bind values to the correct parameter numbers in the query.
Recommended Action:
Review the issued SQL and passed in values carefully, and either adjust the parameter number, or add the missing value for the problematic parameter.
Learn More:
Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →