Forum OpenACS Q&A: Re: Calendar: how to add public events?

Collapse
Posted by Tom Lazar on
claudio,

thanks for that: I just found the admin page with your help! there is no link to it, but when i manually enter the url

/calendar/admin/

i actually get an admin page, wow 😉

of course, this was *after* i manually converted one of the Personal calendars to public...

anyway, now i got the setup i wanted: everybody has a private calendar and can post to the public one.

one thing, though: when i click onto 'edit your calendar preferences' i get the following error:

Database operation "select" failed (exception NSDB, "Query was not a statement returning rows.")

ERROR:  Attribute 'party_id' not found

SQL:


        select  distinct(o.object_id) as calendar_id,
                calendar__name(o.object_id) as calendar_name,
                calendar__show_p(o.object_id, '292') as show_p
        from    acs_objects o
        where    calendar__readable_p(o.object_id, '292') = 't'
        and      party_id = '292'
        and      acs_object_util__object_type_p(o.object_id, 'calendar') = 't'
        and      calendar__private_p(o.object_id) = 'f'

        union

        select  cal_item__on_which_calendar(o.object_id) as calendar_id,
                calendar__name(cal_item__on_which_calendar(o.object_id)) as calendar_name,
                calendar__show_p(cal_item__on_which_calendar(o.object_id), '292') as show_p
        from    acs_objects o
        where    privilege = 'cal_item_read'
        and      party_id = '292'
        and      acs_object_util__object_type_p(o.object_id, 'cal_item') = 't'
        and      calendar__private_p(cal_item__on_which_calendar(o.object_id)) = 'f'

any ideas?

Collapse
Posted by Dis Continued on
Hi Tom -- did you ever find a solution for this? I have just run in to the same problem. Thanks. Michael
Collapse
Posted by Dis Continued on
The database operation error
Collapse
Posted by Dirk Gomez on
Michael, file a bug in bug-tracker. I'll fix this at some point.