]> git.mxchange.org Git - mailer.git/commitdiff
Fix for SQL
authorRoland Häder <roland@mxchange.org>
Sat, 3 Nov 2012 21:02:47 +0000 (21:02 +0000)
committerRoland Häder <roland@mxchange.org>
Sat, 3 Nov 2012 21:02:47 +0000 (21:02 +0000)
inc/extensions/ext-admins.php

index 298bd4ec84a1fdfb7f225eac1a3b9ec973e78166..d21465ce13793b78fc8d84689c3982925565e8cb 100644 (file)
@@ -358,7 +358,7 @@ INDEX (`admin_id`)",
                        case '0.7.9': // SQL queries for v0.7.9
                                addExtensionChangeTableColumnSql('admins_mails', 'admin_id', 'admin_id', 'BIGINT(20) UNSIGNED NULL DEFAULT NULL');
                                addExtensionSql('UPDATE `{?_MYSQL_PREFIX?}_admins_mails` SET `admin_id` = NULL WHERE `admin_id`=0');
-                               addExtensionSql("DELETE `{?_MYSQL_PREFIX?}_admins_mails` WHERE `mail_template` IN ('admin-del_links', 'back-admin', 'done-admin', 'order-admin', 'register-admin')");
+                               addExtensionSql("DELETE FROM `{?_MYSQL_PREFIX?}_admins_mails` WHERE `mail_template` IN ('admin-del_links', 'back-admin', 'done-admin', 'order-admin', 'register-admin')");
 
                                // Update notes (these will be set as task text!)
                                setExtensionUpdateNotes("Spalte <strong>admin_id</strong> ist jetzt Ausgangswert NULL, alte Mail-Templates bereinigt.");