dimitri/pgcharts

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.