From 58dedffde8e1e909e5d64f11b131453b0d477e70 Mon Sep 17 00:00:00 2001 From: "lpsolit%gmail.com" <> Date: Sat, 23 May 2009 17:39:22 +0000 Subject: Bug 487443: MS-SQL requires a different use of SUBSTRING in Bugzilla::User - Patch by Michael Thomas r/a=LpSolit --- Bugzilla/User.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Bugzilla/User.pm b/Bugzilla/User.pm index ac6e72711..58183a005 100644 --- a/Bugzilla/User.pm +++ b/Bugzilla/User.pm @@ -1657,7 +1657,7 @@ sub is_available_username { $dbh->sql_position(q{':'}, 'eventdata') . "- 1)) = ?) OR (tokentype = 'emailnew' AND SUBSTRING(eventdata, (" . - $dbh->sql_position(q{':'}, 'eventdata') . "+ 1)) = ?)", + $dbh->sql_position(q{':'}, 'eventdata') . "+ 1), LENGTH(eventdata)) = ?)", undef, ($username, $username)); if ($eventdata) { -- cgit v1.2.3-24-g4f1b