Page 1 of 1

Error installing components

Posted: Tue Oct 26, 2010 5:00 am
by tydamac
I'm using the ja portfolio template by joomlart and everything works besides the installation of components. I get this error each time I try installing something:

* JInstaller::install: SQL Error. DB function failed with error number 2006
MySQL server has gone away SQL=CREATE TABLE IF NOT EXISTS `jos_ccb_attachments` ( `id` int(10) unsigned NOT NULL auto_increment, `post_id` int(10) unsigned NOT NULL default '0', `ccb_name` varchar(255) NOT NULL default ' ', `real_name` varchar(255) NOT NULL default ' ', `filesize` int(10) unsigned NOT NULL default '0', `hits` int(10) unsigned NOT NULL default '0', `comment` mediumtext NOT NULL, `filetime` int(10) unsigned NOT NULL default '0', `extension` varchar(100) default NULL, `mimetype` varchar(100) default NULL, PRIMARY KEY (`id`) ) DEFAULT CHARSET=utf8;
SQL =

CREATE TABLE IF NOT EXISTS `jos_ccb_attachments` (
`id` int(10) unsigned NOT NULL auto_increment,
`post_id` int(10) unsigned NOT NULL default '0',
`ccb_name` varchar(255) NOT NULL default ' ',
`real_name` varchar(255) NOT NULL default ' ',
`filesize` int(10) unsigned NOT NULL default '0',
`hits` int(10) unsigned NOT NULL default '0',
`comment` mediumtext NOT NULL,
`filetime` int(10) unsigned NOT NULL default '0',
`extension` varchar(100) default NULL,
`mimetype` varchar(100) default NULL,
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;

* Component Install: SQL error or missing or unreadable SQL file. DB function failed with error number 2006
MySQL server has gone away SQL=CREATE TABLE IF NOT EXISTS `jos_ccb_attachments` ( `id` int(10) unsigned NOT NULL auto_increment, `post_id` int(10) unsigned NOT NULL default '0', `ccb_name` varchar(255) NOT NULL default ' ', `real_name` varchar(255) NOT NULL default ' ', `filesize` int(10) unsigned NOT NULL default '0', `hits` int(10) unsigned NOT NULL default '0', `comment` mediumtext NOT NULL, `filetime` int(10) unsigned NOT NULL default '0', `extension` varchar(100) default NULL, `mimetype` varchar(100) default NULL, PRIMARY KEY (`id`) ) DEFAULT CHARSET=utf8;
SQL =

CREATE TABLE IF NOT EXISTS `jos_ccb_attachments` (
`id` int(10) unsigned NOT NULL auto_increment,
`post_id` int(10) unsigned NOT NULL default '0',
`ccb_name` varchar(255) NOT NULL default ' ',
`real_name` varchar(255) NOT NULL default ' ',
`filesize` int(10) unsigned NOT NULL default '0',
`hits` int(10) unsigned NOT NULL default '0',
`comment` mediumtext NOT NULL,
`filetime` int(10) unsigned NOT NULL default '0',
`extension` varchar(100) default NULL,
`mimetype` varchar(100) default NULL,
PRIMARY KEY (`id`)
) 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


Can anyone help please! I'm trying to install a comment extension and have been struggling for days now. The components I'm having trouble with are webee comments and ccboard.

Thanks!