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

[Tom J. <tc...@to...>]

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