SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes - Help please.

Hello

This is my first attempt to install Solidres:
1.- I installed Joomla latest stable version 3.6.0 with no problem, I have the website with the default demo data and the administrator back-end module, both are working fine.
2.- Following your Installation Tutorial I tried to install Solidres in the 3 possible ways all of them giving the following error:
I installed Joomla in a hosting account in a VPS with the following characteristics:
I appreciate a lot your help to find the issue because in Joomla forum I have not found any similar error.

Best regards
joejac

This is what I did:

1.- I reinstalled Joomla with Carset: utf8mb4 Collation: utf8mb4_unicode_ci same problem
2.- I changed all tables and db to MyISAM and restarted MySQL, except these ones:

On these I got:
So these 9 tables still have InnoDB

I have other 2 that has MEMORY type
cabo_finder_tokens MEMORY
cabo_finder_tokens_aggregate MEMORY
The rest are now MyISAM

3.- During the installation Joomla gave a warning that Mcrypt module was not present I installed restarted Apache, verified via command line that php-mcrypt.x86_64 was installed and running but Joomla continued to issue the red warning. I completed the installation successfully despite this warning and Joomla is running fine. But impossible to install Solidres, I installed Joomla only to use Solidres, but no success, this is frustrating, sorry.

4. I have seen in table cabo_assets a field with length 5120:
rules varchar(5120)
4.1 As per several pages in the web this is too long.
dba.stackexchange.com/questions/28219/sq...ified-key-was-too-lo
stackoverflow.com/questions/1814532/1071...-length-is-767-bytes

I do not know what to do, and I spent 2 full days trying to install Solidres.

Any help is very much appreciated.
Thanks and regards
joejac

Thank you very much vietvh,
I will try your solution on the weekend
Best regards
joejac