I have two Invision forums and the issue I'm going to mention is the same on both forums
So I went into my AdminCP the other day to check out the new 'site health dashboard of the latest version (which is excellent I might add!)
In AdminCP I have no critical issues showing but I do have a few showing as 'important issues' so I thought I'd remedy and sort that
So the first one I wanted to sort was the important issue showing in the 'database' section where it says to me that I have 'non-InnoDB tables'
I then go to my hosting server CPanel and into PHPMyAdmin, then into my database, then one by one I find the tables that were MyISAM, clicked 'operations', and changed the storage engine to InnoDB
Everything went perfectly well and all tables changed easily to InnoDB until that is I tried to do this with the ibf_core_sessions table. Every single time I try to change to to InnoDB it gives me the error
Then..
If I click the 'details' link I get this..
Invision say they can't help as it's not an issue with the software but with the hosting
My hosting says I need to speak to Invision as it looks like an upgrade or something could have failed and broken the structure of the site
So I'm stuck
I'm stuck in the middle unable to change the one table from MyISAM to InnoDB
What am I doing wrong and how can I fix it?