Sql error on Mailer DB migrate about remp HOT 5 CLOSED

This unfortunately wouldn't create json type in MySQL/Percona. Also we use JSON types in other parts of REMP tools.

Any chance you could upgrade to 10.2.7+? That version has added alias for JSON type doing exactly what you achieved by changing the migration.

https://mariadb.com/kb/en/library/json-data-type/

from remp.

Hi, based on the error message, it looks like you're using MariaDB. What version do you have? Does it support JSON data type?

from remp.

It's version 10.1.38-MariaDB-0ubuntu0.18.04.1. It doesn't look like MariaDB has the JSON datatype - it uses LONGTEXT instead.

I have fixed the issue with the following migrations/20181106082909_add_extras_to_mail_templates.php:

<?php

use Phinx\Migration\AbstractMigration;
use Phinx\Db\Adapter\MysqlAdapter;

class AddExtrasToMailTemplates extends AbstractMigration
{
    public function change()
    {
        $this->table('mail_templates')
            ->addColumn('extras', 'text', ['null' => true, 'limit' => MysqlAdapter::TEXT_LONG])
            ->update();
    }
}

from remp.

Upgrading to 10.3 has solved the problem. (I also got a "Specified key was too long" error with the previous version.)

from remp.

Great, we'll update the README to mention this as MariaDB might be used by more people.

from remp.