Page MenuHomePhabricator

Installation - Warning: oci_fetch_all(): ORA-01002: fetch out of sequence
Closed, DeclinedPublic

Description

Author: jens.roebel

Description:
Hi

I have had similar problems as discussed elsewhere in this forum related to oci8 using Oracle 11g

These errors have now been solved by following a very detailed description which referred to modicications to the INTERWIKI table and also changes to the two functions removeIdentifierQuotes and isQuotedIdentifier.

I have more success with the installation.

Creating database user... done Creating tables... done Populating default interwiki table... done Initializing statistics... done Generating secret keys... done Creating administrator user account... done Creating main page with default content... Warning: oci_fetch_all(): ORA-01002: fetch out of sequence in C:\Apache2.2\htdocs\wiki\includes\db\DatabaseOracle.php on line 60 done

Thanks Roebel


Version: 1.22.6
Severity: normal

Details

Reference
bz66013

Event Timeline

bzimport raised the priority of this task from to Low.Nov 22 2014, 3:23 AM
bzimport set Reference to bz66013.
bzimport added a subscriber: Unknown Object (MLST).

(In reply to Jens Røbel from comment #0)

I have had similar problems as discussed elsewhere in this forum

Any link handy?

These errors have now been solved by following a very detailed description
which referred to modicications to the INTERWIKI table and also changes to
the two functions removeIdentifierQuotes and isQuotedIdentifier.

Do you have a link for that? Is that what this bug report is about?

Creating database user... done Creating tables... done Populating default
interwiki table... done Initializing statistics... done Generating secret
keys... done Creating administrator user account... done Creating main page
with default content... Warning: oci_fetch_all(): ORA-01002: fetch out of
sequence in C:\Apache2.2\htdocs\wiki\includes\db\DatabaseOracle.php on line
60 done

I assume this bug report is about this warning?:

Warning: oci_fetch_all(): ORA-01002: fetch out of
sequence in C:\Apache2.2\htdocs\wiki\includes\db\DatabaseOracle.php on line
60 done

Jens: Can you please answer comment 1?

jens.roebel wrote:

I have solved the issue by a work around.

The installation was done successfully on a version of Oracle Database 11g Express Edition installed on my local PC.

I have followed carefully detailed description which referred to modicications to the INTERWIKI table and also changes to the two functions removeIdentifierQuotes and isQuotedIdentifier.

Afterwards I exported all objects in the local wiki database base schema and imported it into our business Oracle environment.

It seems to run quite well now.

Thanks
Jens Roebel

Heads-up: As per RFC discussion in August 2019, the previously experimental support for using Oracle or MSSQL as database backends in MediaWiki core has been removed in MediaWiki 1.34, so this task might end up as declined in the future.

Heads-up: As per RFC discussion in August 2019, the previously experimental support for using Oracle or MSSQL as database backends in MediaWiki core has been removed in MediaWiki 1.34, so this task might end up as declined in the future.

No activity, declining.