From 668aca18041c388952aaefb200e38c4020f0e45f Mon Sep 17 00:00:00 2001 From: "Eloy Lafuente (stronk7)" Date: Wed, 20 Jan 2016 03:07:57 +0100 Subject: [PATCH] MDL-52383 Calendar: user prefs are varchar, look for varchars --- lib/db/upgrade.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/lib/db/upgrade.php b/lib/db/upgrade.php index 2b7dacc4705..3975de34a7e 100644 --- a/lib/db/upgrade.php +++ b/lib/db/upgrade.php @@ -4813,11 +4813,11 @@ function xmldb_main_upgrade($oldversion) { $transaction = $DB->start_delegated_transaction(); // Count all users who curretly have that preference set (for progress bar). - $total = $DB->count_records_select('user_preferences', 'name = \'calendar_lookahead\' AND value > 0'); + $total = $DB->count_records_select('user_preferences', "name = 'calendar_lookahead' AND value != '0'"); $pbar = new progress_bar('upgradecalendarlookahead', 500, true); // Get all these users, one at a time. - $rs = $DB->get_recordset_select('user_preferences', 'name = \'calendar_lookahead\' AND value > 0'); + $rs = $DB->get_recordset_select('user_preferences', "name = 'calendar_lookahead' AND value != '0'"); $i = 0; foreach ($rs as $userpref) { -- 2.17.1