From ba73136eabdc150ea128a9253ddb67f54042324e Mon Sep 17 00:00:00 2001 From: stronk7 Date: Sat, 23 May 2009 22:51:53 +0000 Subject: [PATCH] 2.0 prefixes syntax --- lib/db/upgradelib.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/lib/db/upgradelib.php b/lib/db/upgradelib.php index 4c6d35504f..95c9a0c579 100644 --- a/lib/db/upgradelib.php +++ b/lib/db/upgradelib.php @@ -306,11 +306,11 @@ function upgrade_fix_incorrect_mnethostids() { list($in_sql, $in_params) = $DB->get_in_or_equal($hosts, SQL_PARAMS_QM, null, false); $sql = "SELECT id - FROM {$CFG->prefix}user u1 + FROM {user} u1 WHERE u1.mnethostid $in_sql AND NOT EXISTS ( SELECT 'x' - FROM {$CFG->prefix}user u2 + FROM {user} u2 WHERE u2.username = u1.username AND u2.mnethostid = ?)"; -- 2.39.5