每当我尝试加载插件管理器时,最终都会收到此异常。
500 Unknown column 'a.id' in 'where clause' SQL=SELECT COUNT(*) FROM `ebt_extensions` AS a LEFT JOIN ebt_users AS uc ON uc.id=a.checked_out LEFT JOIN ebt_viewlevels AS ag ON ag.id = a.access WHERE `type` = 'plugin' AND (a.enabled IN (0, 1)) AND a.state >= 0 AND a.id != 928 Unknown column 'a.id' in 'where clause' SQL=SELECT a.extension_id , a.name, a.element, a.folder, a.checked_out, a.checked_out_time, a.enabled, a.access, a.ordering,uc.name AS editor,ag.title AS access_level FROM `ebt_extensions` AS a LEFT JOIN ebt_users AS uc ON uc.id=a.checked_out LEFT JOIN ebt_viewlevels AS ag ON ag.id = a.access WHERE `type` = 'plugin' AND (a.enabled IN (0, 1)) AND a.state >= 0 AND a.id != 928 ORDER BY `folder` asc,a.ordering ASC LIMIT 0, 20 Unknown column 'a.id' in 'where clause' SQL=SELECT COUNT(*) FROM `ebt_extensions` AS a LEFT JOIN ebt_users AS uc ON uc.id=a.checked_out LEFT JOIN ebt_viewlevels AS ag ON ag.id = a.access WHERE `type` = 'plugin' AND (a.enabled IN (0, 1)) AND a.state >= 0 AND a.id != 928
我可以在数据库中看到 ebt_extensions 表没有 id 字段(它被 extensions_id 替换)。有谁知道在 Joomla 中执行此查询的文件在哪里?
我正在寻找它,但也选择将它张贴在这里以防万一有人已经知道它。
很可能您最近安装了一个导致这种混乱的插件。去phpMyAdmin
一一禁用最近安装的插件。
如果这没有帮助,那么用全新的 Joomla 安装覆盖核心 Joomla 文件是个好主意(可能是您在其中一个文件中有一些损坏)。
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句