宝塔安装的fecmall ,使用fecyo模板。后台点击“产品信息管理”报错,弹窗提示如下:
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/www.abc.com/vendor/yiisoft/yii2/db/Schema.php:677
Stack trace:
#0 /www/wwwroot/www.abc.com/vendor/yiisoft/yii2/db/Command.php(1298): yii\db\Schema->convertException(Object(PDOException), 'SELECT * FROM `...')
#1 /www/wwwroot/www.abc.com/vendor/yiisoft/yii2/db/Command.php(1159): yii\db\Command->internalExecute('SELECT * FROM `...')
#2 /www/wwwroot/www.abc.com/vendor/yiisoft/yii2/db/Command.php(401): yii\db\Command->queryInternal('fetchAll', NULL)
#3 /www/wwwroot/www.abc.com/vendor/yiisoft/yii2/db/Query.php(248): yii\db\Command->queryAll()
#4 /www/wwwroot/www.abc.com/vendor/yiisoft/yii2/db/ActiveQuery.php(133): yii\db\Query->all(NULL)
#5 /www/wwwroot/www.abc.com/vendor/fancyecommerce/fecshop/services/product/ProductMysqldb.php(200): yii\db\ActiveQuery->all()
#6 /www/wwwroot/www.abc.com/vendor/fancyecommerce/fecshop/services/Product.php(519): fecshop\services\product\ProductMysqldb->coll(Array)
#7 /www/wwwroot/www.abc.com/addons/fecmall/fecyo/app/appadmin/modules/Catalog/block/productinfo/Index.php(404): fecshop\services\Product->coll(Array)
#8 /www/wwwroot/www.abc.com/addons/fecmall/fecyo/app/appadmin/modules/Catalog/block/productinfo/Index.php(75): fecyo\app\appadmin\modules\Catalog\block\productinfo\Index->getTableTbody()
#9 /www/wwwroot/www.abc.com/addons/fecmall/fecyo/app/appadmin/modules/Catalog/controllers/ProductinfoController.php(26): fecyo\app\appadmin\modules\Catalog\block\productinfo\Index->getLastData()
#10 [internal function]: fecyo\app\appadmin\modules\Catalog\controllers\ProductinfoController->actionIndex()
#11 /www/wwwroot/www.abc.com/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array)
#12 /www/wwwroot/www.abc.com/vendor/yiisoft/yii2/base/Controller.php(180): yii\base\InlineAction->runWithParams(Array)
#13 /www/wwwroot/www.abc.com/vendor/yiisoft/yii2/base/Module.php(528): yii\base\Controller->runAction('index', Array)
#14 /www/wwwroot/www.abc.com/vendor/yiisoft/yii2/web/Application.php(103): yii\base\Module->runAction('catalog/product...', Array)
#15 /www/wwwroot/www.abc.com/vendor/yiisoft/yii2/base/Application.php(386): yii\web\Application->handleRequest(Object(yii\web\Request))
#16 /www/wwwroot/www.abc.com/appadmin/web/index.php(50): yii\base\Application->run()
#17 {main}