Installing problem

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?
Responses (8)
  • Accepted Answer

    Sunday, August 09 2009, 10:03 PM - #Permalink
    0
    I 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
    The reply is currently minimized Show
  • Accepted Answer

    Sunday, August 09 2009, 11:01 PM - #Permalink
    0
    If I use "upload package file" the error is: "JFolder::create: Infinite loop detected
    Warning! Failed to move file."

    If I use "Install from directory" or "install from url" the error is: "There was an error uploading this file to the server."

    PHP Version is 4.4.8
    Joomla Version is 1.5.14 Stable
    The reply is currently minimized Show
  • Accepted Answer

    Monday, August 10 2009, 01:04 AM - #Permalink
    0
    I 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;
    The reply is currently minimized Show
  • Accepted Answer

    Monday, August 10 2009, 10:18 AM - #Permalink
    0
    well, 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
    The reply is currently minimized Show
  • Accepted Answer

    Monday, August 10 2009, 10:52 AM - #Permalink
    0
    It didn't work. Now the page go blank (without any error) and it's not installed.
    The reply is currently minimized Show
  • Accepted Answer

    Monday, August 10 2009, 11:45 AM - #Permalink
    0
    read a few posts above. I told you what to do if the problem was the page going blank.
    The reply is currently minimized Show
  • Accepted Answer

    Monday, August 10 2009, 06:47 PM - #Permalink
    0
    Unfortunately I don't have access to php.ini to make those changes. My webhosting told me that can't be change.
    I tried to override the php.ini with .htaccess but no success.
    The reply is currently minimized Show
  • Accepted Answer

    Monday, August 10 2009, 07:19 PM - #Permalink
    0
    well, you need to change this parameter to make the install work. it is very weird that your webmaster does not allow you to change it

    have you tried to just put a php.ini file on the root of your site with a single line of text:

    max_execution_time = 60

    ??
    The reply is currently minimized Show
Your Reply