SJ77 Posted August 9, 2021 Share Posted August 9, 2021 I can see the query running on my server but I have removed the widget everywhere that I can find. Yet it's still running /*IPS\downloads\widgets\_topDownloads::render:99*/ SELECT dfid, count(*) AS downloads FROM `downloads_downloads` LEFT JOIN `downloads_files` ON dfi d=file_id WHERE file_cat IN(2,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21) AND dtime>? GROUP BY `dfid` ORDER BY downloads DESC LIMIT 3 This query always runs slowly and I need it to stop running. Any way to find where this mystery widget is running so I can get rid of it? OR.... Any way in the ACP to simply turn this off regardless of where it is running? Any help appreciated Thank you Link to comment Share on other sites More sharing options...
Daniel F Posted August 9, 2021 Share Posted August 9, 2021 Check your cms_page_widget_areas and core_widget_areas database tables, which should give you a hint where it's being used. SJ77 1 Link to comment Share on other sites More sharing options...
SJ77 Posted August 9, 2021 Author Share Posted August 9, 2021 Yeah that widget is not in those tables. No idea why that query is running on my server. 😞 Link to comment Share on other sites More sharing options...
CoffeeCake Posted August 9, 2021 Share Posted August 9, 2021 We don't have downloads, but could it be a task that runs on a schedule? SJ77 1 Link to comment Share on other sites More sharing options...
Daniel F Posted August 9, 2021 Share Posted August 9, 2021 15 minutes ago, CoffeeCake said: We don't have downloads, but could it be a task that runs on a schedule? Nah, it's a widget ( IPS\downloads\widgets\_topDownloads ) but I have already helped him to locate it. It's hopefully resolved now. SJ77 1 Link to comment Share on other sites More sharing options...
Daniel F Posted August 9, 2021 Share Posted August 9, 2021 OK... short long story if anybody else runs into this... If you don't have the Pages App: check your core_widget_areas database table IF you're using IP.Pages: check your core_widget_areas database table check your cms_page_widget_database areas check your blocks ( ACP => Pages => Blocks ) and the cms_blocks database table. SJ77 1 Link to comment Share on other sites More sharing options...
Recommended Posts