Please make Vanilla compatible with MySQLi

CoolCookie

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..

:)

R_J

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

CoolCookie

Do you mean MyiSam?

R_J

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

CoolCookie

They use MySQL 7.4.8

is that old?

Kaspar

https://open.vanillaforums.com/discussion/comment/263345#Comment_263345

2015-10-16

https://dev.mysql.com/doc/relnotes/mysql-cluster/7.4/en/news-7-4-8.html

Kaspar

5.7+ required

https://github.com/vanilla/vanilla#installation

FYI

https://kinsta.com/knowledgebase/convert-myisam-to-innodb/

Kaspar

from searching around a bit it seems MySQL started depricating MyISAM in 2017 (EDIT: or made InnoDB default over MyISAM))

https://forums.mysql.com/read.php?106,657374,658214#msg-658214