On this moment use i am jocomment 3.26 and my forum gets 4 times a weak world of warcraft, russian and chinees spam. ip-banning is not a sollution for this problem. I want now to upgrade to jocomment 4.0 beta 1 but when i install jocomment get i the following error:
• JInstaller::install: SQL-fout. DB function failed with error number 2006
MySQL server has gone away SQL=CREATE TABLE IF NOT EXISTS `itc_comment_joomvertising` ( `id` int(11) unsigned NOT NULL auto_increment, `type` varchar(255) NOT NULL, `code` TEXT NOT NULL , PRIMARY KEY ( `id` ) ) CHARACTER SET `utf8` COLLATE `utf8_general_ci`;
SQL = CREATE TABLE IF NOT EXISTS `itc_comment_joomvertising` (
• `id` int(11) unsigned NOT NULL auto_increment,
• `type` varchar(255) NOT NULL,
• `code` TEXT NOT NULL ,
• PRIMARY KEY ( `id` )
• ) CHARACTER SET `utf8` COLLATE `utf8_general_ci`;
• component Installeer: SQL fout of SQLbestand ontbreekt of is niet leesbaar. DB function failed with error number 2006
MySQL server has gone away SQL=CREATE TABLE IF NOT EXISTS `itc_comment_joomvertising` ( `id` int(11) unsigned NOT NULL auto_increment, `type` varchar(255) NOT NULL, `code` TEXT NOT NULL , PRIMARY KEY ( `id` ) ) CHARACTER SET `utf8` COLLATE `utf8_general_ci`;
SQL = CREATE TABLE IF NOT EXISTS `itc_comment_joomvertising` (
• `id` int(11) unsigned NOT NULL auto_increment,
• `type` varchar(255) NOT NULL,
• `code` TEXT NOT NULL ,
• PRIMARY KEY ( `id` )
• ) CHARACTER SET `utf8` COLLATE `utf8_general_ci`;
• Error Loading ModulesMySQL server has gone away SQL=SELECT id, title, module, position, content, showtitle, control, params FROM itc_modules AS m LEFT JOIN itc_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
I have manual made this database table but that is not a sollution. I have also remove all jocomment database tables but this also not work
.