EasyEvent Snippet

Hello all,

I’m trying to install the EasyEvent snippet but when I run that I have an error of My-Sql

ERROR:
« Execution of a query to the database failed - 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 tv.id = tvcv.tmplvarid GROUP BY tvc’ at line 12 »
SQL: SELECT MIN(CONCAT(SUBSTRING(tvcv.value,7,4),’-’,SUBSTRING(tvcv.value,4,2),’-’,SUBSTRING(tvcv.value,1,2))) AS startDate FROM `database_sports`.`modx_site_tmplvar_contentvalues` AS tvcv, `database_sports`.`modx_site_tmplvars` AS tv, `database_sports`.`modx_site_content` AS sc WHERE tv.name = ’EasyEvents_Start’ AND tvcv.contentid = sc.id AND sc.parent IN () AND tv.id = tvcv.tmplvarid GROUP BY tvcv.tmplvarid


Please could you help me!!?
How I resolve that problem!!?

Thanks

I would guess that the part of the SQL call here

is what is causing the problem. Presumably there should be something in those parentheses?
Take a look at the value of whatever variable is being used there.
MattC

I opened the file EasyEvents.class.php and the query is on the setDateBoundaries function.
I don’t find anything worong on the querie and I do all the steps of the instalation of the snippet

The query is :
$sql = "SELECT
MIN(CONCAT(SUBSTRING(tvcv.value,7,4),’-’,SUBSTRING(tvcv.value,4,2),’-’,SUBSTRING(tvcv.value,1,2))) AS startDate
FROM
$t_tvcv AS tvcv,
$t_tv AS tv,
$t_sc AS sc
WHERE
tv.name = ’".$this->misc[’tmplVarStart’]."’
AND
tvcv.contentid = sc.id
AND
sc.parent IN ({$this->subParentsList})
AND
tv.id = tvcv.tmplvarid
GROUP BY tvcv.tmplvarid";