ошибка при установки базы

[Devilop]

начинаю заливать базу а мне в ответ выдаються ошибки
вот лог установки GS

лог

L2 Phoenix Setup

### Install Game Server ###

(i) Install Game Server. Warning !!! All Game Server Database will be deleted !!
!
(m) Main menu
(q) Quit

Your choice ?:i

Making a full backup into 26.08.2010-18'07'07_backup_full.sql


Installing general tables !!!

Loading Table: ally_data
Loading Table: auction
Loading Table: auction_bid
Loading Table: bans
Loading Table: bonus
Loading Table: castle
Loading Table: castle_manor_procure
Loading Table: castle_manor_production
Loading Table: character_blocklist
Loading Table: character_bookmarks
Loading Table: character_effects_save
Loading Table: character_friends
Loading Table: character_hennas
Loading Table: character_macroses
Loading Table: character_quests
Loading Table: character_recipebook
Loading Table: character_shortcuts
Loading Table: character_skills
Loading Table: character_skills_save
Loading Table: character_subclasses
Loading Table: character_variables
Loading Table: characters
Loading Table: clan_data
Loading Table: clan_notices
Loading Table: clan_privs
Loading Table: clan_skills
Loading Table: clan_subpledges
Loading Table: clan_wars
Loading Table: clanhall
Loading Table: couples
Loading Table: craftcount
Loading Table: cursed_weapons
Loading Table: dropcount
Loading Table: epic_boss_spawn
Loading Table: forts
Loading Table: forums
Loading Table: game_log
Loading Table: games
Loading Table: global_tasks
Loading Table: heroes
Loading Table: item_attributes
Loading Table: items
Loading Table: items_delayed
Loading Table: killcount
Loading Table: mail
Loading Table: olympiad_nobles
Loading Table: petitions
Loading Table: pets
Loading Table: posts
Loading Table: raidboss_points
Loading Table: raidboss_status
Loading Table: residence_functions
Loading Table: server_variables
Loading Table: seven_signs
Loading Table: seven_signs_festival
ERROR 1101 (42000) at line 1: BLOB/TEXT column 'names' can't have a default valu
e
Loading Table: seven_signs_status
Loading Table: siege_clans
Loading Table: siege_doorupgrade
Loading Table: siege_guards
Loading Table: siege_territory_members
Loading Table: topic
Loading Table: tournament_table
Loading Table: tournament_teams
Loading Table: tournament_variables
Loading Table: vote

Upgrading tables !!!

Loading Table: ai_params
Loading Table: armor
Loading Table: armor_ex
Loading Table: armorsets
Loading Table: auto_chat
Loading Table: auto_chat_text
Loading Table: char_templates
Loading Table: class_list
Loading Table: doors
Loading Table: droplist
Loading Table: etcitem
Loading Table: fish
Loading Table: fishreward
Loading Table: four_sepulchers_spawnlist
Loading Table: henna
Loading Table: henna_trees
Loading Table: lastimperialtomb_spawnlist
Loading Table: locations
Loading Table: lvlupgain
Loading Table: mapregion
Loading Table: merchant_areas_list
Loading Table: minions
Loading Table: npc
ERROR 2006 (HY000) at line 59: MySQL server has gone away
Loading Table: npcskills
Loading Table: pet_data
Loading Table: pets_skills
Loading Table: random_spawn
Loading Table: random_spawn_loc
Loading Table: recipes
Loading Table: recitems
Loading Table: siege_door
Loading Table: skills
Loading Table: skill_learn
Loading Table: skill_spellbooks
Loading Table: skill_trees
Loading Table: spawnlist
Loading Table: tournament_class_list
Loading Table: weapon
Loading Table: weapon_ex
Loading Table: updates

Complete !!!

Для продолжения нажмите любую клавишу . . .

после чего делаю запуск сервера а он критует с такими ошибками

лог ГС

at l2p.gameserver.model.L2Spawn.<init>(L2Spawn.java:95)
at l2p.gameserver.model.AutoSpawnHandler$AutoSpawner.run(AutoSpawnHandle
r.java:404)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$301(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
18:13:42.781 AutoSpawnHandler: An error occurred while initializing spawn insta
nce (Object ID = 268438323): java.lang.NullPointerException
18:13:42.593 AutoSpawnHandler: An error occurred while initializing spawn insta
nce (Object ID = 268438302): java.lang.NullPointerException
java.lang.NullPointerException
at l2p.gameserver.model.L2Spawn.<init>(L2Spawn.java:95)
at l2p.gameserver.model.AutoSpawnHandler$AutoSpawner.run(AutoSpawnHandle
r.java:404)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$301(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
java.lang.NullPointerException
at l2p.gameserver.model.L2Spawn.<init>(L2Spawn.java:95)
at l2p.gameserver.model.AutoSpawnHandler$AutoSpawner.run(AutoSpawnHandle
r.java:404)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$301(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
18:13:42.593 AutoSpawnHandler: An error occurred while initializing spawn insta
nce (Object ID = 268438306): java.lang.NullPointerException
18:13:42.593 AutoSpawnHandler: An error occurred while initializing spawn insta
nce (Object ID = 268438305): java.lang.NullPointerException
java.lang.NullPointerException
at l2p.gameserver.model.L2Spawn.<init>(L2Spawn.java:95)
at l2p.gameserver.model.AutoSpawnHandler$AutoSpawner.run(AutoSpawnHandle
r.java:404)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$301(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
java.lang.NullPointerException
at l2p.gameserver.model.L2Spawn.<init>(L2Spawn.java:95)
at l2p.gameserver.model.AutoSpawnHandler$AutoSpawner.run(AutoSpawnHandle
r.java:404)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$301(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
18:13:42.593 AutoSpawnHandler: An error occurred while initializing spawn insta
nce (Object ID = 268438303): java.lang.NullPointerException
java.lang.NullPointerException
at l2p.gameserver.model.L2Spawn.<init>(L2Spawn.java:95)
at l2p.gameserver.model.AutoSpawnHandler$AutoSpawner.run(AutoSpawnHandle
r.java:404)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$301(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
18:13:42.593 AutoSpawnHandler: An error occurred while initializing spawn insta
nce (Object ID = 268438304): java.lang.NullPointerException
java.lang.NullPointerException
at l2p.gameserver.model.L2Spawn.<init>(L2Spawn.java:95)
at l2p.gameserver.model.AutoSpawnHandler$AutoSpawner.run(AutoSpawnHandle
r.java:404)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$301(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
18:13:42.828 AutoSpawnHandler: An error occurred while initializing spawn insta
nce (Object ID = 268438326): java.lang.NullPointerException
java.lang.NullPointerException
at l2p.gameserver.model.L2Spawn.<init>(L2Spawn.java:95)
at l2p.gameserver.model.AutoSpawnHandler$AutoSpawner.run(AutoSpawnHandle
r.java:404)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$301(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
18:13:42.812 AutoSpawnHandler: An error occurred while initializing spawn insta
nce (Object ID = 268438325): java.lang.NullPointerException
18:13:42.796 AutoSpawnHandler: An error occurred while initializing spawn insta
nce (Object ID = 268438324): java.lang.NullPointerException
java.lang.NullPointerException
at l2p.gameserver.model.L2Spawn.<init>(L2Spawn.java:95)
at l2p.gameserver.model.AutoSpawnHandler$AutoSpawner.run(AutoSpawnHandle
r.java:404)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$301(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
18:13:42.765 AutoSpawnHandler: An error occurred while initializing spawn insta
nce (Object ID = 268438322): java.lang.NullPointerException
java.lang.NullPointerException
at l2p.gameserver.model.L2Spawn.<init>(L2Spawn.java:95)
at l2p.gameserver.model.AutoSpawnHandler$AutoSpawner.run(AutoSpawnHandle
r.java:404)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$301(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
18:13:42.734 AutoSpawnHandler: An error occurred while initializing spawn insta
nce (Object ID = 268438320): java.lang.NullPointerException
java.lang.NullPointerException
at l2p.gameserver.model.L2Spawn.<init>(L2Spawn.java:95)
at l2p.gameserver.model.AutoSpawnHandler$AutoSpawner.run(AutoSpawnHandle
r.java:404)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$301(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
java.lang.NullPointerException
at l2p.gameserver.model.L2Spawn.<init>(L2Spawn.java:95)
at l2p.gameserver.model.AutoSpawnHandler$AutoSpawner.run(AutoSpawnHandle
r.java:404)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$301(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
18:13:42.718 AutoSpawnHandler: An error occurred while initializing spawn insta
nce (Object ID = 268438319): java.lang.NullPointerException
java.lang.NullPointerException
at l2p.gameserver.model.L2Spawn.<init>(L2Spawn.java:95)
at l2p.gameserver.model.AutoSpawnHandler$AutoSpawner.run(AutoSpawnHandle
r.java:404)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$301(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
18:13:42.703 AutoSpawnHandler: An error occurred while initializing spawn insta
nce (Object ID = 268438318): java.lang.NullPointerException
18:13:42.671 AutoSpawnHandler: An error occurred while initializing spawn insta
nce (Object ID = 268438317): java.lang.NullPointerException
java.lang.NullPointerException
at l2p.gameserver.model.L2Spawn.<init>(L2Spawn.java:95)
at l2p.gameserver.model.AutoSpawnHandler$AutoSpawner.run(AutoSpawnHandle
r.java:404)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$301(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
java.lang.NullPointerException
at l2p.gameserver.model.L2Spawn.<init>(L2Spawn.java:95)
at l2p.gameserver.model.AutoSpawnHandler$AutoSpawner.run(AutoSpawnHandle
r.java:404)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$301(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
18:13:42.640 AutoSpawnHandler: An error occurred while initializing spawn insta
nce (Object ID = 268438316): java.lang.NullPointerException
java.lang.NullPointerException
at l2p.gameserver.model.L2Spawn.<init>(L2Spawn.java:95)
at l2p.gameserver.model.AutoSpawnHandler$AutoSpawner.run(AutoSpawnHandle
r.java:404)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$301(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
java.lang.NullPointerException
at l2p.gameserver.model.L2Spawn.<init>(L2Spawn.java:95)
at l2p.gameserver.model.AutoSpawnHandler$AutoSpawner.run(AutoSpawnHandle
r.java:404)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$301(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
java.lang.NullPointerException
at l2p.gameserver.model.L2Spawn.<init>(L2Spawn.java:95)
at l2p.gameserver.model.AutoSpawnHandler$AutoSpawner.run(AutoSpawnHandle
r.java:404)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
access$301(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source
)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

это тока часть лога который я успел поймать
ОС Win XP SP3 Prof
MySQL 5.5
зборка фениксов

[Array]

ERROR 2006 (HY000) at line 59: MySQL server has gone away

Эта ошибка появляется каждый раз? Что-то не то с MySQL.
Возможно из-за этого и все остальные проблемы.

[Devilop]

однако если пытаться сделать обгрейд базы то пишет

вот что

L2 Phoenix Setup

### Upgrade Menu ###

(u) Upgrade Database
(m) Main menu
(q) Quit

Your choice ?:u

Upgrading tables !!!

Loading Table: ai_params
Loading Table: armor
Loading Table: armor_ex
Loading Table: armorsets
Loading Table: auto_chat
Loading Table: auto_chat_text
Loading Table: char_templates
Loading Table: class_list
Loading Table: doors
Loading Table: droplist
Loading Table: etcitem
Loading Table: fish
Loading Table: fishreward
Loading Table: four_sepulchers_spawnlist
Loading Table: henna
Loading Table: henna_trees
Loading Table: lastimperialtomb_spawnlist
Loading Table: locations
Loading Table: lvlupgain
Loading Table: mapregion
Loading Table: merchant_areas_list
Loading Table: minions
Loading Table: npc
ERROR 2006 (HY000) at line 59: MySQL server has gone away
Loading Table: npcskills
Loading Table: pet_data
Loading Table: pets_skills
Loading Table: random_spawn
Loading Table: random_spawn_loc
Loading Table: recipes
Loading Table: recitems
Loading Table: siege_door
Loading Table: skills
Loading Table: skill_learn
Loading Table: skill_spellbooks
Loading Table: skill_trees
Loading Table: spawnlist
Loading Table: tournament_class_list
Loading Table: weapon
Loading Table: weapon_ex
Loading Table: updates

Complete !!!

Для продолжения нажмите любую клавишу . . .

открывал запрос npc.sql опускался до 59 строки а там вот что

смотрим

INSERT INTO `npc` (`ordinal`, `id`, `name`, `title`, `class`, `collision_radius`, `collision_height`, `level`, `sex`, `type`, `ai_type`, `attackrange`, `hp`, `base_hp_regen`, `mp`, `base_mp_regen`, `str`, `con`, `dex`, `int`, `wit`, `men`, `exp`, `sp`, `patk`, `pdef`, `matk`, `mdef`, `atkspd`, `aggro`, `matkspd`, `rhand`, `lhand`, `armor`, `walkspd`, `runspd`, `faction_id`, `faction_range`, `displayId`, `shield_defense_rate`, `shield_defense`, `corpse_time`, `base_rand_dam`, `base_critical`, `physical_hit_modify`, `base_reuse_delay`, `physical_avoid_modify`, `hit_time_factor`, `isDropHerbs`, `shots`, `map_flag`, `boss_flag`) VALUES

и что самое смешное так это то что он ругаеться тока у меня даже с версией MySQL 5,4
когда вручную заливаю в базу через navicat пишет следующее

тыц

[Err] 1153 - Got a packet bigger than 'max_allowed_packet' bytes
[Err] INSERT INTO `npc` (`ordinal`, `id`, `name`, `title`, `class`, `collision_radius`, `collision_height`, `level`, `sex`, `type`, `ai_type`, `attackrange`, `hp`, `base_hp_regen`, `mp`, `base_mp_regen`, `str`, `con`, `dex`, `int`, `wit`, `men`, `exp`, `sp`, `patk`, `pdef`, `matk`, `mdef`, `atkspd`, `aggro`, `matkspd`, `rhand`, `lhand`, `armor`, `walkspd`, `runspd`, `faction_id`, `faction_range`, `displayId`, `shield_defense_rate`, `shield_defense`, `corpse_time`, `base_rand_dam`, `base_critical`, `physical_hit_modify`, `base_reuse_delay`, `physical_avoid_modify`, `hit_time_factor`, `isDropHerbs`, `shots`, `map_flag`, `boss_flag`) VALUES
(1,20001,'Gremlin','','gremlin',10.00,15.00,1,'male','L2Monster','Fighter',40,63,'1.500',44,'0.900',40,43,30,21,20,20,29,2,9,44,7,35,253,0,500,0,0,0,20,50,'',0,0,0,0,7,30,4,4,0,0,'0.37','false','NONE',0,0),
(2,20002,'Rabbit','','rabbit',5.00,4.50,1,'male','L2Monster','Fighter',40,63,'1.500',44,'0.900',40,43,30,21,20,20,29,2,9,44,7,35,253,0,500,0,0,0,50,80,'',0,0,0,0,7,30,4,4,0,0,'0.60','false','NONE',0,0),
(3,20003,'Goblin','','goblin',10.00,16.50,5,'male','L2Monster','Fighter',40,127,'1.900',77,'1.020',40,43,30,21,20,20,178,5,16,50,7,41,253,0,500,4,0,0,40,110,'goblin_clan',300,0,0,0,7,50,1,9,0,0,'0.32','true','NONE',1,0),
(4,20004,'Imp','','imp',10.00,24.00,6,'male','L2Monster','Fighter',40,148,'2.000',86,'1.050',40,43,30,21,20,20,214,6,17,53,7,43,253,0,500,0,0,0,60,80,'demonic_clan',300,0,0,0,7,30,4,4,0,0,'0.34','true','NONE',1,0),
(5,20005,'Imp Elder','','imp',10.00,24.00,7,'male','L2Monster','Fighter',40,171,'2.100',94,'1.080',40,43,30,21,20,20,249,8,19,55,7,44,253,0,500,0,0,0,60,80,'demonic_clan',300,0,0,0,7,30,4,4,0,0,'0.34','true','NONE',1,0),
(6,20006,'Orc Archer','','orc_archer',14.00,25.00,8,'male','L2Monster','Ranger',1100,197,'2.200',103,'1.110',40,43,30,21,20,20,293,10,21,58,10,46,253,0,500,14,0,0,45,110,'orc_clan',300,0,0,0,7,10,8,4,1500,0,'0.80','true','NONE',1,0),
(7,20007,'Green Fungus','','walking_fungus',15.00,22.50,9,'male','L2Monster','Fighter',40,226,'2.300',112,'1.140',40,43,30,21,20,20,321,11,23,60,11,48,253,0,500,0,0,0,70,110,'',0,0,0,0,7,30,4,4,0,0,'0.41','true','NONE',1,0),
(8,20008,'Felim Lizardman','','virud_lizardman',10.00,23.00,14,'male','L2Monster','Fighter',40,364,'2.800',156,'1.290',40,43,30,21,20,20,499,19,37,75,13,61,253,0,500,1,0,0,43,130,'lizardman_clan',300,0,0,0,7,30,4,4,0,0,'0.48','true','NONE',1,0),
(9,20009,'Vuku Orc','','orc',10.00,21.00,14,'male','L2Monster','Fighter',40,364,'2.800',156,'1.290',40,43,30,21,20,20,499,19,37,75,13,61,253,0,500,156,0,0,45,110,'orc_clan',300,0,0,0,7,50,1,9,0,0,'0.48','true','NONE',1,0),
(10,20010,'Felim Lizardman Scout','','virud_lizardman',10.00,23.00,15,'male','L2Monster','Fighter',40,390,'2.900',166,'1.320',40,43,30,21,20,20,534,22,41,78,19,64,253,0,500,16,0,0,43,130,'lizardman_clan',300,0,0,0,7,30,4,4,0,0,'0.48','true','NONE',1,0),
(11,20011,'Vuku Orc Archer','','orc_archer',14.00,25.00,15,'male','L2Monster','Ranger',1100,390,'2.900',166,'1.320',40,43,30,21,20,20,551,22,41,78,19,64,253,0,500,14,0,0,45,110,'orc_clan',300,0,0,0,7,10,8,4,1500,0,'0.80','true','NONE',1,0),
(12,20012,'Gora Werewolf','','werewolf',10.00,26.00,16,'male','L2Monster','Fighter',40,418,'3.000',175,'1.350',40,43,30,21,20,20,582,23,45,81,16,67,253,500,500,0,0,0,50,120,'werewolf_clan',300,0,0,0,7,50,1,9,0,0,'0.43','true','NONE',1,0),
(13,20013,'Dryad','','dryad',9.00,20.00,13,'female','L2Monster','Fighter',40,339,'2.700',147,'1.260',40,43,30,21,20,20,463,18,34,71,12,59,253,0,500,0,0,0,40,110,'elemental1_clan',300,0,0,0,7,30,4,4,0,0,'0.37','true','NONE',1,0),
(14,20014,'Felim Lizardman Warrior','','virud_lizardman_warrior',12.00,30.00,17,'male','L2Monster','Fighter',40,446,'3.100',184,'1.380',40,43,30,21,20,20,606,25,49,84,22,70,253,0,500,16,0,0,52,130,'lizardman_clan',300,0,0,0,7,30,4,4,0,0,'0.59','true','NONE',1,0),
(15,20015,'Marsh Zombie','','zombie',13.00,21.00,13,'male','L2Monster','Mystic',40,339,'2.700',147,'1.260',40,43,30,21,20,20,655,26,34,71,12,59,253,0,500,0,0,0,15,15,'',0,0,0,0,7,30,4,4,0,0,'0.43','true','NONE',1,
[Msg] Finished - Unsuccessfully
--------------------------------------------------

[PROGRAMMATOR]

Все нормально, MySQl не смог обработать столько данных, увеличить значение в max_allowed_packet файла my.ini.

[Joker]

Я такие таблицы разделял на 2 части и заливал.

[Devilop]

чё то я такой параметр в my.ini найти не могу

[PROGRAMMATOR]

Не найдено, не значит что его там нет. Прописать в секцию [mysql] строку >>

max_allowed_packet = 1M

1M можно править как угодно. После изменения нужно перезапустить сервер MySQL.

[GoodShadow]

PROGRAMMATOR, стоит разместить мануэл для тех кто запускает сервера под XP для теста и т.д. очень часто задают подобный вопрос.

А так спасибо мне было полезно узнать про увеличить значение в max_allowed_packet файла my.ini.

[Devilop]

нашёл этот параметр
изменил
ребутнул комп
ошибки при установки базы остались
какие ещё будут предложения

[PROGRAMMATOR]

Лучше загрузите сюда архив с sql и скриптом, который заливает это все. Я проверю.