always get this error.....
* JInstaller::install: Errore SQL. DB function failed with error number 2006
MySQL server has gone away SQL=CREATE TABLE IF NOT EXISTS `jos_joomdoc` ( `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, `dmcounter` int(11) 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, `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`,`approved`,`catid`,`dmcounter`), KEY `own_pub_appr_cat_id` (`dmowner`,`published`,`approved`,`catid`,`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SQL =
CREATE TABLE IF NOT EXISTS `jos_joomdoc` (
`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,
`dmcounter` int(11) 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,
`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`,`approved`,`catid`,`dmcounter`),
KEY `own_pub_appr_cat_id` (`dmowner`,`published`,`approved`,`catid`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
* 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_joomdoc` ( `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, `dmcounter` int(11) 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, `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`,`approved`,`catid`,`dmcounter`), KEY `own_pub_appr_cat_id` (`dmowner`,`published`,`approved`,`catid`,`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SQL =
CREATE TABLE IF NOT EXISTS `jos_joomdoc` (
`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,
`dmcounter` int(11) 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,
`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`,`approved`,`catid`,`dmcounter`),
KEY `own_pub_appr_cat_id` (`dmowner`,`published`,`approved`,`catid`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
* 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
thanks for your help!
