Package: gallery2 Severity: important
Hi, I've just upgraded a box, and the revision on postgresql which hosts the database has changed to 8.2.7. This has stopped gallery functioning, as some behaviour has changed with respect to queries. Gallery issues a query : "SELECT count(g2_mapMap.g_itemId) FROM g2_mapMap WHERE g2_mapMap.g_itemId IN (25,29,34)" which returns an error from the database : "ERROR: IN types character varying and integer cannot be matched". Apparently, this can be fixed by casting the query explicitly, i.e. "SELECT count(g2_mapMap.g_itemId) FROM g2_mapMap WHERE g2_mapMap.g_itemId::INT IN (25,29,34)" which returns 0 on this installation. I'll try manually patching this, but is this perhaps something that's fixed upstream? Many Thanks, Eamonn -- System Information: Debian Release: lenny/sid APT prefers unstable APT policy: (500, 'unstable'), (500, 'testing'), (500, 'stable') Architecture: i386 (i686) Kernel: Linux 2.6.22-3-686 (SMP w/2 CPU cores) Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/bash -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
