:(

1054:Unknown column 'bg_houseinfo.roomid' in 'field list' [ SQL语句 ] : SELECT bg_houseinfo.shopid,bg_houseinfo.roomid,bg_houseinfo.roomimg,bg_houseinfo.roomtype,bg_houseinfo.roombeds,bg_houseinfo.housetype,bg_houseinfo.peoples,bg_houseinfo.nickname,bg_houseinfo.nicknames,bg_houseinfo.num_price,bg_houseinfo.addr FROM `bg_houseinfo` INNER JOIN bg_houseconfig ON bg_houseinfo.shopid = bg_houseconfig.shopid AND bg_houseinfo.roomid = bg_houseconfig.roomid AND bg_houseinfo.shopid = "BD024" AND bg_houseconfig.bedom=1

错误位置

FILE: /www/wwwroot/Erp/Library/ThinkPHP/Library/Think/Db/Driver.class.php  LINE: 350

TRACE

#0 /www/wwwroot/Erp/Library/ThinkPHP/Library/Think/Db/Driver.class.php(350): E('1054:Unknown co...')
#1 /www/wwwroot/Erp/Library/ThinkPHP/Library/Think/Db/Driver.class.php(180): Think\Db\Driver->error()
#2 /www/wwwroot/Erp/Library/ThinkPHP/Library/Think/Db/Driver.class.php(946): Think\Db\Driver->query('SELECT bg_house...', false)
#3 /www/wwwroot/Erp/Library/ThinkPHP/Library/Think/Model.class.php(579): Think\Db\Driver->select(Array)
#4 /www/wwwroot/Erp/Application/Home/Controller/BookController.class.php(158): Think\Model->select()
#5 [internal function]: Home\Controller\BookController->houseDetail()
#6 /www/wwwroot/Erp/Library/ThinkPHP/Library/Think/App.class.php(173): ReflectionMethod->invoke(Object(Home\Controller\BookController))
#7 /www/wwwroot/Erp/Library/ThinkPHP/Library/Think/App.class.php(110): Think\App::invokeAction(Object(Home\Controller\BookController), 'houseDetail')
#8 /www/wwwroot/Erp/Library/ThinkPHP/Library/Think/App.class.php(204): Think\App::exec()
#9 /www/wwwroot/Erp/Library/ThinkPHP/Library/Think/Think.class.php(120): Think\App::run()
#10 /www/wwwroot/Erp/Library/ThinkPHP/ThinkPHP.php(97): Think\Think::start()
#11 /www/wwwroot/Erp/index.php(18): require('/www/wwwroot/Er...')
#12 {main}