安装了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}