Installation problem

mrmad
mrmad
Offline
0
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

    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