Upgrade to 0.6-1 broke add to addressbook

[mathog]

I had been running 0.5.3-1 and upgraded to 0.6-1 in order to get rid of the "..." on long subjects.  0.6-1 seems to work in every way except that it  cannot add entries to or modify the address book.  Every attempt results in a

   could not save the contact address

red pop up message at the top of the screen.  Changes never "take".  So far have not found anything relevant in any log files.  The addressbook worked fine under 0.5.3-1, and all the entries added then work in 0.6-1.

The configuration wasn't changed at the update.

Any suggestions on how to fix this?

Mandriva 2010.0 X86_64 system, RPMs include:

php 5.3.6 (many different RPMs)
roundcubemail-0.6-1.mga2.noarch
postgresql8.4-server-8.4.7-0.1mdv2010.0.x86_64
postgresql8.4-devel-8.4.7-0.1mdv2010.0.x86_64
postgresql8.4-8.4.7-0.1mdv2010.0.x86_64

Thanks.

[SKaero]

Whats in your RoundCube error log?

[mathog]

Whats in your RoundCube error log?

 
Odd, nothing since the update.  Generate an error on purpose (login with wrong password).  Nope, nothing shows up.  Look
in /home/apache2/log/error_log and find:

Code: [Select]

[Thu Dec 22 08:22:23 2011] [error] [client 131.215.12.39] PHP Warning:  Error writing to log file /var/log/roundcubemail/errors; Please check permissions in /usr/share/roundcubemail/program/include/main.inc on line 2115, referer: [url]https://saf.bio.caltech.edu/roundcubemail/[/url]
[Thu Dec 22 08:22:23 2011] [error] [client 131.215.12.39] PHP Notice:  Login failed for username from 131.215.12.39. AUTHENTICATE PLAIN: Authentication failed. in /usr/share/roundcubemail/program/include/main.inc on line 2270, referer: [url]https://saf.bio.caltech.edu/roundcubemail/[/url]

File protection on /var/log/roundcubemail was 700 owner root:root.  Change it to 711.  Files inside are all apache:apache.
(This may not have been an upgrade problem per se.  It is a Mandriva system, and msec sometimes decides to change file protections to what it thinks they should be, rather than what they need to be.)

Good, now failed logins create error messages.  Try the address book thing again, change the first name field on an existing record (from blank to Andrew)

Code: [Select]

[22-Dec-2011 08:29:56] MDB2 Error: no such field (-19): prepare: [Error message: Unable to create prepared statement handle]
[Last executed query: DEALLOCATE PREPARE mdb2_statement_pgsql_38c5e4f57e2331566e45db3dccfd2186f0d0dff75]
[Native message: ERROR:  column "words" of relation "contacts" does not exist
LINE 6: ...caltech.edu', "firstname"='Andrew', "surname"='', "words"=' ...
                                                             ^]

[2011-Dec-22 08:29:56 -0800]: DB Error: prepare: [Error message: Unable to create prepared statement handle]
[Last executed query: DEALLOCATE PREPARE mdb2_statement_pgsql_38c5e4f57e2331566e45db3dccfd2186f0d0dff75]
[Native message: ERROR:  column "words" of relation "contacts" does not exist
LINE 6: ...caltech.edu', "firstname"='Andrew', "surname"='', "words"=' ...
                                                             ^]
 in /usr/share/roundcubemail/program/include/rcube_mdb2.php on line 285 (POST /roundcubemail/?_orig_source=0?_task=addressbook&_action=save)

That looks like some SQL query was invalid.

What next?

Thanks.

[mathog]

I wonder if this has anything to do with the comment at the bottom of this page:

PostgreSQL: Documentation: Manuals: UPDATE

Perhaps Postgresql differs from Mysql in this regard?

[mathog]

Tried upgrading to 0.7.1 using this:

roundcubemail-0.7-1.mga2.noarch RPM

The program works the same as before.  There are now two sets of error messages in the error log, this one appears when the addressbook is opened:

Code: [Select]

in /usr/share/roundcubemail/program/include/rcube_mdb2.php on line 293 (POST /roundcubemail/?_orig_source=0?_task=addressbook&_action=save)
[22-Dec-2011 11:08:56] MDB2 Error: no such table (-18): prepare: [Error message: Unable to create prepared statement handle]
[Last executed query: DEALLOCATE PREPARE mdb2_statement_pgsql_38ac1bdcb27999ca6949ad828bd7468adefa4fd61]
[Native message: ERROR:  relation "searches" does not exist
LINE 1: SELECT search_id AS id, "name" FROM searches WHERE user_id =...
                                            ^]

[2011-Dec-22 11:08:56 -0800]: DB Error: prepare: [Error message: Unable to create prepared statement handle]
[Last executed query: DEALLOCATE PREPARE mdb2_statement_pgsql_38ac1bdcb27999ca6949ad828bd7468adefa4fd61]
[Native message: ERROR:  relation "searches" does not exist
LINE 1: SELECT search_id AS id, "name" FROM searches WHERE user_id =...
                                            ^]
 in /usr/share/roundcubemail/program/include/rcube_mdb2.php on line 293 (GET /roundcubemail/?_task=addressbook)

and this one, which is almost the same as before, appears when an attempt is made to modify an entry:

Code: [Select]

[22-Dec-2011 11:10:12] MDB2 Error: no such field (-19): prepare: [Error message: Unable to create prepared statement handle]
[Last executed query: DEALLOCATE PREPARE mdb2_statement_pgsql_3e96fe8e41354e63fae26ac444a546e8325dae296]
[Native message: ERROR:  column "words" of relation "contacts" does not exist
LINE 6: ...caltech.edu', "firstname"='Andrew', "surname"='', "words"=' ...
                                                             ^]

[2011-Dec-22 11:10:12 -0800]: DB Error: prepare: [Error message: Unable to create prepared statement handle]
[Last executed query: DEALLOCATE PREPARE mdb2_statement_pgsql_3e96fe8e41354e63fae26ac444a546e8325dae296]
[Native message: ERROR:  column "words" of relation "contacts" does not exist
LINE 6: ...caltech.edu', "firstname"='Andrew', "surname"='', "words"=' ...
                                                             ^]
 in /usr/share/roundcubemail/program/include/rcube_mdb2.php on line 293 (POST /roundcubemail/?_orig_source=0?_task=addressbook&_action=save)
rpm -U complained about wanting Python(abi), but Python is installed, for instance

lib64python2.6-2.6.4-1.4mdv2010.0.x86_64

and rpm -U --nodeps completed, with roundcube working well, other than this addressbook problem.  The db.inc.php and main.inc.php are now based on a much earlier version.  Try upgrading those based in current version...  It made no difference, everything stayed as just described.

[alec]

Did you update database structure? Howto_Upgrade

[mathog]

Did you update database structure? Howto_Upgrade

Usually rpm's take care of stuff like that automatically, apparently not this time.  Modified the update script to start with the 0.5.3 line and then did:

su - postgresql
psql roundcubemail
\i  postgres.update.sql
\q

and the address book worked again.

There were a bunch of notices and one error message:

CREATE TABLE
psql:postgres.update.sql:40: ERROR:  sequence "messages_ids" does not exist

That corresponds to the line

DROP SEQUENCE messages_ids;

Probably harmless for a drop to fail if the thing being dropped wasn't there in the first place.

thanks!