安装fecro扩展之后,数据库缺失字段?

bug问题 · swing · 于 3年前 发布 · 1203 次阅读

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

共收到 1 条回复
Fecmall#13年前 0 个赞

您好,问题已经修复,已经发版

安装fecro-1.2.1, 请先还原数据库,重新安装fecro

或者重新安装新的fecmall,然后再安装fecro。

添加回复 (需要登录)
需要 登录 后方可回复, 如果你还没有账号请点击这里 注册
Your Site Analytics