Re: [OPT-general] Calendar plugin and OPT actualization...

[mose <mo...@ma...>]

On Thu, 2002-05-30 at 13:29, David Ruiz Estefan=EDa wrote:
> Hi all...
>=20
>   What is the last Calendar Plugin version?... I've just instaled de vers=
i=F3n
>   at sourceforge (1.07) but doen't work at all, i've upgraded from 1.05
>   versi=F3n (also at sourceforge)... here's the error it gives:

- the 1.07 version only installs with the new OPTUM system for upgrade,
that is included in OPT .942 (previous versions didn't support plugins
upgrade so it was a mess).


>=20
> -------------------------------------------------------------------------=
--
> The following query failed:
> select id, date_format(tstart,'%Hh%i') as h, time_format(duration,'%Hh%i'=
) as dur, title, comment, projectID as pid, peopleID as uid, status from ca=
lendar where to_days(tstart)=3Dto_days(20020526) and ((projectID=3D14) and =
tstart between 20020526 and 20020601) order by tstart asc;
> Unknown column 'status' in 'field list'
> -------------------------------------------------------------------------=
--

- just run that sql command and it will be fixed:

ALTER table calendar add column status enum('todo', 'done', 'maybe',
'event') NOT NUL default 'todo';

(anyway it will probably be altered in next version to match iCalendar
objects types).

>=20
>   Is there another newer version of this plugin????

- most recent released version is 1.07 for now, 1.08 is on the way, but
there will be lotta work in order to become iCalendar compliant (hard,
but worthful imho).

mose

--=20
mose           : http://makina-corpus.com :  Free Software
Tech Manager   : http://makina-corpus.org :  Architectures
Makina Corpus  : V: +33 (0) 1 53 36 46 54 :  & Development