#1 253618

今天在写一条一个表对两个表的左外关联时无法分页，语句如下，我喜欢直接用SQL语句
select a.col1,a.col2,b.col1,c.col1 from (table1 a left join table2 b on a.id=b.bid) left join table3 c on (a.cid=c.cid) order by a.id desc
提示
执行错误: Unknown column 'id' in 'field list'，我去掉分页后可以正常显示，在phpmyadmin中上面的语句也可以正常 显示数据

2012-03-29 15:09:39

#2 253618

修改spModel.php 436行
$total_count = array_pop( array_pop( $this->model_obj->findSql("SELECT COUNT({$this->model_obj->pk}) as sp_counter FROM ($conditions) sp_tmp_table_pager1") ) );
为
$total_count = array_pop( array_pop( $this->model_obj->findSql("SELECT COUNT(*) as sp_counter FROM ($conditions) sp_tmp_table_pager1") ) );
解决，能否不修改这个文件

2012-03-29 15:25:28

#3 jake

$this->model_obj->pk 是等于你的model的主键

$你的model->pk = "*";
再查

2012-03-29 20:01:10

#4 zkbao

刚好也有这个问题，学习了

2014-09-05 22:36:22