SQL QUERY FAILED - 'object_category' is not found.

Hello,

I currently have an issue with syncing my contacts - I find this issue 
in my server log, that 'object_category' is not found.

 From Syslog:
  HORDE: [turba] SQL QUERY FAILED: SQLSTATE[42S22]: Column not found: 
1054 Unknown column 'object_category' in 'field list'  #012#011SELECT 
object_id, owner_id, object_type, object_members, object_uid,#012#011  
object_firstname, object_lastname, object_middlenames,#012#011  
object_nameprefix, object_namesuffix, object_alias,#012#011  
object_yomifirstname, object_yomilastname, object_bday,#012#011  
object_anniversary, object_spouse, object_photo, 
object_phototype,#012#011 object_homestreet, object_homepob, 
object_homecity,#012#011 object_homeprovince, object_homepostalcode, 
object_homecountry,#012#011  object_workstreet, object_workpob, 
object_workcity,#012#011  object_workprovince, object_workpostalcode, 
object_workcountry,#012#011 object_otherstreet, object_otherpob, 
object_othercity,#012#011 object_otherprovince, object_otherpostalcode, 
object_othercountry,#012#011  object_department, object_manager, 
object_assistant, object_tz,#012#011  object_email, object_homephone, 
object_homephone2, object_homefax,#012#011 object_workphone, 
object_workphone2, object_cellphone,#012#011 object_carphone, 
object_radiophone, object_companyphone,#012#011  object_assistantphone, 
object_fax, object_pager, object_title,#012#011  object_role, 
object_company, object_logo, object_logotype,#012#011 object_category, 
object_notes, object_url, object_freebusyurl,#012#011  
object_pgppublickey, object_smimepublickey, object_imaddress,#012#011 
object_imaddress2, object_imaddress3 FROM turba_objects WHERE#012#011  
(owner_id = 'tw') [pid 8847 on line 204 of 
"/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]


I tried already horde-db-migrate which didn't help. I post the results - 
as It is maybe important to know the database versions:

root@lando:~# horde-db-migrate

[  INFO  ] Migrating DB up.
[  INFO  ] Current imp schema version: 3
[  INFO  ] Ending imp schema version: 3
[  INFO  ] Current kronolith schema version: 22
[  INFO  ] Ending kronolith schema version: 22
[  INFO  ] Current turba schema version: 11
[  INFO  ] Ending turba schema version: 11
[  INFO  ] Current nag schema version: 13
[  INFO  ] Ending nag schema version: 13
[  INFO  ] Current mnemo schema version: 7
[  INFO  ] Ending mnemo schema version: 7
[  INFO  ] Current trean schema version: 5
[  INFO  ] Ending trean schema version: 5
[  INFO  ] Current wicked schema version: 6
[  INFO  ] Ending wicked schema version: 6
[  INFO  ] Current gollem schema version: 3
[  INFO  ] Ending gollem schema version: 3
[  INFO  ] Current content schema version: 2
[  INFO  ] Ending content schema version: 2
[  INFO  ] Current Horde_ActiveSync schema version: 21
[  INFO  ] Ending Horde_ActiveSync schema version: 21
[  INFO  ] Current Horde_Alarm schema version: 2
[  INFO  ] Ending Horde_Alarm schema version: 2
[  INFO  ] Current Horde_Auth schema version: 1
[  INFO  ] Ending Horde_Auth schema version: 1
[  INFO  ] Current Horde_Cache schema version: 2
[  INFO  ] Ending Horde_Cache schema version: 2
[  INFO  ] Current Horde_Core schema version: 1
[  INFO  ] Ending Horde_Core schema version: 1
[  INFO  ] Current Horde_Dav schema version: 2
[  INFO  ] Ending Horde_Dav schema version: 2
[  INFO  ] Current Horde_Group schema version: 3
[  INFO  ] Ending Horde_Group schema version: 3
[  INFO  ] Current Horde_History schema version: 6
[  INFO  ] Ending Horde_History schema version: 6
[  INFO  ] Current Horde_Imap_Client schema version: 2
[  INFO  ] Ending Horde_Imap_Client schema version: 2
[  INFO  ] Current Horde_Lock schema version: 3
[  INFO  ] Ending Horde_Lock schema version: 3
[  INFO  ] Current Horde_Perms schema version: 2
[  INFO  ] Ending Horde_Perms schema version: 2
[  INFO  ] Current Horde_Prefs schema version: 3
[  INFO  ] Ending Horde_Prefs schema version: 3
[  INFO  ] Current Horde_Queue schema version: 1
[  INFO  ] Ending Horde_Queue schema version: 1
[  INFO  ] Current Horde_SessionHandler schema version: 2
[  INFO  ] Ending Horde_SessionHandler schema version: 2
[  INFO  ] Current Horde_SyncMl schema version: 1
[  INFO  ] Ending Horde_SyncMl schema version: 1
[  INFO  ] Current Horde_Token schema version: 1
[  INFO  ] Ending Horde_Token schema version: 1
[  INFO  ] Current Horde_Vfs schema version: 4
[  INFO  ] Ending Horde_Vfs schema version: 4
root@lando:~#


I assume that over time, at some time data migration failed maybe. Shall 
I somehow add the  missing field, or is some migration needed?

Regards Tobias




-- 
turba mailing list
Frequently Asked Questions: http://wiki.horde.org/FAQ
To unsubscribe, mail: [email protected]