织梦标签arclistsg调用单表模型出错如何解决

发布时间：2021-12-22 08:49 所属栏目：19 来源：互联网

导读：今天我们在客户开发的过程中使用arclistsg标签时出现Column id in where clause is ambiguous的错误，解决办法如下修改代码include\taglib\arclistsg.lib.php else $gquery = Select ch.addtable,listfields From `dede_arctype` tp left join `dede_channe

今天我们在客户开发的过程中使用arclistsg标签时出现“Column 'id' in where clause is ambiguous”的错误，
解决办法如下
修改代码include\taglib\arclistsg.lib.php
else $gquery = "Select ch.addtable,listfields From `dede_arctype` tp left join `dede_channeltype` ch on ch.id=tp.channeltype where id='$typeid'";

改为

else $gquery = "Select ch.addtable,listfields From `dede_arctype` tp left join `dede_channeltype` ch on ch.id=tp.channeltype where tp.id='$typeid'";

（编辑：ASP站长网）