I think initially looking at the error log it was just the massive posts table - then the users table became corrupted once the posts had been fixed.