[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