Welcome, Guest
Username Password: Remember me
Forgot your password? Forgot your username? Create an account
Foro
Joomla!
Joomla 1.6, 1.7 y 2.5
Otros

Problema base de datos (creo)
(1 viewing) (1) Guest
Reply Topic
New Topic
  • Page:
  • 1

TOPIC: Problema base de datos (creo)

Problema base de datos (creo) 1 year, 2 months ago #18478

Creo que tengo un serio problema con la base de datos o me han vuelto a entrar al hosting porque sino, no me explico esto:

MySQL server has gone away SQL=CREATE TABLE IF NOT EXISTS `jos_jseblod_cck_configuration` ( `id` int(11) NOT NULL auto_increment, `jseblod_section` int(11) NOT NULL, `jseblod_category_auto` int(11) NOT NULL, `jseblod_category_default` int(11) NOT NULL, `jseblod_category_default_reg` int(11) NOT NULL, `view_access_level` int(11) NOT NULL default '23', `edit_access_level` int(11) NOT NULL default '24', `article_creation_mode` tinyint(4) NOT NULL, `article_edition_mode` tinyint(4) NOT NULL, `article_edition2_mode` tinyint(4) NOT NULL, `category_creation_mode` tinyint(4) NOT NULL, `category_edition_mode` tinyint(4) NOT NULL, `category_edition2_mode` tinyint(4) NOT NULL, `user_creation_mode` tinyint(4) NOT NULL, `user_edition_mode` tinyint(4) NOT NULL, `user_edition2_mode` tinyint(4) NOT NULL, `categories_fullscreen` text NOT NULL, `modal_width` int(11) NOT NULL, `modal_height` int(11) NOT NULL, `opening` varchar(50) NOT NULL, `closing` varchar(50) NOT NULL, `template_default_category` tinyint(4) NOT NULL default '0', `type_default_category` tinyint(4) NOT NULL default '0', `item_default_category` tinyint(4) NOT NULL default '0', `template_delete_mode` int(11) NOT NULL default '0', `template_category_delete_mode` int(11) NOT NULL default '0', `type_delete_mode` int(11) NOT NULL default '0', `type_category_delete_mode` int(11) NOT NULL default '0', `item_delete_mode` int(11) NOT NULL default '0', `item_category_delete_mode` int(11) NOT NULL default '0', `template_hidden` text NOT NULL, `jtext_on_label` tinyint(4) NOT NULL default '1', `adminform_tips` tinyint(4) NOT NULL default '1', `siteform_tips` tinyint(4) NOT NULL default '0', `notemplate_display` tinyint(4) NOT NULL default '0', `import_default_mode` tinyint(4) NOT NULL default '0', `export_empty_pack` tinyint(4) NOT NULL default '1', `wysiwyg_editor` varchar(50) NOT NULL, `login_enable` tinyint(4) NOT NULL default '1', `login_typeid` int(11) NOT NULL default '0', `login_templateid` int(11) NOT NULL default '0', `login_itemid` int(11) NOT NULL default '0', `article_typeid` int(11) NOT NULL default '0', `article_templateid` int(11) NOT NULL default '0', `article_itemid` int(11) NOT NULL default '0', `category_typeid` int(11) NOT NULL default '0', `category_templateid` int(11) NOT NULL default '0', `category_itemid` int(11) NOT NULL default '0', `user_typeid` int(11) NOT NULL default '0', `user_templateid` int(11) NOT NULL default '0', `user_itemid` int(11) NOT NULL default '0', `validation_alert` tinyint(4) NOT NULL default '4', `system_component` tinyint(4) NOT NULL default '4', `system_modules` tinyint(4) NOT NULL default '4', `icon_edit` tinyint(4) NOT NULL default '0', `icon_pdf` tinyint(4) NOT NULL default '0', `icon_print` tinyint(4) NOT NULL default '0', `icon_email` tinyint(4) NOT NULL default '0', `cek_column` tinyint(4) NOT NULL default '0', `cek_column_article` tinyint(4) NOT NULL default '0', `cek_column_category` tinyint(4) NOT NULL default '0', `cek_column_user` tinyint(4) NOT NULL default '0', `bool` tinyint(4) NOT NULL default '0', `options` text NOT NULL, `login_bool` tinyint(4) NOT NULL default '0', `article_bool` tinyint(4) NOT NULL default '0', `category_bool` tinyint(4) NOT NULL default '0', `user_bool` tinyint(4) NOT NULL default '0', `bool_publish` tinyint(4) NOT NULL default '0', `bool_hide` tinyint(4) NOT NULL default '0', `bool_check` tinyint(4) NOT NULL default '0', `search_delete_mode` tinyint(4) NOT NULL DEFAULT '0', `search_category_delete_mode` tinyint(4) NOT NULL DEFAULT '0', `search_default_category` tinyint(4) NOT NULL DEFAULT '0', `restriction_type` tinyint(4) NOT NULL default '0', `restriction_field` tinyint(4) NOT NULL default '0', `restriction_content` tinyint(4) NOT NULL default '0', `views_category` tinyint(4) NOT NULL default '0', `views_menu` tinyint(4) NOT NULL default '0', `views_url` tinyint(4) NOT NULL default '0', `views_url_e` tinyint(4) NOT NULL default '0', `checked_out` int(10) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;
SQL =

CREATE TABLE IF NOT EXISTS `jos_jseblod_cck_configuration` (
`id` int(11) NOT NULL auto_increment,
`jseblod_section` int(11) NOT NULL,
`jseblod_category_auto` int(11) NOT NULL,
`jseblod_category_default` int(11) NOT NULL,
`jseblod_category_default_reg` int(11) NOT NULL,
`view_access_level` int(11) NOT NULL default '23',
`edit_access_level` int(11) NOT NULL default '24',
`article_creation_mode` tinyint(4) NOT NULL,
`article_edition_mode` tinyint(4) NOT NULL,
`article_edition2_mode` tinyint(4) NOT NULL,
`category_creation_mode` tinyint(4) NOT NULL,
`category_edition_mode` tinyint(4) NOT NULL,
`category_edition2_mode` tinyint(4) NOT NULL,
`user_creation_mode` tinyint(4) NOT NULL,
`user_edition_mode` tinyint(4) NOT NULL,
`user_edition2_mode` tinyint(4) NOT NULL,
`categories_fullscreen` text NOT NULL,
`modal_width` int(11) NOT NULL,
`modal_height` int(11) NOT NULL,
`opening` varchar(50) NOT NULL,
`closing` varchar(50) NOT NULL,
`template_default_category` tinyint(4) NOT NULL default '0',
`type_default_category` tinyint(4) NOT NULL default '0',
`item_default_category` tinyint(4) NOT NULL default '0',
`template_delete_mode` int(11) NOT NULL default '0',
`template_category_delete_mode` int(11) NOT NULL default '0',
`type_delete_mode` int(11) NOT NULL default '0',
`type_category_delete_mode` int(11) NOT NULL default '0',
`item_delete_mode` int(11) NOT NULL default '0',
`item_category_delete_mode` int(11) NOT NULL default '0',
`template_hidden` text NOT NULL,
`jtext_on_label` tinyint(4) NOT NULL default '1',
`adminform_tips` tinyint(4) NOT NULL default '1',
`siteform_tips` tinyint(4) NOT NULL default '0',
`notemplate_display` tinyint(4) NOT NULL default '0',
`import_default_mode` tinyint(4) NOT NULL default '0',
`export_empty_pack` tinyint(4) NOT NULL default '1',
`wysiwyg_editor` varchar(50) NOT NULL,
`login_enable` tinyint(4) NOT NULL default '1',
`login_typeid` int(11) NOT NULL default '0',
`login_templateid` int(11) NOT NULL default '0',
`login_itemid` int(11) NOT NULL default '0',
`article_typeid` int(11) NOT NULL default '0',
`article_templateid` int(11) NOT NULL default '0',
`article_itemid` int(11) NOT NULL default '0',
`category_typeid` int(11) NOT NULL default '0',
`category_templateid` int(11) NOT NULL default '0',
`category_itemid` int(11) NOT NULL default '0',
`user_typeid` int(11) NOT NULL default '0',
`user_templateid` int(11) NOT NULL default '0',
`user_itemid` int(11) NOT NULL default '0',
`validation_alert` tinyint(4) NOT NULL default '4',
`system_component` tinyint(4) NOT NULL default '4',
`system_modules` tinyint(4) NOT NULL default '4',
`icon_edit` tinyint(4) NOT NULL default '0',
`icon_pdf` tinyint(4) NOT NULL default '0',
`icon_print` tinyint(4) NOT NULL default '0',
`icon_email` tinyint(4) NOT NULL default '0',
`cek_column` tinyint(4) NOT NULL default '0',
`cek_column_article` tinyint(4) NOT NULL default '0',
`cek_column_category` tinyint(4) NOT NULL default '0',
`cek_column_user` tinyint(4) NOT NULL default '0',
`bool` tinyint(4) NOT NULL default '0',
`options` text NOT NULL,
`login_bool` tinyint(4) NOT NULL default '0',
`article_bool` tinyint(4) NOT NULL default '0',
`category_bool` tinyint(4) NOT NULL default '0',
`user_bool` tinyint(4) NOT NULL default '0',
`bool_publish` tinyint(4) NOT NULL default '0',
`bool_hide` tinyint(4) NOT NULL default '0',
`bool_check` tinyint(4) NOT NULL default '0',
`search_delete_mode` tinyint(4) NOT NULL DEFAULT '0',
`search_category_delete_mode` tinyint(4) NOT NULL DEFAULT '0',
`search_default_category` tinyint(4) NOT NULL DEFAULT '0',
`restriction_type` tinyint(4) NOT NULL default '0',
`restriction_field` tinyint(4) NOT NULL default '0',
`restriction_content` tinyint(4) NOT NULL default '0',
`views_category` tinyint(4) NOT NULL default '0',
`views_menu` tinyint(4) NOT NULL default '0',
`views_url` tinyint(4) NOT NULL default '0',
`views_url_e` tinyint(4) NOT NULL default '0',
`checked_out` int(10) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;

Componente Instalar: Error SQL. Archivo SQL no legible o desaparecido. DB function failed with error number 2006
MySQL server has gone away SQL=CREATE TABLE IF NOT EXISTS `jos_jseblod_cck_configuration` ( `id` int(11) NOT NULL auto_increment, `jseblod_section` int(11) NOT NULL, `jseblod_category_auto` int(11) NOT NULL, `jseblod_category_default` int(11) NOT NULL, `jseblod_category_default_reg` int(11) NOT NULL, `view_access_level` int(11) NOT NULL default '23', `edit_access_level` int(11) NOT NULL default '24', `article_creation_mode` tinyint(4) NOT NULL, `article_edition_mode` tinyint(4) NOT NULL, `article_edition2_mode` tinyint(4) NOT NULL, `category_creation_mode` tinyint(4) NOT NULL, `category_edition_mode` tinyint(4) NOT NULL, `category_edition2_mode` tinyint(4) NOT NULL, `user_creation_mode` tinyint(4) NOT NULL, `user_edition_mode` tinyint(4) NOT NULL, `user_edition2_mode` tinyint(4) NOT NULL, `categories_fullscreen` text NOT NULL, `modal_width` int(11) NOT NULL, `modal_height` int(11) NOT NULL, `opening` varchar(50) NOT NULL, `closing` varchar(50) NOT NULL, `template_default_category` tinyint(4) NOT NULL default '0', `type_default_category` tinyint(4) NOT NULL default '0', `item_default_category` tinyint(4) NOT NULL default '0', `template_delete_mode` int(11) NOT NULL default '0', `template_category_delete_mode` int(11) NOT NULL default '0', `type_delete_mode` int(11) NOT NULL default '0', `type_category_delete_mode` int(11) NOT NULL default '0', `item_delete_mode` int(11) NOT NULL default '0', `item_category_delete_mode` int(11) NOT NULL default '0', `template_hidden` text NOT NULL, `jtext_on_label` tinyint(4) NOT NULL default '1', `adminform_tips` tinyint(4) NOT NULL default '1', `siteform_tips` tinyint(4) NOT NULL default '0', `notemplate_display` tinyint(4) NOT NULL default '0', `import_default_mode` tinyint(4) NOT NULL default '0', `export_empty_pack` tinyint(4) NOT NULL default '1', `wysiwyg_editor` varchar(50) NOT NULL, `login_enable` tinyint(4) NOT NULL default '1', `login_typeid` int(11) NOT NULL default '0', `login_templateid` int(11) NOT NULL default '0', `login_itemid` int(11) NOT NULL default '0', `article_typeid` int(11) NOT NULL default '0', `article_templateid` int(11) NOT NULL default '0', `article_itemid` int(11) NOT NULL default '0', `category_typeid` int(11) NOT NULL default '0', `category_templateid` int(11) NOT NULL default '0', `category_itemid` int(11) NOT NULL default '0', `user_typeid` int(11) NOT NULL default '0', `user_templateid` int(11) NOT NULL default '0', `user_itemid` int(11) NOT NULL default '0', `validation_alert` tinyint(4) NOT NULL default '4', `system_component` tinyint(4) NOT NULL default '4', `system_modules` tinyint(4) NOT NULL default '4', `icon_edit` tinyint(4) NOT NULL default '0', `icon_pdf` tinyint(4) NOT NULL default '0', `icon_print` tinyint(4) NOT NULL default '0', `icon_email` tinyint(4) NOT NULL default '0', `cek_column` tinyint(4) NOT NULL default '0', `cek_column_article` tinyint(4) NOT NULL default '0', `cek_column_category` tinyint(4) NOT NULL default '0', `cek_column_user` tinyint(4) NOT NULL default '0', `bool` tinyint(4) NOT NULL default '0', `options` text NOT NULL, `login_bool` tinyint(4) NOT NULL default '0', `article_bool` tinyint(4) NOT NULL default '0', `category_bool` tinyint(4) NOT NULL default '0', `user_bool` tinyint(4) NOT NULL default '0', `bool_publish` tinyint(4) NOT NULL default '0', `bool_hide` tinyint(4) NOT NULL default '0', `bool_check` tinyint(4) NOT NULL default '0', `search_delete_mode` tinyint(4) NOT NULL DEFAULT '0', `search_category_delete_mode` tinyint(4) NOT NULL DEFAULT '0', `search_default_category` tinyint(4) NOT NULL DEFAULT '0', `restriction_type` tinyint(4) NOT NULL default '0', `restriction_field` tinyint(4) NOT NULL default '0', `restriction_content` tinyint(4) NOT NULL default '0', `views_category` tinyint(4) NOT NULL default '0', `views_menu` tinyint(4) NOT NULL default '0', `views_url` tinyint(4) NOT NULL default '0', `views_url_e` tinyint(4) NOT NULL default '0', `checked_out` int(10) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;
SQL =

CREATE TABLE IF NOT EXISTS `jos_jseblod_cck_configuration` (
`id` int(11) NOT NULL auto_increment,
`jseblod_section` int(11) NOT NULL,
`jseblod_category_auto` int(11) NOT NULL,
`jseblod_category_default` int(11) NOT NULL,
`jseblod_category_default_reg` int(11) NOT NULL,
`view_access_level` int(11) NOT NULL default '23',
`edit_access_level` int(11) NOT NULL default '24',
`article_creation_mode` tinyint(4) NOT NULL,
`article_edition_mode` tinyint(4) NOT NULL,
`article_edition2_mode` tinyint(4) NOT NULL,
`category_creation_mode` tinyint(4) NOT NULL,
`category_edition_mode` tinyint(4) NOT NULL,
`category_edition2_mode` tinyint(4) NOT NULL,
`user_creation_mode` tinyint(4) NOT NULL,
`user_edition_mode` tinyint(4) NOT NULL,
`user_edition2_mode` tinyint(4) NOT NULL,
`categories_fullscreen` text NOT NULL,
`modal_width` int(11) NOT NULL,
`modal_height` int(11) NOT NULL,
`opening` varchar(50) NOT NULL,
`closing` varchar(50) NOT NULL,
`template_default_category` tinyint(4) NOT NULL default '0',
`type_default_category` tinyint(4) NOT NULL default '0',
`item_default_category` tinyint(4) NOT NULL default '0',
`template_delete_mode` int(11) NOT NULL default '0',
`template_category_delete_mode` int(11) NOT NULL default '0',
`type_delete_mode` int(11) NOT NULL default '0',
`type_category_delete_mode` int(11) NOT NULL default '0',
`item_delete_mode` int(11) NOT NULL default '0',
`item_category_delete_mode` int(11) NOT NULL default '0',
`template_hidden` text NOT NULL,
`jtext_on_label` tinyint(4) NOT NULL default '1',
`adminform_tips` tinyint(4) NOT NULL default '1',
`siteform_tips` tinyint(4) NOT NULL default '0',
`notemplate_display` tinyint(4) NOT NULL default '0',
`import_default_mode` tinyint(4) NOT NULL default '0',
`export_empty_pack` tinyint(4) NOT NULL default '1',
`wysiwyg_editor` varchar(50) NOT NULL,
`login_enable` tinyint(4) NOT NULL default '1',
`login_typeid` int(11) NOT NULL default '0',
`login_templateid` int(11) NOT NULL default '0',
`login_itemid` int(11) NOT NULL default '0',
`article_typeid` int(11) NOT NULL default '0',
`article_templateid` int(11) NOT NULL default '0',
`article_itemid` int(11) NOT NULL default '0',
`category_typeid` int(11) NOT NULL default '0',
`category_templateid` int(11) NOT NULL default '0',
`category_itemid` int(11) NOT NULL default '0',
`user_typeid` int(11) NOT NULL default '0',
`user_templateid` int(11) NOT NULL default '0',
`user_itemid` int(11) NOT NULL default '0',
`validation_alert` tinyint(4) NOT NULL default '4',
`system_component` tinyint(4) NOT NULL default '4',
`system_modules` tinyint(4) NOT NULL default '4',
`icon_edit` tinyint(4) NOT NULL default '0',
`icon_pdf` tinyint(4) NOT NULL default '0',
`icon_print` tinyint(4) NOT NULL default '0',
`icon_email` tinyint(4) NOT NULL default '0',
`cek_column` tinyint(4) NOT NULL default '0',
`cek_column_article` tinyint(4) NOT NULL default '0',
`cek_column_category` tinyint(4) NOT NULL default '0',
`cek_column_user` tinyint(4) NOT NULL default '0',
`bool` tinyint(4) NOT NULL default '0',
`options` text NOT NULL,
`login_bool` tinyint(4) NOT NULL default '0',
`article_bool` tinyint(4) NOT NULL default '0',
`category_bool` tinyint(4) NOT NULL default '0',
`user_bool` tinyint(4) NOT NULL default '0',
`bool_publish` tinyint(4) NOT NULL default '0',
`bool_hide` tinyint(4) NOT NULL default '0',
`bool_check` tinyint(4) NOT NULL default '0',
`search_delete_mode` tinyint(4) NOT NULL DEFAULT '0',
`search_category_delete_mode` tinyint(4) NOT NULL DEFAULT '0',
`search_default_category` tinyint(4) NOT NULL DEFAULT '0',
`restriction_type` tinyint(4) NOT NULL default '0',
`restriction_field` tinyint(4) NOT NULL default '0',
`restriction_content` tinyint(4) NOT NULL default '0',
`views_category` tinyint(4) NOT NULL default '0',
`views_menu` tinyint(4) NOT NULL default '0',
`views_url` tinyint(4) NOT NULL default '0',
`views_url_e` tinyint(4) NOT NULL default '0',
`checked_out` int(10) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=0 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


He intentado instalar FlexiContent y luego Jseblod CCK y en ambos me da el mismo error, lo raro que hace un tiempo instale varios componentes como Kunena, Content Templater y algunos más y esos si que funcionan bien...
  • Mizunga
  • OFFLINE
  • Colaborador
  • Posts: 461
  • Karma: 28
Unete a la www.euroviajar.com/viajeros.html - Comunidad de Viajeros" y participa en el www.euroviajar.com/foros/5-londres.html - Foro Londres
Reply Quote

Re: Problema base de datos (creo) 1 year, 1 month ago #18517

El problema era el tiempo de instalación, solucionado.
  • Mizunga
  • OFFLINE
  • Colaborador
  • Posts: 461
  • Karma: 28
Unete a la www.euroviajar.com/viajeros.html - Comunidad de Viajeros" y participa en el www.euroviajar.com/foros/5-londres.html - Foro Londres
Reply Quote
Reply Topic
New Topic
  • Page:
  • 1
Foro
Joomla!
Joomla 1.6, 1.7 y 2.5
Otros
Powered by Kunena
Time to create page: 0.31 seconds