[turba] CardDAV error.

[David Verdin]

Dear all,
I'm using Horde since a few years with great pleasure.
I use the CardDAV functionnality to keep sync between my computer and my
phone.

I recently completed the nightmare-ish upgrade from Ubuntu 14.04 to
16.04. that means I upgrade to PHP 7 and Imoved from Turba4.1.3 to 4.2.12.

Everything seemed fine BUT cardDAV does not seem to be working anymore.
The steps to reproduce:

1- access the CardDAV subscription ULR :
https:/<domain.tld>/horde/rpc.php/addressbooks/<username>/contacts:<key>/

What happens:

The following error is returned:

<d:error>
<s:exception>Sabre\DAV\Exception</s:exception>
<s:message>Server error when performing search.</s:message>
<s:sabredav-version>1.8.12</s:sabredav-version>
</d:error>

In the logs, I can read:

2016-12-16T17:10:21+00:00 WARN: HORDE [turba] PHP ERROR: Declaration of
Horde_Form_Type_country::init($prompt = NULL) should be compatible with
Horde_Form_Type_enum::init($values, $prompt = NULL) [pid 27741 on line 0
of "/usr/share/php/Horde/Form/Type.php"]
2016-12-16T17:10:23+00:00 WARN: HORDE PHP ERROR:
session_regenerate_id(): Cannot regenerate session id - session is not
active [pid 27741 on line 102 of "/usr/share/php/Horde/Session/Null.php"]
2016-12-16T17:10:26+00:00 NOTICE: HORDE [imp] Login success for <user>
(127.0.0.1) to {imap://localhost/} [pid 27741 on line 156 of
"/usr/share/horde/imp/lib/Auth.php"]
2016-12-16T18:10:26+01:00 ERR: HORDE [turba] SQL QUERY FAILED:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'object_category'
in 'field list'
SELECT object_id, owner_id, object_type, object_members,
object_uid,
object_firstname, object_lastname, object_middlenames,
object_nameprefix, object_namesuffix, object_alias,
object_yomifirstname, object_yomilastname, object_bday,
object_anniversary, object_spouse, object_photo,
object_phototype,
object_homestreet, object_homepob, object_homecity,
object_homeprovince, object_homepostalcode, object_homecountry,
object_workstreet, object_workpob, object_workcity,
object_workprovince, object_workpostalcode, object_workcountry,
object_otherstreet, object_otherpob, object_othercity,
object_otherprovince, object_otherpostalcode,
object_othercountry,
object_department, object_manager, object_assistant, object_tz,
object_email, object_homephone, object_homephone2,
object_homefax,
object_workphone, object_workphone2, object_cellphone,
object_carphone, object_radiophone, object_companyphone,
object_assistantphone, object_fax, object_pager, object_title,
object_role, object_company, object_logo, object_logotype,
object_category, object_notes, object_url, object_freebusyurl,
object_pgppublickey, object_smimepublickey, object_imaddress,
object_imaddress2, object_imaddress3 FROM turba_objects WHERE
(owner_id = '<user>') [pid 27741 on line 234 of
"/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]

I checked the database and did not find any table called "turba_objects".

The database schema is supposed to be up-to-date as well as the
configuration as per what the web administration interface tells me
-though I can't update horde config, it raises an uncaught exception,
but that must be unrelated.
CalDAV (on Kronolith) is working perfectly.
Access to the Address book through the web interface works well too.

Do you have any clue about how to get out of this situation? I'm quite
stuck here...

Best regards,
David Verdin

[Michael J Rubinsky]

Post by David Verdin
Dear all,
I'm using Horde since a few years with great pleasure.
I use the CardDAV functionnality to keep sync between my computer
and my phone.
I recently completed the nightmare-ish upgrade from Ubuntu 14.04 to
16.04. that means I upgrade to PHP 7 and Imoved from Turba4.1.3 to
4.2.12.
Everything seemed fine BUT cardDAV does not seem to be working anymore.
https:/<domain.tld>/horde/rpc.php/addressbooks/<username>/contacts:<key>/
<d:error>
<s:exception>Sabre\DAV\Exception</s:exception>
<s:message>Server error when performing search.</s:message>
<s:sabredav-version>1.8.12</s:sabredav-version>
</d:error>
2016-12-16T17:10:21+00:00 WARN: HORDE [turba] PHP ERROR: Declaration
of Horde_Form_Type_country::init($prompt = NULL) should be
compatible with Horde_Form_Type_enum::init($values, $prompt = NULL)
[pid 27741 on line 0 of "/usr/share/php/Horde/Form/Type.php"]
session_regenerate_id(): Cannot regenerate session id - session is
not active [pid 27741 on line 102 of
"/usr/share/php/Horde/Session/Null.php"]
2016-12-16T17:10:26+00:00 NOTICE: HORDE [imp] Login success for
<user> (127.0.0.1) to {imap://localhost/} [pid 27741 on line 156 of
"/usr/share/horde/imp/lib/Auth.php"]
SQLSTATE[42S22]: Column not found: 1054 Unknown column
'object_category' in 'field list'
SELECT object_id, owner_id, object_type, object_members, object_uid,
object_firstname, object_lastname, object_middlenames,
object_nameprefix, object_namesuffix, object_alias,
object_yomifirstname, object_yomilastname, object_bday,
object_anniversary, object_spouse, object_photo, object_phototype,
object_homestreet, object_homepob, object_homecity,
object_homeprovince, object_homepostalcode, object_homecountry,
object_workstreet, object_workpob, object_workcity,
object_workprovince, object_workpostalcode, object_workcountry,
object_otherstreet, object_otherpob, object_othercity,
object_otherprovince, object_otherpostalcode, object_othercountry,
object_department, object_manager, object_assistant, object_tz,
object_email, object_homephone, object_homephone2, object_homefax,
object_workphone, object_workphone2, object_cellphone,
object_carphone, object_radiophone, object_companyphone,
object_assistantphone, object_fax, object_pager, object_title,
object_role, object_company, object_logo, object_logotype,
object_category, object_notes, object_url, object_freebusyurl,
object_pgppublickey, object_smimepublickey, object_imaddress,
object_imaddress2, object_imaddress3 FROM turba_objects WHERE
(owner_id = '<user>') [pid 27741 on line 234 of
"/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
I checked the database and did not find any table called "turba_objects".

Then something is very wrong, especially if your migrations say they
are up to date. Additionally, the object_category field is removed by
one of the migrations. Please read turba/docs/UPGRADING.

Post by David Verdin
The database schema is supposed to be up-to-date as well as the
configuration as per what the web administration interface tells me
-though I can't update horde config, it raises an uncaught
exception, but that must be unrelated.
CalDAV (on Kronolith) is working perfectly.
Access to the Address book through the web interface works well too.
Do you have any clue about how to get out of this situation? I'm
quite stuck here...

Do you use a SQL based backend for Turba?

Post by David Verdin
Best regards,
David Verdin
--
turba mailing list
Frequently Asked Questions: http://wiki.horde.org/FAQ

[David Verdin]

OK. After thoroughly searching the web, it turns out the problem had
been discussed already. I probably were not using the right search terms.

I found the solution here:
https://lists.horde.org/archives/turba/Week-of-Mon-20131223/006912.html

I simply removed references to object_category in
/usr/share/horde/turba/config/backends.php and the problem was resolved.

cheers,

David

Post by David Verdin
Dear all,
I'm using Horde since a few years with great pleasure.
I use the CardDAV functionnality to keep sync between my computer and
my phone.
I recently completed the nightmare-ish upgrade from Ubuntu 14.04 to
16.04. that means I upgrade to PHP 7 and Imoved from Turba4.1.3 to 4.2.12.
Everything seemed fine BUT cardDAV does not seem to be working anymore.
https:/<domain.tld>/horde/rpc.php/addressbooks/<username>/contacts:<key>/
<d:error>
<s:exception>Sabre\DAV\Exception</s:exception>
<s:message>Server error when performing search.</s:message>
<s:sabredav-version>1.8.12</s:sabredav-version>
</d:error>
2016-12-16T17:10:21+00:00 WARN: HORDE [turba] PHP ERROR: Declaration
of Horde_Form_Type_country::init($prompt = NULL) should be compatible
with Horde_Form_Type_enum::init($values, $prompt = NULL) [pid 27741 on
line 0 of "/usr/share/php/Horde/Form/Type.php"]
session_regenerate_id(): Cannot regenerate session id - session is not
active [pid 27741 on line 102 of "/usr/share/php/Horde/Session/Null.php"]
2016-12-16T17:10:26+00:00 NOTICE: HORDE [imp] Login success for <user>
(127.0.0.1) to {imap://localhost/} [pid 27741 on line 156 of
"/usr/share/horde/imp/lib/Auth.php"]
SQLSTATE[42S22]: Column not found: 1054 Unknown column
'object_category' in 'field list'
SELECT object_id, owner_id, object_type, object_members,
object_uid,
object_firstname, object_lastname, object_middlenames,
object_nameprefix, object_namesuffix, object_alias,
object_yomifirstname, object_yomilastname, object_bday,
object_anniversary, object_spouse, object_photo,
object_phototype,
object_homestreet, object_homepob, object_homecity,
object_homeprovince, object_homepostalcode, object_homecountry,
object_workstreet, object_workpob, object_workcity,
object_workprovince, object_workpostalcode, object_workcountry,
object_otherstreet, object_otherpob, object_othercity,
object_otherprovince, object_otherpostalcode,
object_othercountry,
object_department, object_manager, object_assistant, object_tz,
object_email, object_homephone, object_homephone2,
object_homefax,
object_workphone, object_workphone2, object_cellphone,
object_carphone, object_radiophone, object_companyphone,
object_assistantphone, object_fax, object_pager, object_title,
object_role, object_company, object_logo, object_logotype,
object_category, object_notes, object_url, object_freebusyurl,
object_pgppublickey, object_smimepublickey, object_imaddress,
object_imaddress2, object_imaddress3 FROM turba_objects WHERE
(owner_id = '<user>') [pid 27741 on line 234 of
"/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
I checked the database and did not find any table called "turba_objects".
The database schema is supposed to be up-to-date as well as the
configuration as per what the web administration interface tells me
-though I can't update horde config, it raises an uncaught exception,
but that must be unrelated.
CalDAV (on Kronolith) is working perfectly.
Access to the Address book through the web interface works well too.
Do you have any clue about how to get out of this situation? I'm quite
stuck here...
Best regards,
David Verdin