Package: gallery2 Version: 2.1-1 Severity: important Upgrade from gallery 2.0.x fails on step 3 with the following output: (this might be a problem already reported to upstream: http://gallery.menalto.com/node/46044 )
Stack Trace: Error (ERROR_STORAGE_FAILURE) : Error trying to run query: ALTER TABLE g2_AccessMap ADD COLUMN g_userOrGroupId INTEGER DEFAULT '0' * in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 1528 (GalleryCoreApi::error) * in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 1304 (GalleryStorageExtras::_executeSql) * in modules/core/classes/GalleryStorage.class at line 625 (GalleryStorageExtras::configureStore) * in modules/core/classes/GalleryStorage/PostgreSqlStorage.class at line 144 (GalleryStorage::configureStore) * in modules/core/CoreModuleExtras.inc at line 1366 (PostgreSqlStorage::configureStore) * in modules/core/module.inc at line 487 (CoreModuleExtras::upgrade) * in modules/core/classes/GalleryModule.class at line 157 (CoreModule::upgrade) * in upgrade/steps/UpgradeCoreModuleStep.class at line 83 (GalleryModule::installOrUpgrade) * in upgrade/index.php at line 221 (UpgradeCoreModuleStep::processRequest) Debug Output: file_exists(/usr/share/gallery2/modules/core/classes/helpers/../../../../config.php) file_exists(/usr/share/gallery2/modules/core/classes/helpers/../../../../plugins/index.modules) [1143316018] can't guarantee 300 -- extending! (postgres7): set datestyle='ISO' (postgres7): select version() (postgres7): select tablename,'T' from pg_tables where tablename not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') union select viewname,'V' from pg_views where viewname not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') file_exists(/usr/local/var/g2data/versions.dat) file(/usr/local/var/g2data/versions.dat, ) is_writeable(/usr/share/gallery2/config.php) getParameter id.adminGroup for core plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'core' AND g2_PluginParameterMap.g_itemId = 0 (postgres7): SELECT g2_UserGroupMap.g_userId, g2_User.g_userName FROM g2_UserGroupMap, g2_User WHERE g2_UserGroupMap.g_groupId = 3 AND g2_UserGroupMap.g_userId = g2_User.g_id ORDER BY g2_User.g_userName LIMIT 1 (postgres7): SELECT g_id, g_entityType FROM g2_Entity WHERE g_id IN (6) (postgres7): SELECT g2_PluginMap.g_pluginId, g2_PluginMap.g_active FROM g2_PluginMap WHERE g2_PluginMap.g_pluginType = 'module' opendir(/usr/share/gallery2/modules/) readdir(Resource id #57) readdir(Resource id #57) readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/archiveupload) file_exists(/usr/share/gallery2/modules/archiveupload/module.inc) getParameter _version for archiveupload plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'archiveupload' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for archiveupload plugin getParameter _requiredCoreApi for archiveupload plugin getParameter _requiredModuleApi for archiveupload plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/albumselect) file_exists(/usr/share/gallery2/modules/albumselect/module.inc) getParameter _version for albumselect plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'albumselect' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for albumselect plugin getParameter _requiredCoreApi for albumselect plugin getParameter _requiredModuleApi for albumselect plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/colorpack) file_exists(/usr/share/gallery2/modules/colorpack/module.inc) getParameter _version for colorpack plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'colorpack' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for colorpack plugin getParameter _requiredCoreApi for colorpack plugin getParameter _requiredModuleApi for colorpack plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/captcha) file_exists(/usr/share/gallery2/modules/captcha/module.inc) getParameter _version for captcha plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'captcha' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for captcha plugin getParameter _requiredCoreApi for captcha plugin getParameter _requiredModuleApi for captcha plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/cart) file_exists(/usr/share/gallery2/modules/cart/module.inc) getParameter _version for cart plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'cart' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for cart plugin getParameter _requiredCoreApi for cart plugin getParameter _requiredModuleApi for cart plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/customfield) file_exists(/usr/share/gallery2/modules/customfield/module.inc) getParameter _version for customfield plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'customfield' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for customfield plugin getParameter _requiredCoreApi for customfield plugin getParameter _requiredModuleApi for customfield plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/comment) file_exists(/usr/share/gallery2/modules/comment/module.inc) getParameter _version for comment plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'comment' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for comment plugin getParameter _requiredCoreApi for comment plugin getParameter _requiredModuleApi for comment plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/core) file_exists(/usr/share/gallery2/modules/core/module.inc) getParameter _version for core plugin getParameter _callbacks for core plugin getParameter _requiredCoreApi for core plugin getParameter _requiredModuleApi for core plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/imageblock) file_exists(/usr/share/gallery2/modules/imageblock/module.inc) getParameter _version for imageblock plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'imageblock' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for imageblock plugin getParameter _requiredCoreApi for imageblock plugin getParameter _requiredModuleApi for imageblock plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/dcraw) file_exists(/usr/share/gallery2/modules/dcraw/module.inc) getParameter _version for dcraw plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'dcraw' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for dcraw plugin getParameter _requiredCoreApi for dcraw plugin getParameter _requiredModuleApi for dcraw plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/debug) file_exists(/usr/share/gallery2/modules/debug/module.inc) getParameter _version for debug plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'debug' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for debug plugin getParameter _requiredCoreApi for debug plugin getParameter _requiredModuleApi for debug plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/exif) file_exists(/usr/share/gallery2/modules/exif/module.inc) getParameter _version for exif plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'exif' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for exif plugin getParameter _requiredCoreApi for exif plugin getParameter _requiredModuleApi for exif plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/ffmpeg) file_exists(/usr/share/gallery2/modules/ffmpeg/module.inc) getParameter _version for ffmpeg plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'ffmpeg' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for ffmpeg plugin getParameter _requiredCoreApi for ffmpeg plugin getParameter _requiredModuleApi for ffmpeg plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/gd) file_exists(/usr/share/gallery2/modules/gd/module.inc) getParameter _version for gd plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'gd' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for gd plugin getParameter _requiredCoreApi for gd plugin getParameter _requiredModuleApi for gd plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/icons) file_exists(/usr/share/gallery2/modules/icons/module.inc) getParameter _version for icons plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'icons' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for icons plugin getParameter _requiredCoreApi for icons plugin getParameter _requiredModuleApi for icons plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/randomhighlight) file_exists(/usr/share/gallery2/modules/randomhighlight/module.inc) getParameter _version for randomhighlight plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'randomhighlight' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for randomhighlight plugin getParameter _requiredCoreApi for randomhighlight plugin getParameter _requiredModuleApi for randomhighlight plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/imageframe) file_exists(/usr/share/gallery2/modules/imageframe/module.inc) getParameter _version for imageframe plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'imageframe' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for imageframe plugin getParameter _requiredCoreApi for imageframe plugin getParameter _requiredModuleApi for imageframe plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/imagemagick) file_exists(/usr/share/gallery2/modules/imagemagick/module.inc) getParameter _version for imagemagick plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'imagemagick' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for imagemagick plugin getParameter _requiredCoreApi for imagemagick plugin getParameter _requiredModuleApi for imagemagick plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/members) file_exists(/usr/share/gallery2/modules/members/module.inc) getParameter _version for members plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'members' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for members plugin getParameter _requiredCoreApi for members plugin getParameter _requiredModuleApi for members plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/migrate) file_exists(/usr/share/gallery2/modules/migrate/module.inc) getParameter _version for migrate plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'migrate' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for migrate plugin getParameter _requiredCoreApi for migrate plugin getParameter _requiredModuleApi for migrate plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/mime) file_exists(/usr/share/gallery2/modules/mime/module.inc) getParameter _version for mime plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'mime' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for mime plugin getParameter _requiredCoreApi for mime plugin getParameter _requiredModuleApi for mime plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/multilang) file_exists(/usr/share/gallery2/modules/multilang/module.inc) getParameter _version for multilang plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'multilang' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for multilang plugin getParameter _requiredCoreApi for multilang plugin getParameter _requiredModuleApi for multilang plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/netpbm) file_exists(/usr/share/gallery2/modules/netpbm/module.inc) getParameter _version for netpbm plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'netpbm' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for netpbm plugin getParameter _requiredCoreApi for netpbm plugin getParameter _requiredModuleApi for netpbm plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/newitems) file_exists(/usr/share/gallery2/modules/newitems/module.inc) getParameter _version for newitems plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'newitems' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for newitems plugin getParameter _requiredCoreApi for newitems plugin getParameter _requiredModuleApi for newitems plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/nokiaupload) file_exists(/usr/share/gallery2/modules/nokiaupload/module.inc) getParameter _version for nokiaupload plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'nokiaupload' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for nokiaupload plugin getParameter _requiredCoreApi for nokiaupload plugin getParameter _requiredModuleApi for nokiaupload plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/panorama) file_exists(/usr/share/gallery2/modules/panorama/module.inc) getParameter _version for panorama plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'panorama' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for panorama plugin getParameter _requiredCoreApi for panorama plugin getParameter _requiredModuleApi for panorama plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/photoaccess) file_exists(/usr/share/gallery2/modules/photoaccess/module.inc) getParameter _version for photoaccess plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'photoaccess' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for photoaccess plugin getParameter _requiredCoreApi for photoaccess plugin getParameter _requiredModuleApi for photoaccess plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/publishxp) file_exists(/usr/share/gallery2/modules/publishxp/module.inc) getParameter _version for publishxp plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'publishxp' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for publishxp plugin getParameter _requiredCoreApi for publishxp plugin getParameter _requiredModuleApi for publishxp plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/quotas) file_exists(/usr/share/gallery2/modules/quotas/module.inc) getParameter _version for quotas plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'quotas' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for quotas plugin getParameter _requiredCoreApi for quotas plugin getParameter _requiredModuleApi for quotas plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/slideshowapplet) file_exists(/usr/share/gallery2/modules/slideshowapplet/module.inc) getParameter _version for slideshowapplet plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'slideshowapplet' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for slideshowapplet plugin getParameter _requiredCoreApi for slideshowapplet plugin getParameter _requiredModuleApi for slideshowapplet plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/rearrange) file_exists(/usr/share/gallery2/modules/rearrange/module.inc) getParameter _version for rearrange plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'rearrange' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for rearrange plugin getParameter _requiredCoreApi for rearrange plugin getParameter _requiredModuleApi for rearrange plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/register) file_exists(/usr/share/gallery2/modules/register/module.inc) getParameter _version for register plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'register' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for register plugin getParameter _requiredCoreApi for register plugin getParameter _requiredModuleApi for register plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/remote) file_exists(/usr/share/gallery2/modules/remote/module.inc) getParameter _version for remote plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'remote' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for remote plugin getParameter _requiredCoreApi for remote plugin getParameter _requiredModuleApi for remote plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/rewrite) file_exists(/usr/share/gallery2/modules/rewrite/module.inc) getParameter _version for rewrite plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'rewrite' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for rewrite plugin getParameter _requiredCoreApi for rewrite plugin getParameter _requiredModuleApi for rewrite plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/search) file_exists(/usr/share/gallery2/modules/search/module.inc) getParameter _version for search plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'search' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for search plugin getParameter _requiredCoreApi for search plugin getParameter _requiredModuleApi for search plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/shutterfly) file_exists(/usr/share/gallery2/modules/shutterfly/module.inc) getParameter _version for shutterfly plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'shutterfly' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for shutterfly plugin getParameter _requiredCoreApi for shutterfly plugin getParameter _requiredModuleApi for shutterfly plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/sizelimit) file_exists(/usr/share/gallery2/modules/sizelimit/module.inc) getParameter _version for sizelimit plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'sizelimit' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for sizelimit plugin getParameter _requiredCoreApi for sizelimit plugin getParameter _requiredModuleApi for sizelimit plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/slideshow) file_exists(/usr/share/gallery2/modules/slideshow/module.inc) getParameter _version for slideshow plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'slideshow' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for slideshow plugin getParameter _requiredCoreApi for slideshow plugin getParameter _requiredModuleApi for slideshow plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/uploadapplet) file_exists(/usr/share/gallery2/modules/uploadapplet/module.inc) getParameter _version for uploadapplet plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'uploadapplet' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for uploadapplet plugin getParameter _requiredCoreApi for uploadapplet plugin getParameter _requiredModuleApi for uploadapplet plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/squarethumb) file_exists(/usr/share/gallery2/modules/squarethumb/module.inc) getParameter _version for squarethumb plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'squarethumb' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for squarethumb plugin getParameter _requiredCoreApi for squarethumb plugin getParameter _requiredModuleApi for squarethumb plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/thumbnail) file_exists(/usr/share/gallery2/modules/thumbnail/module.inc) getParameter _version for thumbnail plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'thumbnail' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for thumbnail plugin getParameter _requiredCoreApi for thumbnail plugin getParameter _requiredModuleApi for thumbnail plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/thumbpage) file_exists(/usr/share/gallery2/modules/thumbpage/module.inc) getParameter _version for thumbpage plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'thumbpage' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for thumbpage plugin getParameter _requiredCoreApi for thumbpage plugin getParameter _requiredModuleApi for thumbpage plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/useralbum) file_exists(/usr/share/gallery2/modules/useralbum/module.inc) getParameter _version for useralbum plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'useralbum' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for useralbum plugin getParameter _requiredCoreApi for useralbum plugin getParameter _requiredModuleApi for useralbum plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/watermark) file_exists(/usr/share/gallery2/modules/watermark/module.inc) getParameter _version for watermark plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'watermark' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for watermark plugin getParameter _requiredCoreApi for watermark plugin getParameter _requiredModuleApi for watermark plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/webcam) file_exists(/usr/share/gallery2/modules/webcam/module.inc) getParameter _version for webcam plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'webcam' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for webcam plugin getParameter _requiredCoreApi for webcam plugin getParameter _requiredModuleApi for webcam plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/zipcart) file_exists(/usr/share/gallery2/modules/zipcart/module.inc) getParameter _version for zipcart plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'zipcart' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for zipcart plugin getParameter _requiredCoreApi for zipcart plugin getParameter _requiredModuleApi for zipcart plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/fotokasten) file_exists(/usr/share/gallery2/modules/fotokasten/module.inc) getParameter _version for fotokasten plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'fotokasten' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for fotokasten plugin getParameter _requiredCoreApi for fotokasten plugin getParameter _requiredModuleApi for fotokasten plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/getid3) file_exists(/usr/share/gallery2/modules/getid3/module.inc) getParameter _version for getid3 plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'getid3' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for getid3 plugin getParameter _requiredCoreApi for getid3 plugin getParameter _requiredModuleApi for getid3 plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/hidden) file_exists(/usr/share/gallery2/modules/hidden/module.inc) getParameter _version for hidden plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'hidden' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for hidden plugin getParameter _requiredCoreApi for hidden plugin getParameter _requiredModuleApi for hidden plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/linkitem) file_exists(/usr/share/gallery2/modules/linkitem/module.inc) getParameter _version for linkitem plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'linkitem' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for linkitem plugin getParameter _requiredCoreApi for linkitem plugin getParameter _requiredModuleApi for linkitem plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/password) file_exists(/usr/share/gallery2/modules/password/module.inc) getParameter _version for password plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'password' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for password plugin getParameter _requiredCoreApi for password plugin getParameter _requiredModuleApi for password plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/permalinks) file_exists(/usr/share/gallery2/modules/permalinks/module.inc) getParameter _version for permalinks plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'permalinks' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for permalinks plugin getParameter _requiredCoreApi for permalinks plugin getParameter _requiredModuleApi for permalinks plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/picasa) file_exists(/usr/share/gallery2/modules/picasa/module.inc) getParameter _version for picasa plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'picasa' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for picasa plugin getParameter _requiredCoreApi for picasa plugin getParameter _requiredModuleApi for picasa plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/rating) file_exists(/usr/share/gallery2/modules/rating/module.inc) getParameter _version for rating plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'rating' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for rating plugin getParameter _requiredCoreApi for rating plugin getParameter _requiredModuleApi for rating plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/reupload) file_exists(/usr/share/gallery2/modules/reupload/module.inc) getParameter _version for reupload plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'reupload' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for reupload plugin getParameter _requiredCoreApi for reupload plugin getParameter _requiredModuleApi for reupload plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/rss) file_exists(/usr/share/gallery2/modules/rss/module.inc) getParameter _version for rss plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'rss' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for rss plugin getParameter _requiredCoreApi for rss plugin getParameter _requiredModuleApi for rss plugin readdir(Resource id #57) is_dir(/usr/share/gallery2/modules/sitemap) file_exists(/usr/share/gallery2/modules/sitemap/module.inc) getParameter _version for sitemap plugin (postgres7): SELECT g2_PluginParameterMap.g_itemId, g2_PluginParameterMap.g_parameterName, g2_PluginParameterMap.g_parameterValue FROM g2_PluginParameterMap WHERE g2_PluginParameterMap.g_pluginType = 'module' AND g2_PluginParameterMap.g_pluginId = 'sitemap' AND g2_PluginParameterMap.g_itemId = 0 getParameter _callbacks for sitemap plugin getParameter _requiredCoreApi for sitemap plugin getParameter _requiredModuleApi for sitemap plugin readdir(Resource id #57) closedir(Resource id #57) (postgres7): SELECT g2_User.g_userName, g2_User.g_fullName, g2_User.g_hashedPassword, g2_User.g_email, g2_User.g_language, g2_Entity.g_id, g2_Entity.g_creationTimestamp, g2_Entity.g_isLinkable, g2_Entity.g_linkId, g2_Entity.g_modificationTimestamp, g2_Entity.g_serialNumber, g2_Entity.g_entityType, g2_Entity.g_onLoadHandlers FROM g2_User, g2_Entity WHERE g2_User.g_id IN (6) AND g2_Entity.g_id=g2_User.g_id GalleryModule::installOrUpgrade core module In bootstrap mode (core module) Configure store for core module (postgres7): set datestyle='ISO' postgres7 error: [-1: ERROR: function "bit_or" already exists with same argument types] in EXECUTE(" CREATE AGGREGATE BIT_OR ( basetype = bit, sfunc = bitor, stype = bit )") (postgres7): CREATE AGGREGATE BIT_OR ( basetype = bit, sfunc = bitor, stype = bit ) Warning: pg_exec() [function.pg-exec]: Query failed: ERROR: function "bit_or" already exists with same argument types in /usr/share/gallery2/lib/adodb/drivers/adodb-postgres64.inc.php on line 741 -1: ERROR: function "bit_or" already exists with same argument types ADOConnection._Execute( CREATE AGGREGATE BIT_OR ( basetype = bit, sfunc = bitor, stype = bit ), false) % line 855, file: adodb.inc.php ADOConnection.Execute( CREATE AGGREGATE BIT_OR ( basetype = bit, sfunc = bitor, stype = bit )) % line 130, file: PostgreSqlStorage.class PostgreSqlStorage.configureStore(core) % line 144, file: GalleryModule.class GalleryModule.installOrUpgrade(true, Object:StatusTemplate) % line 83, file: UpgradeCoreModuleStep.class UpgradeCoreModuleStep.processRequest() % line 221, file: index.php file_exists(/usr/share/gallery2/modules/core/classes/helpers/../../../../modules/core/classes/GalleryStorage/schema.tpl) file(/usr/share/gallery2/modules/core/classes/helpers/../../../../modules/core/classes/GalleryStorage/schema.tpl, ) (postgres7): select tablename,'T' from pg_tables where tablename not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') union select viewname,'V' from pg_views where viewname not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') (postgres7): SELECT g_name, g_major, g_minor FROM g2_Schema (postgres7): CREATE TABLE g2_CacheMap( g_key VARCHAR(32) NOT NULL, g_value text, g_userId INTEGER NOT NULL, g_itemId INTEGER NOT NULL, g_type VARCHAR(32) NOT NULL, g_timestamp INTEGER NOT NULL ) (postgres7): ALTER TABLE g2_CacheMap ADD PRIMARY KEY (g_key, g_userId, g_itemId, g_type) (postgres7): CREATE INDEX g2_CacheMap_69068 ON g2_CacheMap(g_userId) (postgres7): CREATE INDEX g2_CacheMap_75985 ON g2_CacheMap(g_itemId) (postgres7): CREATE INDEX g2_CacheMap_81545 ON g2_CacheMap(g_type) (postgres7): CREATE INDEX g2_CacheMap_24286 ON g2_CacheMap(g_timestamp) (postgres7): INSERT INTO g2_Schema ( g_name, g_major, g_minor ) VALUES('CacheMap', 1, 0); (postgres7): CREATE TABLE g2_PluginPackageMap( g_pluginType VARCHAR(32) NOT NULL, g_pluginId VARCHAR(32) NOT NULL, g_packageName VARCHAR(32) NOT NULL, g_packageVersion VARCHAR(32) NOT NULL, g_packageBuild VARCHAR(32) NOT NULL ) (postgres7): CREATE INDEX g2_PluginPackageMap_80596 ON g2_PluginPackageMap(g_pluginType) (postgres7): INSERT INTO g2_Schema ( g_name, g_major, g_minor ) VALUES('PluginPackageMap', 1, 0); (postgres7): CREATE TABLE g2_SessionMap( g_id VARCHAR(32) NOT NULL, g_userId INTEGER NOT NULL, g_remoteIdentifier VARCHAR(128) NOT NULL, g_creationTimestamp INTEGER NOT NULL, g_modificationTimestamp INTEGER NOT NULL, g_data text ) (postgres7): ALTER TABLE g2_SessionMap ADD PRIMARY KEY (g_id) (postgres7): CREATE INDEX g2_SessionMap_53500 ON g2_SessionMap(g_userId, g_creationTimestamp, g_modificationTimestamp) (postgres7): INSERT INTO g2_Schema ( g_name, g_major, g_minor ) VALUES('SessionMap', 1, 0); Upgrade (or install) core module Entering CoreModuleExtras::upgrade The current version is 1.0.0.x (postgres7): set datestyle='ISO' postgres7 error: [-1: ERROR: function "bit_or" already exists with same argument types] in EXECUTE(" CREATE AGGREGATE BIT_OR ( basetype = bit, sfunc = bitor, stype = bit )") (postgres7): CREATE AGGREGATE BIT_OR ( basetype = bit, sfunc = bitor, stype = bit ) Warning: pg_exec() [function.pg-exec]: Query failed: ERROR: function "bit_or" already exists with same argument types in /usr/share/gallery2/lib/adodb/drivers/adodb-postgres64.inc.php on line 741 -1: ERROR: function "bit_or" already exists with same argument types ADOConnection._Execute( CREATE AGGREGATE BIT_OR ( basetype = bit, sfunc = bitor, stype = bit ), false) % line 855, file: adodb.inc.php ADOConnection.Execute( CREATE AGGREGATE BIT_OR ( basetype = bit, sfunc = bitor, stype = bit )) % line 130, file: PostgreSqlStorage.class PostgreSqlStorage.configureStore(core, Array[1]) % line 1295, file: CoreModuleExtras.inc CoreModuleExtras.upgrade(Object:CoreModule, null, Object:StatusTemplate) % line 487, file: module.inc CoreModule.upgrade(null, Object:StatusTemplate) % line 157, file: GalleryModule.class file_exists(/usr/share/gallery2/modules/core/classes/helpers/../../../../modules/core/classes/GalleryStorage/schema.tpl) file(/usr/share/gallery2/modules/core/classes/helpers/../../../../modules/core/classes/GalleryStorage/schema.tpl, ) (postgres7): select tablename,'T' from pg_tables where tablename not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') union select viewname,'V' from pg_views where viewname not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') (postgres7): SELECT g_name, g_major, g_minor FROM g2_Schema (postgres7): ALTER TABLE g2_PluginParameterMap ADD COLUMN g_parameterValueTemp text (postgres7): UPDATE g2_PluginParameterMap SET g_parameterValueTemp = CAST(g_parameterValue AS text) (postgres7): ALTER TABLE g2_PluginParameterMap DROP g_parameterValue (postgres7): ALTER TABLE g2_PluginParameterMap RENAME g_parameterValueTemp to g_parameterValue (postgres7): ALTER TABLE g2_PluginParameterMap ALTER g_parameterValue SET NOT NULL (postgres7): UPDATE g2_Schema SET g_major=1, g_minor=3 WHERE g_name='PluginParameterMap' AND g_major=1 AND g_minor=2; (postgres7): SELECT g_name, g_major, g_minor FROM g2_Schema (postgres7): SELECT g2_MimeTypeMap.g_extension, g2_MimeTypeMap.g_mimeType, g2_MimeTypeMap.g_viewable FROM g2_MimeTypeMap ORDER BY g2_MimeTypeMap.g_extension DESC (postgres7): SELECT g2_MimeTypeMap.g_extension FROM g2_MimeTypeMap WHERE g2_MimeTypeMap.g_extension = 'wmf' LIMIT 1 (postgres7): INSERT INTO g2_MimeTypeMap (g_extension, g_mimeType, g_viewable) VALUES ('wmf','image/wmf',0) file_exists(/usr/local/var/g2data/plugins/modules) file_exists(/usr/local/var/g2data/plugins/themes) file_exists(/usr/local/var/g2data/plugins) setParameter exec.beNice for core plugin (postgres7): INSERT INTO g2_PluginParameterMap (g_pluginType, g_pluginId, g_itemId, g_parameterName, g_parameterValue) VALUES ('module','core',0,'exec.beNice','0') Plugin parameter exec.beNice for core plugin set successfully (postgres7): set datestyle='ISO' postgres7 error: [-1: ERROR: function "bit_or" already exists with same argument types] in EXECUTE(" CREATE AGGREGATE BIT_OR ( basetype = bit, sfunc = bitor, stype = bit )") (postgres7): CREATE AGGREGATE BIT_OR ( basetype = bit, sfunc = bitor, stype = bit ) Warning: pg_exec() [function.pg-exec]: Query failed: ERROR: function "bit_or" already exists with same argument types in /usr/share/gallery2/lib/adodb/drivers/adodb-postgres64.inc.php on line 741 -1: ERROR: function "bit_or" already exists with same argument types ADOConnection._Execute( CREATE AGGREGATE BIT_OR ( basetype = bit, sfunc = bitor, stype = bit ), false) % line 855, file: adodb.inc.php ADOConnection.Execute( CREATE AGGREGATE BIT_OR ( basetype = bit, sfunc = bitor, stype = bit )) % line 130, file: PostgreSqlStorage.class PostgreSqlStorage.configureStore(core, Array[2]) % line 1366, file: CoreModuleExtras.inc CoreModuleExtras.upgrade(Object:CoreModule, null, Object:StatusTemplate) % line 487, file: module.inc CoreModule.upgrade(null, Object:StatusTemplate) % line 157, file: GalleryModule.class file_exists(/usr/share/gallery2/modules/core/classes/helpers/../../../../modules/core/classes/GalleryStorage/schema.tpl) file(/usr/share/gallery2/modules/core/classes/helpers/../../../../modules/core/classes/GalleryStorage/schema.tpl, ) (postgres7): select tablename,'T' from pg_tables where tablename not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') union select viewname,'V' from pg_views where viewname not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') (postgres7): SELECT g_name, g_major, g_minor FROM g2_Schema (postgres7): DROP INDEX g2_AccessMap_33666 postgres7 error: [-1: ERROR: adding columns with defaults is not implemented HINT: Add the column, then use ALTER TABLE SET DEFAULT.] in EXECUTE("ALTER TABLE g2_AccessMap ADD COLUMN g_userOrGroupId INTEGER DEFAULT '0'") (postgres7): ALTER TABLE g2_AccessMap ADD COLUMN g_userOrGroupId INTEGER DEFAULT '0' Warning: pg_exec() [function.pg-exec]: Query failed: ERROR: adding columns with defaults is not implemented HINT: Add the column, then use ALTER TABLE SET DEFAULT. in /usr/share/gallery2/lib/adodb/drivers/adodb-postgres64.inc.php on line 741 -1: ERROR: adding columns with defaults is not implemented HINT: Add the column, then use ALTER TABLE SET DEFAULT. ADOConnection._Execute(ALTER TABLE g2_AccessMap ADD COLUMN g_userOrGroupId INTEGER DEFAULT '0', false) % line 855, file: adodb.inc.php ADOConnection.Execute(ALTER TABLE g2_AccessMap ADD COLUMN g_userOrGroupId INTEGER DEFAULT '0') % line 1524, file: GalleryStorageExtras.class GalleryStorageExtras._executeSql(DROP INDEX DB_TABLE_PREFIXAccessMap_33666; ALTER TABLE DB_TABLE_PREFIXAccessMap ADD COLUMN DB_COLUMN_PREFIXuserOrGroupId INTEGE...) % line 1304, file: GalleryStorageExtras.class GalleryStorageExtras.configureStore(core, Array[2]) % line 625, file: GalleryStorage.class GalleryStorage.configureStore(core, Array[2]) % line 144, file: PostgreSqlStorage.class realpath(/usr/share/gallery2/modules/core/classes/../../../) Error: Failed to upgrade the core module, this is the error stack trace: Error (ERROR_STORAGE_FAILURE) : Error trying to run query: ALTER TABLE g2_AccessMap ADD COLUMN g_userOrGroupId INTEGER DEFAULT '0'in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 1528 (GalleryCoreApi::error) in modules/core/classes/GalleryStorage/GalleryStorageExtras.class at line 1304 (GalleryStorageExtras::_executeSql) in modules/core/classes/GalleryStorage.class at line 625 (GalleryStorageExtras::configureStore) in modules/core/classes/GalleryStorage/PostgreSqlStorage.class at line 144 (GalleryStorage::configureStore) in modules/core/CoreModuleExtras.inc at line 1366 (PostgreSqlStorage::configureStore) in modules/core/module.inc at line 487 (CoreModuleExtras::upgrade) in modules/core/classes/GalleryModule.class at line 157 (CoreModule::upgrade) in upgrade/steps/UpgradeCoreModuleStep.class at line 83 (GalleryModule::installOrUpgrade) in upgrade/index.php at line 221 (UpgradeCoreModuleStep::processRequest) realpath(/usr/share/gallery2/modules/core/classes/../../../) /A -- System Information: Debian Release: testing/unstable APT prefers unstable APT policy: (500, 'unstable') Architecture: i386 (i686) Shell: /bin/sh linked to /bin/bash Kernel: Linux 2.6.12-1-k7 Locale: LANG=sv_SE.UTF-8, LC_CTYPE=sv_SE.UTF-8 (charmap=UTF-8) Versions of packages gallery2 depends on: ii apache2 2.0.55-4 next generation, scalable, extenda ii apache2-mpm-prefork [httpd 2.0.55-4 traditional model for Apache2 ii debconf [debconf-2.0] 1.4.72 Debian configuration management sy ii imagemagick 6:6.2.4.5-0.7 Image manipulation programs ii libapache2-mod-php5 5.1.2-1+b1 server-side, HTML-embedded scripti ii mysql-client-5.0 [mysql-cl 5.0.19-2 mysql database client binaries ii netpbm 2:10.0-10.1 Graphics conversion tools ii php5 5.1.2-1 server-side, HTML-embedded scripti ii php5-mysql 5.1.2-1+b1 MySQL module for php5 ii wwwconfig-common 0.0.45 Debian web auto configuration Versions of packages gallery2 recommends: pn dcraw <none> (no description available) ii ffmpeg 0.cvs20050918-6 multimedia player, server and enco ii jhead 2.50-1 manipulate the non-image part of E ii libjpeg-progs 6b-12 Programs for manipulating JPEG fil pn mysql-server-4.1 | mysql <none> (no description available) ii php5-gd 5.1.2-1+b1 GD module for php5 ii postgresql-7.4 1:7.4.12-2 object-relational SQL database, ve ii unzip 5.52-7 De-archiver for .zip files ii zip 2.31-3 Archiver for .zip files -- debconf information: * gallery2/mysql/dbserver: localhost * gallery2/restart-webserver: true * gallery2/webserver_type: apache2 * gallery2/mysql/dbname: gallery2 * gallery2/mysql/configure: true * gallery2/purge: false * gallery2/mysql/dbadmin: root -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]