MySQL Error code 1071 After applying multiple changes
<p>I recently received a Lumen/Laravel project which came with an sql file created already by the other developers. While trying to set it up in my system(already set up the environment with the required configurations in MySQL workbench) I kept getting the error</p>

<pre><code>Error Code: 1214. The used table type doesn't support FULLTEXT indexes
</code></pre>

<p>In which apparently the fix lied in changing the datbase engine in the file from <code>InnoDB</code> to <code>MyISAM</code>.</p>

<p>After that change,  I made sure that the collation was set to the required one as specified in the file 
<code>COLLATE=utf8mb4_unicode_ci;</code></p>

<p>But when I try running the file I am now getting an error</p>

<p><code>Error code: 1071. Specified key was too long: max key length is 1000 bytes</code></p>

<p>The file is extremely long(so posting the entirety of the program here would make no sense besides not being rational to post 7000+ lines of sql) and was wondering if there was a simple solution to this. Some other answers here talk about changing individual lines of code in the creation of each table which would make no sense since everyone else is using this without issue(and even then my colleagues are clueless)</p>

<p>So, what alternatives do I have?</p>