by WadJaRa on Mon Jul 28, 2008 2:17 pm
Okay
At first i have loaded the normal .sql files in the database folder from the svn 80 with the database installer.bat.Than i have copied the new .sql files from the CSV170.zip in the database folder and than i have loaded them in navicat. When i want to load skills_data, extra_skills and chest_data than i get this massage at all "finished unsuccessfully"
chest_data massage:
CREATE TABLE `chest_data` (
`id` int(11) NOT NULL auto_increment,
`chestid` int(11) NOT NULL,
`reward` varchar(255) NOT NULL,
`rewardtype` varchar(255) NOT NULL,
`prob` varchar(255) NOT NULL,
`maxamount` varchar(255) NOT NULL,
`maxpossible` int(11) NOT NULL,
`numberofrewards` int(11) NOT NULL,
`Description` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[Msg] Finished - Unsuccessfully
--------------------------------------------------
extra_skills massage:
[Err] 1062 - Duplicate entry '2839' for key 'PRIMARY'
[Err] INSERT INTO `skills_data` VALUES ('2839','0','0','14','0','0','0','0','10','100','0|0|0|0|0','0|0|0|0|0','0|0|0','0|0|0','0','0','0','0','0','0','0','0','0','0','0','0','____________: Metal Moldie _Pre_F2P Unique Skill_','60','0','0','0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------
skills_data massage:
[Err] 1050 - Table 'skills_data' already exists
[Err] #WARNING, multiple skillID detected !! 2987
#WARNING, multiple skillID detected !! 321
#WARNING, multiple skillID detected !! 5587
#Don t forget to enter the good values for fields script, value1, gm_aoe
#
# Table structure for table 'skills_data'
#
CREATE TABLE `skills_data` (
`id` int(11) NOT NULL default '0',
`level` int(11) NOT NULL,
`sp` int(11) NOT NULL,
`type` int(11) NOT NULL,
`range` int(11) NOT NULL,
`target` int(11) NOT NULL,
`power` int(11) NOT NULL,
`duration` int(11) NOT NULL,
`mp` int(11) NOT NULL,
`success` int(11) NOT NULL,
`weapon` varchar(1000) NOT NULL,
`class` varchar(1000) NOT NULL,
`rskills` varchar(1000) NOT NULL,
`lskills` varchar(1000) NOT NULL,
`buff1` int(11) NOT NULL,
`buffv11` int(11) NOT NULL,
`buffv12` int(11) NOT NULL,
`buff2` int(11) NOT NULL,
`buffv21` int(11) NOT NULL,
`buffv22` int(11) NOT NULL,
`buff3` int(11) NOT NULL,
`buffv31` int(11) NOT NULL,
`buffv32` int(11) NOT NULL,
`clevel` int(11) NOT NULL,
`aoe` tinyint(1) NOT NULL,
`aoeradius` int(11) NOT NULL,
`skillname` varchar(100) NOT NULL,
`cooldown` int(11) NOT NULL default '0',
`script` int(11) NOT NULL default '0',
`value1` int(11) NOT NULL default '0',
`gm_aoe` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
[Msg] Finished - Unsuccessfully
--------------------------------------------------
I already get the Fatal Error in my worldserver..
Thx a lot