Forum OpenACS Development: Response to Problems with loading the calendar module
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 😊