When iI use [[!getPage call and tvFilters then output is blank. Using [[getPage and tvFilters and causes pagination problem (pagination links disappear)
My debug output of cached call:
(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 FROM site_content AS modResource WHERE ( ( modResource.parent IN (86,112,110,109,108,104,123,111,124,121) AND modResource.deleted = 0 AND modResource.published = 1 AND modResource.hidemenu = 0 ) AND (EXISTS (SELECT 1 FROM site_tmplvar_contentvalues tvr JOIN site_tmplvars tv ON tvr.value LIKE 'tak' AND tv.name = 'wyswietl-agroexpert' AND tv.id = tvr.tmplvarid WHERE tvr.contentid = modResource.id) OR EXISTS (SELECT 1 FROM site_tmplvars tv WHERE tv.name = 'wyswietl-agroexpert' AND tv.default_text LIKE 'tak' AND tv.id NOT IN (SELECT tmplvarid FROM site_tmplvar_contentvalues WHERE contentid = modResource.id)) ) ) ORDER BY publishedon DESC LIMIT 8, 4
When iI use [[!getPage call and tvFilters then output is blank. Using [[getPage and tvFilters and causes pagination problem (pagination links disappear)
My debug output of cached call:
(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.propertiesFROMsite_contentASmodResourceWHERE ( ( modResource.parent IN (86,112,110,109,108,104,123,111,124,121) ANDmodResource.deleted= 0 ANDmodResource.published= 1 ANDmodResource.hidemenu= 0 ) AND (EXISTS (SELECT 1 FROMsite_tmplvar_contentvaluestvr JOINsite_tmplvarstv ON tvr.value LIKE 'tak' AND tv.name = 'wyswietl-agroexpert' AND tv.id = tvr.tmplvarid WHERE tvr.contentid = modResource.id) OR EXISTS (SELECT 1 FROMsite_tmplvarstv WHERE tv.name = 'wyswietl-agroexpert' AND tv.default_text LIKE 'tak' AND tv.id NOT IN (SELECT tmplvarid FROMsite_tmplvar_contentvaluesWHERE contentid = modResource.id)) ) ) ORDER BY publishedon DESC LIMIT 8, 4