0
Hi.
I just bought the MusCon but I cannot succeed in getting it installed. I tried to install it within administration>component>install both automatic and manual, but it didn't work.
What am i doing wrong?
I just bought the MusCon but I cannot succeed in getting it installed. I tried to install it within administration>component>install both automatic and manual, but it didn't work.
What am i doing wrong?
Responses (8)
-
Accepted Answer
0I dont know. it should work perfectly.
what joomla and php versions are you using? what is exactly going wrong? tell me what you see on the screen. does the screen just turn white after a while? if that is the problem, then is that you PHP configuration variable max_execution_time is set to 15 or 30 probably. change it to 60 and you'll have no problem.
if thats not the problem, tell me what you see
Germi -
Accepted Answer
-
Accepted Answer
0I figure it out and solved the first problem. Now when installing the package I have a database error:
JInstaller::install: Errore SQL. DB function failed with error number 1074
Too big column length for column 'keywords' (max = 255). Use BLOB instead SQL=CREATE TABLE IF NOT EXISTS `lou_muscol_albums` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL, `artist_id` int(12) NOT NULL, `year` year(4) NOT NULL, `month` int(2) NOT NULL default '0', `edition_year` year(4) NOT NULL, `edition_month` int(2) NOT NULL, `edition_country` varchar(127) NOT NULL, `edition_details` varchar(255) NOT NULL, `genre_id` int(3) NOT NULL, `catalog_number` varchar(31) NOT NULL, `label` varchar(127) NOT NULL, `length` varchar(9) NOT NULL, `format_id` int(6) NOT NULL, `image` varchar(255) NOT NULL default 'no_image.jpg', `ndisc` int(11) NOT NULL default '1', `types` varchar(31) NOT NULL, `review` mediumtext NOT NULL, `name2` varchar(255) NOT NULL, `artist2` varchar(255) NOT NULL, `subtitle` varchar(255) NOT NULL, `subartist` varchar(255) NOT NULL, `fisic` varchar(4) NOT NULL default 'si', `points` tinyint(1) NOT NULL default '0', `added` datetime NOT NULL default '0000-00-00 00:00:00', `modified` datetime NOT NULL, `price` decimal(6,2) NOT NULL default '0.00', `tags` varchar(63) NOT NULL, `part_of_set` int(6) NOT NULL default '0', `show_separately` varchar(1) NOT NULL default 'Y', `params` mediumtext NOT NULL, `keywords` varchar(2048) NOT NULL, `user_id` int(6) NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM;
SQL =
CREATE TABLE IF NOT EXISTS `lou_muscol_albums` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL,
`artist_id` int(12) NOT NULL,
`year` year(4) NOT NULL,
`month` int(2) NOT NULL default '0',
`edition_year` year(4) NOT NULL,
`edition_month` int(2) NOT NULL,
`edition_country` varchar(127) NOT NULL,
`edition_details` varchar(255) NOT NULL,
`genre_id` int(3) NOT NULL,
`catalog_number` varchar(31) NOT NULL,
`label` varchar(127) NOT NULL,
`length` varchar(9) NOT NULL,
`format_id` int(6) NOT NULL,
`image` varchar(255) NOT NULL default 'no_image.jpg',
`ndisc` int(11) NOT NULL default '1',
`types` varchar(31) NOT NULL,
`review` mediumtext NOT NULL,
`name2` varchar(255) NOT NULL,
`artist2` varchar(255) NOT NULL,
`subtitle` varchar(255) NOT NULL,
`subartist` varchar(255) NOT NULL,
`fisic` varchar(4) NOT NULL default 'si',
`points` tinyint(1) NOT NULL default '0',
`added` datetime NOT NULL default '0000-00-00 00:00:00',
`modified` datetime NOT NULL,
`price` decimal(6,2) NOT NULL default '0.00',
`tags` varchar(63) NOT NULL,
`part_of_set` int(6) NOT NULL default '0',
`show_separately` varchar(1) NOT NULL default 'Y',
`params` mediumtext NOT NULL,
`keywords` varchar(2048) NOT NULL,
`user_id` int(6) NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
componente Installa: Errore file sql non leggibile o non presente. DB function failed with error number 1074
Too big column length for column 'keywords' (max = 255). Use BLOB instead SQL=CREATE TABLE IF NOT EXISTS `lou_muscol_albums` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL, `artist_id` int(12) NOT NULL, `year` year(4) NOT NULL, `month` int(2) NOT NULL default '0', `edition_year` year(4) NOT NULL, `edition_month` int(2) NOT NULL, `edition_country` varchar(127) NOT NULL, `edition_details` varchar(255) NOT NULL, `genre_id` int(3) NOT NULL, `catalog_number` varchar(31) NOT NULL, `label` varchar(127) NOT NULL, `length` varchar(9) NOT NULL, `format_id` int(6) NOT NULL, `image` varchar(255) NOT NULL default 'no_image.jpg', `ndisc` int(11) NOT NULL default '1', `types` varchar(31) NOT NULL, `review` mediumtext NOT NULL, `name2` varchar(255) NOT NULL, `artist2` varchar(255) NOT NULL, `subtitle` varchar(255) NOT NULL, `subartist` varchar(255) NOT NULL, `fisic` varchar(4) NOT NULL default 'si', `points` tinyint(1) NOT NULL default '0', `added` datetime NOT NULL default '0000-00-00 00:00:00', `modified` datetime NOT NULL, `price` decimal(6,2) NOT NULL default '0.00', `tags` varchar(63) NOT NULL, `part_of_set` int(6) NOT NULL default '0', `show_separately` varchar(1) NOT NULL default 'Y', `params` mediumtext NOT NULL, `keywords` varchar(2048) NOT NULL, `user_id` int(6) NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM;
SQL =
CREATE TABLE IF NOT EXISTS `lou_muscol_albums` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL,
`artist_id` int(12) NOT NULL,
`year` year(4) NOT NULL,
`month` int(2) NOT NULL default '0',
`edition_year` year(4) NOT NULL,
`edition_month` int(2) NOT NULL,
`edition_country` varchar(127) NOT NULL,
`edition_details` varchar(255) NOT NULL,
`genre_id` int(3) NOT NULL,
`catalog_number` varchar(31) NOT NULL,
`label` varchar(127) NOT NULL,
`length` varchar(9) NOT NULL,
`format_id` int(6) NOT NULL,
`image` varchar(255) NOT NULL default 'no_image.jpg',
`ndisc` int(11) NOT NULL default '1',
`types` varchar(31) NOT NULL,
`review` mediumtext NOT NULL,
`name2` varchar(255) NOT NULL,
`artist2` varchar(255) NOT NULL,
`subtitle` varchar(255) NOT NULL,
`subartist` varchar(255) NOT NULL,
`fisic` varchar(4) NOT NULL default 'si',
`points` tinyint(1) NOT NULL default '0',
`added` datetime NOT NULL default '0000-00-00 00:00:00',
`modified` datetime NOT NULL,
`price` decimal(6,2) NOT NULL default '0.00',
`tags` varchar(63) NOT NULL,
`part_of_set` int(6) NOT NULL default '0',
`show_separately` varchar(1) NOT NULL default 'Y',
`params` mediumtext NOT NULL,
`keywords` varchar(2048) NOT NULL,
`user_id` int(6) NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM; -
Accepted Answer
0well, all I can see in all this code is:
DB function failed with error number 1074
Too big column length for column 'keywords' (max = 255)
for some reason your mysql server seems to not like Varchar fields of more than 255 chars.
I had never seen this error before, nobody reported this error. this must be something related to your mysql configuration.
well , what you can do is to open the file wich defines the mysql database tables and replace the fields
`keywords` varchar(2048) NOT NULL,
or
`keywords` varchar(512) NOT NULL,
for
`keywords` varchar(255) NOT NULL,
to do it, you'll have to unzip the installation file. then open admin/install/install.mysql.php
make the replacements and then what you previously unziped. then install
all taht being said, this is a very weird problem and as I said it has something to do with your local configuration. furthermore, you should be using PHP 5 in order to run Music Collection. there's no big deal if you have PHP 4, but maybe you'll have to make a small modification or you wont be able to save albums -
Accepted Answer
-
Accepted Answer
-
Accepted Answer
-
Accepted Answer
Your Reply

Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here.
Register Here »