newsflashes sql 1064 error

[ks-net]

mysql Error [1064] : EXECUTE


URI: index.php
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 'link='index.php?option=com_content&task=section&sectionid=1' AND published='1' ' at line 2
SELECT id FROM elx_menu WHERE published='1' link='index.php?option=com_content&task=section&sectionid=1' AND published='1' AND ((language IS NULL) OR (language LIKE '%english%')) LIMIT 0,1

when linked from mod_sections
 

[datahell]

An "AND" is missing from the query.

SELECT id FROM elx_menu WHERE published='1' AND link='index.php?option=com_content&task=section&sectionid=1' AND published='1' AND ((language IS NULL) OR (language LIKE '%english%')) LIMIT 0,1

[datahell]

Can you tell me where this error is displayed exactly? In module newsflash?

[ks-net]

http://elxis.ks-net.gr/newsflashes/newsflash/

this link shows when ...
from http://elxis.ks-net.gr/
at sections(mod-sections published in left position) .. menu
hit newsflashes(link)...
then in content place appears frontpage-module(?) and below this link to newsflashes  which
when clicked the error appears.

and below each one of  these a note:
This category, and its parent section, are not linked to any menu and therefore are directly viewable on the Front-End of the website. Rather the Content Items contained inside this category are only used to feed items into the Newsflash module. See also, MODULES->SITE MODULES->NEWSFLASH
 ****
this is elxis  2008.1
 
also get an error when follow fqas link in sections menu(leftposition)

idont not care about them i dont really need them...i published them only to see
and i will leave there till you see  the errors...just to know.

[datahell]

I saw the error but I can not locate it. Needs more investigation.

[Farhad Sakhaei]

File : \includes\seopro\com_content.php
Line : 620

Replace :

Code: [Select]

                $query = "SELECT id FROM #__menu WHERE published='1'"
."\n link='index.php?option=com_content&task=".$task2."&sectionid=".intval($row['sectionid'])."'"
To:

Code: [Select]

                $query = "SELECT id FROM #__menu WHERE published='1'"
."\n AND link='index.php?option=com_content&task=".$task2."&sectionid=".intval($row['sectionid'])."'"

[datahell]

Thank you very much!
I updated Elxis SVN and Elxis 2008.1 release at elxis-downloads.com

[Farhad Sakhaei]

It is nothing beside your works John