Welcome,
Guest
.
Please
login
or
register
.
Did you miss your
activation email
?
News:
Elxis documentation
for users and developers.
Home
Help
Login
Register
Elxis CMS Forum
»
Support
»
General
(Moderators:
Ivan Trebješanin
,
Farhad Sakhaei
) »
module problem with mysql
« previous
next »
Print
Pages: [
1
]
Author
Topic: module problem with mysql (Read 4214 times)
ahmet
Sr. Member
Posts: 283
360 HDR Virtual Tours | Windsurfing Sailing
module problem with mysql
«
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
Logged
www.puretourism.co.uk
www.globalpanorama.net
www.bodrumwindsurf.com
webgift
Elxis Team
Hero Member
Posts: 4193
Re: module problem with mysql
«
Reply #1 on:
May 17, 2013, 21:07:43 »
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
.
Logged
Elxis Team •
Custom web design [EN]
-
[EL]
•
.GR Registrar
ahmet
Sr. Member
Posts: 283
360 HDR Virtual Tours | Windsurfing Sailing
Re: module problem with mysql
«
Reply #2 on:
May 19, 2013, 00:36:24 »
both of them..
Logged
www.puretourism.co.uk
www.globalpanorama.net
www.bodrumwindsurf.com
webgift
Elxis Team
Hero Member
Posts: 4193
Re: module problem with mysql
«
Reply #3 on:
May 19, 2013, 12:31:56 »
Relative issues haven't been reported yet. So you do something wrong. Is there a live URL?
Logged
Elxis Team •
Custom web design [EN]
-
[EL]
•
.GR Registrar
Print
Pages: [
1
]
« previous
next »
Elxis CMS Forum
»
Support
»
General
(Moderators:
Ivan Trebješanin
,
Farhad Sakhaei
) »
module problem with mysql