From: Roland Häder Date: Tue, 28 May 2013 12:52:35 +0000 (+0000) Subject: Fixes for SQL error + missing config X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=commitdiff_plain;h=07366c0521a40cdef9ca96c6aa7646f2725db19c Fixes for SQL error + missing config --- diff --git a/inc/extensions/ext-profile.php b/inc/extensions/ext-profile.php index 891ff27198..325ebcc14a 100644 --- a/inc/extensions/ext-profile.php +++ b/inc/extensions/ext-profile.php @@ -118,7 +118,7 @@ switch (getExtensionMode()) { // Add config SQLs addConfigAddSql('profile_update', 'BIGINT(20) UNSIGNED NOT NULL DEFAULT 15768000'); addConfigChangeSql('send_prof_update', 'send_profile_update', "ENUM('Y','N') NOT NULL DEFAULT 'Y'"); - addConfigAddSql('send_prof_update', "ENUM('Y','N') NOT NULL DEFAULT 'Y'"); + addConfigAddSql('send_profile_update', "ENUM('Y','N') NOT NULL DEFAULT 'Y'"); addConfigAddSql('resend_profile_update', 'BIGINT(20) UNSIGNED NOT NULL DEFAULT 172800'); addConfigAddSql('profile_lock', 'BIGINT(20) UNSIGNED NOT NULL DEFAULT 86400'); diff --git a/inc/purge/purge-inact.php b/inc/purge/purge-inact.php index ad663cc4f0..a137f2ebb6 100644 --- a/inc/purge/purge-inact.php +++ b/inc/purge/purge-inact.php @@ -76,7 +76,7 @@ WHERE `status`='CONFIRMED' AND (UNIX_TIMESTAMP() - `joined`) >= {?ap_inactive_since?} AND (UNIX_TIMESTAMP() - `last_online`) >= {?ap_inactive_since?} AND - (UNIX_TIMESTAMP() - `ap_notified`) >= {?ap_inactive_since?} AND + (UNIX_TIMESTAMP() - `ap_notified`) >= {?ap_inactive_since?} " . runFilterChain('user_exclusion_sql', $excludeSql) . " ORDER BY `userid` ASC", __FILE__, __LINE__);