From dc740f97882966bbae4d546f2a3a4baa24c4bcdb Mon Sep 17 00:00:00 2001 From: tjhunt Date: Tue, 28 Apr 2009 09:55:46 +0000 Subject: [PATCH] MDL-18132 - fix upgrade SQL for MS SQL. --- lib/db/upgrade.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/lib/db/upgrade.php b/lib/db/upgrade.php index bcda99f833..9100388e2b 100644 --- a/lib/db/upgrade.php +++ b/lib/db/upgrade.php @@ -1527,7 +1527,8 @@ WHERE gradeitemid IS NOT NULL AND grademax IS NOT NULL"); if ($result && $oldversion < 2009032001) { /// Copy from role_allow_assign into the new table. - $DB->execute('INSERT INTO {role_allow_switch} SELECT * FROM {role_allow_assign}'); + $DB->execute('INSERT INTO {role_allow_switch} (roleid, allowswitch) + SELECT roleid, allowassign FROM {role_allow_assign}'); /// Unset the config variable used in 1.9. unset_config('allowuserswitchrolestheycantassign'); -- 2.39.5