Re: [Davical-general] Davical on Ubuntu (Mate) 24.04

[Florian S. <fs...@de...>]

Hi Tom,

new DAViCal releases sometimes make changes to the database schema, and
the current code assumes a current database version. Looking at
setup.php should inform you about version mismatches and other common
problems.

When you restore a database from a dump of an older version, an update
script, located at /usr/share/davical/dba/update-davical-database in the
Ubuntu package, needs to be run to make the required changes. This is
automated when doing a regular package upgrade, however in case you're
manually changing database content, all you have is the setup.php
checkers.

Florian


On Mon, May 06, 2024 at 02:32:07PM +0100, Tom Jewell wrote:
> I've solved the practical problem of transferring the database from the
> Ubuntu 22.04 Davical to the 24.04 version by exporting .icf and .vcf files
> from Thunderbird mail and Cardbook on the old machine, and importing them
> into the Davical database on the new machine via the Davical web server.
> I've also verified that this new database can be dumped and restored via
> pg_dump and pg_restore, and the resulting calendar can be read and written
> to, unlike, as noted before, when the dump has come from the earlier Davical
> version.  So this isn't an issue for me anymore, although if anybody knows
> what was going on here I'd like to hear about it.
> 
> Davical has been very useful and generally smooth operating for me for ten
> years now (with one or two hiccups), and I hope it goes on forever.  The
> documentation, though... it's not very encouraging for someone who just
> wants the functionality without having to spend days learning the ins and
> outs of apache, postgresql, etc.  What the ordinary user needs is a
> step-by-step cookbook recipe for installation for common systems (e.g.
> Ubuntu).
> 
> 
> On 5/5/24 19:27, Tom Jewell wrote:
> > Well, no luck.  I have page dumped and restored in the simplest possible
> > way, and the calendar populates, but I still can't create an event.  I
> > get the same error codes, and the postgresql log says:
> > 
> > davical_app@davical ERROR:  column "dtstart_orig" of relation
> > "calendar_item" does not exist at character 90
> > 
> > If, however, I start with a completely blank calendar, not a restored
> > one, I can in fact write to it.
> > 
> > 
> > On 5/5/24 18:40, Tom Jewell wrote:
> > > This appears to be a problem with the method I'm using to page dump
> > > from the 22.04 version, then restore to the 24.04 version. This
> > > hasn't been a problem before, and I've been backing up and restoring
> > > the Davical database since 2013. Ah, well.  Am trying alternative
> > > methods to the pg_dump string I've been using, but it may be a while
> > > as my acquaintance with postgresql is pretty minimal.
> > > 
> > > 
> > > On 5/4/24 18:10, Tom Jewell wrote:
> > > > I have installed Ubuntu Mate 24.04 from scratch and then
> > > > installed davical+awl from the Ubuntu repository.  Everything
> > > > seems to go alright, various calendars (Thunderbird, DAVx5)
> > > > populate, but it is not possible to modify the database, i.e,
> > > > add or change an event, or add or modify anything else.  I get a
> > > > 500, status code 2147746065 error when I try.
> > > > 
> > > > After several days of futzing around, I deleted the davical and
> > > > awl directories that I had installed from the repository and
> > > > replaced them with the old davical and awl directories from my
> > > > Ubuntu Mate 22.04 installation.  Everything works this way.
> > > > Perhaps there's something strange going on with this latest
> > > > repository version.
> > > > 
> > > > Meanwhile, is there any danger in using the older versions of
> > > > davical and awl with 24.04?
> > > > 
> > > 
> > > 
> > > _______________________________________________
> > > Davical-general mailing list
> > > Dav...@li...
> > > https://lists.sourceforge.net/lists/listinfo/davical-general
> > 
> > 
> > _______________________________________________
> > Davical-general mailing list
> > Dav...@li...
> > https://lists.sourceforge.net/lists/listinfo/davical-general
> 
> 
> _______________________________________________
> Davical-general mailing list
> Dav...@li...
> https://lists.sourceforge.net/lists/listinfo/davical-general