发新话题
打印

[原创]后台无法显示内容条目BUG

[原创]后台无法显示内容条目BUG

这两天测试用的是这个包:mambo4523-Golden-cn.zip

进后台以后,点内容-》所有内容条目,会报错:
DB function failed with error number 1054
=========================================================
Unknown column 'c.access' in 'on clause' SQL=SELECT c.*, g.name AS groupname, cc.name, u.name AS editor, f.content_id AS frontpage, s.title AS section_name, v.name AS author FROM mos_content AS c, mos_categories AS cc, mos_sections AS s LEFT JOIN mos_groups AS g ON g.id = c.access LEFT JOIN mos_users AS u ON u.id = c.checked_out LEFT JOIN mos_users AS v ON v.id = c.created_by LEFT JOIN mos_content_frontpage AS f ON f.content_id = c.id WHERE c.state >= 0 AND c.catid=cc.id AND cc.section=s.id AND s.scope='content' ORDER BY s.title, c.catid, cc.ordering, cc.title, c.ordering LIMIT 0,10

修改administrator/components/com_content/admin.content.php第201行:
. "\n FROM #__content AS c, #__categories AS cc, #__sections AS s"
改成:
. "\n FROM  #__categories AS cc, #__sections AS s,#__content AS c"
就是逗号隔开的三个部分换换位置,把content拖到后面去就可以了。

现在我用的是mysql-5.0.15-0.rhel3做后台数据库。很多CMS数据库升级后就挂掉了 :  ,搞MAMBO的前辈们可真是有远见啊!

TOP

按照你说的修改了后出现了新的问题

Fatal error: Only variables can be passed by reference in 网址路径/administrator/components/com_content/admin.content.php on line 472

TOP

Re: 按照你说的修改了后出现了新的问题

怀疑是语言设置不对,单元或者分类表被破坏,原来中文的单元、分类名称被改成了“乱码”。
语言的问题,我也犯糊涂。
引用:
原帖由 xiaosong 发表
Fatal error: Only variables can be passed by reference in 网址路径/administrator/components/com_content/admin.content.php on line 472

TOP

发新话题