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.
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.