pdotools-1.9.1-pl2 error
Hi
I upgraded to pdotools-1.9.1-pl2 today and my pdoResources call stopped working
Error log shows
Reverted back to pdotools-1.9.1-pl and working again
I upgraded to pdotools-1.9.1-pl2 today and my pdoResources call stopped working
[[pdoResources? &parents=`47` &limit=`0` &depth=`0` &tpl=`caseCarousel` &sortby=`FIELD(modResource.id, [[arraySort? &parent=`47`]] )` &sortdir=`ASC` &includeTVs=`thumbnailCase` &prepareTVs=`1` &showHidden=`1`]]
Error log shows
0.0000470: xPDO query object created
0.0006659: Included list of tvs: <b>thumbnailCase</b>
0.0004990: leftJoined <i>modTemplateVarResource</i> as <b>TVthumbnailcase</b>
0.0006239: Added selection of <b>modResource</b>: <small>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`</small>
0.0001259: Added selection of <b>modTemplateVarResource</b>: <small></small>
0.0000348: Processed additional conditions
0.0005839: Added where condition: <b>modResource.parent:IN(47), modResource.published=1, modResource.deleted=0</b>
0.0000370: Replaced TV conditions
0.0000641: Sorted by <b>FIELD(modResource.id, 66,65,67,68,69,70,64 )</b>, <b>ASC</b>
0.0003150: SQL prepared <small>"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`, `` FROM `modx_site_content` AS `modResource` LEFT JOIN `modx_site_tmplvar_contentvalues` `TVthumbnailcase` ON `TVthumbnailcase`.`contentid` = `modResource`.`id` AND `TVthumbnailcase`.`tmplvarid` = 31 WHERE ( `modResource`.`parent` IN (47) AND `modResource`.`published` = 1 AND `modResource`.`deleted` = 0 ) ORDER BY FIELD(modResource.id, 66,65,67,68,69,70,64 ) ASC "</small>
0.0004110: Could not process query, error #1054: Unknown column '' in 'field list'
0.0036900: <b>Total time</b>
Reverted back to pdotools-1.9.1-pl and working again
Комментарии: 6
Try to upgrade to pl3
That's fixed it, thanks!
Словил баг на версии 1.9.1pl3 после обновления
в вызове Rand()
[2014-04-01 17:13:24] (ERROR @ /index.php) [pdoTools] Error 42000: FUNCTION modResource.RAND does not exist
в банерУ
[2014-04-01 17:13:15] (ERROR @ /index.php) [pdoTools] Error 42S22: Unknown column 'byAd.position' in 'order clause'
в вызове Rand()
[2014-04-01 17:13:24] (ERROR @ /index.php) [pdoTools] Error 42000: FUNCTION modResource.RAND does not exist
в банерУ
[2014-04-01 17:13:15] (ERROR @ /index.php) [pdoTools] Error 42S22: Unknown column 'byAd.position' in 'order clause'
Поправил, обновись.
да все ок, спасибо.
Не стал добавлять новую ветку, словил похожую ошибку в логах, но на версии pdotools-1.9.2-pl2:
(ERROR @ /index.php) [pdoTools] Error 42S22: Unknown column '' in 'field list'
Подскажите куда копать. Спасибо.
(ERROR @ /index.php) [pdoTools] Error 42S22: Unknown column '' in 'field list'
Подскажите куда копать. Спасибо.
Авторизуйтесь или зарегистрируйтесь, чтобы оставлять комментарии.