[sql] Не устанавлеться база.
7 replies86 viewsCurrently viewing: 1
· 05/03/2009, 03:15 PM
Сборка L2Emu Rev 1730
Краткое изложение сути проблемы: Не получаеться залить базу НПС
Цитата
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 0, "LineageMonster4.beast_fighter_pet", 32.00, 15.70, 55, "male", "L2Pet", 40, ' at line 33
[Err] INSERT INTO `npc` VALUES
(16013, 16013, "Trained Buffalo", 0, "", 0, "Monster2.buffalo", 22, 31, 67, "male", "L2TamedBeast", 40, 3626, 1388, 23.7, 2.78, 40, 43, 30, 21, 20, 10, 0, 0, 1169, 439, 681, 356, 278, 0, 333, 0, 0, 0, 22, 187, "pet_clan", 400, 0, 0, "LAST_HIT", 0, 0, 0, "fighter", "false"),
(16014, 16014, "Trained Buffalo", 0, "", 0, "Monster2.buffalo", 22, 31, 67, "male", "L2TamedBeast", 40, 3626, 1388, 23.7, 2.78, 40, 43, 30, 21, 20, 10, 0, 0, 1169, 439, 681, 356, 278, 0, 333, 0, 0, 0, 22, 187, "pet_clan", 400, 0, 0, "LAST_HIT", 0, 0, 0, "fighter", "false"),
(16015, 16015, "Trained Cougar", 0, "", 0, "Monster.saber_toothed_tiger", 34, 28, 69, "male", "L2TamedBeast", 40, 3784, 1458, 23.7, 2.78, 40, 43, 30, 21, 20, 10, 0, 0, 1265, 460, 746, 373, 278, 0, 333, 0, 0, 0, 66, 192, "pet_clan", 400, 0, 0, "LAST_HIT", 0, 0, 0, "fighter", "false"),
(16016, 16016, "Trained Cougar", 0, "", 0, "Monster.saber_toothed_tiger", 34, 28, 69, "male", "L2TamedBeast", 40, 3784, 1458, 23.7, 2.78, 40, 43, 30, 21, 20, 10, 0, 0, 1265, 460, 746, 373, 278, 0, 333, 0, 0, 0, 66, 192, "pet_clan", 400, 0, 0, "LAST_HIT", 0, 0, 0, "fighter", "false"),
(16017, 16017, "Trained Kookaburra", 0, "", 0, "Monster2.pet_ostrich", 10, 33, 65, "male", "L2TamedBeast", 40, 3465, 1319, 23.7, 2.78, 40, 43, 30, 21, 20, 10, 0, 0, 1077, 418, 619, 340, 278, 0, 333, 0, 0, 0, 25, 209, "pet_clan", 400, 0, 0, "LAST_HIT", 0, 0, 0, "fighter", "false"),
(16018, 16018, "Trained Kookaburra", 0, "", 0, "Monster2.pet_ostrich", 10, 33, 65, "male", "L2TamedBeast", 40, 3465, 1319, 23.7, 2.78, 40, 43, 30, 21, 20, 10, 0, 0, 1077, 418, 619, 340, 278, 0, 333, 0, 0, 0, 25, 209, "pet_clan", 400, 0, 0, "LAST_HIT", 0, 0, 0, "fighter", "false"),
(16019, 16019, "Tiny Baby Buffalo", 0, "", 0, "Monster2.baby_buffalo", 20, 31, 99, "male", "L2Monster", 40, 400000, 9999, 13.43, 3.09, 40, 43, 30, 21, 20, 10, 0, 0, 9000, 5000, 6000, 6000, 300, 0, 333, 0, 0, 0, 88, 132, "NULL", 0, 0, 0, "LAST_HIT", 0, 0, 0, "balanced", "false"),
(16020, 16020, "Tame Tiny Baby Buffalo", 0, "", 0, "Monster2.baby_buffalo", 20, 31, 99, "male", "L2Monster", 40, 400000, 9999, 13.43, 3.09, 40, 43, 30, 21, 20, 10, 0, 0, 9000, 5000, 6000, 6000, 300, 0, 333, 0, 0, 0, 88, 132, "NULL", 0, 0, 0, "LAST_HIT", 0, 0, 0, "balanced", "false"),
(16021, 16021, "Tiny Baby Cougar", 0, "", 0, "Monster2.baby_tiger", 20, 31, 99, "male", "L2Monster", 40, 400000, 9999, 13.43, 3.09, 40, 43, 30, 21, 20, 10, 0, 0, 9000, 5000, 6000, 6000, 300, 0, 333, 0, 0, 0, 88, 132, "NULL", 0, 0, 0, "LAST_HIT", 0, 0, 0, "balanced", "false"),
(16022, 16022, "Tame Tiny Baby Cougar", 0, "", 0, "Monster2.baby_tiger", 20, 31, 99, "male", "L2Monster", 40, 400000, 9999, 13.43, 3.09, 40, 43, 30, 21, 20, 10, 0, 0, 9000, 5000, 6000, 6000, 300, 0, 333, 0, 0, 0, 88, 132, "NULL", 0, 0, 0, "LAST_HIT", 0, 0, 0, "balanced", "false"),
(16023, 16023, "Tiny Baby Kookaburra", 0, "", 0, "Monster2.baby_ostrich", 20, 31, 99, "male", "L2Monster", 40, 400000, 9999, 13.43, 3.09, 40, 43, 30, 21, 20, 10, 0, 0, 9000, 5000, 6000, 6000, 300, 0, 333, 0, 0, 0, 88, 132, "NULL", 0, 0, 0, "LAST_HIT", 0, 0, 0, "balanced", "false"),
(16024, 16024, "Tame Tiny Baby Kookaburra", 0, "", 0, "Monster2.baby_ostrich", 20, 31, 99, "male", "L2Monster", 40, 400000, 9999, 13.43, 3.09, 40, 43, 30, 21, 20, 10, 0, 0, 9000, 5000, 6000, 6000, 300, 0, 333, 0, 0, 0, 88, 132, "NULL", 0, 0, 0, "LAST_HIT", 0, 0, 0, "balanced", "false"),
(16025, 16025, "Great Wolf", 0, "", 0, "LineageMonster4.Pet_Wolf_B", 32, 21.41, 55, "male", "L2Pet", 40, 2444, 2444, 0, 0, 40, 43, 30, 21, 20, 25, 0, 0, 500, 500, 500, 500, 304, 0, 333, 9661, 0, NULL, 45, 170, "NULL", 0, 0, 0, "LAST_HIT", 0, 0, 0, "fighter", "false"),
(16026, 16026, "Beastly Agathion", 0, "", 0, "LineageNPC2.Agathion_BF", 32, 23.56, 70, "male", "L2Npc", 40, 2444, 2444, 0, 0, 10, 10, 10, 10, 10, 10, 0, 0, 500, 500, 500, 500, 253, 0, 253, 0, 0, NULL, 80, 120, "NULL", 0, 0, 0, "LAST_HIT", 0, 0, 0, "balanced", "false"),
(16027, 16027, "Rainbow Agathion", 0, "", 0, "LineageNPC2.Agathion_RA", 32, 23.56, 70, "male", "L2Npc", 40, 2444, 2444, 0, 0, 10, 10
[Msg] Finished - Unsuccessfully
--------------------------------------------------
[Err] INSERT INTO `npc` VALUES
(16013, 16013, "Trained Buffalo", 0, "", 0, "Monster2.buffalo", 22, 31, 67, "male", "L2TamedBeast", 40, 3626, 1388, 23.7, 2.78, 40, 43, 30, 21, 20, 10, 0, 0, 1169, 439, 681, 356, 278, 0, 333, 0, 0, 0, 22, 187, "pet_clan", 400, 0, 0, "LAST_HIT", 0, 0, 0, "fighter", "false"),
(16014, 16014, "Trained Buffalo", 0, "", 0, "Monster2.buffalo", 22, 31, 67, "male", "L2TamedBeast", 40, 3626, 1388, 23.7, 2.78, 40, 43, 30, 21, 20, 10, 0, 0, 1169, 439, 681, 356, 278, 0, 333, 0, 0, 0, 22, 187, "pet_clan", 400, 0, 0, "LAST_HIT", 0, 0, 0, "fighter", "false"),
(16015, 16015, "Trained Cougar", 0, "", 0, "Monster.saber_toothed_tiger", 34, 28, 69, "male", "L2TamedBeast", 40, 3784, 1458, 23.7, 2.78, 40, 43, 30, 21, 20, 10, 0, 0, 1265, 460, 746, 373, 278, 0, 333, 0, 0, 0, 66, 192, "pet_clan", 400, 0, 0, "LAST_HIT", 0, 0, 0, "fighter", "false"),
(16016, 16016, "Trained Cougar", 0, "", 0, "Monster.saber_toothed_tiger", 34, 28, 69, "male", "L2TamedBeast", 40, 3784, 1458, 23.7, 2.78, 40, 43, 30, 21, 20, 10, 0, 0, 1265, 460, 746, 373, 278, 0, 333, 0, 0, 0, 66, 192, "pet_clan", 400, 0, 0, "LAST_HIT", 0, 0, 0, "fighter", "false"),
(16017, 16017, "Trained Kookaburra", 0, "", 0, "Monster2.pet_ostrich", 10, 33, 65, "male", "L2TamedBeast", 40, 3465, 1319, 23.7, 2.78, 40, 43, 30, 21, 20, 10, 0, 0, 1077, 418, 619, 340, 278, 0, 333, 0, 0, 0, 25, 209, "pet_clan", 400, 0, 0, "LAST_HIT", 0, 0, 0, "fighter", "false"),
(16018, 16018, "Trained Kookaburra", 0, "", 0, "Monster2.pet_ostrich", 10, 33, 65, "male", "L2TamedBeast", 40, 3465, 1319, 23.7, 2.78, 40, 43, 30, 21, 20, 10, 0, 0, 1077, 418, 619, 340, 278, 0, 333, 0, 0, 0, 25, 209, "pet_clan", 400, 0, 0, "LAST_HIT", 0, 0, 0, "fighter", "false"),
(16019, 16019, "Tiny Baby Buffalo", 0, "", 0, "Monster2.baby_buffalo", 20, 31, 99, "male", "L2Monster", 40, 400000, 9999, 13.43, 3.09, 40, 43, 30, 21, 20, 10, 0, 0, 9000, 5000, 6000, 6000, 300, 0, 333, 0, 0, 0, 88, 132, "NULL", 0, 0, 0, "LAST_HIT", 0, 0, 0, "balanced", "false"),
(16020, 16020, "Tame Tiny Baby Buffalo", 0, "", 0, "Monster2.baby_buffalo", 20, 31, 99, "male", "L2Monster", 40, 400000, 9999, 13.43, 3.09, 40, 43, 30, 21, 20, 10, 0, 0, 9000, 5000, 6000, 6000, 300, 0, 333, 0, 0, 0, 88, 132, "NULL", 0, 0, 0, "LAST_HIT", 0, 0, 0, "balanced", "false"),
(16021, 16021, "Tiny Baby Cougar", 0, "", 0, "Monster2.baby_tiger", 20, 31, 99, "male", "L2Monster", 40, 400000, 9999, 13.43, 3.09, 40, 43, 30, 21, 20, 10, 0, 0, 9000, 5000, 6000, 6000, 300, 0, 333, 0, 0, 0, 88, 132, "NULL", 0, 0, 0, "LAST_HIT", 0, 0, 0, "balanced", "false"),
(16022, 16022, "Tame Tiny Baby Cougar", 0, "", 0, "Monster2.baby_tiger", 20, 31, 99, "male", "L2Monster", 40, 400000, 9999, 13.43, 3.09, 40, 43, 30, 21, 20, 10, 0, 0, 9000, 5000, 6000, 6000, 300, 0, 333, 0, 0, 0, 88, 132, "NULL", 0, 0, 0, "LAST_HIT", 0, 0, 0, "balanced", "false"),
(16023, 16023, "Tiny Baby Kookaburra", 0, "", 0, "Monster2.baby_ostrich", 20, 31, 99, "male", "L2Monster", 40, 400000, 9999, 13.43, 3.09, 40, 43, 30, 21, 20, 10, 0, 0, 9000, 5000, 6000, 6000, 300, 0, 333, 0, 0, 0, 88, 132, "NULL", 0, 0, 0, "LAST_HIT", 0, 0, 0, "balanced", "false"),
(16024, 16024, "Tame Tiny Baby Kookaburra", 0, "", 0, "Monster2.baby_ostrich", 20, 31, 99, "male", "L2Monster", 40, 400000, 9999, 13.43, 3.09, 40, 43, 30, 21, 20, 10, 0, 0, 9000, 5000, 6000, 6000, 300, 0, 333, 0, 0, 0, 88, 132, "NULL", 0, 0, 0, "LAST_HIT", 0, 0, 0, "balanced", "false"),
(16025, 16025, "Great Wolf", 0, "", 0, "LineageMonster4.Pet_Wolf_B", 32, 21.41, 55, "male", "L2Pet", 40, 2444, 2444, 0, 0, 40, 43, 30, 21, 20, 25, 0, 0, 500, 500, 500, 500, 304, 0, 333, 9661, 0, NULL, 45, 170, "NULL", 0, 0, 0, "LAST_HIT", 0, 0, 0, "fighter", "false"),
(16026, 16026, "Beastly Agathion", 0, "", 0, "LineageNPC2.Agathion_BF", 32, 23.56, 70, "male", "L2Npc", 40, 2444, 2444, 0, 0, 10, 10, 10, 10, 10, 10, 0, 0, 500, 500, 500, 500, 253, 0, 253, 0, 0, NULL, 80, 120, "NULL", 0, 0, 0, "LAST_HIT", 0, 0, 0, "balanced", "false"),
(16027, 16027, "Rainbow Agathion", 0, "", 0, "LineageNPC2.Agathion_RA", 32, 23.56, 70, "male", "L2Npc", 40, 2444, 2444, 0, 0, 10, 10
[Msg] Finished - Unsuccessfully
--------------------------------------------------
Вопрс: Как это исправить?
Мои соображение: Может кто-то выложить исправленые базы npc.sql и coustum_teleport.sql. для этой сборке, бал базы с предыдущих,захожу в игру неодного нпс нету.
0
· 05/03/2009, 06:40 PM
Присоединяюсь к предыдущему оратору.
У меня в инсталляторе выскакивает такая ошибка
Цитата
"ERROR 1064 (42000) at line 1146: You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right syntax to us
e near ' 0, "LineageMonster4.beast_fighter_pet", 32.00, 15.70, 55, "male", "L2Pe
t", 40, ' at line 33"
manual that corresponds to your MySQL server version for the right syntax to us
e near ' 0, "LineageMonster4.beast_fighter_pet", 32.00, 15.70, 55, "male", "L2Pe
t", 40, ' at line 33"
Пробовал импортировать NPC.sql через phpMyAdmin, но возникли аналогичные проблемы.
Если честно даже не понимаю что именно мускулу не нравится в запросе (
0
· 05/03/2009, 06:50 PM
синтаксис неправильный
lekkon4uk
удали нужные те таблицы и залей заново
0
· 05/03/2009, 07:16 PM
Если я удалю это,то я удалю с игры петов, и это будет нехорошо... как нужно,исправить? или я что-то недопонял.
0
· 05/03/2009, 07:38 PM
А я всетаки разобрался )
Проблема оказалась совсем не большая, чуть терпения и пяток правок в блокноте и встает идеально.
Вообще кто не сможет справиться с этой траблой, то что говорить о дальнейшем администрировании сервера...
0
· 05/04/2009, 07:39 AM
Извенеи за оскорбление, но зачем быть хвастуном, исправил проблему,поделись как и что. Я могу написать многое-но сделать мало...... Пожалусто напиши решение что нужно убрать или дописать!
0
Войдите или зарегистрируйтесь чтобы ответить