Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

I find this error in my website that runs with JOOMLA , please help me .?

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 ') ORDER BY c.lft, fp.ordering, a.created DESC LIMIT 0, 4' at line 11 SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM jml_content AS a LEFT JOIN jml_categories AS c ON c.id = a.catid LEFT JOIN jml_users AS ua ON ua.id = a.created_by LEFT JOIN jml_users AS uam ON uam.id = a.modified_by LEFT JOIN jml_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN jml_categories as parent ON parent.id = c.parent_id LEFT JOIN jml_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM jml_categories AS cat JOIN jml_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN jml_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-01-07 22:50:08') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-01-07 22:50:08') AND a.catid IN () ORDER BY c.lft, fp.ordering, a.created DESC LIMIT 0, 4 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 ') ORDER BY c.lft, fp.ordering, a.created DESC' at line 11 SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore ,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM jml_content AS a LEFT JOIN jml_categories AS c ON c.id = a.catid LEFT JOIN jml_users AS ua ON ua.id = a.created_by LEFT JOIN jml_users AS uam ON uam.id = a.modified_by LEFT JOIN jml_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN jml_categories as parent ON parent.id = c.parent_id LEFT JOIN jml_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM jml_categories AS cat JOIN jml_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN jml_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-01-07 22:50:08') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-01-07 22:50:08') AND a.catid IN () ORDER BY c.lft, fp.ordering, a.created DESC

1 Answer

Relevance
  • 9 years ago
    Favorite Answer

    Eureka!! ... located the bug :) :D

    The error is in the clause "AND a.catid IN () " , because no values were specified in the IN() . It should be something like

    AND a.CatId IN (1,2)

    Correct that, it should work.

    Next time, when you post such errors... try to post the relevant code.. here, the same query has been posted twice... and it would be difficult for us to debug it...

    Now cheer up :)

    -- In 'thoughts'...

    Lonely Rogue.

Still have questions? Get your answers by asking now.