Mailing List Archive

Begin forwarded message:

> From: David Wheeler <wheeler@users.sourceforge.net>
> Date: Tue Sep 3, 2002 7:06:24 PM US/Pacific
> To: bricolage-commits@lists.sourceforge.net
> Subject: [Bricolage-Commits] First bug fix that will go into 1.4.1.
>
> Log Message:
> -----------
> First bug fix that will go into 1.4.1. It seems that the category.pl
> 1.3.3
> upgrade script was attempting to create an index that already existed
> -- and
> that was going to be dropped by grp_new_category.pl, anyway. So I
> commented
> that out.

Note to those who are upgrading: If you need this fix, just apply this
patch to inst/upgrade/1.3.3/category.pl:

diff -u -w -d -r1.3 -r1.3.2.1
--- category.pl 17 Jul 2002 10:59:47 -0000 1.3
+++ category.pl 4 Sep 2002 02:06:22 -0000 1.3.2.1
@@ -15,7 +15,7 @@
q{ CREATE UNIQUE INDEX udx_category__uri ON category(uri) },
q{ CREATE INDEX idx_category__lower_uri ON category(LOWER(uri))
},
q{ CREATE INDEX idx_category__parent_id ON category(parent_id)
},
- q{ CREATE INDEX fkx_subcat_grp__category ON
category(category_grp_id) },
+# q{ CREATE INDEX fkx_subcat_grp__category ON
category(category_grp_id) },
);

Yep, that's it -- just comment out the one line.

Sorry for the hassle.

David

--
David Wheeler AIM: dwTheory
david@wheeler.net ICQ: 15726394
http://david.wheeler.net/ Yahoo!: dew7e
Jabber: Theory@jabber.org



-------------------------------------------------------
This sf.net email is sponsored by: OSDN - Tired of that same old
cell phone? Get a new here for FREE!
https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390
_______________________________________________
Bricolage-General mailing list
Bricolage-General@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bricolage-general