From 07366c0521a40cdef9ca96c6aa7646f2725db19c Mon Sep 17 00:00:00 2001 From: =?utf8?q?Roland=20H=C3=A4der?= Date: Tue, 28 May 2013 12:52:35 +0000 Subject: [PATCH 1/1] Fixes for SQL error + missing config --- inc/extensions/ext-profile.php | 2 +- inc/purge/purge-inact.php | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) 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__); -- 2.30.2