安装了fecmall之后,直接就安装这个fecro扩展,中间正常安装,完了之后,发现有些数据库字段缺失
报错信息:
Http status: 500 error
ajaxOptions: error
thrownError:
Exception (Database Exception) 'yii\db\Exception' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'is_deputy' in 'where clause'
The SQL being executed was: SELECT * FROM product_flat
WHERE is_deputy
=1 ORDER BY id
DESC LIMIT 50'
in /www/wwwroot/fecmall/vendor/yiisoft/yii2/db/Schema.php:678
Stack trace: #0 /www/wwwroot/fecmall/vendor/yiisoft/yii2/db/Command.php(1304): yii\db\Schema->convertException(Object(PDOException), 'SELECT FROM `...') #1 /www/wwwroot/fecmall/vendor/yiisoft/yii2/db/Command.php(1165): yii\db\Command->internalExecute('SELECT FROM `...') #2 /www/wwwroot/fecmall/vendor/yiisoft/yii2/db/Command.php(407): yii\db\Command->queryInternal('fetchAll', NULL) #3 /www/wwwroot/fecmall/vendor/yiisoft/yii2/db/Query.php(248): yii\db\Command->queryAll() #4 /www/wwwroot/fecmall/vendor/yiisoft/yii2/db/ActiveQuery.php(133): yii\db\Query->all(NULL) #5 /www/wwwroot/fecmall/vendor/fancyecommerce/fecshop/services/product/ProductMysqldb.php(200): yii\db\ActiveQuery->all() #6 /www/wwwroot/fecmall/vendor/fancyecommerce/fecshop/services/Product.php(519): fecshop\services\product\ProductMysqldb->coll(Array) #7 /www/wwwroot/fecmall/addons/fecmall/fecro/app/appadmin/modules/Catalog/block/productinfo/Index.php(403): fecshop\services\Product->coll(Array) #8 /www/wwwroot/fecmall/addons/fecmall/fecro/app/appadmin/modules/Catalog/block/productinfo/Index.php(75): fecro\app\appadmin\modules\Catalog\block\productinfo\Index->getTableTbody() #9 /www/wwwroot/fecmall/addons/fecmall/fecro/app/appadmin/modules/Catalog/controllers/ProductinfoController.php(26): fecro\app\appadmin\modules\Catalog\block\productinfo\Index->getLastData() #10 [internal function]: fecro\app\appadmin\modules\Catalog\controllers\ProductinfoController->actionIndex() #11 /www/wwwroot/fecmall/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array) #12 /www/wwwroot/fecmall/vendor/yiisoft/yii2/base/Controller.php(180): yii\base\InlineAction->runWithParams(Array) #13 /www/wwwroot/fecmall/vendor/yiisoft/yii2/base/Module.php(528): yii\base\Controller->runAction('index', Array) #14 /www/wwwroot/fecmall/vendor/yiisoft/yii2/web/Application.php(104): yii\base\Module->runAction('catalog/product...', Array) #15 /www/wwwroot/fecmall/vendor/yiisoft/yii2/base/Application.php(392): yii\web\Application->handleRequest(Object(yii\web\Request)) #16 /www/wwwroot/fecmall/appadmin/web/index.php(50): yii\base\Application->run() #17 {main}