Fatal error: Uncaught Exception: 执行语句错误
Array
(
[0] => 42S22
[1] => 1054
[2] => Unknown column 'pu.use' in 'where clause'
)
最终执行的SQL:
select count(*) as MyCount from (select product.*,brand.brief,brand.zh_brief from sl_product as product left join sl_brand as brand on product.cbid=brand.id left join sl_attribute as attribute on product.id=attribute.pid where pu.use=38 group by product.id order by product.delete asc) as tmp in /www/bb-china.net/samao/libs/sys/db.class.php:383
Stack trace:
#0 /www/bb-china.net/samao/libs/sys/pagelist.class.php(150): DB::getCacheOne()
#1 /www/bb-china.net/Apps/Home/controls/search.ctl.php(223): Pagelist->getCacheinfo()
#2 /www/bb-china.net/Apps/Home/controls/search.ctl.php(11): SearchController->getMysql()
#3 /www/bb-china.net/samao/samaophp.php(84): SearchController->indexAction()
#4 /www/bb-china.net/index.php(48): App::Run()
#5 {main}
thrown in /www/bb-china.net/samao/libs/sys/db.class.php on line 383