Removing inaccessible LUNA Commons collections
Introduction
As we advance the LUNA 7 software forward, Collection Sharing is a feature that’s on our list for a future release. To replace the current method for distributing collections, that’s now tied to the LUNA Commons, we’re developing a process that will allow you to easily share your collections with one or more institutions or individuals in LUNA. The simplified process will no longer require our involvement and will be available as a new feature in the LUNA Administrator tool.
In the meantime, more clients are upgrading to LUNA 7 and you may be noticing that some collections in the LUNA Commons are no longer working. If you are one of the institutions making the LUNA Commons collections available in your own instance of the LUNA Viewer, you’ll need to follow the steps below to remove the collections that are no longer working.
Steps to remove inaccessible collections
- Backup your LUNA database.
- Run the delete queries.
- Restart LUNA's Tomcat.
DELETE FROM SHAREDMEDIACOLLECTIONS WHERE INSTITUTIONID LIKE 'CORNELL%'; DELETE FROM SHAREDMEDIACOLLECTIONS WHERE INSTITUTIONID = 'univcincin'; DELETE FROM SHAREDMEDIACOLLECTIONS WHERE INSTITUTIONID = 'JCBBOOKS'; DELETE FROM SHAREDMEDIACOLLECTIONS WHERE INSTITUTIONID = 'CUL_KAR'; DELETE FROM SHAREDMEDIACOLLECTIONS WHERE INSTITUTIONID = 'BIRKBECKBCM'; DELETE FROM SHAREDMEDIACOLLECTIONS WHERE INSTITUTIONID LIKE 'Pomona%'; DELETE FROM SHAREDEXTENDEDCOLLECTIONPROPS WHERE COLLECTIONID LIKE 'CORNELL%'; DELETE FROM SHAREDEXTENDEDCOLLECTIONPROPS WHERE COLLECTIONID LIKE 'univcincin%'; DELETE FROM SHAREDEXTENDEDCOLLECTIONPROPS WHERE COLLECTIONID LIKE 'JCBBOOKS%'; DELETE FROM SHAREDEXTENDEDCOLLECTIONPROPS WHERE COLLECTIONID LIKE 'CUL_KAR%'; DELETE FROM SHAREDEXTENDEDCOLLECTIONPROPS WHERE COLLECTIONID LIKE 'BIRKBECKBCM%'; DELETE FROM SHAREDEXTENDEDCOLLECTIONPROPS WHERE COLLECTIONID LIKE 'Pomona%'; DELETE FROM SHAREDMEDIAFIELDS WHERE INSTITUTIONID LIKE 'CORNELL%'; DELETE FROM SHAREDMEDIAFIELDS WHERE INSTITUTIONID = 'univcincin'; DELETE FROM SHAREDMEDIAFIELDS WHERE INSTITUTIONID = 'JCBBOOKS'; DELETE FROM SHAREDMEDIAFIELDS WHERE INSTITUTIONID = 'CUL_KAR'; DELETE FROM SHAREDMEDIAFIELDS WHERE INSTITUTIONID = 'BIRKBECKBCM'; DELETE FROM SHAREDMEDIAFIELDS WHERE INSTITUTIONID LIKE 'Pomona%'; DELETE FROM MEDIACOLLECTIONS WHERE INSTITUTIONID LIKE 'CORNELL%'; DELETE FROM MEDIACOLLECTIONS WHERE INSTITUTIONID = 'univcincin'; DELETE FROM MEDIACOLLECTIONS WHERE INSTITUTIONID = 'JCBBOOKS'; DELETE FROM MEDIACOLLECTIONS WHERE INSTITUTIONID = 'CUL_KAR'; DELETE FROM MEDIACOLLECTIONS WHERE INSTITUTIONID = 'BIRKBECKBCM'; DELETE FROM MEDIACOLLECTIONS WHERE INSTITUTIONID LIKE 'Pomona%'; DELETE FROM EXTENDEDCOLLECTIONPROPERTIES WHERE COLLECTIONID LIKE 'CORNELL%'; DELETE FROM EXTENDEDCOLLECTIONPROPERTIES WHERE COLLECTIONID LIKE 'univcincin%'; DELETE FROM EXTENDEDCOLLECTIONPROPERTIES WHERE COLLECTIONID LIKE 'JCBBOOKS%'; DELETE FROM EXTENDEDCOLLECTIONPROPERTIES WHERE COLLECTIONID LIKE 'CUL_KAR%'; DELETE FROM EXTENDEDCOLLECTIONPROPERTIES WHERE COLLECTIONID LIKE 'BIRKBECKBCM%'; DELETE FROM EXTENDEDCOLLECTIONPROPERTIES WHERE COLLECTIONID LIKE 'Pomona%'; DELETE FROM MEDIAFIELDS WHERE INSTITUTIONID LIKE 'CORNELL%'; DELETE FROM MEDIAFIELDS WHERE INSTITUTIONID = 'univcincin'; DELETE FROM MEDIAFIELDS WHERE INSTITUTIONID = 'JCBBOOKS'; DELETE FROM MEDIAFIELDS WHERE INSTITUTIONID = 'CUL_KAR'; DELETE FROM MEDIAFIELDS WHERE INSTITUTIONID = 'BIRKBECKBCM'; DELETE FROM MEDIAFIELDS WHERE INSTITUTIONID LIKE 'Pomona%'; DELETE FROM CREDENTIALCOLLECTIONMAP WHERE COLLECTIONID LIKE 'CORNELL%'; DELETE FROM CREDENTIALCOLLECTIONMAP WHERE COLLECTIONID LIKE 'univcincin%'; DELETE FROM CREDENTIALCOLLECTIONMAP WHERE COLLECTIONID LIKE 'JCBBOOKS%'; DELETE FROM CREDENTIALCOLLECTIONMAP WHERE COLLECTIONID LIKE 'CUL_KAR%'; DELETE FROM CREDENTIALCOLLECTIONMAP WHERE COLLECTIONID LIKE 'BIRKBECKBCM%'; DELETE FROM CREDENTIALCOLLECTIONMAP WHERE COLLECTIONID LIKE 'Pomona%';