Status Error when trying to edit

[AndyC]

Under orders / status order ... TB V 1.1.0

When I open the tab or page I get this error message .. I need to add a new status..

Also while at it is there a way to add a note to the Status

-------------------------------------------------------------------------------------------------------------------------------------

ThirtyBeesDatabaseException

Unknown column 'active' in 'field list'

in file classes/order/OrderReturnState.php at line 121

SQL

SELECT `active`
FROM `tb_1order_return_state`
LIMIT 1

Source file: classes/order/OrderReturnState.php

102:     *
103:     * Starting with v1.1.0, thirty bees no longer equips the updater module
104:     * with database upgrade scripts, but equipped Core Updater with the
105:     * capability to read each class' table description and to update the
106:     * database accordingly.
107:     *
108:     * Retrocompatibility: as the above is just a plan and not yet true for
109:     * the time being, this was added as a kludge to bridge the time until it
110:     * actually gets true.
111:     *
112:     * @since 1.1.0
113:     */
114:    public static function installationCheck()
115:    {
116:        $db = Db::getInstance(_PS_USE_SQL_SLAVE_);
117:        $result = $db->executeS(
118:            (new DbQuery())
119:                ->select('`active`')
120:                ->from(static::$definition['table'])
121:                ->limit(1)                                   (Not part of error but info, this has a red line though it) 
122:        );
123:
124:        if ( ! $result) {
125:            $db->execute('ALTER TABLE '
126:                ._DB_PREFIX_.static::$definition['table']
127:                .' ADD COLUMN `active` TINYINT(1) UNSIGNED NOT NULL DEFAULT 1;'
128:            );
129:        }
130:    }
131:

Edited August 24, 2019 by AndyC

[datakick]

To fix this:

1. disable debug mode
2. open the page again
3. enable debug mode
4. open the page again

🙂 

[AndyC]

Thanks ... Looks like it's working now

At first I thought you were joking lol