<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Hi Jeff, <br>
<br>
I don't have an answer to your question, but if you aren't getting
any answers here, you might want to try your question on the
open-ils-dev list since it seems to be a bit more active than this
list.<br>
<br>
Cheers!<br>
Kathy<br>
<br>
<pre class="moz-signature" cols="72">Kathy Lussier
Project Coordinator
Massachusetts Library Network Cooperative
(508) 343-0128
<a class="moz-txt-link-abbreviated" href="mailto:klussier@masslnc.org">klussier@masslnc.org</a>
Twitter: <a class="moz-txt-link-freetext" href="http://www.twitter.com/kmlussier">http://www.twitter.com/kmlussier</a>
</pre>
On 4/7/2014 11:40 PM, Jeff Green wrote:<br>
</div>
<blockquote
cite="mid:CAMNpBqq1kNqGJz0ZEOzvA6J0OQvKZCuzMFsi7b-ybnG0zB_nQQ@mail.gmail.com"
type="cite">
<div dir="ltr">Bumping this to see if anyone can help...</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Mon, Mar 31, 2014 at 9:00 AM, <span
dir="ltr"><<a moz-do-not-send="true"
href="mailto:evergreen-admin-request@list.evergreen-ils.org"
target="_blank">evergreen-admin-request@list.evergreen-ils.org</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">Send
Evergreen-admin mailing list submissions to<br>
<a moz-do-not-send="true"
href="mailto:evergreen-admin@list.evergreen-ils.org">evergreen-admin@list.evergreen-ils.org</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a moz-do-not-send="true"
href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-admin"
target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-admin</a><br>
<br>
or, via email, send a message with subject or body 'help' to<br>
<a moz-do-not-send="true"
href="mailto:evergreen-admin-request@list.evergreen-ils.org">evergreen-admin-request@list.evergreen-ils.org</a><br>
<br>
You can reach the person managing the list at<br>
<a moz-do-not-send="true"
href="mailto:evergreen-admin-owner@list.evergreen-ils.org">evergreen-admin-owner@list.evergreen-ils.org</a><br>
<br>
When replying, please edit your Subject line so it is more
specific<br>
than "Re: Contents of Evergreen-admin digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. Upgrade 2.2.0 to latest... Database error on
2.3-2.4.0 script<br>
(Jeff Green)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Sun, 30 Mar 2014 09:42:56 -0700<br>
From: Jeff Green <<a moz-do-not-send="true"
href="mailto:jeff.green.ca@gmail.com">jeff.green.ca@gmail.com</a>><br>
To: "<<a moz-do-not-send="true"
href="mailto:evergreen-admin@list.evergreen-ils.org">evergreen-admin@list.evergreen-ils.org</a>>"<br>
<<a moz-do-not-send="true"
href="mailto:evergreen-admin@list.evergreen-ils.org">evergreen-admin@list.evergreen-ils.org</a>><br>
Subject: [Evergreen-admin] Upgrade 2.2.0 to latest...
Database error<br>
on 2.3-2.4.0 script<br>
Message-ID:<br>
<<a moz-do-not-send="true"
href="mailto:CAMNpBqo%2BwfWJdXZbFXMd%2B%2B094jOhTUU_fqDbdEjMMd_mj-qzOg@mail.gmail.com">CAMNpBqo+wfWJdXZbFXMd++094jOhTUU_fqDbdEjMMd_mj-qzOg@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Hi. I'm running into an issue upgrading EG 2.2.0 to the
latest, and could<br>
use some help on what to try next. The upgrade crashes
during the 2.3-2.4.0<br>
script, on the DROP EXTENSION tsearch2 command.<br>
<br>
There was an IRC chat (<br>
<a moz-do-not-send="true"
href="http://evergreen-ils.org/irc_logs/evergreen/2013-06/%23evergreen.27-Thu-2013.log"
target="_blank">http://evergreen-ils.org/irc_logs/evergreen/2013-06/%23evergreen.27-Thu-2013.log</a>)<br>
about adding a couple statements. However, still got the
same error.<br>
<br>
I also tried DROP...CASCADE; but that created other errors
later.<br>
<br>
So, I rolled back to my previous snapshot (VM) and am asking
for some<br>
advice on how to proceed! Any suggestions on what to do
next?<br>
<br>
Here's the error:<br>
2014-02-28 13:48:30 PST ERROR: cannot drop extension
tsearch2 because other<br>
objects depend on it<br>
<br>
Here's the statements I added immediately before the DROP
EXTENSION<br>
tsearch2:<br>
DROP AGGREGATE agg_tsvector(tsvector);<br>
DROP FUNCTION tsvector_concat(tsvector, tsvector);<br>
<br>
Script is also throwing these errors:<br>
<br>
psql:2.3-2.4.0-upgrade-db.sql:3996: ERROR: text search
configuration<br>
"english_nostop" does not exist<br>
psql:2.3-2.4.0-upgrade-db.sql:3997: ERROR: text search
configuration<br>
"english_nostop" does not exist<br>
psql:2.3-2.4.0-upgrade-db.sql:3998: ERROR: text search
configuration<br>
"english_nostop" does not exist<br>
psql:2.3-2.4.0-upgrade-db.sql:3999: ERROR: text search
configuration<br>
"english_nostop" does not exist<br>
psql:2.3-2.4.0-upgrade-db.sql:4000: ERROR: text search
configuration<br>
"english_nostop" does not exist<br>
<br>
<br>
Thanks!<br>
<br>
--<br>
Jeff Green<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a moz-do-not-send="true"
href="http://list.evergreen-ils.org/pipermail/evergreen-admin/attachments/20140330/55548f7b/attachment-0001.html"
target="_blank">http://list.evergreen-ils.org/pipermail/evergreen-admin/attachments/20140330/55548f7b/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
_______________________________________________<br>
Evergreen-admin mailing list<br>
<a moz-do-not-send="true"
href="mailto:Evergreen-admin@list.evergreen-ils.org">Evergreen-admin@list.evergreen-ils.org</a><br>
<a moz-do-not-send="true"
href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-admin"
target="_blank">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-admin</a><br>
<br>
<br>
End of Evergreen-admin Digest, Vol 15, Issue 2<br>
**********************************************<br>
</blockquote>
</div>
<br>
<br clear="all">
<div><br>
</div>
-- <br>
Jeff Green<br>
<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Evergreen-admin mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Evergreen-admin@list.evergreen-ils.org">Evergreen-admin@list.evergreen-ils.org</a>
<a class="moz-txt-link-freetext" href="http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-admin">http://list.evergreen-ils.org/cgi-bin/mailman/listinfo/evergreen-admin</a>
</pre>
</blockquote>
<br>
</body>
</html>