Index: openacs-4/contrib/obsolete-packages/bboard/sql/postgresql/bboard-views.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/bboard/sql/postgresql/bboard-views.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/obsolete-packages/bboard/sql/postgresql/bboard-views.sql	29 Jun 2001 20:31:14 -0000	1.1
+++ openacs-4/contrib/obsolete-packages/bboard/sql/postgresql/bboard-views.sql	19 Nov 2001 19:34:23 -0000	1.2
@@ -25,15 +25,19 @@
 
 create view bboard_messages_by_category as
     select msg.*, cat.category_id
-        from bboard_messages_all msg, bboard_category_message_map cat
-        where msg.message_id = cat.message_id
-    UNION
-    select msg.*, NULL as category_id
-        from bboard_messages_all msg
-        where 0 = (select count(1) from bboard_category_message_map cat
-                   where msg.message_id = cat.message_id);
+    from bboard_messages_all msg left join bboard_category_message_map cat on (msg.message_id = cat.message_id);
 
+-- create view bboard_messages_by_category as
+--     select msg.*, cat.category_id
+--         from bboard_messages_all msg, bboard_category_message_map cat
+--         where msg.message_id = cat.message_id
+--     UNION
+--     select msg.*, NULL as category_id
+--         from bboard_messages_all msg
+--         where 0 = (select count(1) from bboard_category_message_map cat
+--                    where msg.message_id = cat.message_id);
 
+
 -- create or replace view bboard_messages_all as
 --     select m.message_id, m.reply_to, m.sent_date, m.sender,
 --            m.title, m.mime_type, m.content, f.forum_id, f.status,
Index: openacs-4/packages/acs-admin/www/apm/packages-install.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/apm/packages-install.tcl,v
diff -u -r1.7 -r1.8
--- openacs-4/packages/acs-admin/www/apm/packages-install.tcl	17 Nov 2001 11:17:56 -0000	1.7
+++ openacs-4/packages/acs-admin/www/apm/packages-install.tcl	19 Nov 2001 19:34:23 -0000	1.8
@@ -80,15 +80,17 @@
 function uncheckAll() {
     for (var i = 0; i < [expr [llength $spec_files] * 2]; ++i)
         document.forms\[0\].elements\[i\].checked = false;
+    this.href='';
 }
 function checkAll() {
     for (var i = 0; i < [expr [llength $spec_files] * 2]; ++i)
         document.forms\[0\].elements\[i\].checked = true;
+    this.href='';
 }
 </script>
-<input type=\"submit\" name=\"null\" value=\"Check all Boxes\" onclick=\"javascript:checkAll()\">
-<input type=\"submit\" name=\"null\" value=\"Uncheck all Boxes\" onclick=\"javascript:uncheckAll()\">
-    "
+<a href=\"packages-install?checked_by_default_p=0&[export_url_vars install_path]\" onclick=\"javascript:uncheckAll();return false\"><b>uncheck all boxes</b></a> |
+<a href=\"packages-install?checked_by_default_p=1&[export_url_vars install_path]\"  onclick=\"javascript:checkAll(); return false\"><b>check all boxes</b></a>
+"
 
     ns_write "<form action=packages-install-2 method=post>"
 
Index: openacs-4/packages/skin/skin.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/skin/skin.info,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/skin/skin.info	11 Aug 2001 17:46:30 -0000	1.3
+++ openacs-4/packages/skin/skin.info	19 Nov 2001 19:34:23 -0000	1.4
@@ -9,7 +9,8 @@
 
     <version name="0.1d" url="http://www.arsdigita.com/acs-repository/download/apm/skin-0.1d.apm">
         <database-support>
-             <database>oracle-8.1.6</database>
+             <database>oracle</database>
+             <database>postgresql</database>
         </database-support>
         <owner url="mailto:christian@arsdigita.com">Christian Brechbuhler</owner>
         <summary>Demonstration of skins or cobranding.</summary>
Index: openacs-4/packages/wp-slim/www/attach.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/wp-slim/www/attach.tcl,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/wp-slim/www/attach.tcl	15 Nov 2001 01:47:13 -0000	1.4
+++ openacs-4/packages/wp-slim/www/attach.tcl	19 Nov 2001 19:34:23 -0000	1.5
@@ -57,8 +57,18 @@
         set revision_id [cr_import_content -image_type cr_wp_image_attachment -other_type cr_wp_file_attachment \
                                            $slide_item_id $tmp_filename $tmp_size $mime_type $client_filename]
     }
-    cr_set_imported_content_live -image_sql [db_map image_data] -other_sql [db_map file_data] \
-                                 $mime_type $revision_id
+    cr_set_imported_content_live -image_sql [db_map image_data] -other_sql [db_map file_data] $mime_type $revision_id
+} on_error {
+    # most likely a duplicate name, double click, or non-image file uploaded as an inline image.
+
+    ad_return_complaint 1 "There was an error trying to add your content.  Most likely causes you've
+<ul><li>Tried to upload a non-image file when you've select the \"display image in-line\" option.
+<li>Tried to add multiple copies of the same attachment to the slide
+<li>Double-clicking the \"Add\" button on the previous page.
+</ul><p>Here is the actual error message:<blockquote><pre>$errmsg</pre></blockquote>"
+
+    return
 }
 
+
 ad_returnredirect edit-slide?[export_url_vars slide_item_id pres_item_id]