Index: openacs-4/packages/faq/faq.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/faq/faq.info,v
diff -u -r1.24 -r1.25
--- openacs-4/packages/faq/faq.info 10 Oct 2009 22:38:10 -0000 1.24
+++ openacs-4/packages/faq/faq.info 17 Sep 2013 11:25:23 -0000 1.25
@@ -7,7 +7,7 @@
f
f
-
+
Nima Mazloumi
Jennie Kim Housman
Elizabeth Wirth
@@ -18,7 +18,7 @@
2
#faq.FAQs#
-
+
Index: openacs-4/packages/faq/sql/postgresql/upgrade/upgrade-5.2.0d5-5.2.0d6.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/faq/sql/postgresql/upgrade/upgrade-5.2.0d5-5.2.0d6.sql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/faq/sql/postgresql/upgrade/upgrade-5.2.0d5-5.2.0d6.sql 17 Sep 2013 11:25:23 -0000 1.1
@@ -0,0 +1,11 @@
+-- Fixing all those objects (faq and faq_q_and_as) with missing package_id
+
+update acs_objects set package_id = context_id where context_id in
+( select package_id from apm_packages where package_key = 'faq')
+and package_id is null ;
+
+UPDATE acs_objects o1 SET package_id = o2.package_id
+FROM acs_objects o2, faq_q_and_as f
+WHERE f.entry_id = o1.object_id
+AND f.faq_id = o2.object_id
+AND o1.package_id is null