Already a Member?

Login to your account.

 | Forgot your password

Table './vm_prod/elgg_annotations' is marked as crashed and last (automatic?) repair failed

QUERY: SELECT distinct e.*, count(ms.string) as sum from elgg_entities e JOIN elgg_annotations a on a.entity_guid = e.guid JOIN elgg_metastrings ms on a.value_id=ms.id WHERE e.type='object' and e.subtype=4 and a.name_id='5323' and ( (a.access_id IN (2)
OR (a.owner_guid = -1)
OR (
a.access_id = 0
AND a.owner_guid = -1
)
) and a.enabled='yes') and ( (e.access_id IN (2)
OR (e.owner_guid = -1)
OR (
e.access_id = 0
AND e.owner_guid = -1
)
) and e.enabled='yes') group by e.guid order by sum desc limit 0 , 24

GARBAGE COLLECTOR Cleaning up unlinked metastrings: