[SOLVED] TNS:no listener in adodb-oci8.inc.php on install

jmnovak

Joined: 2005-02-25
Posts: 16
Posted: Tue, 2005-03-01 17:00

On install getting the error:

Warning: ocinlogon(): _oci_open_server: ORA-12541: TNS:no listener in /www/gallery2/lib/adodb/drivers/adodb-oci8.inc.php on line 219
localhost: ORA-12541: TNS:no listener

Listener up and Apache can connect to DB no problem using other apps. PHP is compiled with OCI8 and Oracle.
<Please check the G2 FAQ (sticky topic in this forum) before posting!>
----

Gallery URL (optional):
Gallery version:vG2
Webserver Apache 1.3.33:
Datatabase 9.2.0.5:
PHP version 4.3.10:
phpinfo URL (optional):
Graphics Toolkit(s):
Operating system: SLES 7
Web browser/version: Mozilla 1.7.5
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Tue, 2005-03-01 17:40

This is in the installer, right?
Do you use some non-standard port for oracle?
 
jmnovak

Joined: 2005-02-25
Posts: 16
Posted: Tue, 2005-03-01 17:46

DB Port is on 1523
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Tue, 2005-03-01 18:01

mindless, do you have an idea why we don't have a "db port" setting in the installer?

usually, the db standard ports are defined in the php.ini. don't know if you also can tnsnames.ora files in the php.ini.
the thing is, that the adodb-oci8.inc.php driver tries to connect on port 1521 (a little more standard/default for oracle).
 
jmnovak

Joined: 2005-02-25
Posts: 16
Posted: Tue, 2005-03-01 18:18

Hmm...I do see odbc default entries in the php.ini file but nothing in the oci8 category.
 
mindless
mindless's picture

Joined: 2004-01-04
Posts: 8601
Posted: Tue, 2005-03-01 19:43

try servername:1523 in the server box of the installer.. does that work?
 
jmnovak

Joined: 2005-02-25
Posts: 16
Posted: Wed, 2005-03-02 18:57

I got a little bit further on this but now I have a whole bunch of errors:

See below:

Error (ERROR_STORAGE_FAILURE)

* in modules/core/classes/GalleryStorage/DatabaseStorage.class at line 1136 (gallerystatus::error)
* in modules/core/classes/GalleryStorage.class at line 220 (oracledatabasestorage::search)
* in modules/core/classes/Gallery.class at line 189 (gallerystorage::search)
* in modules/core/classes/helpers/GalleryPluginHelper_simple.class at line 424 (gallery::search)
* in modules/core/classes/helpers/GalleryPluginHelper_simple.class at line 301 (gallerypluginhelper_simple::fetchpluginlist)
* in modules/core/classes/GalleryCoreApi.class at line 262 (gallerypluginhelper_simple::fetchpluginstatus)
* in modules/core/classes/GalleryPlugin.class at line 136 (gallerycoreapi::fetchpluginstatus)
* in modules/core/classes/GalleryModule.class at line 275 (galleryplugin::activate)
* in install/steps/InstallCoreModuleStep.class at line 90 (coremodule::activate)
* in install/index.php at line 168 (installcoremodulestep::loadtemplatedata)

Debug Output:

file_exists(/www/gallery2/g2data//cache/entity)
file_exists(/www/gallery2/g2data//cache/layout)
file_exists(/www/gallery2/g2data//cache/module)
file_exists(/wwwgallery2/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(/www/gallery2/modules/core/classes/helpers/../../../../modules/core/module.inc)
realpath(/www/gallery2/modules/core/classes/../../..)
Binding text domain: modules_core ->
/www/gallery2/modules/core/locale
file_exists(/www/gallery2/modules/core/classes/GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle)
opendir(/www/gallery2/modules/core/classes/GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle)
readdir(Resource id #52)
readdir(Resource id #52)
readdir(Resource id #52)
readdir(Resource id #52)
readdir(Resource id #52)
readdir(Resource id #52)
readdir(Resource id #52)
readdir(Resource id #52)
readdir(Resource id #52)
readdir(Resource id #52)
readdir(Resource id #52)
readdir(Resource id #52)
readdir(Resource id #52)
readdir(Resource id #52)
readdir(Resource id #52)
readdir(Resource id #52)
readdir(Resource id #52)
readdir(Resource id #52)
readdir(Resource id #52)
readdir(Resource id #52)
readdir(Resource id #52)
readdir(Resource id #52)
readdir(Resource id #52)
readdir(Resource id #52)
readdir(Resource id #52)
readdir(Resource id #52)
readdir(Resource id #52)
readdir(Resource id #52)
readdir(Resource id #52)
readdir(Resource id #52)
readdir(Resource id #52)
readdir(Resource id #52)
readdir(Resource id #52)
readdir(Resource id #52)
readdir(Resource id #52)
readdir(Resource id #52)
readdir(Resource id #52)
readdir(Resource id #52)
readdir(Resource id #52)
readdir(Resource id #52)
readdir(Resource id #52)
readdir(Resource id #52)
readdir(Resource id #52)
readdir(Resource id #52)
closedir(Resource id #52)

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

fopen(/www/gallery2/modules/core/classes/GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle/Schema.sql,
r, 0)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)
fgets(Resource id #54, 4096)
feof(Resource id #54)

(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 error: [955: ORA-00955: name is already used by an existing object
] in EXECUTE("CREATE SEQUENCE g2_SequenceLock START WITH 1")

(oci8po): CREATE SEQUENCE g2_SequenceLock START WITH 1

Warning: ociexecute(): OCIStmtExecute: ORA-00955: name is already
used by an existing object
in
/www/gallery2/lib/adodb/drivers/adodb-oci8.inc.php
on line 869

955: ORA-00955: name is already used by an existing object

adodb_oci8po._execute(CREATE SEQUENCE
g2_SequenceLock START WITH 1, false) %
line 833, file: adodb.inc.php
adodb_oci8po.execute(CREATE SEQUENCE g2_SequenceLock START
WITH 1) % line 893, file: adodb.inc.php
adodb_oci8po.createsequence(g2_SequenceLock) % line 1483, file: DatabaseStorage.class
oracledatabasestorage.configurestore(core) % line 338, file: GalleryStorage.class
gallerystorage.configurestore(core) % line 132, file: GalleryModule.class

realpath(/www/gallery2/modules/core/classes/../../../)
oci8po error: [942: ORA-00942: table or view does not exist
] in EXECUTE("
SELECT
g2_FactoryMap.g_classType,
g2_FactoryMap.g_className,
g2_FactoryMap.g_implId,
g2_FactoryMap.g_implPath,
g2_FactoryMap.g_hints
FROM
g2_FactoryMap
ORDER BY
g2_FactoryMap.g_orderWeight ASC
")

(oci8po):
SELECT
g2_FactoryMap.g_classType,
g2_FactoryMap.g_className,
g2_FactoryMap.g_implId,
g2_FactoryMap.g_implPath,
g2_FactoryMap.g_hints
FROM
g2_FactoryMap
ORDER BY
g2_FactoryMap.g_orderWeight ASC

Warning: ociexecute(): OCIStmtExecute: ORA-00942: table or view
does not exist
in
/www/gallery2/lib/adodb/drivers/adodb-oci8.inc.php
on line 869

942: ORA-00942: table or view does not exist

adodb_oci8po._execute(
SELECT
g2_FactoryMap.g_classT..., false) % line 833, file: adodb.inc.php
adodb_oci8po.execute(
SELECT
g2_FactoryMap.g_classT..., Array[0]) % line 1128, file: DatabaseStorage.class
oracledatabasestorage.search(
SELECT
[GalleryFactoryMap::cl..., Array[0],
Array[0]) % line 220, file: GalleryStorage.class
gallerystorage.search(
SELECT
[GalleryFactoryMap::cl..., Array[0],
Array[0]) % line 189, file: Gallery.class
gallery.search(
SELECT
[GalleryFactoryMap::cl...) % line 99, file: GalleryFactoryHelper_simple.class

oci8po error: [942: ORA-00942: table or view does not exist
] 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(): OCIStmtExecute: ORA-00942: table or view
does not exist
in
/www/gallery2/lib/adodb/drivers/adodb-oci8.inc.php
on line 869

942: ORA-00942: table or view does not exist

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 1128, 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 189,
file: Gallery.class
gallery.search(
SELECT
[GalleryPluginMap::pluginId],
..., Array[1]) % line 424, file: GalleryPluginHelper_simple.class

realpath(/www/gallery2/modules/core/classes/../../../)
oci8po error: [942: ORA-00942: table or view does not exist
] in EXECUTE("
SELECT
g2_FactoryMap.g_classType,
g2_FactoryMap.g_className,
g2_FactoryMap.g_implId,
g2_FactoryMap.g_implPath,
g2_FactoryMap.g_hints
FROM
g2_FactoryMap
ORDER BY
g2_FactoryMap.g_orderWeight ASC
")

(oci8po):
SELECT
g2_FactoryMap.g_classType,
g2_FactoryMap.g_className,
g2_FactoryMap.g_implId,
g2_FactoryMap.g_implPath,
g2_FactoryMap.g_hints
FROM
g2_FactoryMap
ORDER BY
g2_FactoryMap.g_orderWeight ASC

Warning: ociexecute(): OCIStmtExecute: ORA-00942: table or view
does not exist
in
/www/gallery2/lib/adodb/drivers/adodb-oci8.inc.php
on line 869

942: ORA-00942: table or view does not exist

adodb_oci8po._execute(
SELECT
g2_FactoryMap.g_classT..., false) % line 833, file: adodb.inc.php
adodb_oci8po.execute(
SELECT
g2_FactoryMap.g_classT..., Array[0]) % line 1128, file: DatabaseStorage.class
oracledatabasestorage.search(
SELECT
[GalleryFactoryMap::cl..., Array[0],
Array[0]) % line 220, file: GalleryStorage.class
gallerystorage.search(
SELECT
[GalleryFactoryMap::cl..., Array[0],
Array[0]) % line 189, file: Gallery.class
gallery.search(
SELECT
[GalleryFactoryMap::cl...) % line 99, file: GalleryFactoryHelper_simple.class

:o
 
mindless
mindless's picture

Joined: 2004-01-04
Posts: 8601
Posted: Wed, 2005-03-02 21:09

please try again, doing a clean install. make sure the database doesn't have any G2 tables or sequences before you start.
 
jmnovak

Joined: 2005-02-25
Posts: 16
Posted: Wed, 2005-03-02 23:14

Yep...tried that....dropped g2 tables and sequences, did clean install and still get the same message.
 
mindless
mindless's picture

Joined: 2004-01-04
Posts: 8601
Posted: Thu, 2005-03-03 00:47

huh? the debug output clearly shows the error from oracle... i've never heard of our code trying to create sequences twice.. why would this happen?

Please confirm, you see:
oci8po error: [955: ORA-00955: name is already used by an existing object
] in EXECUTE("CREATE SEQUENCE g2_SequenceLock START WITH 1")
when starting with a clean database?
 
jmnovak

Joined: 2005-02-25
Posts: 16
Posted: Thu, 2005-03-03 05:25

Ok slughtly different since there also was an objct type that existed which i also dropped but still get familiar mesage:

rror (ERROR_STORAGE_FAILURE)

* in modules/core/classes/GalleryStorage/DatabaseStorage.class at line 1136 (gallerystatus::error)
* in modules/core/classes/GalleryStorage.class at line 220 (oracledatabasestorage::search)
* in modules/core/classes/Gallery.class at line 189 (gallerystorage::search)
* in modules/core/classes/helpers/GalleryPluginHelper_simple.class at line 424 (gallery::search)
* in modules/core/classes/helpers/GalleryPluginHelper_simple.class at line 301 (gallerypluginhelper_simple::fetchpluginlist)
* in modules/core/classes/GalleryCoreApi.class at line 262 (gallerypluginhelper_simple::fetchpluginstatus)
* in modules/core/classes/GalleryPlugin.class at line 136 (gallerycoreapi::fetchpluginstatus)
* in modules/core/classes/GalleryModule.class at line 275 (galleryplugin::activate)
* in install/steps/InstallCoreModuleStep.class at line 90 (coremodule::activate)
* in install/index.php at line 168 (installcoremodulestep::loadtemplatedata)

Debug Output:

file_exists(/www/sheffieldave.com/gallery2/g2data//cache/entity)
file_exists(/www/sheffieldave.com/gallery2/g2data//cache/layout)
file_exists(/www/sheffieldave.com/gallery2/g2data//cache/module)
file_exists(/www/sheffieldave.com/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(/www/sheffieldave.com/gallery2/modules/core/classes/helpers/../../../../modules/core/module.inc)
realpath(/www/sheffieldave.com/gallery2/modules/core/classes/../../..)
Binding text domain: modules_core ->
/www/sheffieldave.com/gallery2/modules/core/locale
file_exists(/www/sheffieldave.com/gallery2/modules/core/classes/GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle)
opendir(/www/sheffieldave.com/gallery2/modules/core/classes/GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
closedir(Resource id #54)

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

fopen(/www/sheffieldave.com/gallery2/modules/core/classes/GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle/Schema.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)

(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(/www/sheffieldave.com/gallery2/modules/core/classes/GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle/CreateBitOr.sql,
r, 0)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)

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

(oci8po): create or replace type body BIT_OR_IMPL is
static function ODCIAggregateInitialize(sctx IN OUT BIT_OR_IMPL)
return number is
begin
sctx := BIT_OR_IMPL(0);
return ODCIConst.Success;
end;
member function ODCIAggregateIterate(self IN OUT BIT_OR_IMPL,
value IN number) return number is
begin
self.val := (self.val + value) - BitAND(self.val, value);
return ODCIConst.Success;
end;
member function ODCIAggregateTerminate(self IN OUT BIT_OR_IMPL,
returnValue OUT number, flags IN number) return number is
begin
returnValue := self.val;
return ODCIConst.Success;
end;
member function ODCIAggregateMerge(self IN OUT BIT_OR_IMPL,
ctx2 IN BIT_OR_IMPL) return number is
begin
self.val := (self.val + ctx2.val) - BitAND(self.val, ctx2.val);
return ODCIConst.Success;
end;
end;

(oci8po): create or replace function BIT_OR(input number) return number
parallel_enable aggregate using BIT_OR_IMPL;

oci8po error: [900: ORA-00900: invalid SQL statement
] in EXECUTE("-- Extra semicolons above ensure executed statements
includes a semicolon at the end
-- (one is stripped off when this file is split into multiple blocks)")

(oci8po): -- Extra semicolons above ensure executed statements includes a
semicolon at the end
-- (one is stripped off when this file is split into multiple blocks)

Warning: ociexecute(): OCIStmtExecute: ORA-00900: invalid SQL
statement
in
/www/sheffieldave.com/gallery2/lib/adodb/drivers/adodb-oci8.inc.php
on line 869

900: ORA-00900: invalid SQL statement

adodb_oci8po._execute(-- Extra semicolons above
ensure executed statements includes a ..., false) % line 833, file: adodb.inc.php
adodb_oci8po.execute(-- Extra semicolons above ensure
executed statements includes a ...) %
line 1702, file: DatabaseStorage.class
oracledatabasestorage._executesqlfile(/www/sheffieldave.com/gallery2/modules/core/classes/GalleryStora...) % line 1511, file: DatabaseStorage.class
oracledatabasestorage.configurestore(core) % line 338, file: GalleryStorage.class
gallerystorage.configurestore(core) % line 132, file: GalleryModule.class

realpath(/www/sheffieldave.com/gallery2/modules/core/classes/../../../)
oci8po error: [942: ORA-00942: table or view does not exist
] in EXECUTE("
SELECT
g2_FactoryMap.g_classType,
g2_FactoryMap.g_className,
g2_FactoryMap.g_implId,
g2_FactoryMap.g_implPath,
g2_FactoryMap.g_hints
FROM
g2_FactoryMap
ORDER BY
g2_FactoryMap.g_orderWeight ASC
")

(oci8po):
SELECT
g2_FactoryMap.g_classType,
g2_FactoryMap.g_className,
g2_FactoryMap.g_implId,
g2_FactoryMap.g_implPath,
g2_FactoryMap.g_hints
FROM
g2_FactoryMap
ORDER BY
g2_FactoryMap.g_orderWeight ASC

Warning: ociexecute(): OCIStmtExecute: ORA-00942: table or view
does not exist
in
/www/sheffieldave.com/gallery2/lib/adodb/drivers/adodb-oci8.inc.php
on line 869

942: ORA-00942: table or view does not exist

adodb_oci8po._execute(
SELECT
g2_FactoryMap.g_classT..., false) % line 833, file: adodb.inc.php
adodb_oci8po.execute(
SELECT
g2_FactoryMap.g_classT..., Array[0]) % line 1128, file: DatabaseStorage.class
oracledatabasestorage.search(
SELECT
[GalleryFactoryMap::cl..., Array[0],
Array[0]) % line 220, file: GalleryStorage.class
gallerystorage.search(
SELECT
[GalleryFactoryMap::cl..., Array[0],
Array[0]) % line 189, file: Gallery.class
gallery.search(
SELECT
[GalleryFactoryMap::cl...) % line 99, file: GalleryFactoryHelper_simple.class

oci8po error: [942: ORA-00942: table or view does not exist
] 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(): OCIStmtExecute: ORA-00942: table or view
does not exist
in
/www/sheffieldave.com/gallery2/lib/adodb/drivers/adodb-oci8.inc.php
on line 869

942: ORA-00942: table or view does not exist

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 1128, 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 189,
file: Gallery.class
gallery.search(
SELECT
[GalleryPluginMap::pluginId],
..., Array[1]) % line 424, file: GalleryPluginHelper_simple.class

realpath(/www/sheffieldave.com/gallery2/modules/core/classes/../../../)
oci8po error: [942: ORA-00942: table or view does not exist
] in EXECUTE("
SELECT
g2_FactoryMap.g_classType,
g2_FactoryMap.g_className,
g2_FactoryMap.g_implId,
g2_FactoryMap.g_implPath,
g2_FactoryMap.g_hints
FROM
g2_FactoryMap
ORDER BY
g2_FactoryMap.g_orderWeight ASC
")

(oci8po):
SELECT
g2_FactoryMap.g_classType,
g2_FactoryMap.g_className,
g2_FactoryMap.g_implId,
g2_FactoryMap.g_implPath,
g2_FactoryMap.g_hints
FROM
g2_FactoryMap
ORDER BY
g2_FactoryMap.g_orderWeight ASC

Warning: ociexecute(): OCIStmtExecute: ORA-00942: table or view
does not exist
in
/www/sheffieldave.com/gallery2/lib/adodb/drivers/adodb-oci8.inc.php
on line 869

942: ORA-00942: table or view does not exist

adodb_oci8po._execute(
SELECT
g2_FactoryMap.g_classT..., false) % line 833, file: adodb.inc.php
adodb_oci8po.execute(
SELECT
g2_FactoryMap.g_classT..., Array[0]) % line 1128, file: DatabaseStorage.class
oracledatabasestorage.search(
SELECT
[GalleryFactoryMap::cl..., Array[0],
Array[0]) % line 220, file: GalleryStorage.class
gallerystorage.search(
SELECT
[GalleryFactoryMap::cl..., Array[0],
Array[0]) % line 189, file: Gallery.class
gallery.search(
SELECT
[GalleryFactoryMap::cl...) % line 99, file: GalleryFactoryHelper_simple.class
 
mindless
mindless's picture

Joined: 2004-01-04
Posts: 8601
Posted: Thu, 2005-03-03 06:57

ay, what is up with that.

Quote:
oci8po error: [900: ORA-00900: invalid SQL statement
] in EXECUTE("-- Extra semicolons above ensure executed statements
includes a semicolon at the end
-- (one is stripped off when this file is split into multiple blocks)")

<sigh>
so, first check that function BIT_OR was created succesfully (from the above it looks like it was).. then drop everything (again) and retry after making this change to modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle/CreateBitOr.sql
(i think that's the filename)
Remove those two lines starting with --
it's just a comment.. i don't know why it's causing an error.
 
jmnovak

Joined: 2005-02-25
Posts: 16
Posted: Thu, 2005-03-03 15:38

Hi Mindless,

Ok...removed all comments from CreateBitOr.sql (both at the beginning and at the end) and ended up with the following errors:

Error (ERROR_STORAGE_FAILURE)

* in modules/core/classes/GalleryStorage/DatabaseStorage.class at line 1136 (gallerystatus::error)
* in modules/core/classes/GalleryStorage.class at line 220 (oracledatabasestorage::search)
* in modules/core/classes/Gallery.class at line 189 (gallerystorage::search)
* in modules/core/classes/helpers/GalleryPluginHelper_simple.class at line 424 (gallery::search)
* in modules/core/classes/helpers/GalleryPluginHelper_simple.class at line 301 (gallerypluginhelper_simple::fetchpluginlist)
* in modules/core/classes/GalleryCoreApi.class at line 262 (gallerypluginhelper_simple::fetchpluginstatus)
* in modules/core/classes/GalleryPlugin.class at line 136 (gallerycoreapi::fetchpluginstatus)
* in modules/core/classes/GalleryModule.class at line 275 (galleryplugin::activate)
* in install/steps/InstallCoreModuleStep.class at line 90 (coremodule::activate)
* in install/index.php at line 168 (installcoremodulestep::loadtemplatedata)

Debug Output:

file_exists(/www/gallery2/g2data//cache/entity)
file_exists(/www/gallery2/g2data//cache/layout)
file_exists(/www/gallery2/g2data//cache/module)
file_exists(/www/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(/www/gallery2/modules/core/classes/helpers/../../../../modules/core/module.inc)
realpath(/www/gallery2/modules/core/classes/../../..)
Binding text domain: modules_core ->
/www/gallery2/modules/core/locale
file_exists(/www/gallery2/modules/core/classes/GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle)
opendir(/www/gallery2/modules/core/classes/GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
readdir(Resource id #54)
closedir(Resource id #54)

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

fopen(/www/gallery2/modules/core/classes/GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle/Schema.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)

(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(/www/gallery2/modules/core/classes/GalleryStorage/../../../../modules/core/classes/GalleryStorage/DatabaseStorage/schema/platform/oracle/CreateBitOr.sql,
r, 0)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)
fgets(Resource id #63, 4096)
feof(Resource id #63)

(oci8po): 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 or replace type body BIT_OR_IMPL is
static function ODCIAggregateInitialize(sctx IN OUT BIT_OR_IMPL)
return number is
begin
sctx := BIT_OR_IMPL(0);
return ODCIConst.Success;
end;
member function ODCIAggregateIterate(self IN OUT BIT_OR_IMPL,
value IN number) return number is
begin
self.val := (self.val + value) - BitAND(self.val, value);
return ODCIConst.Success;
end;
member function ODCIAggregateTerminate(self IN OUT BIT_OR_IMPL,
returnValue OUT number, flags IN number) return number is
begin
returnValue := self.val;
return ODCIConst.Success;
end;
member function ODCIAggregateMerge(self IN OUT BIT_OR_IMPL,
ctx2 IN BIT_OR_IMPL) return number is
begin
self.val := (self.val + ctx2.val) - BitAND(self.val, ctx2.val);
return ODCIConst.Success;
end;
end;

oci8po error: [24344: ORA-24344: success with compilation error
] in EXECUTE("create or replace function BIT_OR(input number) return
number
parallel_enable aggregate using BIT_OR_IMPL;;")

(oci8po): create or replace function BIT_OR(input number) return number
parallel_enable aggregate using BIT_OR_IMPL;;

Warning: ociexecute(): OCIStmtExecute: OCI_SUCCESS_WITH_INFO:
ORA-24344: success with compilation error
in
/www/gallery2/lib/adodb/drivers/adodb-oci8.inc.php
on line 869

24344: ORA-24344: success with compilation error

adodb_oci8po._execute(create or replace
function BIT_OR(input number) return number
..., false) % line 833, file: adodb.inc.php
adodb_oci8po.execute(create or replace function BIT_OR(input
number) return number
...) % line 1702, file: DatabaseStorage.class
oracledatabasestorage._executesqlfile(/www/gallery2/modules/core/classes/GalleryStora...) % line 1511, file: DatabaseStorage.class
oracledatabasestorage.configurestore(core) % line 338, file: GalleryStorage.class
gallerystorage.configurestore(core) % line 132, file: GalleryModule.class

realpath(/www/gallery2/modules/core/classes/../../../)
oci8po error: [942: ORA-00942: table or view does not exist
] in EXECUTE("
SELECT
g2_FactoryMap.g_classType,
g2_FactoryMap.g_className,
g2_FactoryMap.g_implId,
g2_FactoryMap.g_implPath,
g2_FactoryMap.g_hints
FROM
g2_FactoryMap
ORDER BY
g2_FactoryMap.g_orderWeight ASC
")

(oci8po):
SELECT
g2_FactoryMap.g_classType,
g2_FactoryMap.g_className,
g2_FactoryMap.g_implId,
g2_FactoryMap.g_implPath,
g2_FactoryMap.g_hints
FROM
g2_FactoryMap
ORDER BY
g2_FactoryMap.g_orderWeight ASC

Warning: ociexecute(): OCIStmtExecute: ORA-00942: table or view
does not exist
in
/www/gallery2/lib/adodb/drivers/adodb-oci8.inc.php
on line 869

942: ORA-00942: table or view does not exist

adodb_oci8po._execute(
SELECT
g2_FactoryMap.g_classT..., false) % line 833, file: adodb.inc.php
adodb_oci8po.execute(
SELECT
g2_FactoryMap.g_classT..., Array[0]) % line 1128, file: DatabaseStorage.class
oracledatabasestorage.search(
SELECT
[GalleryFactoryMap::cl..., Array[0],
Array[0]) % line 220, file: GalleryStorage.class
gallerystorage.search(
SELECT
[GalleryFactoryMap::cl..., Array[0],
Array[0]) % line 189, file: Gallery.class
gallery.search(
SELECT
[GalleryFactoryMap::cl...) % line 99, file: GalleryFactoryHelper_simple.class

oci8po error: [942: ORA-00942: table or view does not exist
] 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(): OCIStmtExecute: ORA-00942: table or view
does not exist
in
/www/gallery2/lib/adodb/drivers/adodb-oci8.inc.php
on line 869

942: ORA-00942: table or view does not exist

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 1128, 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 189,
file: Gallery.class
gallery.search(
SELECT
[GalleryPluginMap::pluginId],
..., Array[1]) % line 424, file: GalleryPluginHelper_simple.class

realpath(/www/gallery2/modules/core/classes/../../../)
oci8po error: [942: ORA-00942: table or view does not exist
] in EXECUTE("
SELECT
g2_FactoryMap.g_classType,
g2_FactoryMap.g_className,
g2_FactoryMap.g_implId,
g2_FactoryMap.g_implPath,
g2_FactoryMap.g_hints
FROM
g2_FactoryMap
ORDER BY
g2_FactoryMap.g_orderWeight ASC
")

(oci8po):
SELECT
g2_FactoryMap.g_classType,
g2_FactoryMap.g_className,
g2_FactoryMap.g_implId,
g2_FactoryMap.g_implPath,
g2_FactoryMap.g_hints
FROM
g2_FactoryMap
ORDER BY
g2_FactoryMap.g_orderWeight ASC

Warning: ociexecute(): OCIStmtExecute: ORA-00942: table or view
does not exist
in
/www/gallery2/lib/adodb/drivers/adodb-oci8.inc.php
on line 869

942: ORA-00942: table or view does not exist

adodb_oci8po._execute(
SELECT
g2_FactoryMap.g_classT..., false) % line 833, file: adodb.inc.php
adodb_oci8po.execute(
SELECT
g2_FactoryMap.g_classT..., Array[0]) % line 1128, file: DatabaseStorage.class
oracledatabasestorage.search(
SELECT
[GalleryFactoryMap::cl..., Array[0],
Array[0]) % line 220, file: GalleryStorage.class
gallerystorage.search(
SELECT
[GalleryFactoryMap::cl..., Array[0],
Array[0]) % line 189, file: Gallery.class
gallery.search(
SELECT
[GalleryFactoryMap::cl...) % line 99, file: GalleryFactoryHelper_simple.class

Any ideas?
 
mindless
mindless's picture

Joined: 2004-01-04
Posts: 8601
Posted: Thu, 2005-03-03 15:52

try taking off one of the semicolons at the end of the file.
 
jmnovak

Joined: 2005-02-25
Posts: 16
Posted: Thu, 2005-03-03 16:11

Yep...tried that...even tried executing in Toad as a script...it executes but executes with compilation errors...Somehow, I think, is adodb-oci8.inc.php can't seem to recognize this DB error. What do you think?
 
mindless
mindless's picture

Joined: 2004-01-04
Posts: 8601
Posted: Thu, 2005-03-03 16:26

select * from user_errors;
what do you get?

note that the previous run before you removed the -- comments that line seemed to execute ok (and i asked you to verify the function was created successfully).. the debug output showed one semicolon on that statement.. the run after removing the comments showed 2 semicolons.. what did you see after removing one? the log shows one semicolon but still says it is an error?
 
jmnovak

Joined: 2005-02-25
Posts: 16
Posted: Thu, 2005-03-03 16:43

SQL> select * from user_errors;

NAME TYPE SEQUENCE LINE POSITION
------------------------------ ------------ ---------- ---------- ----------
TEXT
--------------------------------------------------------------------------------
BIT_OR FUNCTION 1 2 47
PLS-00103: Encountered the symbol ";"

BIT_OR_IMPL TYPE BODY 1 28 1
PLS-00103: Encountered the symbol "CREATE" when expecting one of the following:

;
 
mindless
mindless's picture

Joined: 2004-01-04
Posts: 8601
Posted: Thu, 2005-03-03 16:54

maybe change the other ;; to just ; ??
i really don't know when oracle wants a semicolon in these statements or not.. seems inconsistent across oracle versions and/or platforms.. experiment with semicolons and figure out what works, then let us know.
(alternatively, if you just want to get it working.. drop everything, manually enter the CreateBitOr.sql commands into sqlplus, rename CreateBitOr.sql to not end in .sql and rerun the installer)
 
jmnovak

Joined: 2005-02-25
Posts: 16
Posted: Thu, 2005-03-03 17:36

Ok...I've tried experimenting with this...It looks like the issue is the part of the script:

create or replace function BIT_OR(input number) return number
parallel_enable aggregate using BIT_OR_IMPL;

which simply will not compile.

forgive my lack of technical abilities but this function is referencing the object type?

I have therefore tried your alternative solution which was to rename the sql statement and have gotten past the database table creation but now can not launch G2 and am getting the following errors:

Error (ERROR_STORAGE_FAILURE):
in file modules/core/classes/GalleryStorage/DatabaseStorage.class at line 1136 (gallerystatus::error)
in file modules/core/classes/GalleryStorage.class at line 220 (oracledatabasestorage::search)
in file modules/core/classes/Gallery.class at line 189 (gallerystorage::search)
in file modules/core/classes/helpers/GalleryPermissionHelper_medium.class at line 86 (gallery::search)
in file modules/core/classes/GalleryCoreApi.class at line 540 (gallerypermissionhelper_medium::fetchpermissionsforitems)
in file modules/core/classes/helpers/GalleryPermissionHelper_medium.class at line 251 (gallerycoreapi::fetchpermissionsforitems)
in file modules/core/classes/GalleryCoreApi.class at line 552 (gallerypermissionhelper_medium::getpermissions)
in file modules/comment/module.inc at line 127 (gallerycoreapi::getpermissions)
in file modules/core/classes/GalleryLayout.class at line 721 (commentmodule::getitemlinks)
in file layouts/matrix/layout.inc at line 263 (matrixlayout::loadlayouttemplate)
in file layouts/matrix/layout.inc at line 155 (matrixlayout::_loadalbumtemplate)
in file modules/core/ShowItem.inc at line 136 (matrixlayout::loadtemplate)
in file modules/core/classes/GalleryView.class at line 246 (showitemview::loadtemplate)
in file main.php at line 286 (showitemview::doloadtemplate)
in file main.php at line 46
in file main.php at line 39

I'm completely at a dead end.
 
jmnovak

Joined: 2005-02-25
Posts: 16
Posted: Thu, 2005-03-03 18:11

ok..

I've managed to compile the function now I am getting errors on the type body:

create or replace type body BIT_OR_IMPL is
static function ODCIAggregateInitialize(sctx IN OUT BIT_OR_IMPL)
return number is
begin
sctx := BIT_OR_IMPL(0);
return ODCIConst.Success;
end;
member function ODCIAggregateIterate(self IN OUT BIT_OR_IMPL,
value IN number) return number is
begin
self.val := (self.val + value) - BitAND(self.val, value);
return ODCIConst.Success
member function ODCIAggregateTerminate(self IN OUT BIT_OR_IMPL,
returnValue OUT number, flags IN number) return number is
begin
returnValue := self.val;
return ODCIConst.Success;
end;
member function ODCIAggregateMerge(self IN OUT BIT_OR_IMPL,
ctx2 IN BIT_OR_IMPL) return number is
begin
self.val := (self.val + ctx2.val) - BitAND(self.val, ctx2.val);
return ODCIConst.Success;
end;

where the error is:

PLS-00103: Encountered the symbol "MEMBER" when expecting one of the following:

. ( * @ % & = - + ; < / > at in is mod not rem
<an exponent (**)> <> or != or ~= >= <= <> and or like
between ||
 
jmnovak

Joined: 2005-02-25
Posts: 16
Posted: Thu, 2005-03-03 18:27

ok...

I think I've corrected the code for the type body...

for 9.2.0.X the correct format should be:

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

CREATE OR REPLACE
type body BIT_OR_IMPL is
static function ODCIAggregateInitialize(sctx IN OUT BIT_OR_IMPL)
return number is
begin
sctx := BIT_OR_IMPL(0);
return ODCIConst.Success;
end;
member function ODCIAggregateIterate(self IN OUT BIT_OR_IMPL,
value IN number) return number is
begin
self.val := (self.val + value) - BitAND(self.val, value);
return ODCIConst.Success;
end;
member function ODCIAggregateTerminate(self IN OUT BIT_OR_IMPL,
returnValue OUT number, flags IN number) return number is
begin
returnValue := self.val;
return ODCIConst.Success;
end;
member function ODCIAggregateMerge(self IN OUT BIT_OR_IMPL,
ctx2 IN BIT_OR_IMPL) return number is
begin
self.val := (self.val + ctx2.val) - BitAND(self.val, ctx2.val);
return ODCIConst.Success;
end;
end;
/
 
jmnovak

Joined: 2005-02-25
Posts: 16
Posted: Thu, 2005-03-03 18:38

forgot to mention....

the function BIT_OR needed to be compiled using

alter function <schema_name>.BIT_OR compile;

the code is:

CREATE OR REPLACE function BIT_OR(input number) return number
parallel_enable aggregate using BIT_OR_IMPL;
 
mindless
mindless's picture

Joined: 2004-01-04
Posts: 8601
Posted: Thu, 2005-03-03 21:27

did you change anything in BIT_OR_IMPL? i don't see any changes.. looks like you just used "/" in a couple places to meet sqlplus syntax. i don't think you can pass "/" via a sql connection from php.. or did you get the above listing to work via the G2 installer?
you only needed the alter function statement because you got errors initially, right? that command just triggers a recompile..
FYI, the file currently in CVS works as-is with oracle 9.2.0.2 on solaris.
 
jmnovak

Joined: 2005-02-25
Posts: 16
Posted: Thu, 2005-03-03 21:50

Yes...It looks like it was the extra semicolon at the end of the type body create which was causing the whole thing to stall.

This is running on a SuSE Linux Enterprise Server w/ Oracle 9.2.0.6

Performance isn't as good as I hoped compared to a mysql db. Thumbnails take a while to come up. Any ideas to improve performance?
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Thu, 2005-03-03 23:30

ïf you have full control over the box, install a php accelerator (cache), like PHPA or turk mm cache. G2 takes a lot of advantage of these php accelerators.
 
jmnovak

Joined: 2005-02-25
Posts: 16
Posted: Fri, 2005-03-04 15:38

wow! Great recommendation! I've tried PHPA and it works great w/oracle.
 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Fri, 2005-03-04 15:49

sidenote: activate PHPA after building the site / changing files, webdevelopment. during development, PHPA rather introduces strange errors because it has still old versions of some php source files in cache etc. i had some strange issues :)
 
mindless
mindless's picture

Joined: 2004-01-04
Posts: 8601
Posted: Fri, 2005-03-04 16:10

jmnovak, if you're willing to test out the installer a bit more it would be great to figure out what syntax for CreateBitOr.sql will work on most oracle setups. I'm thinking of moving the comment at the end of the file up with the comment at the top. Then maybe change the last ;; to ; if it is needed..