Home
The Toolkit for Online Communities
17303 Community Members, 2 members online, 2208 visitors today
Log In Register
OpenACS Home : Forums : OpenACS Development : Question regarding timezones

Forum OpenACS Development: Question regarding timezones

Icon of envelope Request notifications

Collapse
Posted by Lilian Tong on
I'm porting the data model (the cal-table-create.sql file) of the
calendar module at the moment and I'm having a bit of trouble with
this file.
When I put this file through psql, the following error is raised:

psql:cal-table-create.sql:81: ERROR:  Relation 'timezones' does not
exist
psql:cal-table-create.sql:89: ERROR:  relation 'cal_party_prefs' does
not exist
psql:cal-table-create.sql:93: ERROR:  Relation 'cal_party_prefs' does
not exist
psql:cal-table-create.sql:98: ERROR:  Relation 'cal_party_prefs' does
not exist
psql:cal-table-create.sql:102: ERROR:  Relation 'cal_party_prefs' does
not exist
psql:cal-table-create.sql:108: ERROR:  Relation 'cal_party_prefs' does
not exist
psql:cal-table-create.sql:113: ERROR:  Relation 'cal_party_prefs' does
not exist
psql:cal-table-create.sql:122: ERROR:  Relation 'cal_party_prefs' does
not exist

when i removed the timezones section, the whole file works fine.

This is the part of the program raising those errors:

create table cal_party_prefs (
                      ..
                      .. -- works fine here
                      ..

        time_zone      integer
                      constraint cal_pty_prefs_time_zone_fk
                      references timezones
                      on delete cascade,

                      ..
                      .. -- works fine here
                      ..
);

comment.........;
comment.........;

will anyone be able to help?

Lilian

Collapse
Posted by Jowell Sabino on
timezones table is part of acs-reference. calendar depends on it.
Collapse
Posted by Jonathan Marsden on
This package is assigned to Rafael Calvo, according to the status page.

Should it be assigned to Lilian instead?  Lilian, are you one of Rafael's students, maybe?  If not, be careful to avoid duplicating porting work already being done by others.

Collapse
Posted by Don Baccus on
Her address looks right for one of his students, but I'll double check and have her e-mail Jon Griffin about acs-references (Lilian - you'll get private e-mail from me in a few minutes).
Collapse
Posted by Lilian Tong on
Thank you for your help. And yes, I'm one of Rafael's students working on the calendar package.
Collapse
Posted by Don Baccus on
OK, I've put you down for calendar on the status sheet.
Collapse
Posted by Charles Mok on
Can you put my name down as well, because I'm also working on the calendar package with Rafael.

Thanks