[Mediawiki-l] Fwd: Oracle Support for Mediawiki

[Sumana Harihareswara]

Please respond on the list and to Sebastian.  Thanks!

-------- Original Message --------
Subject: Oracle Support for Mediawiki
Date: Mon, 07 Nov 2011 15:26:38 +0800
From: Sebastian Ulbricht <sebastian.ulbricht at gmx.de>
To: sumanah at wikimedia.org

Hello Sumana,

i've got your email address from Markus Glaser because he thinks, you
could help me.
The company of Markus has a customer, which want's to run Mediawiki with
an Oracle DB.
It's my job to make the wiki running with this setup and i got a problem.

When is start the install process of Mediawiki 1.17, all seems to be okay.
All tables will be created at the database and finally, there comes an
error ORA-01722.

Restarting the installation finishes the installation process and the
localSettings.php will be created and offered to download.

The problem is, that the wiki is running fine but it has no articles on
this time.
When i try to create an article, there comes the following error-message:

Es ist ein Datenbankfehler aufgetreten. Der Grund kann ein
Programmierfehler sein. Die letzte Datenbankabfrage lautete:

    INSERT INTO "MWPAGE"

(page_id,page_namespace,page_title,page_counter,page_restrictions,page_is_redirect,page_is_new,page_random,page_touched,page_latest,page_len)
    VALUES (:page_id, :page_namespace, :page_title, :page_counter, NULL,
    :page_is_redirect, :page_is_new, :page_random, :page_touched,
    :page_latest, :page_len)

aus der Funktion "DatabaseOracle::insertOneRow". Die Datenbank meldete
den Fehler "1722: ORA-01722: Ungültige Zahl".

I'm not really sure, because i'm new to Oracle DB, but i think the
Trigger, created in the database build a wrong datatype.
Do you have any idea, what i could do to resolve this problem?
I'm really thankful for any help, i can get.

best regards
Sebastian Ulbricht