installed and built a Joomla site with K2 in my local pc.
using K2 created 2 K2 items. Frontend display them okay.

But when moving this pc site localhost db DUMP to host domain, encountered below error:
Error

SQL query:

CREATE TABLE `tp1_k2_items` ( `id` int(11) not null auto_increment, `title` varchar(255) not null, `alias` varchar(255), `catid` int(11) not null, `published` smallint(6) not null default '0', `introtext` mediumtext not null, `fulltext` mediumtext not null, `video` text, `gallery` varchar(255), `extra_fields` text, `extra_fields_search` text not null, `created` datetime not null, `created_by` int(11) not null default '0', `created_by_alias` varchar(255) not null, `checked_out` int(10) unsigned not null, `checked_out_time` datetime not null, `modified` datetime not null, `modified_by` int(11) not null default '0', `publish_up` datetime not null, `publish_down` datetime not null, `trash` smallint(6) not null default '0', `access` int(11) not null default '0', `ordering` int(11) not null default '0', `featured` smallint(6) not null default '0', `featured_ordering` int(11) not null defau[...]

MySQL said: Documentation
#1170 - BLOB/TEXT column 'introtext' used in key specification without a key length

Googled internet with no luck.

Posted here looking for your great help.

Found this when i googled - www.mydigitallife.info/mysql-error-1170-42000-blobtext-column-used-in-key-specification-without-a-key-length/

tried follow the link to manually modify DUMP file, limiting all mediumtext column to a small length (tried 333, 11), but still shows error message saying total index length can't be more than 1000.

Any other clue?

Perhaps a developer may be able to assist you.

If it was me, i would just backup the localsite wiith akeeba backup and use akeeba kickstart to extract and install at my host.