[horde] Cannot update Contacts
Henning
Twilek at gmx.de
Sun May 11 19:33:23 UTC 2014
Since Horde 5.2. I cannot update the data of my Contacts from the
webinterface (this might be linked to the sync problems earlier). When
trying to update contact information I get something like...
2014-05-11T21:29:27+02:00 ERR: HORDE [turba] SQL QUERY FAILED:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in
your SQL syntax; check the manual that corresponds to your MySQL server
version for the right syntax to use near ' object_notes = '', object_url =
'', object_freebusyurl = '', object_pgppublicke' at line 1
UPDATE turba_objects SET owner_id = 'twilek', object_type = 'Object',
object_members = NULL, object_uid =
'20140511182945.fMmGr5wbDWhkQONF0kXEHg4 at xxx.de', object_firstname
= 'Test', object_lastname = 'Test', object_middlenames = '',
object_nameprefix = '', object_namesuffix = '', object_alias = '',
object_bday = NULL, object_anniversary = NULL, object_spouse = '',
object_photo = NULL, object_phototype = NULL, 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_department = '', object_tz = '', object_email = '',
object_email2 = '', object_email3 = '', object_homephone = '',
object_homefax = '', object_workphone = '', object_cellphone = '',
object_assistantphone = '', object_fax = '', object_pager = '',
object_title = '', object_role = '', object_company = '', object_logo
= NULL, object_logotype = NULL, object_category = , object_notes = '',
object_url = '', object_freebusyurl = '', object_pgppublickey = '',
object_smimepublickey = '', object_imaddress = '', object_imaddress2 =
'', object_imaddress3 = '' WHERE object_id =
'xDfz5DdLsAIsYjVWx7VJ7Q8' [pid 25347 on line 204 of
"/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
2014-05-11T21:29:27+02:00 ERR: HORDE [turba] Server error when saving data.
[pid 25347 on line 544 of "/var/www/webmail/turba/lib/Driver/Sql.php"]
At some point the database schema seems to have gone corrupt but I can´t
figure out where and how...
More information about the horde
mailing list