Upgrade problem 0.8 -> 0.8.4

apn

Joined: 2005-02-09
Posts: 2
Posted: Wed, 2005-02-09 21:03

Hi all,
While upgrading gallery2 I've got an error relating to the postgresql database migration (upgrading Core Module from 0.8 to 0.8.4)

Quote:
Currently installed 0.8
New version 0.8.4

Here are my server informations:

Gallery URL (optional): http://www.pnzone.net/gallery2/ http://www.pnzone.net/gallery2update/
Gallery version: 2
Webserver (with version): Apache 2.0.53
Datatabase (with version): PostGreSQL 7.4.7
PHP version (eg 4.2.1): 5.0.3
phpinfo URL (optional): http://pnzone.net/~apn/phpv.php
Graphics Toolkit(s):
Operating system: FreeBSD 5.3-Release
Web browser/version: Mozilla 1.7.5

Here is the message who appears while trying to upgrade:

Quote:

An error ocurred while upgrading Gallery Core Module

Something went wrong when we tried to upgrade the core module. In the boxes below you can find some debug information. Report this in the Gallery Forums and we'll help you diagnose the problem.
Stack Trace:
Error (ERROR_STORAGE_FAILURE)

* in modules/core/classes/GalleryStorage/DatabaseStorage.class at line 741 (PostgreSqlDatabaseStorage::error)
* in modules/core/classes/GalleryStorage.class at line 241 (PostgreSqlDatabaseStorage::execute)
* in modules/core/CoreModuleExtras.inc at line 201 (GalleryStorage::execute)
* in modules/core/module.inc at line 663 (CoreModule::upgrade)
* in modules/core/classes/GalleryModule.class at line 168 (CoreModule::upgrade)
* in upgrade/steps/UpgradeCoreModuleStep.class at line 50 (CoreModule::installOrUpgrade)
* in upgrade/index.php at line 146 (UpgradeCoreModuleStep::loadTemplateData)

Debug Output:

file_exists(/home/apache/g2data/sessions/4a0b139fb42c9d41aac464d61a8be9aa)
clearstatcache()
filesize(/home/apache/g2data/sessions/4a0b139fb42c9d41aac464d61a8be9aa)
fopen(/home/apache/g2data/sessions/4a0b139fb42c9d41aac464d61a8be9aa, rb, 0)
flock(Resource id #26, 6, )
fread(Resource id #26, 9759)
flock(Resource id #26, 3, )
fclose(Resource id #26)

(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(/home/apache/g2data//versions.dat)

(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
/net/http/html/gallery2/lib/adodb/drivers/adodb-postgres64.inc.php
on line 722

-1: ERROR: function "bit_or" already exists with same argument types

ADODB_postgres7._Execute(
CREATE AGGREGATE BIT_OR
(
basetype = ..., false) % line
833, file: adodb.inc.php
ADODB_postgres7.Execute(
CREATE AGGREGATE BIT_OR
(
basetype = ...) % line 128,
file: PostgreSqlDatabaseStorage.class
PostgreSqlDatabaseStorage.configureStore(core) % line 338, file: GalleryStorage.class
GalleryStorage.configureStore(core) % line 163, file: GalleryModule.class
CoreModule.installOrUpgrade(true) % line 50, file: UpgradeCoreModuleStep.class

file_exists(/net/http/html/gallery2/modules/core/classes/GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/postgres)
opendir(/net/http/html/gallery2/modules/core/classes/GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/postgres)
readdir(Resource id #49)
readdir(Resource id #49)
readdir(Resource id #49)
readdir(Resource id #49)
readdir(Resource id #49)
readdir(Resource id #49)
readdir(Resource id #49)
readdir(Resource id #49)
readdir(Resource id #49)
readdir(Resource id #49)
readdir(Resource id #49)
readdir(Resource id #49)
readdir(Resource id #49)
readdir(Resource id #49)
readdir(Resource id #49)
readdir(Resource id #49)
readdir(Resource id #49)
readdir(Resource id #49)
readdir(Resource id #49)
readdir(Resource id #49)
readdir(Resource id #49)
readdir(Resource id #49)
readdir(Resource id #49)
readdir(Resource id #49)
readdir(Resource id #49)
readdir(Resource id #49)
readdir(Resource id #49)
readdir(Resource id #49)
readdir(Resource id #49)
readdir(Resource id #49)
readdir(Resource id #49)
readdir(Resource id #49)
readdir(Resource id #49)
readdir(Resource id #49)
readdir(Resource id #49)
closedir(Resource id #49)

(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

fopen(/net/http/html/gallery2/modules/core/classes/GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/postgres/GalleryDerivativePreferencesMap.sql,
r, 0)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)
fgets(Resource id #52, 4096)
feof(Resource id #52)

(postgres7): -- This file was automatically generated from an XSL
template, which is
-- why it looks so ugly. Editing it by hand would be a bad idea.
--

CREATE TABLE g2_DerivativePrefsMap (
g_itemId
INTEGER

,
g_order
INTEGER

,
g_derivativeType
INTEGER

,
g_derivativeOperations
VARCHAR(

255

)

)

(postgres7): CREATE INDEX g2_DerivativePrefsMap_75985
ON g2_DerivativePrefsMap
(g_itemId)

(postgres7): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'DerivativePrefsMap',
1,
0
)

fclose(Resource id #52)
fopen(/net/http/html/gallery2/modules/core/classes/GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/postgres/GalleryToolkitOperationMap.sql,
r, 0)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)
fgets(Resource id #56, 4096)
feof(Resource id #56)

(postgres7): -- This file was automatically generated from an XSL
template, which is
-- why it looks so ugly. Editing it by hand would be a bad idea.
--

CREATE TABLE g2_TkOperatnMap (
g_name
VARCHAR(

128

)

NOT NULL

,
g_parametersCrc
VARCHAR(

32

)

NOT NULL

,
g_outputMimeType
VARCHAR(

128

)

,
g_description
VARCHAR(

255

)

)

(postgres7): ALTER TABLE g2_TkOperatnMap
ADD PRIMARY KEY (g_name)

(postgres7): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'TkOperatnMap',
1,
0
)

fclose(Resource id #56)
fopen(/net/http/html/gallery2/modules/core/classes/GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/postgres/GalleryToolkitOperationMimeTypeMap.sql,
r, 0)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)
fgets(Resource id #60, 4096)
feof(Resource id #60)

(postgres7): -- This file was automatically generated from an XSL
template, which is
-- why it looks so ugly. Editing it by hand would be a bad idea.
--

CREATE TABLE g2_TkOperatnMimeTypeMap (
g_operationName
VARCHAR(

128

)

NOT NULL

,
g_toolkitId
VARCHAR(

128

)

NOT NULL

,
g_mimeType
VARCHAR(

128

)

NOT NULL

,
g_priority
INTEGER

NOT NULL

)

(postgres7): CREATE INDEX g2_TkOperatnMimeTypeMap_2014
ON g2_TkOperatnMimeTypeMap
(g_operationName)

(postgres7): CREATE INDEX g2_TkOperatnMimeTypeMap_79463
ON g2_TkOperatnMimeTypeMap
(g_mimeType)

(postgres7): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'TkOperatnMimeTypeMap',
1,
0
)

fclose(Resource id #60)
fopen(/net/http/html/gallery2/modules/core/classes/GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/postgres/GalleryToolkitOperationParameterMap.sql,
r, 0)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)
fgets(Resource id #65, 4096)
feof(Resource id #65)

(postgres7): -- This file was automatically generated from an XSL
template, which is
-- why it looks so ugly. Editing it by hand would be a bad idea.
--

CREATE TABLE g2_TkOperatnParameterMap (
g_operationName
VARCHAR(

128

)

NOT NULL

,
g_position
INTEGER

NOT NULL

,
g_type
VARCHAR(

128

)

NOT NULL

,
g_description
VARCHAR(

255

)

)

(postgres7): CREATE INDEX g2_TkOperatnParameterMap_2014
ON g2_TkOperatnParameterMap
(g_operationName)

(postgres7): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'TkOperatnParameterMap',
1,
0
)

fclose(Resource id #65)
fopen(/net/http/html/gallery2/modules/core/classes/GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/postgres/GalleryToolkitPropertyMap.sql,
r, 0)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)
fgets(Resource id #69, 4096)
feof(Resource id #69)

(postgres7): -- This file was automatically generated from an XSL
template, which is
-- why it looks so ugly. Editing it by hand would be a bad idea.
--

CREATE TABLE g2_TkPropertyMap (
g_name
VARCHAR(

128

)

NOT NULL

,
g_type
VARCHAR(

128

)

NOT NULL

,
g_description
VARCHAR(

128

)

NOT NULL

)

(postgres7): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'TkPropertyMap',
1,
0
)

fclose(Resource id #69)
fopen(/net/http/html/gallery2/modules/core/classes/GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/postgres/GalleryToolkitPropertyMimeTypeMap.sql,
r, 0)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)
fgets(Resource id #72, 4096)
feof(Resource id #72)

(postgres7): -- This file was automatically generated from an XSL
template, which is
-- why it looks so ugly. Editing it by hand would be a bad idea.
--

CREATE TABLE g2_TkPropertyMimeTypeMap (
g_propertyName
VARCHAR(

128

)

NOT NULL

,
g_toolkitId
VARCHAR(

128

)

NOT NULL

,
g_mimeType
VARCHAR(

128

)

NOT NULL

)

(postgres7): CREATE INDEX g2_TkPropertyMimeTypeMap_52881
ON g2_TkPropertyMimeTypeMap
(g_propertyName)

(postgres7): CREATE INDEX g2_TkPropertyMimeTypeMap_79463
ON g2_TkPropertyMimeTypeMap
(g_mimeType)

(postgres7): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'TkPropertyMimeTypeMap',
1,
0
)

fclose(Resource id #72)
fopen(/net/http/html/gallery2/modules/core/classes/GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/postgres/ExternalIdMap.sql,
r, 0)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)
fgets(Resource id #77, 4096)
feof(Resource id #77)

(postgres7): -- This file was automatically generated from an XSL
template, which is
-- why it looks so ugly. Editing it by hand would be a bad idea.
--

CREATE TABLE g2_ExternalIdMap (
g_externalId
VARCHAR(

128

)

NOT NULL

,
g_entityType
VARCHAR(

32

)

NOT NULL

,
g_entityId
INTEGER

NOT NULL

)

(postgres7): ALTER TABLE g2_ExternalIdMap
ADD PRIMARY KEY (g_externalId
,
g_entityType)

(postgres7): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'ExternalIdMap',
1,
0
)

fclose(Resource id #77)
file_exists(/home/apache/g2data//versions.dat)

(postgres7):
SELECT
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_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 error: [-1: ERROR: syntax error at or near "." at character 132]
in EXECUTE("
UPDATE
g2_PluginParameterMap
SET
g2_PluginParameterMap.g_parameterName = '_version'
WHERE
g2_PluginParameterMap.g_parameterName = 'version'
AND
g2_PluginParameterMap.g_pluginType = 'module'
AND
g2_PluginParameterMap.g_itemId = 0
")

(postgres7):
UPDATE
g2_PluginParameterMap
SET
g2_PluginParameterMap.g_parameterName = '_version'
WHERE
g2_PluginParameterMap.g_parameterName = 'version'
AND
g2_PluginParameterMap.g_pluginType = 'module'
AND
g2_PluginParameterMap.g_itemId = 0

Warning: pg_exec() [function.pg-exec]: Query failed: ERROR:
syntax error at or near "." at character 132 in
/net/http/html/gallery2/lib/adodb/drivers/adodb-postgres64.inc.php
on line 722

-1: ERROR: syntax error at or near "." at character 132

ADODB_postgres7._Execute(
UPDATE
g2_PluginParameter...) % line 818, file: adodb.inc.php
ADODB_postgres7.Execute(
UPDATE
g2_PluginParameter..., Array[2]) % line 735, file: DatabaseStorage.class
PostgreSqlDatabaseStorage.execute(
UPDATE
[GalleryPluginPara..., Array[2]) % line 241, file: GalleryStorage.class
GalleryStorage.execute(
UPDATE
[GalleryPluginPara..., Array[2]) % line 201, file: CoreModuleExtras.inc
CoreModule.upgrade(Object:CoreModule, null) % line 663, file: module.inc

realpath(/net/http/html/gallery2/modules/core/classes/../../../)
postgres7 error: [-1: ERROR: current transaction is aborted, commands
ignored until end of transaction block] in EXECUTE("
SELECT
g2_PluginMap.g_pluginId,
g2_PluginMap.g_active
FROM
g2_PluginMap
WHERE
g2_PluginMap.g_pluginType = 'module'
")

(postgres7):
SELECT
g2_PluginMap.g_pluginId,
g2_PluginMap.g_active
FROM
g2_PluginMap
WHERE
g2_PluginMap.g_pluginType = 'module'

Warning: pg_exec() [function.pg-exec]: Query failed: ERROR:
current transaction is aborted, commands ignored until end of transaction
block in
/net/http/html/gallery2/lib/adodb/drivers/adodb-postgres64.inc.php
on line 722

-1: ERROR: current transaction is aborted, commands ignored until end of
transaction block

ADODB_postgres7._Execute(
SELECT
g2_PluginMap.g_pluginId,
...) % line 818, file: adodb.inc.php

ADODB_postgres7.Execute(
SELECT
g2_PluginMap.g_pluginId,
..., Array[1]) % line 712, file:
DatabaseStorage.class

PostgreSqlDatabaseStorage.search(
SELECT
[GalleryPluginMap::pluginId],
..., Array[1], Array[0]) % line 220,
file: GalleryStorage.class
GalleryStorage.search(
SELECT
[GalleryPluginMap::pluginId],
..., Array[1], Array[0]) % line 184,
file: Gallery.class
Gallery.search(
SELECT
[GalleryPluginMap::pluginId],
..., Array[1]) % line 395, file: GalleryPluginHelper_simple.class

Can you help me ?
Thank you very much in advance ...
 
bharat
bharat's picture

Joined: 2002-05-21
Posts: 7994
Posted: Thu, 2005-02-10 18:08

Try upgrading to the latest nightly snapshot from here and
see if that resolves your problem for you. We've made a
lot of improvements since the alpha-4 release and may well
have resolved this problem already.
 
apn

Joined: 2005-02-09
Posts: 2
Posted: Thu, 2005-02-10 19:35

Hi,

Thank you very much for your answer.

I took the last sources from this night and effectively, the upgrade process is well done :-)

But now I got an error in main.php:

Quote:

Database Error

An error has occurred while interacting with the database.

Back to the Gallery
Error Detail -
Error (ERROR_STORAGE_FAILURE) :

* in modules/core/classes/GalleryStorage/DatabaseStorage.class at line 377 (PostgreSqlDatabaseStorage::error)
* in modules/core/classes/GalleryStorage.class at line 113 (PostgreSqlDatabaseStorage::loadEntities)
* in modules/core/classes/helpers/GalleryEntityHelper_simple.class at line 89 (GalleryStorage::loadEntities)
* in modules/core/classes/GalleryCoreApi.class at line 2118 (ShowItemView::loadEntitiesById)
* in modules/core/classes/GalleryView.class at line 328 (ShowItemView::loadEntitiesById)
* in modules/core/ShowItem.inc at line 44 (ShowItemView::_getItem)
* in modules/core/classes/GalleryView.class at line 210 (ShowItemView::getThemeName)
* in main.php at line 257 (ShowItemView::doLoadTemplate)
* in main.php at line 46
* in main.php at line 39

My old version (0.8) of gallery2 isn't anymore functionnal (while browsing some albums, not alls).
Do you have an idea on what is going wrong with this ?

old version: http://www.pnzone.net/gallery2
latest version: http://www.pnzone.net/gallery2updated
 
bharat
bharat's picture

Joined: 2002-05-21
Posts: 7994
Posted: Mon, 2005-02-14 09:02

I'm not sure what's going wrong here, but we don't properly support upgrading from version 0.8, unfortunately. Your best bet will be to reinstall with the latest version; we do support upgrading from there. Sorry...