Page MenuHomePhabricator

update.php doesn't work on oracle: DatabaseOracle::doQuery: ORA-00911: invalid character
Closed, DeclinedPublic

Description

petr@eliska:/var/www/w$ php maintenance/update.php
MediaWiki 1.22alpha Updater

Going to run database updates for wiki
Depending on the size of your database this may take a while!
Abort with control-c in the next five seconds (skip this countdown with --quick) ... 0
Recreating functions ...done.
Inserting page 0 if missing ... ok
...user_former_groups table already exists.
...index i02 already set on user table.
Modifying up_property field of table user_properties ...A database query syntax error has occurred.
The last attempted database query was:
"ALTER TABLE {$wgDBprefix}user_properties MODIFY up_property varchar2(255)
"
from within function "DatabaseOracle::doQuery".
Database returned error "911: ORA-00911: invalid character"


Version: 1.22.0
Severity: major

Details

Reference
bz53709

Event Timeline

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

Now it would be awesome to know which exact "invalid character" was found. :(

I guess the invalid character is the "{" of {$wgDBprefix}. That PHP variable should have been substituted on the query sent to the database instead of being leaked as such!

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.