Getting MySQL error when migrating DB about twill HOT 4 CLOSED

You got it right @msurguy, your MySQL version does not support the JSON column type, which was introduced in MySQL 5.7, and is used by Twill.

There's a Gist discussion here about upgrading MAMP's MySQL to 5.7. I did not try it but some users seem to figure it out this way.

You might want to take a look at laravel/valet or laravel/homestead if you are interested in moving away from MAMP.

Thanks again, I'll make sure to update our docs with a more precise requirements section as Twill is not supporting MySQL versions older than 5.7.

from twill.

Hi @msurguy! Thanks for reporting your issue, we're so glad to see someone already trying Twill!

Since Laravel 5.4, a change was made to the default database character set, and it’s now utf8mb4 which includes support for storing emojis. As long as you are running MySQL v5.7.7 and higher you do not need to do anything.

Since you're running MySQL v5.6.38, you would need to add the following to your AppServiceProvider.php file boot method:

use Illuminate\Support\Facades\Schema;

public function boot()
{
    Schema::defaultStringLength(191);
}

References: Laravel News - Laravel documentation

from twill.

@ifox got it! Thanks for the pointers and suggestions! I'll try this out on Valet probably next week as I'm working hard on grad school and other projects :)

I really am looking forward to getting this to run, was dreaming about building a similar product myself a while ago (kinda like https://carrd.co/) so am very grateful that someone built the whole system and open sourced it!

from twill.

Thanks @ifox! That helped to get through the first problem!

Now, it complains about some other MySQL error that I suspect to be also coming from MySQL version but not sure...

Thanks for bearing with me through these initial steps!

from twill.