Topic on Project:Support desk

I have 3 wiki's that I upgradet from 1.15 to 1.23.3. the last one with an error when updating the database. can anybody help? thanks, sergej

(...)
...valid_tag table already exists.
Creating user_properties table ...
An error occurred:
Es ist ein Datenbankabfragefehler aufgetreten.
Abfrage: CREATE TABLE `user_properties`(
 up_user int not null,
 up_property varbinary(32) not null,
 up_value blob
 ) ENGINE=InnoDB, DEFAULT CHARSET=binary

Funktion: DatabaseBase::sourceFile( /share/MD0_DATA/Qweb/wiki/maintenance/archives/patch-user_properties.sql )
Fehler: 1142 CREATE command denied to user 'bkwiki'@'localhost' for table 'user_properties' (localhost)

Backtrace:
#0 /share/MD0_DATA/Qweb/wiki/includes/db/Database.php(1123): DatabaseBase->reportQueryError('CREATE command ...', 1142, 'CREATE TABLE  `u...', 'DatabaseBase::s...', false)
#1 /share/MD0_DATA/Qweb/wiki/includes/db/Database.php(3858): DatabaseBase->query('CREATE TABLE `u...', 'DatabaseBase::s...')
#2 /share/MD0_DATA/Qweb/wiki/includes/db/Database.php(3772): DatabaseBase->sourceStream(Resource id #104, false, false,'DatabaseBase::s...', false)
#3 /share/MD0_DATA/Qweb/wiki/includes/installer/DatabaseUpdater.php(647): DatabaseBase->sourceFile('/share/MD0_DATA...')
#4 /share/MD0_DATA/Qweb/wiki/includes/installer/DatabaseUpdater.php(670): DatabaseUpdater->applyPatch('patch-user_prop...', false, 'Creating user_p...')
#5 [internal function]: DatabaseUpdater->addTable('user_properties', 'patch-user_prop...')
#6 /share/MD0_DATA/Qweb/wiki/includes/installer/DatabaseUpdater.php(441): call_user_func_array(Array, Array)
#7 /share/MD0_DATA/Qweb/wiki/includes/installer/DatabaseUpdater.php(401): DatabaseUpdater->runUpdates(Array, false)
#8 /share/MD0_DATA/Qweb/wiki/includes/installer/DatabaseInstaller.php(280): DatabaseUpdater->doUpdates()
#9 /share/MD0_DATA/Qweb/wiki/includes/installer/WebInstallerPage.php(646): DatabaseInstaller->doUpgrade()
#10 /share/MD0_DATA/Qweb/wiki/includes/installer/WebInstaller.php(283): WebInstaller_Upgrade->execute()
#11 /share/MD0_DATA/Qweb/wiki/mw-config/index.php(63): WebInstaller->execute(Array)
#12 /share/MD0_DATA/Qweb/wiki/mw-config/index.php(31): wfInstallerMain()
#13 {main}
Purging caches...done.

Hello,

there is an error message:

CREATE command denied to user 'bkwiki'@'localhost'

which say, what went wrong :) The database user, with which you try to upgrade the database, have no right to created tables. So, the solution is to grant the right to the database, or use a user, who is permitted to create tables, for the upgrade process using Manual:$wgDBadminuser and Manual:$wgDBadminpassword.

thank you!

since I haven't changed anything on the user rights I din't assume it will be the problem - but anyway, see below it worked out fine with rewriting the user and its permissions.

regards sergej

I solved the problem somehow myself:

I deleted the user and re installed him (in mysql). rerunning the update and it worked!

sorry bothering you!