Ciao a tutti.
Ho un problema nekll'istallazione del componente docman su sito joomla.
Riesco ad installare altri componenti senza problemi.
L'errore è il seguente:
--------------------------------------------------------------
MySQL server has gone away SQL=CREATE TABLE IF NOT EXISTS `jos_docman` ( `id` int(11) NOT NULL auto_increment, `catid` int(11) NOT NULL default 1, `dmname` text NOT NULL, `dmdescription` longtext, `dmdate_published` datetime NOT NULL default '0000-00-00 00:00:00', `dmowner` int(4) NOT NULL default -1, `dmfilename` text NOT NULL, `published` tinyint(1) NOT NULL default 0, `dmurl` text NULL, `dmcounter` int(11) NULL default 0, `checked_out` int(11) NOT NULL default 0, `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `approved` tinyint(1) NOT NULL default 0, `dmthumbnail` text NULL, `dmlastupdateon` datetime default '0000-00-00 00:00:00', `dmlastupdateby` int(5) NOT NULL default -1, `dmsubmitedby` int(5) NOT NULL default -1, `dmmantainedby` int(5) default 0, `dmlicense_id` int(5) default 0, `dmlicense_display` tinyint(1) NOT NULL default 0, `access` int(11) unsigned NOT NULL default 0, `attribs` text NOT NULL, PRIMARY KEY (`id`), KEY `pub_appr_own_cat_name` (`published`,`approved`,`dmowner`,`catid`,`dmname` (64)), KEY `appr_pub_own_cat_date` (`approved`,`published`,`dmowner`,`catid`,`dmdate_ published`), KEY `own_pub_appr_cat_count`(`dmowner`,`published`,`ap proved`,`catid`,`dmcounter`), KEY `own_pub_appr_cat_id` (`dmowner`, `published`, `approved`, `catid`, `id`) ) TYPE=MyISAM;
SQL =
CREATE TABLE IF NOT EXISTS `jos_docman` (
`id` int(11) NOT NULL auto_increment,
`catid` int(11) NOT NULL default 1,
`dmname` text NOT NULL, `dmdescription` longtext,
`dmdate_published` datetime NOT NULL default '0000-00-00 00:00:00',
`dmowner` int(4) NOT NULL default -1,
`dmfilename` text NOT NULL,
`published` tinyint(1) NOT NULL default 0,
`dmurl` text NULL,
`dmcounter` int(11) NULL default 0,
`checked_out` int(11) NOT NULL default 0,
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`approved` tinyint(1) NOT NULL default 0,
`dmthumbnail` text NULL,
`dmlastupdateon` datetime default '0000-00-00 00:00:00',
`dmlastupdateby` int(5) NOT NULL default -1,
`dmsubmitedby` int(5) NOT NULL default -1,
`dmmantainedby` int(5) default 0,
`dmlicense_id` int(5) default 0,
`dmlicense_display` tinyint(1) NOT NULL default 0,
`access` int(11) unsigned NOT NULL default 0,
`attribs` text NOT NULL,
PRIMARY KEY (`id`),
KEY `pub_appr_own_cat_name` (`published`,`approved`,`dmowner`,`catid`,`dmname` (64)),
KEY `appr_pub_own_cat_date` (`approved`,`published`,`dmowner`,`catid`,`dmdate_ published`),
KEY `own_pub_appr_cat_count`(`dmowner`,`published`,`ap proved`,`catid`,`dmcounter`),
KEY `own_pub_appr_cat_id` (`dmowner`, `published`, `approved`, `catid`, `id`)
) TYPE=MyISAM;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_docman` ( `id` int(11) NOT NULL auto_increment, `catid` int(11) NOT NULL default 1, `dmname` text NOT NULL, `dmdescription` longtext, `dmdate_published` datetime NOT NULL default '0000-00-00 00:00:00', `dmowner` int(4) NOT NULL default -1, `dmfilename` text NOT NULL, `published` tinyint(1) NOT NULL default 0, `dmurl` text NULL, `dmcounter` int(11) NULL default 0, `checked_out` int(11) NOT NULL default 0, `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `approved` tinyint(1) NOT NULL default 0, `dmthumbnail` text NULL, `dmlastupdateon` datetime default '0000-00-00 00:00:00', `dmlastupdateby` int(5) NOT NULL default -1, `dmsubmitedby` int(5) NOT NULL default -1, `dmmantainedby` int(5) default 0, `dmlicense_id` int(5) default 0, `dmlicense_display` tinyint(1) NOT NULL default 0, `access` int(11) unsigned NOT NULL default 0, `attribs` text NOT NULL, PRIMARY KEY (`id`), KEY `pub_appr_own_cat_name` (`published`,`approved`,`dmowner`,`catid`,`dmname` (64)), KEY `appr_pub_own_cat_date` (`approved`,`published`,`dmowner`,`catid`,`dmdate_ published`), KEY `own_pub_appr_cat_count`(`dmowner`,`published`,`ap proved`,`catid`,`dmcounter`), KEY `own_pub_appr_cat_id` (`dmowner`, `published`, `approved`, `catid`, `id`) ) TYPE=MyISAM;
SQL =
CREATE TABLE IF NOT EXISTS `jos_docman` (
`id` int(11) NOT NULL auto_increment,
`catid` int(11) NOT NULL default 1,
`dmname` text NOT NULL, `dmdescription` longtext,
`dmdate_published` datetime NOT NULL default '0000-00-00 00:00:00',
`dmowner` int(4) NOT NULL default -1,
`dmfilename` text NOT NULL,
`published` tinyint(1) NOT NULL default 0,
`dmurl` text NULL,
`dmcounter` int(11) NULL default 0,
`checked_out` int(11) NOT NULL default 0,
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`approved` tinyint(1) NOT NULL default 0,
`dmthumbnail` text NULL,
`dmlastupdateon` datetime default '0000-00-00 00:00:00',
`dmlastupdateby` int(5) NOT NULL default -1,
`dmsubmitedby` int(5) NOT NULL default -1,
`dmmantainedby` int(5) default 0,
`dmlicense_id` int(5) default 0,
`dmlicense_display` tinyint(1) NOT NULL default 0,
`access` int(11) unsigned NOT NULL default 0,
`attribs` text NOT NULL,
PRIMARY KEY (`id`),
KEY `pub_appr_own_cat_name` (`published`,`approved`,`dmowner`,`catid`,`dmname` (64)),
KEY `appr_pub_own_cat_date` (`approved`,`published`,`dmowner`,`catid`,`dmdate_ published`),
KEY `own_pub_appr_cat_count`(`dmowner`,`published`,`ap proved`,`catid`,`dmcounter`),
KEY `own_pub_appr_cat_id` (`dmowner`, `published`, `approved`, `catid`, `id`)
) TYPE=MyISAM;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
DOCman is a document management and download component for Joomla
Carica file pacchetto
Pacchetto:
Installazione da cartella
---------------------------------------------------------------
Come posso procedere?
ho visto che anche un altro utente ha avuto oggi un pb simile ma non ha spiegato la soluzione
grazie 1000!
Mi pare di aver capito che il problema potrebbe dipendere dal max_allowed_packet che ha un valore basso.
Infatti usando myphpadmin e impostando la query show variables vedo che il value è 1048576. Mi dite come faccio ad aumentare tale valore?
C'è un comando sql da poter dare?