Last modified: 2014-07-31 19:32:23 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T70877, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 68877 - Has syntax errors when integrating with Oracle backend
Has syntax errors when integrating with Oracle backend
Status: RESOLVED DUPLICATE of bug 68874
Product: MediaWiki
Classification: Unclassified
Database (Other open bugs)
1.23.1
PC All
: Unprioritized blocker (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks: oracle
  Show dependency treegraph
 
Reported: 2014-07-30 21:07 UTC by Arjun
Modified: 2014-07-31 19:32 UTC (History)
1 user (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Arjun 2014-07-30 21:07:03 UTC
I've been trying to find answers to this bug but I'm simply not getting anywhere. I'm using an oracle backend and it installs correctly. But the minute I access index.php it gives me the following error (This is after enabling sqlerrors in my LocalSettings.php file)

A database query error has occurred. This may indicate a bug in the software.

Query:
INSERT INTO /*Q*/L10N_CACHE (lc_lang,lc_key,lc_value) VALUES (:lc_lang, :lc_key, )
Function: DatabaseOracle::insertOneRow
Error: 936 ORA-00936: missing expression
I ran the update.php in the maintenance folder and it updated fine.

These are the results which I get when I run eval.php and the following commands:

var_dump( $wgContLang );
var_dump( Language::factory( 'da' ) );

object(Language)#7 (14) {
  ["mConverter"]=>
  object(FakeConverter)#8 (1) {
    ["mLang"]=>
    *RECURSION*
  }
  ["mVariants"]=>
  NULL
  ["mCode"]=>
  string(2) "en"
  ["mLoaded"]=>
  bool(false)
  ["mMagicExtensions"]=>
  array(0) {
  }
  ["mMagicHookDone"]=>
  bool(false)
  ["mHtmlCode":"Language":private]=>
  NULL
  ["mParentLanguage":"Language":private]=>
  bool(false)
  ["dateFormatStrings"]=>
  array(0) {
  }
  ["mExtendedSpecialPageAliases"]=>
  NULL
  ["namespaceNames":protected]=>
  NULL
  ["mNamespaceIds":protected]=>
  NULL
  ["namespaceAliases":protected]=>
  NULL
  ["transformData"]=>
  array(0) {
  }
}

PHP Warning:  strpos() expects parameter 1 to be string, object given in /var/www/html/devinsample/mediawiki-1.23.1/includes/db/DatabaseOracle.php on line 1308
PHP Warning:  strpos() expects parameter 1 to be string, object given in /var/www/html/devinsample/mediawiki-1.23.1/includes/db/DatabaseOracle.php on line 1304
PHP Warning:  substr() expects parameter 1 to be string, object given in /var/www/html/devinsample/mediawiki-1.23.1/includes/db/DatabaseOracle.php on line 1304
Caught exception DBQueryError: A database error has occurred. Did you forget to run maintenance/update.php after upgrading?  See: https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script
Query: INSERT INTO /*Q*/L10N_CACHE (lc_lang,lc_key,lc_value) VALUES (:lc_lang, :lc_key, )
Function: DatabaseOracle::insertOneRow
Error: 936 ORA-00936: missing expression

#0 /var/www/html/devinsample/mediawiki-1.23.1/includes/db/DatabaseOracle.php(709): DatabaseOracle->reportQueryError('ORA-00936: miss...', 936, 'INSERT INTO /*Q...', 'DatabaseOracle:...')
#1 /var/www/html/devinsample/mediawiki-1.23.1/includes/db/DatabaseOracle.php(576): DatabaseOracle->insertOneRow('l10n_cache', Array, 'LCStoreDB::set')
#2 /var/www/html/devinsample/mediawiki-1.23.1/includes/cache/LocalisationCache.php(1229): DatabaseOracle->insert('l10n_cache', Array, 'LCStoreDB::set')
#3 /var/www/html/devinsample/mediawiki-1.23.1/includes/cache/LocalisationCache.php(963): LCStoreDB->set('messages:nov', 'nov')
#4 /var/www/html/devinsample/mediawiki-1.23.1/includes/cache/LocalisationCache.php(452): LocalisationCache->recache('da')
#5 /var/www/html/devinsample/mediawiki-1.23.1/includes/cache/LocalisationCache.php(326): LocalisationCache->initLanguage('da')
#6 /var/www/html/devinsample/mediawiki-1.23.1/includes/cache/LocalisationCache.php(260): LocalisationCache->loadItem('da', 'fallback')
#7 /var/www/html/devinsample/mediawiki-1.23.1/languages/Language.php(4146): LocalisationCache->getItem('da', 'fallback')
#8 /var/www/html/devinsample/mediawiki-1.23.1/languages/Language.php(237): Language::getFallbacksFor('da')
#9 /var/www/html/devinsample/mediawiki-1.23.1/languages/Language.php(196): Language::newFromCode('da')
#10 /var/www/html/devinsample/mediawiki-1.23.1/maintenance/eval.php(81) : eval()'d code(1): Language::factory('da')
#11 /var/www/html/devinsample/mediawiki-1.23.1/maintenance/eval.php(81): eval()
#12 {main}





And finally these are my error logs

[Tue Jul 29 22:55:08 2014] [error] [client 10.168.54.77] PHP Warning:  strpos() expects parameter 1 to be string, object given in /var/www/html/devinsample/mediawiki-1.23.1/includes/db/DatabaseOracle.php on line 1308
[Tue Jul 29 22:55:08 2014] [error] [client 10.168.54.77] PHP Warning:  strpos() expects parameter 1 to be string, object given in /var/www/html/devinsample/mediawiki-1.23.1/includes/db/DatabaseOracle.php on line 1304
[Tue Jul 29 22:55:08 2014] [error] [client 10.168.54.77] PHP Warning:  substr() expects parameter 1 to be string, object given in /var/www/html/devinsample/mediawiki-1.23.1/includes/db/DatabaseOracle.php on line 1304
[Tue Jul 29 22:55:08 2014] [error] [client 10.168.54.77] PHP Warning:  strpos() expects parameter 1 to be string, object given in /var/www/html/devinsample/mediawiki-1.23.1/includes/db/DatabaseOracle.php on line 1308
[Tue Jul 29 22:55:08 2014] [error] [client 10.168.54.77] PHP Warning:  strpos() expects parameter 1 to be string, object given in /var/www/html/devinsample/mediawiki-1.23.1/includes/db/DatabaseOracle.php on line 1304
[Tue Jul 29 22:55:08 2014] [error] [client 10.168.54.77] PHP Warning:  substr() expects parameter 1 to be string, object given in /var/www/html/devinsample/mediawiki-1.23.1/includes/db/DatabaseOracle.php on line 1304
[Tue Jul 29 22:55:08 2014] [error] [client 10.168.54.77] PHP Warning:  strpos() expects parameter 1 to be string, object given in /var/www/html/devinsample/mediawiki-1.23.1/includes/db/DatabaseOracle.php on line 1308
[Tue Jul 29 22:55:08 2014] [error] [client 10.168.54.77] PHP Warning:  strpos() expects parameter 1 to be string, object given in /var/www/html/devinsample/mediawiki-1.23.1/includes/db/DatabaseOracle.php on line 1304
[Tue Jul 29 22:55:08 2014] [error] [client 10.168.54.77] PHP Warning:  substr() expects parameter 1 to be string, object given in /var/www/html/devinsample/mediawiki-1.23.1/includes/db/DatabaseOracle.php on line 1304
Comment 1 db [inactive,noenotif] 2014-07-31 08:49:52 UTC

*** This bug has been marked as a duplicate of bug 64970 ***
Comment 2 db [inactive,noenotif] 2014-07-31 19:32:23 UTC

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

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links