Your message dated Fri, 17 May 2013 11:43:14 +0000 with message-id <[email protected]> and subject line Bug#707941: Removed package(s) from unstable has caused the Debian Bug report #518572, regarding [gallery2] PostgreSQL backend: column "g_userid" is of type integer but expression is of type text 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 this message is talking about, this may indicate a serious mail system misconfiguration somewhere. Please contact [email protected] immediately.) -- 518572: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=518572 Debian Bug Tracking System Contact [email protected] with problems
--- Begin Message ---Package: gallery2 Version: 2.3-1 Severity: normal --- Please enter the report below this line. --- When using Gallery2 with PostgreSQL as a database backend, I get the following error when using "image block" in sidebar theme settings: ------------------------------------- Warning: pg_query_params() [function.pg-query-params]: Query failed: ERROR: column "g_userid" is of type integer but expression is of type text HINT: You will need to rewrite or cast the expression. in /usr/share/php/adodb/drivers/adodb-postgres7.inc.php on line 113 -1: ERROR: column "g_userid" is of type integer but expression is of type text HINT: You will need to rewrite or cast the expression. ADOConnection._Execute( INSERT INTO g2_ImageBlockCacheMap SELECT DISTINCT ?, ?, g2_Entity.g_creationTimestamp, g2_Entity.g_id, FLOOR(RANDOM() *..., Array[45]) % line 1007, file: adodb.inc.php ADOConnection.Execute( INSERT INTO g2_ImageBlockCacheMap SELECT DISTINCT ?, ?, g2_Entity.g_creationTimestamp, g2_Entity.g_id, FLOOR(RANDOM() *..., Array[45]) % line 952, file: GalleryStorageExtras.class GalleryStorageExtras.execute( INSERT INTO [ImageBlockCacheMap] SELECT DISTINCT ?, ?, [GalleryEntity::creationTimestamp], [GalleryEntity::id], FLOOR(R..., Array[45]) % line 507, file: GalleryStorage.class GalleryStorage.execute( INSERT INTO [ImageBlockCacheMap] SELECT DISTINCT ?, ?, [GalleryEntity::creationTimestamp], [GalleryEntity::id], FLOOR(R..., Array[45]) % line 742, file: ImageBlockHelper.class ImageBlockHelper.cacheViewableTree(17) % line 520, file: ImageBlockHelper.class Error performing imageblock.LoadImageBlock callback realpath(/usr/share/gallery2/modules/core/classes/../../../) realpath(/var/www/net/gallery.windfluechter.net/) Error (ERROR_STORAGE_FAILURE) * in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 959 (GalleryCoreApi::error) * in modules/core/classes/GalleryStorage.class at line 507 (GalleryStorageExtras::execute) * in modules/imageblock/classes/ImageBlockHelper.class at line 742 (GalleryStorage::execute) * in modules/imageblock/classes/ImageBlockHelper.class at line 520 (ImageBlockHelper::cacheViewableTree) * in modules/imageblock/classes/ImageBlockHelper.class at line 283 (ImageBlockHelper::fetchViewableData) * in modules/imageblock/classes/ImageBlockHelper.class at line 93 (ImageBlockHelper::_getBlockData) * in modules/imageblock/Callbacks.inc at line 83 (ImageBlockHelper::loadImageBlocks) * in modules/core/classes/GalleryTemplateAdapter.class at line 1052 (ImageBlockCallbacks::callback) * in g2data/smarty/templates_c/%%626616196/matrix/%%A3^A3E^A3E218EA%%ImageBlock.tpl.php at line 5 (GalleryTemplateAdapter::callback) * in /usr/share/php/smarty/libs/Smarty.class.php at line 1868 * in modules/core/classes/GalleryTemplateAdapter.class at line 983 (Smarty::_smarty_include) * in g2data/smarty/templates_c/%%626616196/matrix/%%B4^B49^B49848CB%%sidebar.tpl.php at line 7 (GalleryTemplateAdapter::block) * in /usr/share/php/smarty/libs/Smarty.class.php at line 1868 * in modules/core/classes/GalleryTemplateAdapter.class at line 909 (Smarty::_smarty_include) * in g2data/smarty/templates_c/%%626616196/matrix/%%AD^AD7^AD74CEE9%%photo.tpl.php at line 12 (GalleryTemplateAdapter::theme) * in /usr/share/php/smarty/libs/Smarty.class.php at line 1868 * in modules/core/classes/GalleryTemplateAdapter.class at line 909 (Smarty::_smarty_include) * in g2data/smarty/templates_c/%%626616196/matrix/%%3A^3A8^3A818B59%%theme.tpl.php at line 55 (GalleryTemplateAdapter::theme) * in /usr/share/php/smarty/libs/Smarty.class.php at line 1262 * in modules/core/classes/GallerySmarty.class at line 61 (Smarty::fetch) * in modules/core/classes/GalleryTemplate.class at line 219 (GallerySmarty::fetch) * in main.php at line 521 (GalleryTemplate::fetch) * in main.php at line 104 * in main.php at line 88 * in main.php at line 3 file_exists(/var/www/net/gallery.windfluechter.net/g2data/cache/module/_all/0/0/GalleryPluginHelper_fetchPluginStatus.inc) getParameter smarty.compile_check for core plugin file_exists(/var/www/net/gallery.windfluechter.net/g2data/cache/module/core/0/0/0.inc) file_exists(/var/www/net/gallery.windfluechter.net/g2data/smarty/templates_c/%%626616196/matrix/%%C7^C79^C79EEB7F%%ItemInfo.tpl.php) strftime(%x, 1231148074) file_exists(/var/www/net/gallery.windfluechter.net/g2data/smarty/templates_c/%%626616196/matrix/%%F3^F3E^F3EB483E%%PhotoSizes.tpl.php) file_exists(/var/www/net/gallery.windfluechter.net/g2data/cache/entity/2/1/21143.inc) file_exists(/var/www/net/gallery.windfluechter.net/g2data/cache/entity/2/1/21080.inc) file_exists(/var/www/net/gallery.windfluechter.net/g2data/cache/entity/1/9/19996.inc) file_exists(/var/www/net/gallery.windfluechter.net/g2data/cache/entity/4/4/4457.inc) file_exists(/var/www/net/gallery.windfluechter.net/g2data/cache/entity/0/0/7.inc) file_exists(/var/www/net/gallery.windfluechter.net/g2data/smarty/templates_c/%%626616196/matrix/%%5A^5A3^5A33504B%%Navigator.tpl.php) file_exists(/var/www/net/gallery.windfluechter.net/g2data/cache/entity/2/1/21148.inc) file_exists(/var/www/net/gallery.windfluechter.net/g2data/cache/entity/2/1/21588.inc) file_exists(/var/www/net/gallery.windfluechter.net/g2data/cache/entity/2/1/21127.inc) file_exists(/var/www/net/gallery.windfluechter.net/g2data/cache/entity/2/1/21138.inc) file_exists(/var/www/net/gallery.windfluechter.net/g2data/cache/entity/2/5/25248.inc) file_exists(/var/www/net/gallery.windfluechter.net/g2data/smarty/templates_c/%%626616196/matrix/%%F6^F68^F68636C4%%ExifInfo.tpl.php) postgres7 error: [-1: ERROR: current transaction is aborted, commands ignored until end of transaction block] in EXECUTE(" SELECT g2_Group.g_id, g2_Group.g_groupName FROM g2_UserGroupMap, g2_Group WHERE g2_Group.g_id = g2_UserGroupMap.g_groupId AND g2_UserGroupMap.g_userId = ? ORDER BY g2_Group.g_groupName ") ------------------------------------- This aborted transaction also causes the exif block not being displayed. When I remove "image block" from theme settings, exif works like a charme. Maybe this also has impact on other packages such as serendipity. There's a s9y plugin to integrate the random image block into the s9y sidebar. I discovered the above error while trying to get that s9y plugin working, but the server always gave me a error 500. Regards, Ingo --- System information. --- Architecture: i386 Kernel: Linux 2.6.26-1-xen-686 Debian Release: squeeze/sid 500 unstable ftp.de.debian.org --- Package information. --- Depends (Version) | Installed =======================-+-=========== | -- Ciao... // Fon: 0381-2744150 Ingo \X/ http://blog.windfluechter.net gpg pubkey: http://www.juergensmann.de/ij_public_key.asc
--- End Message ---
--- Begin Message ---Version: 2.3.2.dfsg-1+rm Dear submitter, as the package gallery2 has just been removed from the Debian archive unstable we hereby close the associated bug reports. We are sorry that we couldn't deal with your issue properly. For details on the removal, please see http://bugs.debian.org/707941 The version of this package that was in Debian prior to this removal can still be found using http://snapshot.debian.org/. This message was generated automatically; if you believe that there is a problem with it please contact the archive administrators by mailing [email protected]. Debian distribution maintenance software pp. Luca Falavigna (the ftpmaster behind the curtain)
--- End Message ---
