分销商利润列表、平台商利润列表点击搜索报错

bug问题 · cococup · 于 4年前 发布 · 1310 次阅读

1,linux,多商户分销

2,分销商利润列表、平台商利润列表两个功能,输入起始和结束日期,点击搜索,显示错误如下:

jaxOptions: error thrownError: Internal Server Error Page: 404 !!!! ,页面找不到 /distribute/profit/manager?%2Fdistribute%2Fprofit%2Fmanager=&_=1584246156913,,请先建立相应的module/controller/action ,再访问该URL

共收到 1 条回复 问题提问
Fecmall#14年前 0 个赞

我测试了一下(平台商后台), 不填写时间,进行搜索,没有问题,不报错,填写时间报错:

Http status: 500 Internal Server Error
ajaxOptions: error
thrownError: Internal Server Error
Exception (Database Exception) 'yii\db\Exception' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'distribute_created_at' in 'where clause'
The SQL being executed was: SELECT * FROM `platform_profit` WHERE (`increment_id` LIKE '%1100000055%') AND (`distribute_created_at` >= 1583769600) AND (`distribute_created_at` < 1585238400) ORDER BY `id` DESC LIMIT 50' 

in /www/web/demo/fecbdc/vendor/yiisoft/yii2/db/Schema.php:674

Stack trace:
#0 /www/web/demo/fecbdc/vendor/yiisoft/yii2/db/Command.php(1295): yii\db\Schema->convertException(Object(PDOException), 'SELECT * FROM `...')
#1 /www/web/demo/fecbdc/vendor/yiisoft/yii2/db/Command.php(1158): yii\db\Command->internalExecute('SELECT * FROM `...')
#2 /www/web/demo/fecbdc/vendor/yiisoft/yii2/db/Command.php(399): yii\db\Command->queryInternal('fetchAll', NULL)
#3 /www/web/demo/fecbdc/vendor/yiisoft/yii2/db/Query.php(237): yii\db\Command->queryAll()
#4 /www/web/demo/fecbdc/vendor/yiisoft/yii2/db/ActiveQuery.php(133): yii\db\Query->all(NULL)
#5 /www/web/demo/fecbdc/addons/fecmall/fecbdc/services/platform/Profitlog.php(80): yii\db\ActiveQuery->all()
#6 /www/web/demo/fecbdc/vendor/fancyecommerce/fecshop/app/appadmin/modules/AppadminbaseBlock.php(514): fecbdc\services\platform\Profitlog->coll(Array)
#7 /www/web/demo/fecbdc/addons/fecmall/fecbdc/app/appadmin/modules/Distribute/block/platformprofit/Manager.php(56): fecshop\app\appadmin\modules\AppadminbaseBlock->getTableTbody()
#8 /www/web/demo/fecbdc/addons/fecmall/fecbdc/app/appadmin/modules/Distribute/controllers/PlatformprofitController.php(24): fecbdc\app\appadmin\modules\Distribute\block\platformprofit\Manager->getLastData()
#9 [internal function]: fecbdc\app\appadmin\modules\Distribute\controllers\PlatformprofitController->actionManager()
#10 /www/web/demo/fecbdc/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array)
#11 /www/web/demo/fecbdc/vendor/yiisoft/yii2/base/Controller.php(157): yii\base\InlineAction->runWithParams(Array)
#12 /www/web/demo/fecbdc/vendor/yiisoft/yii2/base/Module.php(528): yii\base\Controller->runAction('manager', Array)
#13 /www/web/demo/fecbdc/vendor/yiisoft/yii2/web/Application.php(103): yii\base\Module->runAction('distribute/plat...', Array)
#14 /www/web/demo/fecbdc/vendor/yiisoft/yii2/base/Application.php(386): yii\web\Application->handleRequest(Object(yii\web\Request))
#15 /www/web/demo/fecbdc/appadmin/web/index.php(50): yii\base\Application->run()
#16 {main}

后面修正一下。

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