Bug 3862

Description of problem:

When upgrading roundcubemail it is necessary to upgrade the database.  The distribution includes the scripts to do this, for instance: postgres.update.sql,
but it is not run automatically, nor is there a warning to do so.  The result
is that the upgraded installation is slightly broken and there are no indications to that effect.  In my case on upgrading from 0.5.3 to 0.6.1, and then from there to 0.7.1, the addressbook stopped accepting changes at each update.


Version-Release number of selected component (if applicable):

at least 0.6.1 and 0.7.1

How reproducible:

2 out of 2 upgrades (did this with both the 0.6.1 and 0.7.1 releases.)


Steps to Reproduce:
1. download the roundcubemail noarch rpm
2. rpm -U --nodeps (rpmname)
3. try to modify an existing addressbook entry within roundcube, it will not work.

On my system (mandriva 2010.0, but probably the same on Mageia) the fix is to do:

cp /usr/share/roundcubemail/SQL/postgres.update.sql /tmp
chmod 777 /tmp/postgres.update.sql
#edit /tmp/postgres.update.sql, leaving only commands from current
# version which is being updated
su - postgres
psql roundcubemail
\i /tmp/postgres.update.sql
\q
exit
rm /tmp/postgres.update.sql

Note, the --nodeps is required because on Mandriva 2010.0 there is otherwise
a complaint about a missing "python (api)" dependency.  Not sure if that happens on mageia or not, but it can be ignored so long as python is actually installed.