Unable to get past "Database error 42883: operator does not exist: text = boolean"
nsrandom opened this issue · 0 comments
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.