Forum OpenACS Development: Re: What's the best approach to update timezone rules?

Collapse
4: Re: What's the best approach to update timezone rules? (response to 3)
Posted by Gustaf Neumann on 02/08/14 12:04 PM
Hi Cesáreo,

when the data in packages/ref-timezones/sql/common/ looks right, then see packages/ref-timezones/tcl/apm-callback-procs.tcl for how to update the database.

all the best
-gn

Collapse
5: Re: What's the best approach to update timezone rules? (response to 4)
Posted by Cesareo Garci­a Rodicio on 02/08/14 02:15 PM
Hi Gustaf,

Yeah, it seems to be an upgrade problem. I'll load into database openacs/packages/ref-timezones/sql/postgresql/upgrade/upgrade-timezones.ctl

So the best approach seems to be:
1. Check rules in packages/ref-timezones/sql/common/timezones-rules.dat
2. Upgrade (vía upgrade-timezones.ctl or via apm-callback-procs.tcl)

Thanks !
Cesáreo

Collapse
6: Re: What's the best approach to update timezone rules? (response to 5)
Posted by Cesareo Garci­a Rodicio on 03/07/14 08:16 PM
Hi

I've forgot to upgrade this.

I had to upgrade it manually. It seemed to be originally an upgrade problem in my setup.

I had to do a DROP .. CASCADE (in upgrade script packages/ref-timezones/sql/postgresql/ref-timezones-drop.sql
there is no CASCADE and I had errors with events package).

Thanks
Cesáreo