This simple SQL script will reset the Folder Community property of all folders to “All Communities”. This is handy if you have allot of folders and need them to be visible in more than one Community.
UPDATE CONTENTSTATUS SET COMMUNITYID=-1 WHERE objecttype =2;