pdoResources 1.6.0 pl. Ошибка &resources

Здравствуйте!

Возникает ошибка с вызовом pdoResources &resources — указанные документы не выводятся.
Вызов:
[[!getPage?
&elementClass=`modSnippet`
&element=`pdoResources`
&resources=`47,48`
&tpl=`product1`
&includeTVs=`1`
&processTVs=`1`
&hideContainers=`1`
&limit=`45`
&sortby=`id`
&pageVarKey=`page`
&showLog=`1`
&includeTVs=`imaget,price,price_old,share,categories`
]]
Указанные ресурсы существую и опубликованы. Вообще, там должен стоять сниппет, который возвращает нужные ID ресурсов, указал 47 и 48 для проверки — и не работает.

Часть документов должна выводится тут. Вот что выводит лог:
0.0000222: pdoTools loaded
0.0007629: Conditions prepared
0.0000429: Query parameters ready
0.0000710: xPDO query object created
0.0005410: Included list of tvs: price, imaget, share, price_old, categories
0.0003181: leftJoined modTemplateVarResource as TVprice
0.0002820: leftJoined modTemplateVarResource as TVimaget
0.0002820: leftJoined modTemplateVarResource as TVshare
0.0002909: leftJoined modTemplateVarResource as TVprice_old
0.0002820: leftJoined modTemplateVarResource as TVcategories
0.0000110: Grouped by modResource.id
0.0004590: Added selection of modResource: SQL_CALC_FOUND_ROWS `id`, `type`, `contentType`, `pagetitle`, `longtitle`, `description`, `alias`, `link_attributes`, `published`, `pub_date`, `unpub_date`, `parent`, `isfolder`, `introtext`, `richtext`, `template`, `menuindex`, `searchable`, `cacheable`, `createdby`, `createdon`, `editedby`, `editedon`, `deleted`, `deletedon`, `deletedby`, `publishedon`, `publishedby`, `menutitle`, `donthit`, `privateweb`, `privatemgr`, `content_dispo`, `hidemenu`, `class_key`, `context_key`, `content_type`, `uri`, `uri_override`, `hide_children_in_tree`, `show_in_tree`, `properties`
0.0000210: Added selection of TVprice: IFNULL(`value`, "") as `tv.price`
0.0000160: Added selection of TVimaget: IFNULL(`value`, "") as `tv.imaget`
0.0000160: Added selection of TVshare: IFNULL(`value`, "0") as `tv.share`
0.0000172: Added selection of TVprice_old: IFNULL(`value`, "") as `tv.price_old`
0.0000160: Added selection of TVcategories: IFNULL(`value`, "") as `tv.categories`
0.0003879: Added where condition: published=1, deleted=0, isfolder=0, modResource.id:IN(47,48), modResource.parent:IN(26)
0.0000322: Sorted by find_in_set(`modResource`.`id`,'47,48'), 
0.0000088: Limited to 45, offset 0
0.0004251: SQL prepared "SELECT SQL_CALC_FOUND_ROWS `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(`TVprice`.`value`, "") as `tv.price`, IFNULL(`TVimaget`.`value`, "") as `tv.imaget`, IFNULL(`TVshare`.`value`, "0") as `tv.share`, IFNULL(`TVprice_old`.`value`, "") as `tv.price_old`, IFNULL(`TVcategories`.`value`, "") as `tv.categories` FROM `modx_site_content` AS `modResource` LEFT JOIN `modx_site_tmplvar_contentvalues` `TVprice` ON `TVprice`.`contentid` = `modResource`.`id` AND `TVprice`.`tmplvarid` = 7 LEFT JOIN `modx_site_tmplvar_contentvalues` `TVimaget` ON `TVimaget`.`contentid` = `modResource`.`id` AND `TVimaget`.`tmplvarid` = 18 LEFT JOIN `modx_site_tmplvar_contentvalues` `TVshare` ON `TVshare`.`contentid` = `modResource`.`id` AND `TVshare`.`tmplvarid` = 19 LEFT JOIN `modx_site_tmplvar_contentvalues` `TVprice_old` ON `TVprice_old`.`contentid` = `modResource`.`id` AND `TVprice_old`.`tmplvarid` = 20 LEFT JOIN `modx_site_tmplvar_contentvalues` `TVcategories` ON `TVcategories`.`contentid` = `modResource`.`id` AND `TVcategories`.`tmplvarid` = 22 WHERE  ( `modResource`.`published` = 1 AND `modResource`.`deleted` = 0 AND `modResource`.`isfolder` = 0 AND `modResource`.`id` IN (47,48) AND `modResource`.`parent` IN (26) )  GROUP BY modResource.id ORDER BY find_in_set(`modResource`.`id`,'47,48') LIMIT 45 "
0.0008199: SQL executed
0.0001690: Total rows: 0
0.0000291: Rows fetched
0.0000329: Prepared and processed TVs
0.0000081: Returning processed chunks
0.0053642: Total time
15 728 640: Memory usage
Буду благодарен за помощь!
Игорь Козлов
14 сентября 2013, 17:03
modx.pro
1 317
0

Комментарии: 2

Василий Наумкин
14 сентября 2013, 21:06
0
Забыл параметр &parents=`0`
Авторизуйтесь или зарегистрируйтесь, чтобы оставлять комментарии.
2