From bfb948b589693e4f2f9604b2c695716f9aa81de7 Mon Sep 17 00:00:00 2001 From: Joshua Ferraro Date: Wed, 31 Oct 2007 08:03:49 -0500 Subject: [PATCH] escaping @a to avoid updatedatabase failure Signed-off-by: Joshua Ferraro --- updater/updatedatabase | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/updater/updatedatabase b/updater/updatedatabase index 98f7b5153a..44419e730e 100755 --- a/updater/updatedatabase +++ b/updater/updatedatabase @@ -509,7 +509,7 @@ if (C4::Context->preference("Version") < TransformToNum($DBversion)) { $dbh->do("ALTER TABLE action_logs DROP PRIMARY KEY"); $dbh->do("ALTER TABLE action_logs ADD KEY timestamp (timestamp,user)"); $dbh->do("ALTER TABLE action_logs ADD action_id INT(11) NOT NULL FIRST"); - $dbh->do("UPDATE action_logs SET action_id = if (@a, @a:=@a+1, @a:=1)"); + $dbh->do("UPDATE action_logs SET action_id = if (\@a, \@a:=\@a+1, \@a:=1)"); $dbh->do("ALTER TABLE action_logs MODIFY action_id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY"); print "Upgrade to $DBversion done (added column to action_logs)\n"; SetVersion ($DBversion); -- 2.39.5