search

KalikoCMS / KalikoCMS.Core

Open source content management system (CMS) for the ASP.NET platform.
GNU Lesser General Public License v3.0
145 stars 64 forks source link

MySQl database #79

Open willemhoog opened 8 years ago

willemhoog commented 8 years ago

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 commented 8 years ago

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

fschultz commented 8 years ago

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 commented 8 years ago

Which version of MySQL are you using?

willemhoog commented 8 years ago

I'm using 5.x.

fschultz commented 8 years ago

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

fschultz commented 8 years ago

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

fschultz commented 8 years ago

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 commented 8 years ago

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.