5.0.0 - 严重 - 未处理
$where = [];
if(!empty($params['name'])) $where[] = ['h.name', 'like',"%{$params['name']}%"];
if(!empty($params['url'])) $where[] = ['url', 'like',"%{$params['url']}%"];
if(!empty($params['cate_name'])) $where[] = ['c.name', 'like',"%{$params['cate_name']}%"];
$list = db::name('nhost')->alias('h')
->field('h.id, h.name host_name, h.url, h.create_time, c.name cate_name')
->leftJoin('ncate c', 'c.id=h.ncate_id')
->order('h.id desc')
->where($where)
->limit($limit_start, $params['pageSize'])
->select();
参数:pageNum=1&pageSize=10&name=baidu报错:Column not found: 1054 Unknown column 'h.name' in 'where clause'