Mysql2::Error: Data too long for column 'body' at row 1: INSERT INTO `spree_themes_templates

[NAHNAH55]

When using mysql, importing the theme "Unite" fails with a database error.

ActiveRecord::ValueTooLong in Spree::Admin::ThemesController#upload

Mysql2::Error: Data too long for column 'body' at row 1: INSERT INTO spree_themes_templates (name, body, path, locale, theme_id, created_at, updated_at) VALUES ('slick.js', '/*\n _ _ _ \n | () | | __ ()\n/ | | |/ | |/ / | / |\n\ \ | | (| < _ | \ \\n|/||\||\()/ |/\n |/\n\n Version: 1.8.0\n Author: Ken Wheeler\n Website: http://kenwheeler.github.io\n Docs: http://kenwheeler.github.io/slick\n Repo: http://github.com/kenwheeler/slick\n Issues: http://github.com/kenwheeler/slick/issues\n\n /\n/ global window, document, define, jQuery, setInterval, clearInterval */\n;(function(factory) {\n 'use strict';\n if (typeof define === 'function' && define.amd) {\n define(['jquery'], factory);\n } else if (typeof exports !== 'undefined') {\n module.exports = factory(require('jquery'));\n } else {\n factory(jQuery);\n }\n\n}(function($) {\n 'use strict';\n var Slick = window.Slick || {};\n\n Slick = (function() {\n\n var instanceUid = 0;\n\n function Slick(element, settings) {\n\n var _ = this, dataSettings;\n\n _.defaults = {\n accessibility: true,\n adaptiveHeight: false,\n appendArrows: $(element),\n appendDots: $(element),\n arrows: true,\n asNavFor: null,\n prevArrow: '<button class="slick-prev" aria-label="Previous" type="button">Prev..........................................................

And so on. The full dump is really long.

[himanshumishra31]

Hi @NAHNAH55

This issue is db specific. It works fine on postgresql but mysql fails.
Kindly add a migration to your application

change_column :spree_themes_templates, :body, :longtext

It will work.
Thank you