عزیزان سلام
چند ماهیه روی یک سرور جدید دارم کار میکنم. 2 تا سایت جوملا دارم که از روی لوکال انتقال دادم.
مشکلی نداره ، جر نصب کامپوننت ها. به طور مثال با کامپوننت های Docman و Joomgallery مشکل داره.
به خواطر متن طولانی از دوستان عضر خواهر میکنم.کد:* JInstaller::install: خطای SQL. DB function failed with error number 2006
MySQL server has gone away SQL=CREATE TABLE IF NOT EXISTS `ind_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`,`approved`,`catid`,`dmcounter`), KEY `own_pub_appr_cat_id` (`dmowner`, `published`, `approved`, `catid`, `id`) ) TYPE=MyISAM;
SQL =
CREATE TABLE IF NOT EXISTS `ind_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`,`approved`,`catid`,`dmcounter`),
KEY `own_pub_appr_cat_id` (`dmowner`, `published`, `approved`, `catid`, `id`)
) TYPE=MyISAM;
* کامپوننت نصب: SQL خطا دارد، یا مفقود شده است و یا فایل SQL قابل خواندن نمیباشد. DB function failed with error number 2006
MySQL server has gone away SQL=CREATE TABLE IF NOT EXISTS `ind_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`,`approved`,`catid`,`dmcounter`), KEY `own_pub_appr_cat_id` (`dmowner`, `published`, `approved`, `catid`, `id`) ) TYPE=MyISAM;
SQL =
CREATE TABLE IF NOT EXISTS `ind_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`,`approved`,`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 ind_modules AS m LEFT JOIN ind_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
** تگ کد اضافه شد
