1. Forums
  3. Archive
  5. CB
  7. CB 1.2 RC1
  9. General Discussion
  11. Error number 2006 installing CB 1.2

Error number 2006 installing CB 1.2

15 years 10 months ago #66246 by balu
Error number 2006 installing CB 1.2 was created by balu
Error number 2006 installing CB 1.2 on Joomla 1.5.3
PHP-Version:5.2.6

please help me

* JInstaller::install: SQL-Fehler DB function failed with error number 2006
MySQL server has gone away SQL=CREATE TABLE IF NOT EXISTS `jos_comprofiler` ( `id` int(11) NOT NULL default '0', `user_id` int(11) NOT NULL default '0', `firstname` VARCHAR( 100 ), `middlename` VARCHAR( 100 ) , `lastname` VARCHAR( 100 ), `hits` int(11) NOT NULL default '0', `avatar` varchar(255) default NULL, `avatarapproved` tinyint(4) default '1', `approved` tinyint(4) NOT NULL default '1', `confirmed` tinyint(4) NOT NULL default '1', `lastupdatedate` datetime NOT NULL default '0000-00-00 00:00:00', `banned` tinyint(4) NOT NULL default '0', `banneddate` datetime default NULL, `bannedby` int(11) default NULL, `bannedreason` mediumtext, `acceptedterms` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM;
SQL =

CREATE TABLE IF NOT EXISTS `jos_comprofiler` (
`id` int(11) NOT NULL default '0',
`user_id` int(11) NOT NULL default '0',
`firstname` VARCHAR( 100 ),
`middlename` VARCHAR( 100 ) ,
`lastname` VARCHAR( 100 ),
`hits` int(11) NOT NULL default '0',
`avatar` varchar(255) default NULL,
`avatarapproved` tinyint(4) default '1',
`approved` tinyint(4) NOT NULL default '1',
`confirmed` tinyint(4) NOT NULL default '1',
`lastupdatedate` datetime NOT NULL default '0000-00-00 00:00:00',
`banned` tinyint(4) NOT NULL default '0',
`banneddate` datetime default NULL,
`bannedby` int(11) default NULL,
`bannedreason` mediumtext,
`acceptedterms` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;

* Komponente Installieren: SQL-Fehler DB function failed with error number 2006
MySQL server has gone away SQL=CREATE TABLE IF NOT EXISTS `jos_comprofiler` ( `id` int(11) NOT NULL default '0', `user_id` int(11) NOT NULL default '0', `firstname` VARCHAR( 100 ), `middlename` VARCHAR( 100 ) , `lastname` VARCHAR( 100 ), `hits` int(11) NOT NULL default '0', `avatar` varchar(255) default NULL, `avatarapproved` tinyint(4) default '1', `approved` tinyint(4) NOT NULL default '1', `confirmed` tinyint(4) NOT NULL default '1', `lastupdatedate` datetime NOT NULL default '0000-00-00 00:00:00', `banned` tinyint(4) NOT NULL default '0', `banneddate` datetime default NULL, `bannedby` int(11) default NULL, `bannedreason` mediumtext, `acceptedterms` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM;
SQL =

CREATE TABLE IF NOT EXISTS `jos_comprofiler` (
`id` int(11) NOT NULL default '0',
`user_id` int(11) NOT NULL default '0',
`firstname` VARCHAR( 100 ),
`middlename` VARCHAR( 100 ) ,
`lastname` VARCHAR( 100 ),
`hits` int(11) NOT NULL default '0',
`avatar` varchar(255) default NULL,
`avatarapproved` tinyint(4) default '1',
`approved` tinyint(4) NOT NULL default '1',
`confirmed` tinyint(4) NOT NULL default '1',
`lastupdatedate` datetime NOT NULL default '0000-00-00 00:00:00',
`banned` tinyint(4) NOT NULL default '0',
`banneddate` datetime default NULL,
`bannedby` int(11) default NULL,
`bannedreason` mediumtext,
`acceptedterms` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;

Please Log in to join the conversation.

15 years 10 months ago #66310 by balu
Replied by balu on topic Re:Error number 2006 installing CB 1.2
no ideas ???

Please Log in to join the conversation.

15 years 10 months ago #66323 by beat
Replied by beat on topic Re:Error number 2006 installing CB 1.2
Well, errors seems self-explanatory:

MySQL server has gone away


Looks like either your server is completely overloaded, or you have a mysql server problem.

Or you are using special database drivers/extensions...

Or your webserver doesn't have mysql rights to create a sql table...and that's inforced in a curious way.
Beat - Community Builder Team Member

Before posting on forums: Read FAQ thoroughly -- Help us spend more time coding by helping others in this forum, many thanks :)
CB links: Our membership - CBSubs - Templates - Hosting - Forge - Send me a Private Message (PM) only for private/confidential info

Please Log in to join the conversation.

Moderators: beat, nant, krileon
  1. Forums
  3. Archive
  5. CB
  7. CB 1.2 RC1
  9. General Discussion
  11. Error number 2006 installing CB 1.2
Time to create page: 0.247 seconds

Facebook Twitter LinkedIn

    You are here:  
  1. Home
  2. Forums
  3. Archive
  4. CB
  5. CB 1.2 RC1
  6. General Discussion
  7. Error number 2006 installing CB 1.2

Search

Login / Logout

User Menu