关于DZ X1.5 X2.0 后台管理——论坛版块编辑出错问题

火网互联张婧琪

Discuz! Database Error  
The database has encountered a problem. Need Help?

--------------------------------------------------------------------------------

Error messages:  
•[Type] 查询语句错误
•[1143] SELECT command denied to user 'qiduidc'@'localhost' for column 'fid' in table 'f'
•[Query] SELECT *, f.fid AS fid FROM forum_forum f LEFT JOIN forum_forumfield ff USING (fid) WHERE f.fid IN (1)

解决方法如下

找到/source/admincp/admincp_forums.php  这个文件

如果是用 dreamweaver打开能看到行数的 直接找到 1024行 将其修改为
$query = DB::query("SELECT f.*, f.fid AS fid FROM ".DB::table('forum_forum')." f


如果用记事本打开的 就搜索下 按ctrl+f 搜索
$query = DB::query("SELECT *, f.fid AS fid FROM ".DB::table('forum_forum')." f

找到后将其改为
$query = DB::query("SELECT f.*, f.fid AS fid FROM ".DB::table('forum_forum')." f

然后保存上传！

问题解决了

以上内容转载于火网互联