ошибка при старте серва

как ето и где править net.sf.l2j.gameserver.communitybbs.BB.Forum error while saving new Forum to db com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '5' for key 'forum_id'

 

а вкаком файле

 

Spoiler: forums.sql

/*
Navicat MySQL Data Transfer

Source Server : localhost_3306
Source Server Version : 50153
Source Host : localhost:3306
Source Database : l2jdb

Target Server Type : MYSQL
Target Server Version : 50153
File Encoding : 65001

Date: 2017-11-22 2110
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for forums
-- ----------------------------
DROP TABLE IF EXISTS `forums`;
CREATE TABLE `forums` (
`forum_id` int(8) DEFAULT '0',
`forum_name` varchar(255) NOT NULL DEFAULT '',
`forum_parent` int(8) NOT NULL DEFAULT '0',
`forum_post` int(8) NOT NULL DEFAULT '0',
`forum_type` int(8) NOT NULL DEFAULT '0',
`forum_perm` int(8) NOT NULL DEFAULT '0',
`forum_owner_id` int(8) NOT NULL DEFAULT '0',
UNIQUE KEY `forum_id` (`forum_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of forums
-- ----------------------------
INSERT INTO `forums` VALUES ('1', 'NormalRoot', '0', '0', '0', '1', '0');
INSERT INTO `forums` VALUES ('2', 'ClanRoot', '0', '0', '0', '0', '0');
INSERT INTO `forums` VALUES ('3', 'MemoRoot', '0', '0', '0', '0', '0');
INSERT INTO `forums` VALUES ('4', 'MailRoot', '0', '0', '0', '0', '0');
INSERT INTO `forums` VALUES ('5', '1212', '3', '0', '3', '3', '268481041');

 

више таблица чо там править

 

исправил всем спс

 

Spoiler: forums.sql

/*
Navicat MySQL Data Transfer

Source Server : localhost_3306
Source Server Version : 50153
Source Host : localhost:3306
Source Database : l2jdb

Target Server Type : MYSQL
Target Server Version : 50153
File Encoding : 65001

Date: 2017-11-22 2110
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for forums
-- ----------------------------
DROP TABLE IF EXISTS `forums`;
CREATE TABLE `forums` (
`forum_id` int(8) DEFAULT '0',
`forum_name` varchar(255) NOT NULL DEFAULT '',
`forum_parent` int(8) NOT NULL DEFAULT '0',
`forum_post` int(8) NOT NULL DEFAULT '0',
`forum_type` int(8) NOT NULL DEFAULT '0',
`forum_perm` int(8) NOT NULL DEFAULT '0',
`forum_owner_id` int(8) NOT NULL DEFAULT '0',
UNIQUE KEY `forum_id` (`forum_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of forums
-- ----------------------------
INSERT INTO `forums` VALUES ('1', 'NormalRoot', '0', '0', '0', '1', '0');
INSERT INTO `forums` VALUES ('2', 'ClanRoot', '0', '0', '0', '0', '0');
INSERT INTO `forums` VALUES ('3', 'MemoRoot', '0', '0', '0', '0', '0');
INSERT INTO `forums` VALUES ('4', 'MailRoot', '0', '0', '0', '0', '0');
INSERT INTO `forums` VALUES ('5', '1212', '3', '0', '3', '3', '268481041');

ето после

Spoiler: forums.sql

-- ---------------------------
-- Table structure for forums
-- ---------------------------
CREATE TABLE IF NOT EXISTS `forums` (
`forum_id` int(8) NOT NULL default '0',
`forum_name` varchar(255) NOT NULL default '',
`forum_parent` int(8) NOT NULL default '0',
`forum_post` int(8) NOT NULL default '0',
`forum_type` int(8) NOT NULL default '0',
`forum_perm` int(8) NOT NULL default '0',
`forum_owner_id` int(8) NOT NULL default '0',
UNIQUE KEY `forum_id` (`forum_id`)
);


INSERT IGNORE INTO `forums` VALUES (1, 'NormalRoot', 0, 0, 0, 1, 0);
INSERT IGNORE INTO `forums` VALUES (2, 'ClanRoot', 0, 0, 0, 0, 0);
INSERT IGNORE INTO `forums` VALUES (3, 'MemoRoot', 0, 0, 0, 0, 0);
INSERT IGNORE INTO `forums` VALUES (4, 'MailRoot', 0, 0, 0, 0, 0);