Your message dated Sun, 16 Apr 2006 11:02:16 -0700
with message-id <[EMAIL PROTECTED]>
and subject line Bug#362152: fixed in gallery2 2.1.1-1
has caused the attached Bug report to be marked as done.

This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.

(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere.  Please contact me immediately.)

Debian bug tracking system administrator
(administrator, Debian Bugs database)

--- Begin Message ---
Package: gallery2
Version: 2.1-1

Upgrading the software from gallery v2.0.4 to (debian package) 2.1-1
works fine. However, when you run the gallery upgrade application it fails.

I'm not a developer, so caveat emptor .. but applying the fix I describe
here made things work:

http://gallery.menalto.com/node/47759

================================================================

The following looks to be the required fix - it successfully through the
upgrade.

It looks like a Postgres SQL statement in the template has been
overlooked ... the file that I've updated is:
modules/core/classes/GalleryStorage/schema.tpl

.. and here is the diff:

==========================
--- schema.tpl.ORIG 2006-03-20 16:38:59.000000000 +0000
+++ schema.tpl 2006-04-12 15:33:26.000000000 +0100
@@ -809,7 +809,11 @@
# A_GalleryAccessMap_1.0
DROP INDEX DB_TABLE_PREFIXAccessMap_33666;

-ALTER TABLE DB_TABLE_PREFIXAccessMap ADD COLUMN
DB_COLUMN_PREFIXuserOrGroupId INTEGER DEFAULT '0';
+ALTER TABLE DB_TABLE_PREFIXAccessMap ADD COLUMN
DB_COLUMN_PREFIXuserOrGroupId INTEGER;
+
+UPDATE g2_AccessMap
+ SET g_userOrGroupId='0'
+ WHERE g_userOrGroupId IS NULL;

ALTER TABLE DB_TABLE_PREFIXAccessMap ALTER DB_COLUMN_PREFIXuserOrGroupId
SET NOT NULL;

==========================

Note: When you rerun the upgrade you will get a note in stage-1 saying
this file has been modified.
================================================================

Cheers


Ivan
-- 
Ivan Beveridge <[EMAIL PROTECTED]>


--- End Message ---
--- Begin Message ---
Source: gallery2
Source-Version: 2.1.1-1

We believe that the bug you reported is fixed in the latest version of
gallery2, which is due to be installed in the Debian FTP archive:

gallery2_2.1.1-1.diff.gz
  to pool/main/g/gallery2/gallery2_2.1.1-1.diff.gz
gallery2_2.1.1-1.dsc
  to pool/main/g/gallery2/gallery2_2.1.1-1.dsc
gallery2_2.1.1-1_all.deb
  to pool/main/g/gallery2/gallery2_2.1.1-1_all.deb
gallery2_2.1.1.orig.tar.gz
  to pool/main/g/gallery2/gallery2_2.1.1.orig.tar.gz



A summary of the changes between this version and the previous one is
attached.

Thank you for reporting the bug, which will now be closed.  If you
have further comments please address them to [EMAIL PROTECTED],
and the maintainer will reopen the bug report if appropriate.

Debian distribution maintenance software
pp.
Michael C. Schultheiss <[EMAIL PROTECTED]> (supplier of updated gallery2 
package)

(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing [EMAIL PROTECTED])


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Format: 1.7
Date: Sun, 16 Apr 2006 16:42:35 +0000
Source: gallery2
Binary: gallery2
Architecture: source all
Version: 2.1.1-1
Distribution: unstable
Urgency: low
Maintainer: Michael C. Schultheiss <[EMAIL PROTECTED]>
Changed-By: Michael C. Schultheiss <[EMAIL PROTECTED]>
Description: 
 gallery2   - web-based photo album written in PHP
Closes: 359000 362152 362936
Changes: 
 gallery2 (2.1.1-1) unstable; urgency=low
 .
   * New upstream release (Closes: #362936)
     + Bugfixes for Postgres7 (Closes: #359000, #362152)
Files: 
 de6a9ba67c9c6c218c52aa7828c6d5bd 586 web optional gallery2_2.1.1-1.dsc
 a7567f3d318b755c2f37eb91aa821212 10028354 web optional 
gallery2_2.1.1.orig.tar.gz
 c358970dd82ced0bfc7943678582062d 11366 web optional gallery2_2.1.1-1.diff.gz
 fffd5f5aac8598a6765a904dcb089b2e 10252858 web optional gallery2_2.1.1-1_all.deb

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (GNU/Linux)

iD8DBQFEQng0yJBzD6P54w4RAoXzAJ9RaeT56a1T6Z+mcOsa8CCY1KrXBACfT1Wc
VGPaNOZ01OzHSv0bUOzMB2M=
=Oo/q
-----END PGP SIGNATURE-----


--- End Message ---

Reply via email to