Topic on Project:Support desk

Jump to navigation Jump to search
Balbitus (talkcontribs)

Hello everybody,

I have intalled mediawiki on my computer a few time ago. Using Easy PHP and the documentation, all works fine. Now my compagny says : "yeah this is good, we want to implement it but... we only have oracle server available"

So is it possible to put mediawiki using an oracle database (10g) on windows server 2008r2 or 2003

MaxSem (talkcontribs)

Yes, Oracle is supported. However, if the problem is about sysadmins not wanting to install another database server, or bureacuracy prohibiting them from doing that, you can use MediaWiki with SQLite - which requires no extra installation and is better supported.

Balbitus (talkcontribs)

Yeah it's the bureacuracy. In the end, they will give me a server with Windows Server 2008r2 and oracle 10g installed and then tell me : "ok now install mediawiki, customise it and full it". It's easy on my computer but I hope not make some mystakes on a running server (they are a lot of possibility that the server will have other databases on it for production)...

Csebits (talkcontribs)

Dear friend,

Here same i have installed mediawiki1.17 with oracle working fine but whenever i add extension like sementic mediawiki,external data, give some error. how can i remove the error. and search option also not working.

please give some suggestion..

error: databaseOracle:doQuery" database returned error "942:ORA-00942 table or view does not exist...

Raymond.herrera24 (talkcontribs)


I've the same exact problem, have you known the resolution?

Thank you.

Jasper Deng (talkcontribs)

Both of you probably did not run update.php: cd "C:/<path to MediaWiki>/maintenance"

"C:/<path to your PHP executable>/php.exe" update.php Ignore the DLL-related errors you may receive when doing this on Windows.

Raymond.herrera24 (talkcontribs)

I've ran it a couple of times but still i get the ora error when uploading files and the search feature just displays exact title queries

Jasper Deng (talkcontribs)

Sounds like you find a legitimate bug, since most people don't use Oracle for MediaWiki. A bug report can be filed at Bugzilla.

Raymond.herrera24 (talkcontribs)

is there an immediate fix for this? (talkcontribs)

Hi, maybe you have to change some query tables ... For example on oracle, table text does not exist, its replaced by pagecontent table. Ive installed mediawiki 1.19 with oracle 11gr2 instant client and sphinx search extension with unixodbc. All the queries in sphinx.conf are written for mysql db. It's not difficult to replace them with oracle db compliant queries (talkcontribs)

Hey guys, I had exactly the same problem, but found a first step to solve it:

The search relys on Oracle Text. This is why the wiki db user needs to have CTXAPP rights (can also be seen in file maintenance/oracle/user.sql):

SQL> grant CTXAPP to ...;

I ran into this problem, because I didn't use the wizard to create my user (which didn't work and I was too lazy to step into the reasons), but created it myself. After granting the above role, I had to manually rebuild the indexes - I hope this will work from scratch, if you add the role at the beginning.
Unfortunately I'm still unsatisfied, because the search only finds terms in lower case. Meaning you have to enter the search term in lower case, the results are case insensitive then...
Again to workaround this, I modified the line containg CONTAINS in includes/search/SearchOracle.php to surround $$searchon with LOWER:

return " CONTAINS($field, LOWER($searchon), 1) > 0 ";

Now it seems to find any search string, but I'll have to keep an eye on index rebuilding...

THOMALEXANDRE (talkcontribs)

I also have problem with Oracle 11, and mediawiki 1.20 When it tries to install the database and create the table some error appear ORA-02291: integrity, parent key problem.... (doesn't to copy the full message as the server is in hungarian) Anyone experimented this type of problem?

Ciencia Al Poder (talkcontribs)

ORA-02291 is a foreign key constraint violation . This probably shouldn't happen on a fresh install but most likely on an upgrade from an old version. Is this the case? The name of the foreign key would be very useful to know where it happens.

bugzilla:38916 lists all currently known issues with Oracle (see the Depends on field). If this bug is not there you should create a new one and mark it as blocker of bug 38916.

THOMALEXANDRE (talkcontribs)

Yes it happen with a brand new version (1.20), I think this is the foreign key id: WIKI_REVISION_FK2 (coming from C:\Inetpub\wwwroot\Mediawiki\includes\db\DatabaseOracle.php on line 965)

Ciencia Al Poder (talkcontribs)

THOMALEXANDRE, this issue seems to be the one reported at bugzilla:38411, but that bug was closed as "The actual problem reported by this bug was obviously a problem with DB", since the user said "Now its working fine". You may want to comment on that bug about your problem, or reopening it again.

Reply to "MediWiki with Oracle"