Dedecms标签arclistsg调用单表模型出错的解决方法

| | Comments (0)



使用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'";


修改的地方主要为where tp.id='$typeid'"中间的 tp.id,原为id,在前面加了 tp.

Leave a comment

Archives

Ads by google

Pages

Powered by Movable Type 4.24-en

About this Entry

This page contains a single entry by 单点日志 published on February 8, 2010 7:35 PM.

Excel使用 FormulaArray 属性的运行时错误1004的原因分析 was the previous entry in this blog.

用Excel优化你的网赚资源的使用技巧 is the next entry in this blog.

Find recent content on the main index or look in the archives to find all content.