Re: Projects in Webui

On Wed, 2009-06-10 at 14:24 -0400, Adam Tauno Williams wrote:
> On Wed, 2009-06-10 at 18:16 +0200, Christian Naumer wrote:
> > Another one here! I can't delete any appointments...
> > Here the log:
> > Jun 10 16:15:38 ogo-webui-5.5 [6921]: PG0x0xa8ad0c4 SQL: DELETE FROM
> > date_info WHERE date_id=1462581
> > Jun 10 16:15:38 ogo-webui-5.5 [6921]: PG0x0xa8ad0c4 SQL: SELECT
> > t1.abstract, t1.company_id, t1.creation_date, t1.current_owner_id,
> > t1.date_id, t1.db_status, t1.document_id, t1.file_type,
> > t1.first_owner_id, t1.is_folder, t1.is_note, t1.lastmodified_date,
> > t1.object_version, t1.parent_document_id, t1.project_id, t1.status,
> > t1.title, t1.version_count FROM  note t1 WHERE t1.date_id=1462581
> > Jun 10 16:15:38 ogo-webui-5.5 [6921]: PG0x0xa8ad0c4 SQL: ROLLBACK
> > TRANSACTION
> > Jun 10 16:15:38 ogo-webui-5.5 [6921]: (1B091B09014A2FDBBF) command
> > appointment::delete({
> >     deleteAllCyclic = 0;
> 
> Ok, on the source tree that gets tarball'd and shipped to the build
> service I must have dorked something.  I'll check it out - watch for a
> new build. Sorry.

Ah! Doh!  You're missing some v5.5 schema changes.

-- object_id & auth_id in ACLs should be an INT
-- may already be fixed in some databases for PG8.3 compat
ALTER TABLE object_acl 
  ALTER COLUMN object_id TYPE INT USING object_id::int;
ALTER TABLE object_acl 
  ALTER COLUMN auth_id   TYPE INT USING auth_id::int;
-- field to connect documents and notes to contacts
ALTER TABLE document ADD COLUMN company_id INT NULL;

See if that fixes your issue.

-- 
OpenGroupware.org Users
[email protected]
http://mail.opengroupware.org/mailman/listinfo/users