Page MenuHomePhabricator

ORA-00936: With version 1.23 MW with Oracle database fails to connect to DB
Closed, ResolvedPublic

Description

Installing MediaWiki with an Oracle database fails after version 1.22.10. A fresh, completely extension free installation configured with:

MediaWiki 1.22.10 (66fcbb6)
PHP 5.3.17 (apache2handler)
Oracle 11.2.0.4.0

works.

As I'm tracking MW using Git, I did: $git checkout 1.23.0

Refreshing the MainPage results in:

Warning: strpos() expects parameter 1 to be string, object given in /u1/MediaWiki/includes/db/DatabaseOracle.php on line 1308 Warning: strpos() expects parameter 1 to be string, object given in /u1/MediaWiki/includes/db/DatabaseOracle.php on line 1304 Warning: substr() expects parameter 1 to be string, object given in /u1/MediaWiki/includes/db/DatabaseOracle.php on line 1304
A database query error has occurred. This may indicate a bug in the software.

Backtrace:

#0 /u1/MediaWiki/includes/db/DatabaseOracle.php(709): DatabaseOracle->reportQueryError('ORA-00936: miss...', 936, 'INSERT INTO /*Q...', 'DatabaseOracle:...')
#1 /u1/MediaWiki/includes/db/DatabaseOracle.php(576): DatabaseOracle->insertOneRow('l10n_cache', Array, 'LCStoreDB::set')
#2 /u1/MediaWiki/includes/cache/LocalisationCache.php(1229): DatabaseOracle->insert('l10n_cache', Array, 'LCStoreDB::set')
#3 /u1/MediaWiki/includes/cache/LocalisationCache.php(963): LCStoreDB->set('messages:nov', 'Nov')
#4 /u1/MediaWiki/includes/cache/LocalisationCache.php(452): LocalisationCache->recache('en')
#5 /u1/MediaWiki/includes/cache/LocalisationCache.php(326): LocalisationCache->initLanguage('en')
#6 /u1/MediaWiki/includes/cache/LocalisationCache.php(260): LocalisationCache->loadItem('en', 'specialPageAlia...')
#7 /u1/MediaWiki/languages/Language.php(3055): LocalisationCache->getItem('en', 'specialPageAlia...')
#8 /u1/MediaWiki/includes/specialpage/SpecialPageFactory.php(240): Language->getSpecialPageAliases()
#9 /u1/MediaWiki/includes/specialpage/SpecialPageFactory.php(277): SpecialPageFactory::getAliasList()
#10 /u1/MediaWiki/includes/Title.php(1009): SpecialPageFactory::resolveAlias('Version')
#11 /u1/MediaWiki/includes/Wiki.php(188): Title->isSpecial('Badtitle')
#12 /u1/MediaWiki/includes/Wiki.php(588): MediaWiki->performRequest()
#13 /u1/MediaWiki/includes/Wiki.php(447): MediaWiki->main()
#14 /u1/MediaWiki/index.php(46): MediaWiki->run()
#15 {main}


Version: 1.23.3
Severity: critical

Details

Reference
bz71251

Event Timeline

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

Thanks for taking the time to report this!

Please try with the latest stable version (MediaWiki 1.23.3) and report back.
The 1.23.x series has received some Oracle fixes if I remember correctly.

With 1.23.3 I receive the same error. I also receive this error with the master branch. It would seem 1.22.10 is the last working version with Oracle as the DB.

Same stacktrace as https://bugzilla.wikimedia.org/show_bug.cgi?id=68874 comment 1 hence marking as duplicate.

  • This bug has been marked as a duplicate of bug 68874 ***