Alright: the error I reported earlier in the log extract remains even when cal_items really does get created. So I dug a bit further, basically just playing with the offending query in psql.
The fix is easy, but I don't know why it is required. Advice from a real PG guru suggested 😊
The issue is with PG not being able to identify the type of the constant string in the ' ' as checked_p part of the select!
If you change that to
select distinct(calendar_id) as calendar_id, calendar_name,
' '::varchar as checked_p
from ...
then the query concerned works fine.
Could someone please exlain why PG is unable to figure out that ' ' is a string?? Anyway, at least you now have a suggested fix!
This fix moves the error I see to one from www/cal-dayview.tcl, where it looks like you have some "sql in a string" stuff going on
that needs a careful looking over. I'm going to call a halt here for today, and let you folks debug that one 😊
