PDA

Zobacz pełną wersję : Nie można zainstalować komponentu Remository



kosmity
08-12-2005, 14: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;

stone
08-12-2005, 22:32
Oj, cos sie wywalilo
Zacznijmy od tego ze skad pobrales komponent i czy napewno jest to najnowsza wersja?

kosmity
08-12-2005, 22:43
Komponent pobrałem z Polskiego Centrum Joomla. Jest to najnowsza wersja: 3.22 PL. Lokalnie dizała bez problemu - problem zaczyna się na serwerze. Jednak wszystko inne chodzi ok.

stone
08-12-2005, 23:09
A jaka masz wersje php i mysql'a?

kosmity
09-12-2005, 00:23
Database Version: 4.1.11 PHP Version: 4.3.11 Web Server: Apache
afe Mode: OFF Open basedir: none Display Errors: ON Short Open Tags: ON File Uploads: ON Magic Quotes: ON Register Globals: ON Output Buffering: OFF Session save path: /tmp Session auto start: 0 XML enabled: Yes Zlib enabled: Yes
Disabled Functions: exec,system,shell_exec,passthru,phpinfo,escapeshel lcmd,escapeshellarg,dl,proc_open,proc_close,pcntl_ exec,psockopen,socket_listen,socket_bind,socket_cr eate,socket_sendto

stone
09-12-2005, 22:00
hmm, wyglada ok

co do bledu analizujac linijke ktora generuje blad byc moze zamiast

FULLTEXT (`filetitle`,`description`,`smalldesc`,`fileauthor `)

powinno by

FULLTEXT `filetitle` (`filetitle`,`description`,`smalldesc`,`fileauthor `)

sprobuj zmienic to w pliku xml i zainstalowac ponownie

kosmity
09-12-2005, 23:16
Niestety nie pomogło!!!

stone
10-12-2005, 23:06
To jeszcze inaczej
Jezeli na localu udalo ci sie zainstalowac to zrob zrzut tej tabeli wklej do pliku instalacyjnego

webdj.pl
16-12-2006, 11:05
WITAM, PRÓBUJE ZAINSTALOWAĆ REMOSITORY 3.40 PL NO I NIECHCE MI SIE ZAINSTALOWAĆ, WYWALA MI COŚ TAKIEGO:


Wczytaj component - Wczytanie pliku NIEUDANE
Błąd: W pakiecie instalacyjnym - brak pliku Joomla! XML.
[ Dalej... ]
Wczytaj component - Niepowodzenie
Nie znaleziono pliku instalacyjnego:
/srv/www/htdocs/web1896/html/media/install_4583b4c302a64/
[ Dalej... ]


CO MAM ZROBIĆ ? - Pomocy :(

stone
17-12-2006, 21:41
Czasem niestety są problemy z odczytanie plików xml z polskich paczek. Ściągnij oryginalną paczkę i podmień ten plik xml w polskiej paczce i sprobuj jeszcze raz zainstalować

josh
18-12-2006, 08:11
problem juz rozwiazany, paczka z Remosem 3.4 PL poprawiona :)

webdj.pl
03-01-2007, 22:47
mam problem, bo jak powrzucam pliki itp.. to na stronie mi pokazuje foldery, w których są pliki. Jak klikne w jakis folder to otwiera sie tylko biała strona na której jest napisane:

Illegal download attempt.