I have a website (not made by me, working on restyling) that manage achitect pubblications and every architect have page with own menu with Home - Bio - Project 1 - Project 2 and so on. And i have modules (bio and projects) assigned to Home. Now i have something like 580 Bio modules and i would like to remove them only from Home of architect page. Is there anyway to do that in "automatic way"? Or i have to open every single module and remove assignment from home menu item?
Joomla 3.9.2 installed
Thank you
Code that unset module assignment on page that you want
DELETE FROM dbprefix_modules_menu
WHERE menuid = HOME_PAGE_ID
AND moduleid IN ( SELECT moduleid FROM (
SELECT mm.moduleid
FROM dbprefix_modules_menu AS mm
WHERE mm.moduleid = MODULE_ID ) tempTable
)
Replace dbprefix with your real database prefix. Replace HOME_PAGE_ID and MODULE_ID with their corresponding values from the ID column of the Menu Items manager, look at the attached screenshot.