search

yesilmen-vm / YesilCMS

YesilCMS is based on BlizzCMS and specifically adapted for VMaNGOS Core and includes new features and many bug fixes.
MIT License
23 stars 35 forks source link

MySQL 5.5 can't use JSON database field type #20

Open lightningcal opened 5 months ago

lightningcal commented 5 months ago

I was able to get this to install on MySQL 5.5 but I had to change a column type to LONGTEXT since JSON type is only supported in 5.7 and up.

application\migrations\042_create_timeline.php

From:

'description' => array( 'type' => 'JSON', 'null' => false, 'comment' => 'JSON for MySQL, LONGTEXT for MariaDB' ),

to:

'description' => array( 'type' => 'LONGTEXT', 'null' => false, 'comment' => 'JSON for MySQL, LONGTEXT for MariaDB' ),