Elxis CMS Forum
Support => General => Topic started by: ahmet on May 17, 2013, 15:31:38
-
hello,
when i try to use a module like ultimate content display or others
i have ...
mysql Error [1064] : EXECUTE
URI: index.php?mylang=english
Message: 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 '' at line 16
SELECT a.id, a.introtext, a.maintext, a.images, a.attribs, a.title, a.seotitle, a.state, a.created, a.modified, a.created_by, cc.seotitle AS catseotitle, s.seotitle AS secseotitle FROM elx_content a INNER JOIN elx_categories cc ON cc.id = a.catid INNER JOIN elx_sections s ON s.id = a.sectionid WHERE a.state = '1' AND (a.id = '') AND a.access IN (29) AND cc.access IN (29) AND s.access IN (29) AND (a.publish_up = '1979-12-19 00:00:00' OR a.publish_up <= '2013-05-17 15:29:33') AND (a.publish_down = '2060-01-01 00:00:00' OR a.publish_down >= '2013-05-17 15:29:33') AND ((a.language IS NULL) OR (a.language LIKE '%english%')) AND ((cc.language IS NULL) OR (cc.language LIKE '%english%')) AND ((s.language IS NULL) OR (s.language LIKE '%english%')) AND cc.published = '1' AND s.published = '1' ORDER BY
PHP Error [Warning]
URI: index.php?mylang=english
Path: /modules/mod_contentitem.php
-
As it seems the order by state haven't been set to the MySQL query. Are you sure that it's the Ultimate content module? As it seems that error is generated from /modules/mod_contentitem.php.
-
both of them..
-
Relative issues haven't been reported yet. So you do something wrong. Is there a live URL?