1064-joomla 3页面上的错误 [英] 1064-Error on joomla 3 page

问题描述

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

I'm building a website (locally), and after a little work - created new categories, deleted all the default ones, created some test articles, unpublished a couple of modules and edited other ones, I tried to open the page and I got this error:

您的SQL语法有误；请查看手册 对应于您的MySQL服务器版本以使用正确的语法 在行的') AND c.extension = 'com_content' AND c.published = 1'附近 10

"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."

我该如何解决?

推荐答案

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

You have not given input value for content.id field. And hence the query is incomplete causing an SQLException.

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

这篇关于1064-joomla 3页面上的错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！