Hey guys, I wanted to test this out, but when I tried to install K2 on one of my dev templates, it wouldn't work, I got this error message:

JInstaller::install: SQL Error. DB function failed with error number 2006
MySQL server has gone away SQL=CREATE TABLE IF NOT EXISTS `jos_k2_attachments` ( `id` int(11) NOT NULL auto_increment, `itemID` int(11) NOT NULL, `filename` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `titleAttribute` text NOT NULL, `hits` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `itemID` (`itemID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SQL =
CREATE TABLE IF NOT EXISTS `jos_k2_attachments` (
`id` int(11) NOT NULL auto_increment,
`itemID` int(11) NOT NULL,
`filename` varchar(255) NOT NULL,
`title` varchar(255) NOT NULL,
`titleAttribute` text NOT NULL,
`hits` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `itemID` (`itemID`)
) ENGINE=MyISAM 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_k2_attachments` ( `id` int(11) NOT NULL auto_increment, `itemID` int(11) NOT NULL, `filename` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `titleAttribute` text NOT NULL, `hits` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `itemID` (`itemID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SQL =
CREATE TABLE IF NOT EXISTS `jos_k2_attachments` (
`id` int(11) NOT NULL auto_increment,
`itemID` int(11) NOT NULL,
`filename` varchar(255) NOT NULL,
`title` varchar(255) NOT NULL,
`titleAttribute` text NOT NULL,
`hits` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `itemID` (`itemID`)
) ENGINE=MyISAM 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

Any help would be greatly appreciated

I'm getting the same exact error.

Can anyone help?

I have the latest release of K2 installed. I am only getting this error when attempting to modify a category. Here is a snapshot and the text of the two errors received.



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



DB function failed with error number 2006
MySQL server has gone away SQL=SELECT ordering AS value, name AS text FROM jos_k2_categories ORDER BY ordering

I share the same problem. When trying to install K2 Component, it shows me this error:


* JInstaller::install: SQL Error. DB function failed with error number 2006
MySQL server has gone away SQL=CREATE TABLE IF NOT EXISTS `jos_k2_attachments` ( `id` int(11) NOT NULL AUTO_INCREMENT, `itemID` int(11) NOT NULL, `filename` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `titleAttribute` text NOT NULL, `hits` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `itemID` (`itemID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SQL =

CREATE TABLE IF NOT EXISTS `jos_k2_attachments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`itemID` int(11) NOT NULL,
`filename` varchar(255) NOT NULL,
`title` varchar(255) NOT NULL,
`titleAttribute` text NOT NULL,
`hits` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `itemID` (`itemID`)
) ENGINE=MyISAM 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_k2_attachments` ( `id` int(11) NOT NULL AUTO_INCREMENT, `itemID` int(11) NOT NULL, `filename` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `titleAttribute` text NOT NULL, `hits` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `itemID` (`itemID`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SQL =

CREATE TABLE IF NOT EXISTS `jos_k2_attachments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`itemID` int(11) NOT NULL,
`filename` varchar(255) NOT NULL,
`title` varchar(255) NOT NULL,
`titleAttribute` text NOT NULL,
`hits` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `itemID` (`itemID`)
) ENGINE=MyISAM 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

bump

Did anyone find a solution? I'm getting this today while trying to install latest K2...