网络营销

升级到dedecms5.7后，网站会出现很多问题，今天才发现一个武汉留学的一个网站搜索页面无法显示，原因是dede系统升级改了文件，在王健同学的帮助下，解决了这个问题，下面记录一下，希望对遇见同样问题的朋友有所帮助！

 

打开修改puls/advancedsearch.php文件，找到复制代码（不同版本可能有所差别）

$query = "SELECT addon.*, arctype.* FROM $addontable addon
        LEFT JOIN arctype ON arctype.id = addon.typeid
        $where $orderby";
    } else {
        $query = "SELECT main.id AS aid,main.*,main.description AS description1, type.*
    FROM $maintable main
    LEFT JOIN type ON type.id = main.typeid
    LEFT JOIN $addontable addon ON addon.aid = main.id
    $where  $orderby";

 
在select后面增加"addon.*,"
修改后应该是复制代码

$query = "select addon.*, arctype.* from $addontable addon
  left join dede_arctype arctype on arctype.id=addon.typeid
  $where $orderby";
} else {
  $query = "select addon.*,main.id as aid,main.*,main.description as description1, type.*
from $maintable main
left join dede_arctype type on type.id=main.typeid
left join $addontable addon on addon.aid=main.id
$where  $orderby";

注意，有两个地方要加
显示结果要修改模板文件，在plus/advancedsearch.htm，{dede:datalist}中直接调用{dede:field.字段名称/}就OK了。

-------------------------简易方法----------------------------------

 
1.打开puls/advancedsearch.php
2.查找$query = "SELECT addon.*, arctype.*
3.选中
$query = "SELECT main.id AS aid,main.*,main.description AS description1, type.*
    FROM $maintable main
    LEFT JOIN dede_arctype type ON type.id = main.typeid
    LEFT JOIN $addontable addon ON addon.aid = main.id
    $where  $orderby";
4.替换为：
$query = "select addon.*, arctype.* from $addontable addon
  left join dede_arctype arctype on arctype.id=addon.typeid
  $where $orderby";
} else {
  $query = "select addon.*,main.id as aid,main.*,main.description as description1, type.*
from $maintable main
left join dede_arctype type on type.id=main.typeid
left join $addontable addon on addon.aid=main.id
$where  $orderby";