Unknown column 'object_category'

Simon B <[email protected]>
Newsgroups gmane.comp.horde.turba
Message-ID <CAOmHMuFxDj9bfj1GQ+ECsPYY=hj6Qr22Z+M8jaCk=BVdNYNdxw@mail.gmail.com>
Hi

I'm not sure which update prompted this error, but since the last time
I used the addressbook (about 3 weeks ago), this has come up.
Basically clicking on a contact name to view/edit a contact results
in:

QUERY FAILED: 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_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_department, object_tz, object_email, object_workemail,
object_workphone, object_cellphone, object_workcellphone,
object_homephone, object_homefax, 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 object_id IN ('JkH3OFyZnp9OhjnOp7IHy_A') AND
owner_id = '[email protected]

The admin panel says all DB schemas are up to date.  What do I do now
- how do I debug this?

Adding a test contact results in this error:

There was an error adding the new contact. Contact your system
administrator for further help

(On that note thank you so much for renabling the copy of error messages)! :)

The horde log has:

2013-12-27T10:49:13+00:00 ERR: HORDE-BETA [turba] SQL QUERY FAILED:
Unknown column 'object_category' in 'field list'
        INSERT INTO turba_objects (object_type, object_firstname,
          object_lastname, object_middlenames, object_nameprefix,
          object_namesuffix, object_alias, object_bday, object_spouse,
          object_anniversary, object_photo, 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_tz, object_email, object_workemail,
          object_homephone, object_workphone, object_cellphone,
          object_workcellphone, object_fax, object_homefax, object_pager,
          object_assistantphone, object_imaddress, object_imaddress2,
          object_imaddress3, object_title, object_role, object_company,
          object_department, object_logo, object_category, object_notes,
          object_url, object_freebusyurl, object_pgppublickey,
          object_smimepublickey, owner_id, object_uid, object_id) VALUES
          ('Object', 'Test', 'Test', '', '', '', '', NULL, '', NULL, NULL, '',
          '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '',
          '', '', '', '', '', '', '', '', '', '', '', '', NULL, '', '', '', '',
          '', '', '[email protected]',
          '[email protected]',
          'LEgCLy_TDylHPNSMvdK14w5') [pid 20344 on line 315 of
"/usr/share/git-horde5/framework/Db/lib/Horde/Db/Adapter/Mysqli.php"]
2013-12-27T10:49:13+00:00 ERR: HORDE-BETA [turba] QUERY FAILED:
Unknown column 'object_category' in 'field list'

The only thing I notice - and this is weird, is when I go to the
configuration options for Turba it's showing my address books as
options for the client and gal addressbooks.  Is this normal?

Address Book (turba) 4.2.0-git
SQL DB schema is ready.
Application is ready.
 Horde (horde) 5.2.0-git

Thanks

Simon
-- 
turba mailing list
Frequently Asked Questions: http://wiki.horde.org/FAQ
To unsubscribe, mail: [email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.