From: Roland Häder Date: Tue, 31 Jul 2012 19:16:28 +0000 (+0000) Subject: Fix for wrong SQL statement 'LOW_PRIRITY' X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=commitdiff_plain;h=a454def0bfba8288ffc839d034c710f034cf4728 Fix for wrong SQL statement 'LOW_PRIRITY' --- diff --git a/inc/extensions/ext-beg.php b/inc/extensions/ext-beg.php index 36236bfac3..2c61987565 100644 --- a/inc/extensions/ext-beg.php +++ b/inc/extensions/ext-beg.php @@ -81,7 +81,7 @@ INDEX (`userid`)", addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_member_menu` WHERE `what` IN ('beg','beg2')"); // Unregister module - addExtensionSql("DELETE LOW_PRIRITY FROM `{?_MYSQL_PREFIX?}_mod_reg` WHERE `module`='beg' LIMIT 1"); + addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_mod_reg` WHERE `module`='beg' LIMIT 1"); break; case 'activate': // Do stuff when admin activates this extension diff --git a/inc/extensions/ext-bitcoins.php b/inc/extensions/ext-bitcoins.php index 626488786e..e753abe98e 100644 --- a/inc/extensions/ext-bitcoins.php +++ b/inc/extensions/ext-bitcoins.php @@ -59,7 +59,7 @@ switch (getExtensionMode()) { case 'remove': // Do stuff when removing extension // SQL commands to run - //addExtensionSql("DELETE LOW_PRIRITY FROM `{?_MYSQL_PREFIX?}_mod_reg` WHERE `module`='foo' LIMIT 1"); + //addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_mod_reg` WHERE `module`='foo' LIMIT 1"); break; case 'activate': // Do stuff when admin activates this extension diff --git a/inc/extensions/ext-sponsor.php b/inc/extensions/ext-sponsor.php index e04bb00bd5..bf9948b823 100644 --- a/inc/extensions/ext-sponsor.php +++ b/inc/extensions/ext-sponsor.php @@ -402,7 +402,7 @@ INDEX (`sponsor_id`)", addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_admin_menu` WHERE `action`='sponsor' OR `what` IN('repr_sponsor','sponsor_medit','sponsor_madd')"); addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_guest_menu` WHERE `action`='sponsor'"); addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_member_menu` WHERE `what` IN('sponsor_list','sponsor_reg')"); - addExtensionSql("DELETE LOW_PRIRITY FROM `{?_MYSQL_PREFIX?}_mod_reg` WHERE `module` IN ('sponsor','sponsor_confirm','sponsor_ref') LIMIT 3"); + addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_mod_reg` WHERE `module` IN ('sponsor','sponsor_confirm','sponsor_ref') LIMIT 3"); break; case 'activate': // Do stuff when admin activates this extension diff --git a/inc/extensions/ext-teams.php b/inc/extensions/ext-teams.php index b9ad10675e..8ad3a93d01 100644 --- a/inc/extensions/ext-teams.php +++ b/inc/extensions/ext-teams.php @@ -59,7 +59,7 @@ switch (getExtensionMode()) { case 'remove': // Do stuff when removing extension // SQL commands to run - //addExtensionSql("DELETE LOW_PRIRITY FROM `{?_MYSQL_PREFIX?}_mod_reg` WHERE `module`='foo' LIMIT 1"); + //addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_mod_reg` WHERE `module`='foo' LIMIT 1"); break; case 'activate': // Do stuff when admin activates this extension diff --git a/inc/extensions/ext-yacy.php b/inc/extensions/ext-yacy.php index c9b4168476..a5bf57852f 100644 --- a/inc/extensions/ext-yacy.php +++ b/inc/extensions/ext-yacy.php @@ -59,7 +59,7 @@ switch (getExtensionMode()) { case 'remove': // Do stuff when removing extension // SQL commands to run - //addExtensionSql("DELETE LOW_PRIRITY FROM `{?_MYSQL_PREFIX?}_mod_reg` WHERE `module`='foo' LIMIT 1"); + //addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_mod_reg` WHERE `module`='foo' LIMIT 1"); break; case 'activate': // Do stuff when admin activates this extension diff --git a/inc/loader/load-extension.php b/inc/loader/load-extension.php index 966df4784c..ac83a0f813 100644 --- a/inc/loader/load-extension.php +++ b/inc/loader/load-extension.php @@ -152,7 +152,7 @@ if (($GLOBALS['cache_instance']->loadCacheFile('extension')) && ($GLOBALS['cache // Is the name valid? if (!isExtensionNameValid($content['ext_name'])) { // Is not valid name (empty ext-foo.php script) - SQL_QUERY_ESC("DELETE LOW_PRIRITY FROM `{?_MYSQL_PREFIX?}_extensions` WHERE `ext_name`='%s' LIMIT 1", + SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_extensions` WHERE `ext_name`='%s' LIMIT 1", array($content['ext_name']), __FILE__, __LINE__); } else { // Didn't load so deactivate it