Action Plan à For %CONTEXT0% issue correction
4: Run:
UPDATE location SET LocationSet_Id = 2 WHERE LocationSet_Id = 3;
UPDATE contentrule SET LocationSet_Id =2 WHERE LocationSet_Id = 3;
5: Run:
A. SELECT * FROM interactionoperation WHERE LocationSet_Id = 3;
B. SELECT count(*) FROM interactionoperation WHERE LocationSet_Id = 3; à mark the count.
6: Run:
UPDATE interactionoperation SET LocationSet_Id = 2 WHERE LocationSet_Id = 3 AND interactionoperationtype IN (0,3);
Note: Count of the rows affected from this query should match the earlier count from step 5 sub step B
7. Run:
SELECT * FROM interactionoperation WHERE LocationSet_Id = 3;
Note: This will verify no records are left on Locationset_id 3.
8: From locationset table we will delete the Locationset where id = 3 using below query.
(We are deleting the %CONTEXT0% location)
Run: DELETE locationset FROM locationset WHERE `Id` = '3';
9: After this database has been corrected: