I'm trying to re index my table and it's been failing with An error has occurred: Failed to fetch Any idea what could be going wrong ?

Why are you shouting for a mod? That is only for reporting issues with this forum or a post needing moderation. This is a user helping user forum, not support. If a user can help based on the info you gave they likely will.

oh my bad I thought a mod could help me

You'll likely need to provide more info on what you are doing and from where. Besides showing an SQL command you don't give any useful info. Failed to fetch usually means there is a connection issue from client to server.