U132: There is no parameter $1 / $n
SQLSTATE: 42P02 (Class 42 — Syntax Error or Access Rule Violation: undefined_parameter)
Example Postgres Log Output:
ERROR: there is no parameter $1 at character 8 STATEMENT: SELECT $1;
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.
This may occur when you have a problem in your application with how you bind values to the correct parameter numbers in the query.
Review the issued SQL and passed in values carefully, and either adjust the parameter number, or add the missing value for the problematic parameter.
Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →