Форум администраторов игровых серверов - Показать сообщение отдельно

***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
--------------------------------------------------

Развернуть ↓

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