M
M
medvedgoff2021-03-16 15:41:57
MODX
medvedgoff, 2021-03-16 15:41:57

PdoMenu does not display resources if there are less than 6 of them, what is the error?

I display a menu in another resource, a neighboring resource id 1
Finds, but does not display resources if there are less than 5 of them (judging by the log). When there are 6 or more resources, it displays without problems. What could be the question? Rearranged, created test from scratch all levels, changed the coincidence condition, does not want to.

The most interesting thing, if in the example below, is removed from the output by changing to the left value, i.e. c does not include a resource in the selection, it displays resources in "tack2" even if there are less than 5 of them .

Here is an exemplary structure if the value is changed, then the remaining resources are displayed, even if there are less than 5 matches with the condition. ) --- subsubF (the value matches the condition)
---subsubIn (value matches the condition)
---subsubC (value matches the condition)
---subsubO (value matches the condition)
-id10050
--categorizer
---subject (display this menu here)

Output code
[[pdoMenu ? &showLog=`1` &parents=`1` &includeTVs=`prv,ib-filt` &where=`{"ib-filt":"[[*ib-filt]]"}`]

] comments two more logs)

0.0020080: pdoTools loaded
0.0000350: xPDO query object created
0.0026438: Included list of tvs: ib-filt, prv
0.0003660: leftJoined modTemplateVarResource as TVib-filt
0.0003390: leftJoined modTemplateVarResource as TVprv
0.0006230: 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`, `content`, `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.0000169: Added selection of modTemplateVarResource: IFNULL(`value`, '') AS `ib-filt`
0.0000138: Added selection of modTemplateVarResource: IFNULL(`value`, '') AS `prv`
0.0000670: Replaced TV conditions
0.0047030: Processed additional conditions
0.0055900: Added where condition: `TVib-filt`.`value`=терморегулятор, modResource.parent:IN(1,348,298,39,40,7,3619,3968,467,429,442,349,365,381,3666,3599,3804,3805,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,430,431,432,433,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,451,3664,3665,3806,3807,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,382,383,384,385,386,387,388,389,390,391,392,393,394,395,3667,3668,3669,3670,3671,3672,3673,3674,3675,3676,3677,3678,3679,3680,3681,3682,3600,3601,3602,3603,3604,3605,3606,3607,3608,3609,3610,3611,3612,3613,3614,3615,3616,3808,3809,3810,3811,3812,3813,3814,3815,3816,3817,3818,3819,3820,3821,3822,3823,3824,3825,3826,3827,3828,3829,3830,3831,3832,3833,3834,3835,3836,3837,3838,3969,452,483,3583,396,3757,453,454,455,456,457,458,459,460,461,462,463,464,465,466,484,485,486,487,488,489,490,491,492,493,494,495,496,497,3584,3585,3586,3587,3588,3589,3590,3591,3592,3593,3594,3595,3596,3597,3598,3784,3785,3786,3787,3788,3789,3790,3791,3792,3793,3794,3795,3796,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,3758,3759,3760,3761,3762,3763,3764,3765,3766,3767,3768,3769,3770,3771,3772,3971,498,3620,499,500,501,502,503,504,505,506,3621,3622,3623,3624,3625,3626,3627,3628,3970,3702,3721,3722,3723,507,520,533,546,559,582,3755,3756,3728,3729,3730,3731,3732,3733,3734,3735,3736,3737,3738,3739,3740,3741,3742,3743,3744,3745,3746,3747,3748,3749,3750,3751,3752,3753,3754,508,510,512,514,515,516,3658,3659,3660,3661,3662,3663,521,523,525,527,528,529,3646,3647,3648,3649,3650,3651,534,536,538,540,541,542,3652,3653,3654,3655,3656,3657,547,549,551,553,554,555,3640,3641,3642,3643,3644,3645,560,561,562,563,564,565,566,567,568,569,570,571,583,584,585,586,587,588,589,590,591,3629,1908,3630,3977,3776,3777,3778,3781,3802,3803,3571,3798,3570,3569,3689,3690,1905,3693,1927,3696,3694,3695,3579,3561,3562,1931,3563,3564,1922,3566,1921,1919,3779,3780,3782,3799,3573,3572,3580,1923,1909,1914,1920,1910,1915,1911,1916,1912,1917,3797,1906,3692,1907,3691,1928,3699,3697,3698,1929,3581,3560,3700,3800,3575,3574,3801,3576,3578,3577,3783,3582,1932,1933,3684,3685,3683,3565,3687,3688,3686,1918,1913,1924,1925,3567,3967,3637,3638), modResource.template:IN(4), modResource.published=1, modResource.hidemenu=0, modResource.deleted=0, modResource.context_key=web
0.0000379: Replaced TV conditions
0.0002100: Sorted by modResource.menuindex, ASC
0.0005128: 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`.`content`, `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(`TVib-filt`.`value`, '') AS `ib-filt`, IFNULL(`TVprv`.`value`, '') AS `prv` FROM `plan_site_content` AS `modResource` LEFT JOIN `plan_site_tmplvar_contentvalues` `TVib-filt` ON `TVib-filt`.`contentid` = `modResource`.`id` AND `TVib-filt`.`tmplvarid` = 148 LEFT JOIN `plan_site_tmplvar_contentvalues` `TVprv` ON `TVprv`.`contentid` = `modResource`.`id` AND `TVprv`.`tmplvarid` = 10 WHERE  ( `TVib-filt`.`value` = 'терморегулятор' AND `modResource`.`parent` IN (1,348,298,39,40,7,3619,3968,467,429,442,349,365,381,3666,3599,3804,3805,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,430,431,432,433,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,451,3664,3665,3806,3807,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,382,383,384,385,386,387,388,389,390,391,392,393,394,395,3667,3668,3669,3670,3671,3672,3673,3674,3675,3676,3677,3678,3679,3680,3681,3682,3600,3601,3602,3603,3604,3605,3606,3607,3608,3609,3610,3611,3612,3613,3614,3615,3616,3808,3809,3810,3811,3812,3813,3814,3815,3816,3817,3818,3819,3820,3821,3822,3823,3824,3825,3826,3827,3828,3829,3830,3831,3832,3833,3834,3835,3836,3837,3838,3969,452,483,3583,396,3757,453,454,455,456,457,458,459,460,461,462,463,464,465,466,484,485,486,487,488,489,490,491,492,493,494,495,496,497,3584,3585,3586,3587,3588,3589,3590,3591,3592,3593,3594,3595,3596,3597,3598,3784,3785,3786,3787,3788,3789,3790,3791,3792,3793,3794,3795,3796,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,3758,3759,3760,3761,3762,3763,3764,3765,3766,3767,3768,3769,3770,3771,3772,3971,498,3620,499,500,501,502,503,504,505,506,3621,3622,3623,3624,3625,3626,3627,3628,3970,3702,3721,3722,3723,507,520,533,546,559,582,3755,3756,3728,3729,3730,3731,3732,3733,3734,3735,3736,3737,3738,3739,3740,3741,3742,3743,3744,3745,3746,3747,3748,3749,3750,3751,3752,3753,3754,508,510,512,514,515,516,3658,3659,3660,3661,3662,3663,521,523,525,527,528,529,3646,3647,3648,3649,3650,3651,534,536,538,540,541,542,3652,3653,3654,3655,3656,3657,547,549,551,553,554,555,3640,3641,3642,3643,3644,3645,560,561,562,563,564,565,566,567,568,569,570,571,583,584,585,586,587,588,589,590,591,3629,1908,3630,3977,3776,3777,3778,3781,3802,3803,3571,3798,3570,3569,3689,3690,1905,3693,1927,3696,3694,3695,3579,3561,3562,1931,3563,3564,1922,3566,1921,1919,3779,3780,3782,3799,3573,3572,3580,1923,1909,1914,1920,1910,1915,1911,1916,1912,1917,3797,1906,3692,1907,3691,1928,3699,3697,3698,1929,3581,3560,3700,3800,3575,3574,3801,3576,3578,3577,3783,3582,1932,1933,3684,3685,3683,3565,3687,3688,3686,1918,1913,1924,1925,3567,3967,3637,3638) AND `modResource`.`template` IN (4) AND `modResource`.`published` = 1 AND `modResource`.`hidemenu` = 0 AND `modResource`.`deleted` = 0 AND `modResource`.`context_key` = 'web' )  ORDER BY modResource.menuindex ASC "
0.0026729: SQL executed
0.0000911: Total rows: 5
0.0000501: Rows fetched
0.0001271: Returning raw data
0.0000269: Tree was built
0.0156388: Total time
10 223 616: Memory usage

Answer the question

In order to leave comments, you need to log in

[[+comments_count]] answer(s)
M
medvedgoff, 2021-03-16
@medvedgoff

That's when 6 resources are:

0.0020678: pdoTools loaded
0.0000370: xPDO query object created
0.0004878: Included list of tvs: ib-filt, prv
0.0004039: leftJoined modTemplateVarResource as TVib-filt
0.0003622: leftJoined modTemplateVarResource as TVprv
0.0008180: 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`, `content`, `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.0000181: Added selection of modTemplateVarResource: IFNULL(`value`, '') AS `ib-filt`
0.0000150: Added selection of modTemplateVarResource: IFNULL(`value`, '') AS `prv`
0.0000579: Replaced TV conditions
0.0054069: Processed additional conditions
0.0062709: Added where condition: `TVib-filt`.`value`=терморегулятор, modResource.parent:IN(1,348,298,39,40,7,3619,3968,467,429,442,349,365,381,3666,3599,3804,3805,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,430,431,432,433,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,451,3664,3665,3806,3807,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,382,383,384,385,386,387,388,389,390,391,392,393,394,395,3667,3668,3669,3670,3671,3672,3673,3674,3675,3676,3677,3678,3679,3680,3681,3682,3600,3601,3602,3603,3604,3605,3606,3607,3608,3609,3610,3611,3612,3613,3614,3615,3616,3808,3809,3810,3811,3812,3813,3814,3815,3816,3817,3818,3819,3820,3821,3822,3823,3824,3825,3826,3827,3828,3829,3830,3831,3832,3833,3834,3835,3836,3837,3838,3969,452,483,3583,396,3757,453,454,455,456,457,458,459,460,461,462,463,464,465,466,484,485,486,487,488,489,490,491,492,493,494,495,496,497,3584,3585,3586,3587,3588,3589,3590,3591,3592,3593,3594,3595,3596,3597,3598,3784,3785,3786,3787,3788,3789,3790,3791,3792,3793,3794,3795,3796,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,3758,3759,3760,3761,3762,3763,3764,3765,3766,3767,3768,3769,3770,3771,3772,3971,498,3620,499,500,501,502,503,504,505,506,3621,3622,3623,3624,3625,3626,3627,3628,3970,3702,3721,3722,3723,507,520,533,546,559,582,3755,3756,3728,3729,3730,3731,3732,3733,3734,3735,3736,3737,3738,3739,3740,3741,3742,3743,3744,3745,3746,3747,3748,3749,3750,3751,3752,3753,3754,508,510,512,514,515,516,3658,3659,3660,3661,3662,3663,521,523,525,527,528,529,3646,3647,3648,3649,3650,3651,534,536,538,540,541,542,3652,3653,3654,3655,3656,3657,547,549,551,553,554,555,3640,3641,3642,3643,3644,3645,560,561,562,563,564,565,566,567,568,569,570,571,583,584,585,586,587,588,589,590,591,3629,1908,3630,3978,3977,3776,3777,3778,3781,3802,3803,3571,3798,3570,3569,3689,3690,1905,3693,1927,3696,3694,3695,3579,3561,3562,1931,3563,3564,1922,3566,1921,1919,3779,3780,3782,3799,3573,3572,3580,1923,1909,1914,1920,1910,1915,1911,1916,1912,1917,3797,1906,3692,1907,3691,1928,3699,3697,3698,1929,3581,3560,3700,3800,3575,3574,3801,3576,3578,3577,3783,3582,1932,1933,3684,3685,3683,3565,3687,3688,3686,1918,1913,1924,1925,3567,3967,3637,3638), modResource.template:IN(4), modResource.published=1, modResource.hidemenu=0, modResource.deleted=0, modResource.context_key=web
0.0000300: Replaced TV conditions
0.0001950: Sorted by modResource.menuindex, ASC
0.0005128: 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`.`content`, `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(`TVib-filt`.`value`, '') AS `ib-filt`, IFNULL(`TVprv`.`value`, '') AS `prv` FROM `plan_site_content` AS `modResource` LEFT JOIN `plan_site_tmplvar_contentvalues` `TVib-filt` ON `TVib-filt`.`contentid` = `modResource`.`id` AND `TVib-filt`.`tmplvarid` = 148 LEFT JOIN `plan_site_tmplvar_contentvalues` `TVprv` ON `TVprv`.`contentid` = `modResource`.`id` AND `TVprv`.`tmplvarid` = 10 WHERE  ( `TVib-filt`.`value` = 'терморегулятор' AND `modResource`.`parent` IN (1,348,298,39,40,7,3619,3968,467,429,442,349,365,381,3666,3599,3804,3805,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,430,431,432,433,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,451,3664,3665,3806,3807,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,382,383,384,385,386,387,388,389,390,391,392,393,394,395,3667,3668,3669,3670,3671,3672,3673,3674,3675,3676,3677,3678,3679,3680,3681,3682,3600,3601,3602,3603,3604,3605,3606,3607,3608,3609,3610,3611,3612,3613,3614,3615,3616,3808,3809,3810,3811,3812,3813,3814,3815,3816,3817,3818,3819,3820,3821,3822,3823,3824,3825,3826,3827,3828,3829,3830,3831,3832,3833,3834,3835,3836,3837,3838,3969,452,483,3583,396,3757,453,454,455,456,457,458,459,460,461,462,463,464,465,466,484,485,486,487,488,489,490,491,492,493,494,495,496,497,3584,3585,3586,3587,3588,3589,3590,3591,3592,3593,3594,3595,3596,3597,3598,3784,3785,3786,3787,3788,3789,3790,3791,3792,3793,3794,3795,3796,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,3758,3759,3760,3761,3762,3763,3764,3765,3766,3767,3768,3769,3770,3771,3772,3971,498,3620,499,500,501,502,503,504,505,506,3621,3622,3623,3624,3625,3626,3627,3628,3970,3702,3721,3722,3723,507,520,533,546,559,582,3755,3756,3728,3729,3730,3731,3732,3733,3734,3735,3736,3737,3738,3739,3740,3741,3742,3743,3744,3745,3746,3747,3748,3749,3750,3751,3752,3753,3754,508,510,512,514,515,516,3658,3659,3660,3661,3662,3663,521,523,525,527,528,529,3646,3647,3648,3649,3650,3651,534,536,538,540,541,542,3652,3653,3654,3655,3656,3657,547,549,551,553,554,555,3640,3641,3642,3643,3644,3645,560,561,562,563,564,565,566,567,568,569,570,571,583,584,585,586,587,588,589,590,591,3629,1908,3630,3978,3977,3776,3777,3778,3781,3802,3803,3571,3798,3570,3569,3689,3690,1905,3693,1927,3696,3694,3695,3579,3561,3562,1931,3563,3564,1922,3566,1921,1919,3779,3780,3782,3799,3573,3572,3580,1923,1909,1914,1920,1910,1915,1911,1916,1912,1917,3797,1906,3692,1907,3691,1928,3699,3697,3698,1929,3581,3560,3700,3800,3575,3574,3801,3576,3578,3577,3783,3582,1932,1933,3684,3685,3683,3565,3687,3688,3686,1918,1913,1924,1925,3567,3967,3637,3638) AND `modResource`.`template` IN (4) AND `modResource`.`published` = 1 AND `modResource`.`hidemenu` = 0 AND `modResource`.`deleted` = 0 AND `modResource`.`context_key` = 'web' )  ORDER BY modResource.menuindex ASC "
0.0025380: SQL executed
0.0000920: Total rows: 6
0.0000589: Rows fetched
0.0001562: Returning raw data
0.0000448: Tree was built
0.0000260: Start template tree
0.0016122: Created inline "modChunk" with name "ad22a6773e8643db35baf6e56fa79c5d"
0.0033379: Created inline "modChunk" with name "dc6d3757597108f87f958f868cf1591a"
0.0007510: End template tree
0.0201080: Total time
10 223 616: Memory usage

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question