So since Vanilla has updated to 4.0, it's incompatible with MyiSam
My host uses MyiSam and says I can't use it because they don't support InnoDB (the engine that Vanilla needs)
It would be great if Vanilla 4.0 was compatible with MyiSam..
InnoDB is so old that I cannot remember a time when it wasn't available. You should challenge your hoster what's hindering them from using a newer version. Their version must be out of support for a long time already anyway.
But there has been an option in the config which allowed forcing an engine. I'll try to find it tomorrow
Do you mean MyiSam?
I'm interested in web development for a few years already and I know that MyIsam is older than InnoDB, but I really meant that I cannot remember a time when InnoDB didn't exist. Your hoster must be using an ancient version of MySQL. And I found the config setting (it wasn't that hard) but there are a few places in Vanilla where InnoDB is hard wired, so that config setting will not help you: https://github.com/vanilla/vanilla/search?q=innodb&type=
But that would have been a workaround anyway. If your hoster only provides antique server software, you are bound to PHP scripts from years before
They use MySQL 7.4.8
is that old?
from searching around a bit it seems MySQL started depricating MyISAM in 2017 (EDIT: or made InnoDB default over MyISAM))