Installation problem

Monday, November 09 2009, 07:43 AM

Offline

Hello Germi,

I recently needed to start my entire website form scratch, moving to a new server. I have since then problems installing JMC 1.5.0 (I fear that file might be corrupt and hence need to download a new one)

My server is running php 5 (5.1.4-Debian-0.1~sarge1 ), max_execution_time 60 60
max_input_time 60 60

Any ideas?





        * JInstaller::install: SQL-Fehler DB function failed with error number 2013

          Lost connection to MySQL server during query SQL=CREATE TABLE IF NOT EXISTS `jos_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, `hits` INT( 11 ) NOT NULL , `buy_link` VARCHAR( 255 ) NOT NULL , `album_file` VARCHAR( 255 ) NOT NULL , PRIMARY KEY (`id`) ) TYPE=MyISAM DEFAULT CHARSET=utf8;

          SQL =



          CREATE TABLE IF NOT EXISTS `jos_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,

            `hits` INT( 11 ) NOT NULL ,

            `buy_link` VARCHAR( 255 ) NOT NULL ,

            `album_file` VARCHAR( 255 ) NOT NULL ,

            PRIMARY KEY  (`id`)

          ) TYPE=MyISAM  DEFAULT CHARSET=utf8;



        * Komponente Installieren: SQL-Fehler! Fehlende oder nicht lesbare SQL-Datei. DB function failed with error number 2013

          Lost connection to MySQL server during query SQL=CREATE TABLE IF NOT EXISTS `jos_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, `hits` INT( 11 ) NOT NULL , `buy_link` VARCHAR( 255 ) NOT NULL , `album_file` VARCHAR( 255 ) NOT NULL , PRIMARY KEY (`id`) ) TYPE=MyISAM DEFAULT CHARSET=utf8;

          SQL =



          CREATE TABLE IF NOT EXISTS `jos_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,

            `hits` INT( 11 ) NOT NULL ,

            `buy_link` VARCHAR( 255 ) NOT NULL ,

            `album_file` VARCHAR( 255 ) NOT NULL ,

            PRIMARY KEY  (`id`)

          ) TYPE=MyISAM  DEFAULT CHARSET=utf8;

Responses (1)

Accepted Answer

Germinal Camps

Offline
Monday, November 09 2009, 04:50 PM - #Permalink
0

mmm.. never faced this problem before...

but you could install it fine the first time, right? and the package is the same...

have you just... tried again? maybe you can increase the max_execution_time, but I dont think thats the cause...
The reply is currently minimized Show

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.

Installation problem

Accepted Answer

Please login to post a reply