Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Viewing tables gives 500 with error prepared statement needs 2 parameters #23

Open
larsyencken opened this issue Aug 7, 2024 · 0 comments · May be fixed by #24
Open

Viewing tables gives 500 with error prepared statement needs 2 parameters #23

larsyencken opened this issue Aug 7, 2024 · 0 comments · May be fixed by #24

Comments

@larsyencken
Copy link

Problem

When using DuckDB native DB files, and you click on a specific table in the interface, it gives 500 Prepared statement needs 2 parameters, 0 given

Screenshot 2024-08-07 at 10 50 50

Expected behaviour

It correctly renders the table page.

Stacktrace

It appears that the parameters get lost in transition to the proxy cursor:

Screenshot 2024-08-07 at 10 52 12
@larsyencken larsyencken changed the title Viewing tables gives 500 Viewing tables gives 500 with error prepared statement needs 2 parametres Aug 7, 2024
@larsyencken larsyencken changed the title Viewing tables gives 500 with error prepared statement needs 2 parametres Viewing tables gives 500 with error prepared statement needs 2 parameters Aug 7, 2024
larsyencken added a commit to larsyencken/datasette-parquet that referenced this issue Aug 7, 2024
@larsyencken
Fixes error in parameters of prepared statements during rewrite
1b4b8fd 
Fixes cldellow#23

The dependencies for this package are unpinned. `sqlglot` upstream
changed their rewriting to do more, so this package now needs to do a
little less.

This commit removes some rewriting that was failing with recent package
versions, and pins `sqlglot` to `>=21.2` in `setup.py`.
@larsyencken larsyencken linked a pull request Aug 7, 2024 that will close this issue
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Fixes error in parameters of prepared statements during rewrite larsyencken/datasette-parquet
1 participant
@larsyencken