WindfluechterNet Blog

Yesterday I asked for help because I was missing exif information in my Gallery2 installation. Today I found the reason for this, when I was trying get a random image block displayed in my blog, which fails as well.
There seems a bug in /usr/share/php/adodb/drivers/adodb-postgres7.inc.php:

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 “)

So, when there’s the image block activated in theme setting, some queries like the above are failing and neither the image block nor the exif data block is displayed. The temporary solution is therefor to remove the image block from your theme or deactivate/uninstall the plugin at all. The long term solution will be to wait for an updated gallery2 after I’ve reported this bug to the BTS… 😉

UPDATE: #518572