آپلود سایت - نسخه‌ی قابل چاپ

کد:

SQL query:



-- -------------------------------------------------------- -- -- Table structure for table `ram9d_k2_items` -- CREATE TABLE IF NOT EXISTS `ram9d_k2_items` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL, `alias` varchar(255) DEFAULT NULL, `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) DEFAULT NULL, `extra_fields` text CHARACTER SET utf8 COLLATE utf8_unicode_ci, `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 [...]



MySQL said: Documentation



#1214 - The used table type doesn't support FULLTEXT indexes

کد:

Database error processing line 3

Database server error reply:



ErrNo #0

 SQL=

Raw query text:



CREATE TABLE `#__k2_items` (   `id` int(11) NOT NULL AUTO_INCREMENT,   `title` varchar(255) NOT NULL,   `alias` varchar(255) DEFAULT NULL,   `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) DEFAULT NULL,   `extra_fields` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,   `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 DEFAULT '0',   `image_caption` text NOT NULL,   `image_credits` varchar(255) NOT NULL,   `video_caption` text NOT NULL,   `video_credits` varchar(255) NOT NULL,   `hits` int(10) unsigned NOT NULL,   `params` text NOT NULL,   `metadesc` text NOT NULL,   `metadata` text NOT NULL,   `metakey` text NOT NULL,   `plugins` text NOT NULL,   `language` char(7) NOT NULL,   PRIMARY KEY (`id`),   KEY `item` (`published`,`publish_up`,`publish_down`,`trash`,`access`),   KEY `catid` (`catid`),   KEY `created_by` (`created_by`),   KEY `ordering` (`ordering`),   KEY `featured` (`featured`),   KEY `featured_ordering` (`featured_ordering`),   KEY `hits` (`hits`),   KEY `created` (`created`),   KEY `language` (`language`),   FULLTEXT KEY `search` (`title`,`introtext`,`fulltext`,`extra_fields_search`,`image_caption`,`image_credits`,`video_caption`,`video_credits`,`metadesc`,`metakey`),   FULLTEXT KEY `title` (`title`) ) ENGINE=InnoDB AUTO_INCREMENT=273 DEFAULT CHARSET=utf8