1054:Unknown column 'a.start_price' in 'where clause' [ SQL语句 ] : SELECT COUNT(*) AS tp_count FROM knight_motor as a INNER JOIN knight_motor_brand as b on a.brand_id = b.id WHERE ( a.status >= 8 ) AND ( a.region_pid = 8133 ) AND ( a.brand_id = 58 ) AND ( a.start_price >= 10000 ) AND ( a.start_price < 20000 ) AND ( a.age_id = 60 ) LIMIT 1

错误位置

FILE: /webroot/www/libraries/ThinkPHP3.2/Library/Think/Db/Driver.class.php  LINE: 350

TRACE

#0 /webroot/www/libraries/ThinkPHP3.2/Library/Think/Db/Driver.class.php(350): E('1054:Unknown co...')
#1 /webroot/www/libraries/ThinkPHP3.2/Library/Think/Db/Driver.class.php(180): Think\Db\Driver->error()
#2 /webroot/www/libraries/ThinkPHP3.2/Library/Think/Db/Driver.class.php(946): Think\Db\Driver->query('SELECT COUNT(*)...', false)
#3 /webroot/www/libraries/ThinkPHP3.2/Library/Think/Model.class.php(970): Think\Db\Driver->select(Array)
#4 /webroot/www/libraries/ThinkPHP3.2/Library/Think/Model.class.php(227): Think\Model->getField('COUNT(*) AS tp_...')
#5 /webroot/www/usedcar.knight-un.com/App/Home/Controller/IndexController.class.php(214): Think\Model->__call('count', Array)
#6 /webroot/www/usedcar.knight-un.com/App/Home/Controller/IndexController.class.php(214): Home\Model\MotorModel->count()
#7 /webroot/www/usedcar.knight-un.com/App/Home/Controller/IndexController.class.php(124): Home\Controller\IndexController->commonlist()
#8 [internal function]: Home\Controller\IndexController->lists()
#9 /webroot/www/libraries/ThinkPHP3.2/Library/Think/App.class.php(173): ReflectionMethod->invoke(Object(Home\Controller\IndexController))
#10 /webroot/www/libraries/ThinkPHP3.2/Library/Think/App.class.php(110): Think\App::invokeAction(Object(Home\Controller\IndexController), 'lists')
#11 /webroot/www/libraries/ThinkPHP3.2/Library/Think/App.class.php(204): Think\App::exec()
#12 /webroot/www/libraries/ThinkPHP3.2/Library/Think/Think.class.php(120): Think\App::run()
#13 /webroot/www/libraries/ThinkPHP3.2/ThinkPHP.php(97): Think\Think::start()
#14 /webroot/www/usedcar.knight-un.com/index.php(31): require('/webroot/www/li...')
#15 {main}