[turba] CardDAV error.

[Michael J Rubinsky]

Quoting David Verdin <david at gnothi.fr>:

> 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".

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.



> 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?


>
> Best regards,
> David Verdin
> -- 
> turba mailing list
> Frequently Asked Questions: http://wiki.horde.org/FAQ
> To unsubscribe, mail: turba-unsubscribe at lists.horde.org



-- 
mike
The Horde Project
http://www.horde.org
https://www.facebook.com/hordeproject
https://www.twitter.com/hordeproject
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2007 bytes
Desc: S/MIME Signature
URL: <https://lists.horde.org/archives/turba/attachments/20161216/81df9f6d/attachment.bin>