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.

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

Unable to get past "Database error 42883: operator does not exist: text = boolean" #33

Open
nsrandom opened this issue Apr 1, 2022 · 0 comments

Comments

@nsrandom
Copy link

nsrandom commented Apr 1, 2022

Hi, I managed to build pgcharts on my Mac, and set it up with an existing database.
But all queries are failing with the following error.

Date/time: 2022-04-01-12:10!
An unhandled error condition has been signalled:
Database error 42883: operator does not exist: text = boolean
HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
QUERY: (SELECT * FROM db WHERE (dbname = false))

Backtrace for: #
0: (TRIVIAL-BACKTRACE:PRINT-BACKTRACE-TO-STREAM #)
1: (TRIVIAL-BACKTRACE:PRINT-BACKTRACE # :OUTPUT NIL :IF-EXISTS :APPEND :VERBOSE T)
2: (PGCHARTS::FRONT-RAW-QUERY NIL)
3: ((:METHOD HUNCHENTOOT:ACCEPTOR-DISPATCH-REQUEST (SIMPLE-ROUTES:SIMPLEROUTES-ACCEPTOR T)) # #) [fast-method]
4: ((:METHOD HUNCHENTOOT:HANDLE-REQUEST (HUNCHENTOOT:ACCEPTOR HUNCHENTOOT:REQUEST)) # #) [fast-method]
5: ((:METHOD HUNCHENTOOT:PROCESS-REQUEST (T)) #) [fast-method]
6: (HUNCHENTOOT::DO-WITH-ACCEPTOR-REQUEST-COUNT-INCREMENTED # #)
7: ((:METHOD HUNCHENTOOT:PROCESS-CONNECTION (HUNCHENTOOT:ACCEPTOR T)) # #) [fast-method]
8: ((:METHOD HUNCHENTOOT:PROCESS-CONNECTION :AROUND (HUNCHENTOOT:ACCEPTOR T)) # #) [fast-method]
9: ((FLET HUNCHENTOOT::PROCESS-CONNECTION% :IN HUNCHENTOOT::HANDLE-INCOMING-CONNECTION%) # #)
10: ((LAMBDA NIL :IN BORDEAUX-THREADS::BINDING-DEFAULT-SPECIALS))
11: ((FLET SB-UNIX::BODY :IN SB-THREAD::RUN))
12: ((FLET "WITHOUT-INTERRUPTS-BODY-11" :IN SB-THREAD::RUN))
13: ((FLET SB-UNIX::BODY :IN SB-THREAD::RUN))
14: ((FLET "WITHOUT-INTERRUPTS-BODY-4" :IN SB-THREAD::RUN))
15: (SB-THREAD::RUN)
16: ("foreign function: call_into_lisp")
17: ("foreign function: funcall1")

My query is as simple as:

SELECT * FROM punters;

where the punters table is defined as:

CREATE TABLE punters (
    year integer not null,
    month integer not null,
    day integer not null,
    name text not null,
    hands integer,
    chips integer not null,
    amount numeric(5,2) not null,
    buyins integer
);

I feel like I might be making some small obvious mistake, but I can't figure it out. StackOverflow seems to say that I might be using non standard table columns, but I am only using standard data types afaict.

Any help would be much appreciated.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant