G2 problem install with oracle database

golgot13

Joined: 2005-04-07
Posts: 1
Posted: Thu, 2005-04-07 11:11

On step 7 :

Unable to install the core module
Unable to activate the core module

Error installing Gallery Core
Something went wrong when we tried to install 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 C:\Inetpub\AlbumPhotos\gallery2\modules\core\classes\GalleryStorage\DatabaseStorage.class at line 1150 (OracleDatabaseStorage::error)
in C:\Inetpub\AlbumPhotos\gallery2\modules\core\classes\GalleryStorage.class at line 220 (OracleDatabaseStorage::search)
in C:\Inetpub\AlbumPhotos\gallery2\modules\core\classes\Gallery.class at line 206 (GalleryStorage::search)
in C:\Inetpub\AlbumPhotos\gallery2\modules\core\classes\helpers\GalleryPluginHelper_simple.class at line 424 (Gallery::search)
in C:\Inetpub\AlbumPhotos\gallery2\modules\core\classes\helpers\GalleryPluginHelper_simple.class at line 301 (CoreModule::fetchPluginList)
in C:\Inetpub\AlbumPhotos\gallery2\modules\core\classes\GalleryCoreApi.class at line 262 (CoreModule::fetchPluginStatus)
in C:\Inetpub\AlbumPhotos\gallery2\modules\core\classes\GalleryPlugin.class at line 136 (CoreModule::fetchPluginStatus)
in C:\Inetpub\AlbumPhotos\gallery2\modules\core\classes\GalleryModule.class at line 275 (CoreModule::activate)
in C:\Inetpub\AlbumPhotos\gallery2\install\steps\InstallCoreModuleStep.class at line 89 (CoreModule::activate)
in C:\Inetpub\AlbumPhotos\gallery2\install\index.php at line 168 (InstallCoreModuleStep::loadTemplateData)

Debug Output:
file_exists(C:\Inetpub\AlbumPhotos\gallery2\g2data\/cache/entity)
file_exists(C:\Inetpub\AlbumPhotos\gallery2\g2data\/cache/layout)
file_exists(C:\Inetpub\AlbumPhotos\gallery2\g2data\/cache/module)
file_exists(C:\Inetpub\AlbumPhotos\gallery2\g2data\/cache/derivative)
--------------------------------------------------------------------------------
(oci8po): ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD'

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(oci8po): select lower(table_name), table_type from cat where table_type
in ('TABLE', 'VIEW')
--------------------------------------------------------------------------------

file_exists(C:\Inetpub\AlbumPhotos\gallery2\modules\core\classes\helpers/../../../../modules/core/module.inc)
file_exists(C:\Inetpub\AlbumPhotos\gallery2\modules\core\classes\GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle)
opendir(C:\Inetpub\AlbumPhotos\gallery2\modules\core\classes\GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
readdir(Resource id #55)
closedir(Resource id #55)
--------------------------------------------------------------------------------
(oci8po): select lower(table_name), table_type from cat where table_type
in ('TABLE', 'VIEW')
--------------------------------------------------------------------------------

fopen(C:\Inetpub\AlbumPhotos\gallery2\modules\core\classes\GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle/Schema.sql,
r, 0)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fgets(Resource id #58, 4096)
feof(Resource id #58)
fclose(Resource id #58)
--------------------------------------------------------------------------------
(oci8po): -- 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_Schema (
g_name
VARCHAR2(
128
)

NOT NULL

,
g_major
INTEGER

NOT NULL

,
g_minor
INTEGER

NOT NULL

)
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(oci8po): ALTER TABLE g2_Schema
ADD PRIMARY KEY (g_name)
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(oci8po): INSERT INTO g2_Schema (
g_name,
g_major,
g_minor
) VALUES (
'Schema',
1,
0
)
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(oci8po): CREATE SEQUENCE g2_SequenceLock START WITH 1

--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(oci8po): CREATE SEQUENCE g2_SequenceId START WITH 1
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
(oci8po): SELECT g_name, g_major, g_minor FROM g2_Schema

--------------------------------------------------------------------------------

fopen(C:\Inetpub\AlbumPhotos\gallery2\modules\core\classes\GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle/CreateBitOr.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)
fclose(Resource id #65)
oci8po error: [24344: ORA-24344: op鲡tion r鵳sie avec erreur de
compilation
] in EXECUTE("-- Create BIT_OR aggregate function (requires Oracle 9i or
higher)

create or replace type BIT_OR_IMPL as object (
val NUMBER,
static function ODCIAggregateInitialize(sctx IN OUT BIT_OR_IMPL)
return number,
member function ODCIAggregateIterate(self IN OUT BIT_OR_IMPL,
value IN number) return number,
member function ODCIAggregateTerminate(self IN OUT BIT_OR_IMPL,
returnValue OUT number, flags IN number) return number,
member function ODCIAggregateMerge(self IN OUT BIT_OR_IMPL,
ctx2 IN BIT_OR_IMPL) return number
)")

--------------------------------------------------------------------------------
(oci8po): -- Create BIT_OR aggregate function (requires Oracle 9i or
higher)

create or replace type BIT_OR_IMPL as object (
val NUMBER,
static function ODCIAggregateInitialize(sctx IN OUT BIT_OR_IMPL)
return number,
member function ODCIAggregateIterate(self IN OUT BIT_OR_IMPL,
value IN number) return number,
member function ODCIAggregateTerminate(self IN OUT BIT_OR_IMPL,
returnValue OUT number, flags IN number) return number,
member function ODCIAggregateMerge(self IN OUT BIT_OR_IMPL,
ctx2 IN BIT_OR_IMPL) return number
)
--------------------------------------------------------------------------------

Warning: ociexecute() [function.ociexecute]: OCIStmtExecute:
OCI_SUCCESS_WITH_INFO: ORA-24344: op鲡tion r鵳sie avec erreur de
compilation
in
C:\Inetpub\AlbumPhotos\gallery2\lib\adodb\drivers\adodb-oci8.inc.php
on line 869
24344: ORA-24344: op鲡tion r鵳sie avec erreur de compilation

ADODB_oci8po._Execute(-- Create BIT_OR
aggregate function (requires Oracle 9i or highe..., false) % line 833, file: adodb.inc.php
ADODB_oci8po.Execute(-- Create BIT_OR aggregate function
(requires Oracle 9i or highe...) % line
1716, file: DatabaseStorage.class
OracleDatabaseStorage._executeSqlFile(C:\Inetpub\AlbumPhotos\gallery2\modules\core\classes\GalleryStor...) % line 1524, file: DatabaseStorage.class
OracleDatabaseStorage.configureStore(core) % line 338, file: GalleryStorage.class
GalleryStorage.configureStore(core) % line 132, file: GalleryModule.class

realpath(C:\Inetpub\AlbumPhotos\gallery2\modules\core\classes/../../../)
oci8po error: [942: ORA-00942: Table ou vue inexistante
] in EXECUTE("
SELECT
g2_PluginMap.g_pluginId,
g2_PluginMap.g_active
FROM
g2_PluginMap
WHERE
g2_PluginMap.g_pluginType = ?
")

--------------------------------------------------------------------------------
(oci8po):
SELECT
g2_PluginMap.g_pluginId,
g2_PluginMap.g_active
FROM
g2_PluginMap
WHERE
g2_PluginMap.g_pluginType = ?
[ (0=>'module') ]
--------------------------------------------------------------------------------

Warning: ociexecute() [function.ociexecute]: OCIStmtExecute:
ORA-00942: Table ou vue inexistante
in
C:\Inetpub\AlbumPhotos\gallery2\lib\adodb\drivers\adodb-oci8.inc.php
on line 869
942: ORA-00942: Table ou vue inexistante

ADODB_oci8po._Execute(
SELECT
g2_PluginMap.g_pluginId,
..., Array[1]) % line 829, file: adodb.inc.php
ADODB_oci8po.Execute(
SELECT
g2_PluginMap.g_pluginId,
..., Array[1]) % line 1142, file: DatabaseStorage.class
OracleDatabaseStorage.search(
SELECT
[GalleryPluginMap::pluginId]..., Array[1],
Array[0]) % line 220, file: GalleryStorage.class
GalleryStorage.search(
SELECT
[GalleryPluginMap::pluginId]..., Array[1],
Array[0]) % line 206, file: Gallery.class
Gallery.search(
SELECT
[GalleryPluginMap::pluginId]..., Array[1]) % line 424, file: GalleryPluginHelper_simple.class

realpath(C:\Inetpub\AlbumPhotos\gallery2\modules\core\classes/../../../)

----

Gallery URL (optional):
Gallery version: 0.9.0
Webserver (with version): IIS5
Datatabase (with version): Oracle 9.2.0.1.0
PHP version (eg 4.2.1):5.0.4.4
phpinfo URL (optional):
Graphics Toolkit(s):
Operating system:Windows 2000 Server
Web browser/version:
G1 version (for migration bugs):

 
mindless
mindless's picture

Joined: 2004-01-04
Posts: 8601
Posted: Thu, 2005-04-07 18:17

search the forums for other topics about oracle and CreateBitOr.sql
if you can come up with a syntax for this file that works on your system, let us know.