MySQl database

[willemhoog]

Hey,

I'm trying to use a MySQL database.
But I get the error:

Specified key was too long; max key length is 767 bytes

[willemhoog]

Used diffent connectionstring. But nothing seems to work.
What is the correct connetionstring?

[fschultz]

Hi,
I suspect that your connection string might be correct and that the error that you see comes from the creation of the tables in the database. Or more precis one of the primary keys that is out of range. I'm a little bit puzzled why since there shouldn't be any keys as large as that, but I'll try to find out why and get back to you.

[fschultz]

Which version of MySQL are you using?

[willemhoog]

I'm using 5.x.

[fschultz]

Thanks! I'll set up a MySQL 5.x database to see if I can fix this issue.

[fschultz]

I've found the issue and will commit an update tomorrow.

[fschultz]

I've created a new branch which should work with MySQL: https://github.com/KalikoCMS/KalikoCMS.Core/tree/1.1.1-dev

I will add a few other fixes before pushing a new 1.1.1 NuGet-package later this week.

[fschultz]

Seems there's some trouble with the fix :( It solves the problem for new websites using MySQL but introduces another for existing installations. I'm sorry to say it, but I need to revert the previous check-in while waiting for some help concerning Telerik's Data Access that handles the schemas.

While waiting for a new solution this version can be used to run with MySQL:
https://github.com/KalikoCMS/KalikoCMS.Core/tree/43f7c0d6797bcf4755f58cbd942fce1911abc3a6

Please note that there can be a bit of manual work to update the MySQL database if using the version linked above since one of the tables might require change.