Index: openacs-4/packages/contacts/sql/postgresql/contacts-messages-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/contacts/sql/postgresql/contacts-messages-create.sql,v diff -u -r1.7 -r1.8 --- openacs-4/packages/contacts/sql/postgresql/contacts-messages-create.sql 3 Jan 2006 22:14:55 -0000 1.7 +++ openacs-4/packages/contacts/sql/postgresql/contacts-messages-create.sql 29 Jan 2006 16:11:29 -0000 1.8 @@ -34,7 +34,7 @@ -- Banner contains the path to an image which can be inserted into the open office mailing document banner varchar(500), -- PS is the post scriptum, which is commonly used in mailings. - ps varchar(500), + ps varchar(500) ); create view contact_messages as @@ -43,7 +43,7 @@ cmi.message_type, cmi.locale, cmi.banner, - cmi.ps + cmi.ps, cr.title, cr.description, cr.content, Index: openacs-4/packages/contacts/sql/postgresql/contacts-package-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/contacts/sql/postgresql/contacts-package-create.sql,v diff -u -r1.5 -r1.6 --- openacs-4/packages/contacts/sql/postgresql/contacts-package-create.sql 4 Oct 2005 02:58:37 -0000 1.5 +++ openacs-4/packages/contacts/sql/postgresql/contacts-package-create.sql 29 Jan 2006 16:11:29 -0000 1.6 @@ -107,15 +107,15 @@ v_folder_id := cf.folder_id from cr_items ci, cr_folders cf where ci.item_id = cf.folder_id - and ci.parent_id = ''0'' + and ci.parent_id = ''-4'' and ci.name = ''contacts''; if v_folder_id is null then v_folder_id := content_folder__new ( ''contacts'', ''Contacts'', NULL, - ''0'' + ''-4'' ); end if; Index: openacs-4/packages/contacts/www/message-ae.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/contacts/www/message-ae.tcl,v diff -u -r1.5 -r1.6 --- openacs-4/packages/contacts/www/message-ae.tcl 3 Jan 2006 22:14:55 -0000 1.5 +++ openacs-4/packages/contacts/www/message-ae.tcl 29 Jan 2006 16:11:29 -0000 1.6 @@ -123,6 +123,13 @@ set content_format "text/plain" } + if {![exists_and_not_null banner]} { + set banner "" + } + if {![exists_and_not_null ps]} { + set ps "" + } + contact::message::save \ -item_id $item_id \ -owner_id $owner_id \