Last modified: 2012-05-10 01:24:08 UTC
When updating from 1.17 to 1.19.0, I ran the maintenance/update.php script (with the --quick option) and received this database permissions message about my "wikiuser" user, whose name is "gentlegi_gguser": Making user_last_timestamp nullable... A database query syntax error has occurred. The last attempted database query was: "ALTER TABLE `gg_user_newtalk` MODIFY user_last_timestamp varbinary(14) NULL default NULL " from within function "DatabaseBase::sourceFile( /path/w/maintenance/archives/patch-user-newtalk-timestamp-null.sql )". Database returned error "1142: ALTER command denied to user 'gentlegi_gguser'@'localhost' for table 'gg_user_newtalk' (localhost)" I've never received this kind of message from a MW database update. Did I do something wrong? Is anything misconfigured? I was able to get around the issue by temporarily granting all privileges to this database user.
(In reply to comment #0) > When updating from 1.17 to 1.19.0, I ran the maintenance/update.php script > (with the --quick option) and received this database permissions message about > my "wikiuser" user, whose name is "gentlegi_gguser": > > Making user_last_timestamp nullable... A database query syntax error has > occurred. > The last attempted database query was: > "ALTER TABLE `gg_user_newtalk` MODIFY user_last_timestamp varbinary(14) NULL > default NULL > " > from within function "DatabaseBase::sourceFile( > /path/w/maintenance/archives/patch-user-newtalk-timestamp-null.sql )". > Database returned error "1142: ALTER command denied to user > 'gentlegi_gguser'@'localhost' for table 'gg_user_newtalk' (localhost)" > > I've never received this kind of message from a MW database update. Did I do > something wrong? Is anything misconfigured? > > I was able to get around the issue by temporarily granting all privileges to > this database user. Yes, this is an config problem. If you don't give your day to day user the rights, use the following $wgDBadminuser and $wgDBadminpassword
Thanks Sam. I thought I had a $wgDBadminpassword defined, but I must have removed it when MediaWiki deprecated the AdminSettings.php file.