mysql - 1064-joomla 3 页面出现错误

Question

我正在(本地)构建一个网站，经过一些工作 - 创建了新类别，删除了所有默认类别，创建了一些测试文章，取消发布了几个模块并编辑了其他模块，我尝试打开该页面我得到了这个错误:

"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND c.extension = 'com_content' AND c.published = 1' at line 10

SQL=SELECT DISTINCT c.id AS CID FROM sbv9a_categories AS c 
      LEFT JOIN sbv9a_content AS content ON c.id = content.catid 
     WHERE ( content.id = ) AND c.extension = 'com_content' AND c.published = 1

It appears the page you were looking for doesn't exist. Sorry about that."

我该如何解决这个问题？

Answer 1

您尚未为 content.id 字段提供输入值。因此查询不完整，导致 SQLException。

WHERE ( content.id = ) AND c.extension = 'com_content' AND c.published = 1
 -------------------^ value is missing here