Salve a tutti!!
Ho da poco avuto a che fare con Joomla e non sono molto esperto.. mi scuso se posto una richiesta troppo stupida ma ho cercato nel forum e anche con google ma non ho trovato una risposta esauriente al mio problema.
Vorrei aggiungere al mio sito joomla il componente JComments per gestire per l'appunto i commenti.
Durante l'installazione ricevo l'errore
* JInstaller::install: Errore SQL. DB function failed with error number 2006
MySQL server has gone away SQL=CREATE TABLE IF NOT EXISTS `jos_jcomments` ( `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `parent` INT(11) UNSIGNED NOT NULL DEFAULT '0', `path` VARCHAR(255) NOT NULL DEFAULT '', `level` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', `object_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', `object_group` VARCHAR(255) NOT NULL DEFAULT '', `object_params` TEXT NOT NULL DEFAULT '', `lang` VARCHAR(255) NOT NULL DEFAULT '', `userid` INT(11) UNSIGNED NOT NULL DEFAULT '0', `name`VARCHAR(255) NOT NULL DEFAULT '', `username`VARCHAR(255) NOT NULL DEFAULT '', `email` VARCHAR(255) NOT NULL DEFAULT '', `homepage` VARCHAR(255) NOT NULL DEFAULT '', `title` VARCHAR(255) NOT NULL DEFAULT '', `comment` TEXT NOT NULL DEFAULT '', `ip` VARCHAR(15) NOT NULL DEFAULT '', `date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `isgood` SMALLINT(5) UNSIGNED NOT NULL default '0', `ispoor` SMALLINT(5) UNSIGNED NOT NULL default '0', `published` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', `subscribe` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', `source` VARCHAR(255) NOT NULL DEFAULT '', `source_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', `checked_out` INT(11) UNSIGNED NOT NULL DEFAULT '0', `checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `editor` VARCHAR(50) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_userid` (`userid`), KEY `idx_source` (`source`), KEY `idx_email` (`email`), KEY `idx_lang` (`lang`), KEY `idx_subscribe` (`subscribe`), KEY `idx_checkout` (`checked_out`), KEY `idx_object` (`object_id`, `object_group`, `published`, `date`), KEY `idx_path` (`path`, `level`) ) TYPE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`;
SQL =
CREATE TABLE IF NOT EXISTS `jos_jcomments` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`parent` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`path` VARCHAR(255) NOT NULL DEFAULT '',
`level` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`object_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`object_group` VARCHAR(255) NOT NULL DEFAULT '',
`object_params` TEXT NOT NULL DEFAULT '',
`lang` VARCHAR(255) NOT NULL DEFAULT '',
`userid` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`name`VARCHAR(255) NOT NULL DEFAULT '',
`username`VARCHAR(255) NOT NULL DEFAULT '',
`email` VARCHAR(255) NOT NULL DEFAULT '',
`homepage` VARCHAR(255) NOT NULL DEFAULT '',
`title` VARCHAR(255) NOT NULL DEFAULT '',
`comment` TEXT NOT NULL DEFAULT '',
`ip` VARCHAR(15) NOT NULL DEFAULT '',
`date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`isgood` SMALLINT(5) UNSIGNED NOT NULL default '0',
`ispoor` SMALLINT(5) UNSIGNED NOT NULL default '0',
`published` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`subscribe` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`source` VARCHAR(255) NOT NULL DEFAULT '',
`source_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`checked_out` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`editor` VARCHAR(50) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `idx_userid` (`userid`),
KEY `idx_source` (`source`),
KEY `idx_email` (`email`),
KEY `idx_lang` (`lang`),
KEY `idx_subscribe` (`subscribe`),
KEY `idx_checkout` (`checked_out`),
KEY `idx_object` (`object_id`, `object_group`, `published`, `date`),
KEY `idx_path` (`path`, `level`)
) TYPE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`;
* componente Installa: Errore file sql non leggibile o non presente. DB function failed with error number 2006
MySQL server has gone away SQL=CREATE TABLE IF NOT EXISTS `jos_jcomments` ( `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `parent` INT(11) UNSIGNED NOT NULL DEFAULT '0', `path` VARCHAR(255) NOT NULL DEFAULT '', `level` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', `object_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', `object_group` VARCHAR(255) NOT NULL DEFAULT '', `object_params` TEXT NOT NULL DEFAULT '', `lang` VARCHAR(255) NOT NULL DEFAULT '', `userid` INT(11) UNSIGNED NOT NULL DEFAULT '0', `name`VARCHAR(255) NOT NULL DEFAULT '', `username`VARCHAR(255) NOT NULL DEFAULT '', `email` VARCHAR(255) NOT NULL DEFAULT '', `homepage` VARCHAR(255) NOT NULL DEFAULT '', `title` VARCHAR(255) NOT NULL DEFAULT '', `comment` TEXT NOT NULL DEFAULT '', `ip` VARCHAR(15) NOT NULL DEFAULT '', `date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `isgood` SMALLINT(5) UNSIGNED NOT NULL default '0', `ispoor` SMALLINT(5) UNSIGNED NOT NULL default '0', `published` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', `subscribe` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', `source` VARCHAR(255) NOT NULL DEFAULT '', `source_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', `checked_out` INT(11) UNSIGNED NOT NULL DEFAULT '0', `checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `editor` VARCHAR(50) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_userid` (`userid`), KEY `idx_source` (`source`), KEY `idx_email` (`email`), KEY `idx_lang` (`lang`), KEY `idx_subscribe` (`subscribe`), KEY `idx_checkout` (`checked_out`), KEY `idx_object` (`object_id`, `object_group`, `published`, `date`), KEY `idx_path` (`path`, `level`) ) TYPE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`;
SQL =
CREATE TABLE IF NOT EXISTS `jos_jcomments` (
`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
`parent` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`path` VARCHAR(255) NOT NULL DEFAULT '',
`level` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`object_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`object_group` VARCHAR(255) NOT NULL DEFAULT '',
`object_params` TEXT NOT NULL DEFAULT '',
`lang` VARCHAR(255) NOT NULL DEFAULT '',
`userid` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`name`VARCHAR(255) NOT NULL DEFAULT '',
`username`VARCHAR(255) NOT NULL DEFAULT '',
`email` VARCHAR(255) NOT NULL DEFAULT '',
`homepage` VARCHAR(255) NOT NULL DEFAULT '',
`title` VARCHAR(255) NOT NULL DEFAULT '',
`comment` TEXT NOT NULL DEFAULT '',
`ip` VARCHAR(15) NOT NULL DEFAULT '',
`date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`isgood` SMALLINT(5) UNSIGNED NOT NULL default '0',
`ispoor` SMALLINT(5) UNSIGNED NOT NULL default '0',
`published` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`subscribe` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
`source` VARCHAR(255) NOT NULL DEFAULT '',
`source_id` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`checked_out` INT(11) UNSIGNED NOT NULL DEFAULT '0',
`checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`editor` VARCHAR(50) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `idx_userid` (`userid`),
KEY `idx_source` (`source`),
KEY `idx_email` (`email`),
KEY `idx_lang` (`lang`),
KEY `idx_subscribe` (`subscribe`),
KEY `idx_checkout` (`checked_out`),
KEY `idx_object` (`object_id`, `object_group`, `published`, `date`),
KEY `idx_path` (`path`, `level`)
) TYPE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`;
* Non è possibile cancellare il file selezionato: 'uninstall.jcomments.php'
* Non è possibile cancellare il file selezionato: 'install.jcomments.php'
* Error Loading ModulesMySQL server has gone away SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 2 AND m.client_id = 1 ORDER BY position, ordering
cioè sembra che il server SQL chiuda la connessione prima del tempo...
Leggendo in giro potrebbe essere un problema di potenza messa a disposizione da Altervista. Ho il database cosiddetto a potenza elevata..
Provando poi anche con l'installazione da cartella viene restituito lo stesso errore..
C'è la possibilità di installare il componente?
Grazie a tutti