Last modified: 2013-09-04 11:51:19 UTC
While upgrading a large db from 1.16.5 to 1.17.0, update.php failed way too late with inadequate permissions. Now I'm going to have to run update.php again after giving it a different user. The error for the failure was: Creating iwlinks table...A database query syntax error has occurred. The last attempted database query was: "CREATE TABLE `pf_iwlinks` ( iwl_from int unsigned NOT NULL default 0, iwl_prefix varbinary(20) NOT NULL default '', iwl_title varchar(255) binary NOT NULL default '' ) ENGINE=InnoDB, DEFAULT CHARSET=binary "
Quick google suggests checking for "current sql user permissions" isn't a simple thing, it's very much try it, and see if it keels over then
I think mysql would show you the current user's grants. But in any case, it would just be nice to have these keeling over instances earlier rather than later. When we create users, for example, we evidently don't (or didn't?) grant them the ability to create tables, so we should know to test for that earlier rather than later.