Space is left with no "admin" and users being locked-out of administering a space

A few users have reported to have lost all admin rights for a Space and not able to perform any "Administrative" tasks on this Space such as adding or removing users and groups. For every such action, they receive the error "You are not allowed to remove all the Administration Permissions for this space." This problem was mostly observed while performing a Space import/export or a site restore. For some reason, the Space lost all "admin" rights during this task.

The workaround to this problem, at the moment is to assign permissions manually through the database, as there is no "System Administrator" or "Super User" who can assign Space Level permissions through a UI, in situations such as these.

The following steps are recommended for assigning space permissions manually:
Please ensure that you have a complete backup of your <Confluence-Home> AND your database before attempting the following steps:

1) You would first be required to locate the Space Key corresponding to your space which can be located by going to the "Browse Space" section of this space and refer to the URL displayed at the top of the page. It should be similar to:

http://localhost:8080/pages/listpages-dirview.action?key=<Your Space key>

2) Connect to your database and run the following query on the SPACES table:

SELECT SPACEID FROM SPACES WHERE SPACEKEY = '<Your Space key from Step 1>'

This query will give you the SPACEID for the Space for which the "admin" rights have been lost.
3) Run the following query on your SPACEPERMISSIONS table:

INSERT INTO SPACEPERMISSIONS 
(PERMID,SPACEID,PERMTYPE,PERMUSERNAME,CREATOR,CREATIONDATE,LASTMODIFIER,LASTMODDATE) VALUES 
(<PERMID relative to your table>,
<SpaceID from the previous query>,
<'One of the Permissions from the list below'>,
<'Username to whom the permission has to be assigned'>,
<'Username who created the Space'>,
<'Creation Date'>,
<'Username who last modified this Space'>,
<'Last modified Date'>)

The list of available Space permissions:
VIEW
COMMENT
EDITSPACE
SETSPACEPERMISSIONS
REMOVEPAGE
REMOVECOMMENT
CREATEATTACHMENT
REMOVEATTACHMENT
EDITBLOG
EXPORTPAGE
EXPORTSPACE
REMOVEMAIL
SETPAGEPERMISSIONS

Refresh your database after editing this table to ensure the new values have been updated correctly and then revisit your Space and check whether the new permissions are reflected in the "Browse Space->Permissions" page.