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

***Devilop*** · 26.08.2010, 17:08

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

лог:

Развернуть ↓

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

лог ГС:

Развернуть ↓

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

***Array*** · 26.08.2010, 17:23

Цитата:

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

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

***Devilop*** · 26.08.2010, 17:36

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

вот что:

Развернуть ↓

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

смотрим:

Развернуть ↓

и что самое смешное так это то что он ругаеться тока у меня даже с версией 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,'mal e','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,2 0,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,4 3,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',4 0,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','L2Mo nster','Fighter',40,148,'2.000',86,'1.050',40,43,3 0,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','L2Mo nster','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,4 5,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','NON E',1,0),
(8,20008,'Felim Lizardman','','virud_lizardman',10.00,23.00,14,'ma le','L2Monster','Fighter',40,364,'2.800',156,'1.29 0',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','F ighter',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,'or c_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',4 0,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','L2M onster','Ranger',1100,390,'2.900',166,'1.320',40,4 3,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','L2M onster','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.4 3','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,3 0,4,4,0,0,'0.59','true','NONE',1,0),
(15,20015,'Marsh Zombie','','zombie',13.00,21.00,13,'male','L2Monst er','Mystic',40,339,'2.700',147,'1.260',40,43,30,2 1,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 · 26.08.2010, 17:43

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

***Joker*** · 26.08.2010, 17:46

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

***Devilop*** · 26.08.2010, 17:49

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

PROGRAMMATOR · 26.08.2010, 17:52

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

Цитата:

max_allowed_packet = 1M

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

~~GoodShadow~~ · 26.08.2010, 17:56

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

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

***Devilop*** · 26.08.2010, 18:01

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

PROGRAMMATOR · 26.08.2010, 18:03

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

26.08.2010, 17:08	#1
*Devilop* Герой Регистрация: 13.01.2010 Адрес: город Протвино Возраст: 32 Сообщений: 1,004 Отблагодарили 96 раз(а) Рейтинг мнений:	ошибка при установки базы начинаю заливать базу а мне в ответ выдаються ошибки вот лог установки 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:9 5) at l2p.gameserver.model.AutoSpawnHandler$AutoSpawner. run(AutoSpawnHandle r.java:404) at java.util.concurrent.Executors$RunnableAdapter.cal l(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRun(Unkn own Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask. access$301(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask. run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(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:9 5) at l2p.gameserver.model.AutoSpawnHandler$AutoSpawner. run(AutoSpawnHandle r.java:404) at java.util.concurrent.Executors$RunnableAdapter.cal l(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRun(Unkn own Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask. access$301(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask. run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(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:9 5) at l2p.gameserver.model.AutoSpawnHandler$AutoSpawner. run(AutoSpawnHandle r.java:404) at java.util.concurrent.Executors$RunnableAdapter.cal l(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRun(Unkn own Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask. access$301(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask. run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(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:9 5) at l2p.gameserver.model.AutoSpawnHandler$AutoSpawner. run(AutoSpawnHandle r.java:404) at java.util.concurrent.Executors$RunnableAdapter.cal l(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRun(Unkn own Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask. access$301(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask. run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(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:9 5) at l2p.gameserver.model.AutoSpawnHandler$AutoSpawner. run(AutoSpawnHandle r.java:404) at java.util.concurrent.Executors$RunnableAdapter.cal l(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRun(Unkn own Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask. access$301(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask. run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(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:9 5) at l2p.gameserver.model.AutoSpawnHandler$AutoSpawner. run(AutoSpawnHandle r.java:404) at java.util.concurrent.Executors$RunnableAdapter.cal l(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRun(Unkn own Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask. access$301(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask. run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(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:9 5) at l2p.gameserver.model.AutoSpawnHandler$AutoSpawner. run(AutoSpawnHandle r.java:404) at java.util.concurrent.Executors$RunnableAdapter.cal l(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRun(Unkn own Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask. access$301(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask. run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(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:9 5) at l2p.gameserver.model.AutoSpawnHandler$AutoSpawner. run(AutoSpawnHandle r.java:404) at java.util.concurrent.Executors$RunnableAdapter.cal l(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRun(Unkn own Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask. access$301(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask. run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(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:9 5) at l2p.gameserver.model.AutoSpawnHandler$AutoSpawner. run(AutoSpawnHandle r.java:404) at java.util.concurrent.Executors$RunnableAdapter.cal l(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRun(Unkn own Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask. access$301(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask. run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(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:9 5) at l2p.gameserver.model.AutoSpawnHandler$AutoSpawner. run(AutoSpawnHandle r.java:404) at java.util.concurrent.Executors$RunnableAdapter.cal l(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRun(Unkn own Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask. access$301(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask. run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(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:9 5) at l2p.gameserver.model.AutoSpawnHandler$AutoSpawner. run(AutoSpawnHandle r.java:404) at java.util.concurrent.Executors$RunnableAdapter.cal l(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRun(Unkn own Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask. access$301(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask. run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(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:9 5) at l2p.gameserver.model.AutoSpawnHandler$AutoSpawner. run(AutoSpawnHandle r.java:404) at java.util.concurrent.Executors$RunnableAdapter.cal l(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRun(Unkn own Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask. access$301(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask. run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(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:9 5) at l2p.gameserver.model.AutoSpawnHandler$AutoSpawner. run(AutoSpawnHandle r.java:404) at java.util.concurrent.Executors$RunnableAdapter.cal l(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRun(Unkn own Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask. access$301(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask. run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(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:9 5) at l2p.gameserver.model.AutoSpawnHandler$AutoSpawner. run(AutoSpawnHandle r.java:404) at java.util.concurrent.Executors$RunnableAdapter.cal l(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRun(Unkn own Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask. access$301(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask. run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(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:9 5) at l2p.gameserver.model.AutoSpawnHandler$AutoSpawner. run(AutoSpawnHandle r.java:404) at java.util.concurrent.Executors$RunnableAdapter.cal l(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRun(Unkn own Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask. access$301(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask. run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(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:9 5) at l2p.gameserver.model.AutoSpawnHandler$AutoSpawner. run(AutoSpawnHandle r.java:404) at java.util.concurrent.Executors$RunnableAdapter.cal l(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRun(Unkn own Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask. access$301(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask. run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(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:9 5) at l2p.gameserver.model.AutoSpawnHandler$AutoSpawner. run(AutoSpawnHandle r.java:404) at java.util.concurrent.Executors$RunnableAdapter.cal l(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRun(Unkn own Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask. access$301(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask. run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(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:9 5) at l2p.gameserver.model.AutoSpawnHandler$AutoSpawner. run(AutoSpawnHandle r.java:404) at java.util.concurrent.Executors$RunnableAdapter.cal l(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRun(Unkn own Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask. access$301(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask. run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(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 зборка фениксов __________________ ЛЮДИ ВКЛЮЧИТЕ ВАШИ МОЗГИ а то китайцы уже андроидов в телефоны пихают Nokia N810

26.08.2010, 17:36	#3
*Devilop* Герой Регистрация: 13.01.2010 Адрес: город Протвино Возраст: 32 Сообщений: 1,004 Отблагодарили 96 раз(а) Рейтинг мнений:	Re: ошибка при установки базы однако если пытаться сделать обгрейд базы то пишет вот что: Свернуть ↑ 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,'mal e','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,2 0,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,4 3,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',4 0,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','L2Mo nster','Fighter',40,148,'2.000',86,'1.050',40,43,3 0,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','L2Mo nster','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,4 5,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','NON E',1,0), (8,20008,'Felim Lizardman','','virud_lizardman',10.00,23.00,14,'ma le','L2Monster','Fighter',40,364,'2.800',156,'1.29 0',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','F ighter',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,'or c_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',4 0,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','L2M onster','Ranger',1100,390,'2.900',166,'1.320',40,4 3,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','L2M onster','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.4 3','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,3 0,4,4,0,0,'0.59','true','NONE',1,0), (15,20015,'Marsh Zombie','','zombie',13.00,21.00,13,'male','L2Monst er','Mystic',40,339,'2.700',147,'1.260',40,43,30,2 1,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 -------------------------------------------------- Свернуть ↑Развернуть ↓ __________________ ЛЮДИ ВКЛЮЧИТЕ ВАШИ МОЗГИ а то китайцы уже андроидов в телефоны пихают Nokia N810

26.08.2010, 17:43	#4
PROGRAMMATOR Администратор Регистрация: 09.11.2007 Адрес: Украина, Кривбасс Возраст: 38 Сообщений: 6,377 Отблагодарили 3,722 раз(а) Рейтинг мнений: 578	Re: ошибка при установки базы Все нормально, MySQl не смог обработать столько данных, увеличить значение в max_allowed_packet файла my.ini. __________________ composer require laravel/framework yarn add vue

26.08.2010, 17:46	#5
*Joker* Герой Регистрация: 19.06.2008 Сообщений: 323 Отблагодарили 37 раз(а) Рейтинг мнений:	Re: ошибка при установки базы Я такие таблицы разделял на 2 части и заливал.

26.08.2010, 17:49	#6
*Devilop* Герой Регистрация: 13.01.2010 Адрес: город Протвино Возраст: 32 Сообщений: 1,004 Отблагодарили 96 раз(а) Рейтинг мнений:	Re: ошибка при установки базы чё то я такой параметр в my.ini найти не могу __________________ ЛЮДИ ВКЛЮЧИТЕ ВАШИ МОЗГИ а то китайцы уже андроидов в телефоны пихают Nokia N810

26.08.2010, 17:56	#8
~~GoodShadow~~ Изгнанные Регистрация: 27.11.2009 Адрес: Питер Возраст: 36 Сообщений: 509 Отблагодарили 311 раз(а) Рейтинг мнений:	Re: ошибка при установки базы PROGRAMMATOR, стоит разместить мануэл для тех кто запускает сервера под XP для теста и т.д. очень часто задают подобный вопрос. А так спасибо мне было полезно узнать про увеличить значение в max_allowed_packet файла my.ini.

26.08.2010, 18:01	#9
*Devilop* Герой Регистрация: 13.01.2010 Адрес: город Протвино Возраст: 32 Сообщений: 1,004 Отблагодарили 96 раз(а) Рейтинг мнений:	Re: ошибка при установки базы нашёл этот параметр изменил ребутнул комп ошибки при установки базы остались какие ещё будут предложения __________________ ЛЮДИ ВКЛЮЧИТЕ ВАШИ МОЗГИ а то китайцы уже андроидов в телефоны пихают Nokia N810

26.08.2010, 18:03	#10
PROGRAMMATOR Администратор Регистрация: 09.11.2007 Адрес: Украина, Кривбасс Возраст: 38 Сообщений: 6,377 Отблагодарили 3,722 раз(а) Рейтинг мнений: 578	Re: ошибка при установки базы Лучше загрузите сюда архив с sql и скриптом, который заливает это все. Я проверю. __________________ composer require laravel/framework yarn add vue

Здесь присутствуют: 1 (пользователей: 0 , гостей: 1)

Похожие темы
Тема	Автор	Раздел	Ответов	Последнее сообщение
Ошибка в обновление базы	FllearTM	Серверная часть	12	02.06.2010 14:15
Ошибка базы данных	Herovata	Rising Force Online	0	10.05.2010 17:29
Ошибка при установке базы	zloy_ua	Lineage II	4	29.01.2010 19:32
Ошибка при установки геодаты	lVDPlSilveR	Работа с геодатой	5	21.10.2009 23:12
Ошибка базы	maxo	Lineage II	1	13.12.2008 11:14