[turba] Unknown column 'object_category'

[Michael J Rubinsky]

Quoting Simon B <simon.buongiorno at 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 = 'simon at example.net
>
> 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, '',  
> '', '', '',
>           '', '', 'simon at example.net',
>           '20131227104913.zK84QldIFYywwskhVrr7Ag5 at webmail.lydiard.net',
>           '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


Categories were removed in Turba 4.2, and the schema was updated  
accordingly. You probably need to remove the category attribute from  
your backends.local.php config.

Looks like this still needs to be documented in turba/docs/UPGRADING.
-- 
mike

The Horde Project (www.horde.org)
mrubinsk at horde.org
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 5849 bytes
Desc: S/MIME Signature
URL: <http://lists.horde.org/archives/turba/attachments/20131227/2dffb617/attachment.bin>