Hi dear modx people,
i am curently struggling with a getResources Call -or all my getResources calls. If i enter the parameter &parents=`someID`, I get no output, no error, nothing. I have to call every single resource via &resources=`1,2,3,4`
I already postet this to
http://tracker.modx.com/issues/8158 - buf as i need to finish this site, i would really appreciate your help on this one.
If I add &debug=`true` to the call, i get the following entries in the modx error log:
[2012-06-24 15:41:59] (ERROR @ /index.php) context for 15 is web
[2012-06-24 15:41:59] (ERROR @ /index.php) SELECT `modResource`.`id`, `modResource`.`type`, `modResource`.`contentType`, `modResource`.`pagetitle`, `modResource`.`longtitle`, `modResource`.`description`, `modResource`.`alias`, `modResource`.`link_attributes`, `modResource`.`published`, `modResource`.`pub_date`, `modResource`.`unpub_date`, `modResource`.`parent`, `modResource`.`isfolder`, `modResource`.`introtext`, `modResource`.`richtext`, `modResource`.`template`, `modResource`.`menuindex`, `modResource`.`searchable`, `modResource`.`cacheable`, `modResource`.`createdby`, `modResource`.`createdon`, `modResource`.`editedby`, `modResource`.`editedon`, `modResource`.`deleted`, `modResource`.`deletedon`, `modResource`.`deletedby`, `modResource`.`publishedon`, `modResource`.`publishedby`, `modResource`.`menutitle`, `modResource`.`donthit`, `modResource`.`privateweb`, `modResource`.`privatemgr`, `modResource`.`content_dispo`, `modResource`.`hidemenu`, `modResource`.`class_key`, `modResource`.`context_key`, `modResource`.`content_type`, `modResource`.`uri`, `modResource`.`uri_override`, `modResource`.`hide_children_in_tree`, `modResource`.`show_in_tree`, `modResource`.`properties`, IFNULL(tvSort.value, tvDefault.default_text) AS sortTV FROM `modx_site_content` AS `modResource` LEFT JOIN `modx_site_tmplvars` `tvDefault` ON `tvDefault`.`name` = 'date' LEFT JOIN `modx_site_tmplvar_contentvalues` `tvSort` ON ( tvSort.contentid = modResource.id AND tvSort.tmplvarid = tvDefault.id ) WHERE ( ( modResource.parent IN (15,16,25,26) AND `modResource`.`deleted` = 0 AND `modResource`.`published` = 1 AND `modResource`.`hidemenu` = 0 ) AND `modResource`.`id` NOT IN (25) ) ORDER BY sortTV DESC, publishedon DESC LIMIT 5
My entire call is this:
[[!getResources? &parents=`15` &resources=`-25` &limit=`5` &depth=`2` &sortbyTV=`date` &sortdirTV=`DESC` &includeTVs=`true` &tpl=`eventsRowTpl` &debug=`true`]]
I'd be glad for any hint!
Guido