[horde] Turba errors after updating to 2.2

Johan Huldtgren johan+horde at obitus.org
Sat Mar 1 16:25:17 UTC 2008


When I try to browse my address book (sql based), I get:

DB Error: no such field.

This is after I've run 2.1_to_2.2_sql_schema.php  (which went
through without errors).

 From my PostgreSQL log, I see this:

Mar  1 16:53:11 www postgres[67939]: [20-1] LOG:  statement: SELECT  
object_id, object_type, owner_id, object_name, object_email,  
object_company FROM turba_objects WHERE  (owner_id = 'johan')
Mar  1 16:53:11 www postgres[67939]: [21-1] ERROR:  column  
"object_name" does not exist at character 42

So it seems that somewhere turba is still referencing object_name
which gets dropped in the schema update. Taking a look at the
schema for turba_objects, we see that there is no object_name anymore.

--
-- Name: turba_objects; Type: TABLE; Schema: public; Owner: pgsql; Tablespace:
--

CREATE TABLE turba_objects (
     object_id character varying(32) NOT NULL,
     owner_id character varying(255) NOT NULL,
     object_type character varying(255) DEFAULT 'Object'::character  
varying NOT NULL,
     object_uid character varying(255),
     object_members text,
     object_alias character varying(32),
     object_email character varying(255),
     object_homephone character varying(25),
     object_workphone character varying(25),
     object_cellphone character varying(25),
     object_fax character varying(25),
     object_title character varying(255),
     object_company character varying(255),
     object_notes text,
     object_pgppublickey text,
     object_smimepublickey text,
     object_freebusyurl character varying(255),
     object_firstname character varying(255),
     object_lastname character varying(255),
     object_middlenames character varying(255),
     object_nameprefix character varying(255),
     object_namesuffix character varying(32),
     object_phototype character varying(10),
     object_bday character varying(10),
     object_homestreet character varying(255),
     object_homepob character varying(10),
     object_homecity character varying(255),
     object_homeprovince character varying(255),
     object_homepostalcode character varying(255),
     object_homecountry character varying(255),
     object_workstreet character varying(255),
     object_workpob character varying(10),
     object_workcity character varying(255),
     object_workprovince character varying(255),
     object_workpostalcode character varying(255),
     object_workcountry character varying(255),
     object_tz character varying(32),
     object_geo character varying(255),
     object_pager character varying(25),
     object_role character varying(255),
     object_logotype character varying(10),
     object_category character varying(80),
     object_url character varying(255),
     object_photo text,
     object_logo text
);

So how does one solve this?

Versions:

OS: FreeBSD 6.2-STABLE
php5-5.2.5_1
postgresql-server-8.2.6
horde-base-3.2_1
horde-imp-4.2
horde-ingo-1.2
horde-kronolith-2.2
horde-mimp-1.0.2
horde-mnemo-2.2
horde-nag-2.2
horde-turba-2.2
horde-vacation-3.0.1_1

Thanks,
.jh


More information about the horde mailing list