AndyC Posted August 24, 2019 Share Posted August 24, 2019 (edited) 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 Link to comment Share on other sites More sharing options...
datakick Posted August 24, 2019 Share Posted August 24, 2019 To fix this: disable debug mode open the page again enable debug mode open the page again 🙂 1 Link to comment Share on other sites More sharing options...
AndyC Posted August 24, 2019 Author Share Posted August 24, 2019 Thanks ... Looks like it's working now At first I thought you were joking lol 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now