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
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.