No valid database connection 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 ( a.state = 1 )) AND ( a.publish_up = '0000-00-00 00:00:00 SQL=SELECT a.id, a.title, a.created,u.name as author,a.created_by_alias as created_by_alias ,a.sectionid,COUNT(a.id) as total,a.introtext, a.fulltext, a.access, cc.title as section, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore FROM jos_content AS a INNER JOIN jos_categories AS cc ON cc.id = a.catid INNER JOIN jos_sections AS s ON s.id=a.sectionid INNER JOIN jos_users AS u ON u.id=a.created_by WHERE (a.id in () AND ( a.state = 1 )) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-07-30 14:36:01' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-07-30 14:36:01' ) AND cc.published = 1 GROUP BY(a.id) ORDER BY a.ordering LIMIT 0, 10

Powered by Tags for Joomla

Newsletter