From 6ce144078a09d2087013c1694eb3cc7dd9002f39 Mon Sep 17 00:00:00 2001
From: Alan Knowles <alan@roojs.com>
Date: Tue, 21 Apr 2015 16:55:39 +0800
Subject: [PATCH] UpdateDatabase/MysqlLinks.php

---
 UpdateDatabase/MysqlLinks.php | 8 +++++---
 1 file changed, 5 insertions(+), 3 deletions(-)

diff --git a/UpdateDatabase/MysqlLinks.php b/UpdateDatabase/MysqlLinks.php
index 865f1821..f8513d06 100644
--- a/UpdateDatabase/MysqlLinks.php
+++ b/UpdateDatabase/MysqlLinks.php
@@ -195,9 +195,11 @@ class Pman_Core_UpdateDatabase_MysqlLinks {
                 $err = substr("Failed Delete {$target_table} refs {$source_table}:{$source_col}", 0, 64);
                 $trigger .="
                     SET mid = 0;
-                    SELECT count(*) into mid FROM {$source_table} WHERE {$source_col} = OLD.{$target_col} LIMIT 1;
-                    IF mid > 0 THEN   
-                       UPDATE `$err` SET x = 1;
+                    IF OLD.id > 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;
+                        END IF;
                     END IF;
                 ";
             }
-- 
2.39.2