There is a problem with deleting and then restoring
spaces in version 2.0 and greater.
If you delete a space and then restore it from trash,
then there is a risk that the space and any top level
components will be deleted once the number of days to
keep trash has passed for those components. To prevent
this happening replace
/interact/modules/space/space.inc.php with the patched
file.
If you have deleted and restored any spaces you will
need to run the following sql against your interact
database to fix any existing problems.
First run
SELECT SpaceKey,interact_Modules.ModuleKey,ParentKey,
interact_Modules.StatusKey,
interact_ModuleSpaceLinks.StatusKey FROM
interact_Modules, interact_ModuleSpaceLinks WHERE
interact_Modules.ModuleKey=interact_ModuleSpaceLinks.ModuleKey
and interact_Modules.StatusKey=4 and
interact_ModuleSpaceLinks.StatusKey!=4;
This will identify if there are existing problems - if
the number of results for this query is > 0, then also
run the following query
UPDATE interact_Modules,interact_ModuleSpaceLinks SET
interact_Modules.StatusKey=1 WHERE
interact_Modules.ModuleKey=interact_ModuleSpaceLinks.ModuleKey
AND interact_Modules.StatusKey=4 AND
interact_ModuleSpaceLinks.StatusKey!=4;
