From 3b4d36089ac7d9385b17c1f31adb517d9d72d087 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Tue, 21 Apr 2015 16:56:17 +0800 Subject: [PATCH] UpdateDatabase/MysqlLinks.php --- UpdateDatabase/MysqlLinks.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/UpdateDatabase/MysqlLinks.php b/UpdateDatabase/MysqlLinks.php index f8513d06..990117ab 100644 --- a/UpdateDatabase/MysqlLinks.php +++ b/UpdateDatabase/MysqlLinks.php @@ -195,7 +195,7 @@ class Pman_Core_UpdateDatabase_MysqlLinks { $err = substr("Failed Delete {$target_table} refs {$source_table}:{$source_col}", 0, 64); $trigger .=" SET mid = 0; - IF OLD.id > 0 THEN + IF OLD.{$target_col} > 0 THEN SELECT count(*) into mid FROM {$source_table} WHERE {$source_col} = OLD.{$target_col} LIMIT 1; IF mid > 0 THEN UPDATE `$err` SET x = 1; -- 2.39.2