Difference between revisions of "Wikimedia"

From Tech
Jump to navigationJump to search
(Created page with "=Update to wheezy= If, after upgrading from debian squeeze to wheezy you get this error while running the wikimedia update.php script: from within function "DatabaseBase::sou...")
 
 
Line 10: Line 10:
   
 
The error above is only about the missing create grant, but after fixing that the update.php script will complain about missing index, alter grants, so the above command will fix everything in one go.
 
The error above is only about the missing create grant, but after fixing that the update.php script will complain about missing index, alter grants, so the above command will fix everything in one go.
  +
  +
test: <math> i </math>

Latest revision as of 17:59, 11 March 2016

Update to wheezy

If, after upgrading from debian squeeze to wheezy you get this error while running the wikimedia update.php script:

from within function "DatabaseBase::sourceFile( /usr/share/mediawiki/maintenance/archives/patch-user_properties.sql )".
Database returned error "1142: CREATE command denied to user 'wikiuser'@'localhost' for table 'user_properties' (localhost)"

Then you can fix it using

$ mysql -u root -p
mysql> grant alter, index, create on `wikitech`.* to 'wikiuser'@'localhost';

The error above is only about the missing create grant, but after fixing that the update.php script will complain about missing index, alter grants, so the above command will fix everything in one go.

test: