kosmity
08-12-2005, 13:21
Niestety znów problem...
SAFE MODE = OFF
Inne komponenty instalują się bez problemowo
Tymczasem remository wyrzuca błąd:
SQL Error DB function failed with error number 1283
Column 'filetitle' cannot be part of FULLTEXT index SQL=CREATE TABLE IF NOT EXISTS `jos_downloads_files` ( `id` int NOT NULL auto_increment, `sequence` int NOT NULL default '0', `windowtitle` varchar(255) NOT NULL default '', `realname` varchar(255) NOT NULL default '', `islocal` tinyint unsigned NOT NULL default '1', `containerid` smallint NOT NULL default '0', `filepath` varchar (255) NOT NULL default '', `filesize` varchar(255) NOT NULL default '', `filetype` varchar(255) NOT NULL default '', `filetitle` varchar(255) NOT NULL default '', `description` text NOT NULL default '', `smalldesc` text NOT NULL default '', `autoshort` tinyint unsigned NOT NULL default '1', `license` text NOT NULL default '', `licenseagree` tinyint unsigned NOT NULL default '0', `price` int NOT NULL default '0', `currency` char(3) NOT NULL default '', `downloads` int NOT NULL default '0', `url` varchar (255) NOT NULL default '', `icon` varchar(50) NOT NULL default '', `published` tinyint unsigned NOT NULL default '1', `registered` tinyint unsigned NOT NULL default '2', `userupload` tinyint unsigned NOT NULL default '3', `recommended` tinyint unsigned NOT NULL default '0', `recommend_text` text NOT NULL default '', `featured` tinyint NOT NULL default '0', `featured_st_date` date NOT NULL default '2000-01-01', `featured_end_date` date NOT NULL default '2000-01-01', `featured_priority` smallint NOT NULL default '0', `featured_seq` smallint NOT NULL default '0', `featured_text` text NOT NULL default '', `opsystem` varchar (50) NOT NULL default '', `legaltype` varchar (50)NOT NULL default '', `requirements` text NOT NULL default '', `company` varchar (255) NOT NULL default '', `releasedate` date NOT NULL default '1000-01-01', `languages` text NOT NULL default '', `company_URL` varchar (255) NOT NULL default '', `translator` varchar (255) NOT NULL default '', `fileversion` varchar(50) NOT NULL default '', `fileauthor` varchar(100) NOT NULL default '', `author_URL` varchar (255) NOT NULL default '', `filedate` datetime NOT NULL default '2000-01-01 00:00:00', `filehomepage` varchar(255) NOT NULL default '', `screenurl` varchar(255) NOT NULL default '', `plaintext` tinyint unsigned NOT NULL default '0', `isblob` tinyint unsigned NOT NULL default '0', `groupid` smallint NOT NULL default '0', `submittedby` mediumint NOT NULL default '0', `submitdate` datetime NOT NULL default '2000-01-01 00:00:00', UNIQUE KEY `id` (`id`), KEY `filetitle` (`filetitle`), KEY `realname` (`realname`), KEY `url` (`url`), KEY `containerid` (`containerid`,`published`), KEY `recommended` (`containerid`,`recommended`,`published`), KEY `featured` (`containerid`,`featured`,`published`,`featured_st _date`,`featured_end_date`), KEY `opsystem` (`containerid`,`opsystem`,`published`), FULLTEXT (`filetitle`,`description`,`smalldesc`,`fileauthor `) ) TYPE=MyISAM;
SQL =
CREATE TABLE IF NOT EXISTS `jos_downloads_files` ( `id` int NOT NULL auto_increment, `sequence` int NOT NULL default '0', `windowtitle` varchar(255) NOT NULL default '', `realname` varchar(255) NOT NULL default '', `islocal` tinyint unsigned NOT NULL default '1', `containerid` smallint NOT NULL default '0', `filepath` varchar (255) NOT NULL default '', `filesize` varchar(255) NOT NULL default '', `filetype` varchar(255) NOT NULL default '', `filetitle` varchar(255) NOT NULL default '', `description` text NOT NULL default '', `smalldesc` text NOT NULL default '', `autoshort` tinyint unsigned NOT NULL default '1', `license` text NOT NULL default '', `licenseagree` tinyint unsigned NOT NULL default '0', `price` int NOT NULL default '0', `currency` char(3) NOT NULL default '', `downloads` int NOT NULL default '0', `url` varchar (255) NOT NULL default '', `icon` varchar(50) NOT NULL default '', `published` tinyint unsigned NOT NULL default '1', `registered` tinyint unsigned NOT NULL default '2', `userupload` tinyint unsigned NOT NULL default '3', `recommended` tinyint unsigned NOT NULL default '0', `recommend_text` text NOT NULL default '', `featured` tinyint NOT NULL default '0', `featured_st_date` date NOT NULL default '2000-01-01', `featured_end_date` date NOT NULL default '2000-01-01', `featured_priority` smallint NOT NULL default '0', `featured_seq` smallint NOT NULL default '0', `featured_text` text NOT NULL default '', `opsystem` varchar (50) NOT NULL default '', `legaltype` varchar (50)NOT NULL default '', `requirements` text NOT NULL default '', `company` varchar (255) NOT NULL default '', `releasedate` date NOT NULL default '1000-01-01', `languages` text NOT NULL default '', `company_URL` varchar (255) NOT NULL default '', `translator` varchar (255) NOT NULL default '', `fileversion` varchar(50) NOT NULL default '', `fileauthor` varchar(100) NOT NULL default '', `author_URL` varchar (255) NOT NULL default '', `filedate` datetime NOT NULL default '2000-01-01 00:00:00', `filehomepage` varchar(255) NOT NULL default '', `screenurl` varchar(255) NOT NULL default '', `plaintext` tinyint unsigned NOT NULL default '0', `isblob` tinyint unsigned NOT NULL default '0', `groupid` smallint NOT NULL default '0', `submittedby` mediumint NOT NULL default '0', `submitdate` datetime NOT NULL default '2000-01-01 00:00:00', UNIQUE KEY `id` (`id`), KEY `filetitle` (`filetitle`), KEY `realname` (`realname`), KEY `url` (`url`), KEY `containerid` (`containerid`,`published`), KEY `recommended` (`containerid`,`recommended`,`published`), KEY `featured` (`containerid`,`featured`,`published`,`featured_st _date`,`featured_end_date`), KEY `opsystem` (`containerid`,`opsystem`,`published`), FULLTEXT (`filetitle`,`description`,`smalldesc`,`fileauthor `) ) TYPE=MyISAM;
SAFE MODE = OFF
Inne komponenty instalują się bez problemowo
Tymczasem remository wyrzuca błąd:
SQL Error DB function failed with error number 1283
Column 'filetitle' cannot be part of FULLTEXT index SQL=CREATE TABLE IF NOT EXISTS `jos_downloads_files` ( `id` int NOT NULL auto_increment, `sequence` int NOT NULL default '0', `windowtitle` varchar(255) NOT NULL default '', `realname` varchar(255) NOT NULL default '', `islocal` tinyint unsigned NOT NULL default '1', `containerid` smallint NOT NULL default '0', `filepath` varchar (255) NOT NULL default '', `filesize` varchar(255) NOT NULL default '', `filetype` varchar(255) NOT NULL default '', `filetitle` varchar(255) NOT NULL default '', `description` text NOT NULL default '', `smalldesc` text NOT NULL default '', `autoshort` tinyint unsigned NOT NULL default '1', `license` text NOT NULL default '', `licenseagree` tinyint unsigned NOT NULL default '0', `price` int NOT NULL default '0', `currency` char(3) NOT NULL default '', `downloads` int NOT NULL default '0', `url` varchar (255) NOT NULL default '', `icon` varchar(50) NOT NULL default '', `published` tinyint unsigned NOT NULL default '1', `registered` tinyint unsigned NOT NULL default '2', `userupload` tinyint unsigned NOT NULL default '3', `recommended` tinyint unsigned NOT NULL default '0', `recommend_text` text NOT NULL default '', `featured` tinyint NOT NULL default '0', `featured_st_date` date NOT NULL default '2000-01-01', `featured_end_date` date NOT NULL default '2000-01-01', `featured_priority` smallint NOT NULL default '0', `featured_seq` smallint NOT NULL default '0', `featured_text` text NOT NULL default '', `opsystem` varchar (50) NOT NULL default '', `legaltype` varchar (50)NOT NULL default '', `requirements` text NOT NULL default '', `company` varchar (255) NOT NULL default '', `releasedate` date NOT NULL default '1000-01-01', `languages` text NOT NULL default '', `company_URL` varchar (255) NOT NULL default '', `translator` varchar (255) NOT NULL default '', `fileversion` varchar(50) NOT NULL default '', `fileauthor` varchar(100) NOT NULL default '', `author_URL` varchar (255) NOT NULL default '', `filedate` datetime NOT NULL default '2000-01-01 00:00:00', `filehomepage` varchar(255) NOT NULL default '', `screenurl` varchar(255) NOT NULL default '', `plaintext` tinyint unsigned NOT NULL default '0', `isblob` tinyint unsigned NOT NULL default '0', `groupid` smallint NOT NULL default '0', `submittedby` mediumint NOT NULL default '0', `submitdate` datetime NOT NULL default '2000-01-01 00:00:00', UNIQUE KEY `id` (`id`), KEY `filetitle` (`filetitle`), KEY `realname` (`realname`), KEY `url` (`url`), KEY `containerid` (`containerid`,`published`), KEY `recommended` (`containerid`,`recommended`,`published`), KEY `featured` (`containerid`,`featured`,`published`,`featured_st _date`,`featured_end_date`), KEY `opsystem` (`containerid`,`opsystem`,`published`), FULLTEXT (`filetitle`,`description`,`smalldesc`,`fileauthor `) ) TYPE=MyISAM;
SQL =
CREATE TABLE IF NOT EXISTS `jos_downloads_files` ( `id` int NOT NULL auto_increment, `sequence` int NOT NULL default '0', `windowtitle` varchar(255) NOT NULL default '', `realname` varchar(255) NOT NULL default '', `islocal` tinyint unsigned NOT NULL default '1', `containerid` smallint NOT NULL default '0', `filepath` varchar (255) NOT NULL default '', `filesize` varchar(255) NOT NULL default '', `filetype` varchar(255) NOT NULL default '', `filetitle` varchar(255) NOT NULL default '', `description` text NOT NULL default '', `smalldesc` text NOT NULL default '', `autoshort` tinyint unsigned NOT NULL default '1', `license` text NOT NULL default '', `licenseagree` tinyint unsigned NOT NULL default '0', `price` int NOT NULL default '0', `currency` char(3) NOT NULL default '', `downloads` int NOT NULL default '0', `url` varchar (255) NOT NULL default '', `icon` varchar(50) NOT NULL default '', `published` tinyint unsigned NOT NULL default '1', `registered` tinyint unsigned NOT NULL default '2', `userupload` tinyint unsigned NOT NULL default '3', `recommended` tinyint unsigned NOT NULL default '0', `recommend_text` text NOT NULL default '', `featured` tinyint NOT NULL default '0', `featured_st_date` date NOT NULL default '2000-01-01', `featured_end_date` date NOT NULL default '2000-01-01', `featured_priority` smallint NOT NULL default '0', `featured_seq` smallint NOT NULL default '0', `featured_text` text NOT NULL default '', `opsystem` varchar (50) NOT NULL default '', `legaltype` varchar (50)NOT NULL default '', `requirements` text NOT NULL default '', `company` varchar (255) NOT NULL default '', `releasedate` date NOT NULL default '1000-01-01', `languages` text NOT NULL default '', `company_URL` varchar (255) NOT NULL default '', `translator` varchar (255) NOT NULL default '', `fileversion` varchar(50) NOT NULL default '', `fileauthor` varchar(100) NOT NULL default '', `author_URL` varchar (255) NOT NULL default '', `filedate` datetime NOT NULL default '2000-01-01 00:00:00', `filehomepage` varchar(255) NOT NULL default '', `screenurl` varchar(255) NOT NULL default '', `plaintext` tinyint unsigned NOT NULL default '0', `isblob` tinyint unsigned NOT NULL default '0', `groupid` smallint NOT NULL default '0', `submittedby` mediumint NOT NULL default '0', `submitdate` datetime NOT NULL default '2000-01-01 00:00:00', UNIQUE KEY `id` (`id`), KEY `filetitle` (`filetitle`), KEY `realname` (`realname`), KEY `url` (`url`), KEY `containerid` (`containerid`,`published`), KEY `recommended` (`containerid`,`recommended`,`published`), KEY `featured` (`containerid`,`featured`,`published`,`featured_st _date`,`featured_end_date`), KEY `opsystem` (`containerid`,`opsystem`,`published`), FULLTEXT (`filetitle`,`description`,`smalldesc`,`fileauthor `) ) TYPE=MyISAM;