Typo in naming a database column fixed

diff --git a/inc/extensions/ext-earning.php b/inc/extensions/ext-earning.php
index 52f103d50be8d4b7b14b43f77775940b332df054..8f4b944e795729b0aac7e2b4934dec0a28b45d51 100644 (file)
--- a/inc/extensions/ext-earning.php
+++ b/inc/extensions/ext-earning.php
@@ -76,7 +76,7 @@ UNIQUE `earning_group_name` (`earning_group`,`earning_provider`)",
 `earning_userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `earning_active` ENUM('Y','N') NOT NULL DEFAULT 'Y',
 `earning_added` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
-`earning_cancelled` TIMESTAMP NULL DEFAULT NULL,
+`earning_canceled` TIMESTAMP NULL DEFAULT NULL,
 `earning_daily_amount` SMALLINT(7) NOT NULL DEFAULT 0,
 `earning_current_amount` SMALLINT(7) NOT NULL DEFAULT 0,
 `earning_points` FLOAT(20,5) NOT NULL DEFAULT 0.00000,

diff --git a/inc/libs/earning_functions.php b/inc/libs/earning_functions.php
index b0300dbcf0c790030776f9eb93215261d6e4a7c3..5773ee4422ac195623ba570aa8608a731a9daec6 100644 (file)
--- a/inc/libs/earning_functions.php
+++ b/inc/libs/earning_functions.php
@@ -153,7 +153,7 @@ function updateMemberEarning ($earningId, $dailyAmount, $isActive = 'Y') {
        // Does the user cancel the earning?
        if ($isActive == 'N') {
                // Then update cancellation timestamp as well
-               $moreSql = ', `earning_cancelled`=NOW()';
+               $moreSql = ', `earning_canceled`=NOW()';
        } // END - if
 
        // Update database record

diff --git a/inc/modules/member/what-earning.php b/inc/modules/member/what-earning.php
index 27c2a9a3aef063dd1679d4717c665388aa7146f7..28af0bce9eb4ba6c323d076634c5bed3829ff418 100644 (file)
--- a/inc/modules/member/what-earning.php
+++ b/inc/modules/member/what-earning.php
@@ -76,7 +76,7 @@ if (SQL_NUMROWS($result) > 0) {
                $result2 = SQL_QUERY_ESC('SELECT
        u.`earning_active`,
        UNIX_TIMESTAMP(u.`earning_added`) AS `earning_added`,
-       UNIX_TIMESTAMP(u.`earning_cancelled`) AS `earning_cancelled`,
+       UNIX_TIMESTAMP(u.`earning_canceled`) AS `earning_canceled`,
        u.`earning_daily_amount`,
        u.`earning_points`
 FROM