[turba] CardDAV error.

[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

Le 16/12/2016 à 18:28, David Verdin a écrit :
> 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