Архив - только для чтения | |
| Модератор форума: andycrowz |
| Форум Корзина форума Корзина r12.3_ManGOS 10967 ScriptDev2 r1924+Patches (revision 12.3 (quest rewrite) for 3.3.5a 12340) |
| r12.3_ManGOS 10967 ScriptDev2 r1924+Patches |
dezertir1, ууу, приехали
читай мануалы, тут их полно ну а если вкратце, то создаем базы, заливаем их структуру, заливаем базу, заливаем апдейты
Сообщение # 391 написано 28.07.2011 в 08:36
|
Так я вот так все и делал, но когда начинаю заливать апдейты, то вылетает ошибка такого рода
Code There was an error while executing a query. The query and the error message has been logged at: C:\Documents and Settings\Dimon\Application Data\SQLyog\sqlyog.err. Please click on "Open Error File..." to open the error file. и вот сам лог ошибки Code Query: ALTER TABLE db_version_ytdb CHANGE COLUMN 592_FIX_11321 593_FIX_11346 bit Error occured at:2011-07-26 01:21:32 Line no.:2 Error Code: 1054 - Unknown column '592_FIX_11321' in 'db_version_ytdb' Query: ALTER TABLE db_version CHANGE COLUMN required_11312_01_mangos_mangos_string required_11335_01_mangos_mangos_string bit Error occured at:2011-07-26 01:22:03 Line no.:1 Error Code: 1054 - Unknown column 'required_11312_01_mangos_mangos_string' in 'db_version' Query: ALTER TABLE character_db_version CHANGE COLUMN required_11117_02_characters_world required_11299_01_characters_character_aura bit Error occured at:2011-07-26 01:25:17 Line no.:1 Error Code: 1054 - Unknown column 'required_11117_02_characters_world' in 'character_db_version' Query: ALTER TABLE character_db_version CHANGE COLUMN required_11391_01_characters_auction required_11436_01_characters_character_queststatus bit Error occured at:2011-07-26 01:25:21 Line no.:1 Error Code: 1054 - Unknown column 'required_11391_01_characters_auction' in 'character_db_version' Query: ALTER TABLE db_version CHANGE COLUMN required_11453_01_mangos_spell_proc_event required_11489_01_mangos_creature_template bit Error occured at:2011-07-26 01:47:08 Line no.:1 Error Code: 1054 - Unknown column 'required_11453_01_mangos_spell_proc_event' in 'db_version' Query: ALTER TABLE db_version CHANGE COLUMN required_11453_01_mangos_spell_proc_event required_11489_01_mangos_creature_template bit Error occured at:2011-07-26 01:48:08 Line no.:1 Error Code: 1054 - Unknown column 'required_11453_01_mangos_spell_proc_event' in 'db_version' Query: ALTER TABLE db_version CHANGE COLUMN required_11452_02_mangos_spell_proc_event required_11453_01_mangos_spell_proc_event bit Error occured at:2011-07-26 02:12:14 Line no.:1 Error Code: 1054 - Unknown column 'required_11452_02_mangos_spell_proc_event' in 'db_version' Query: (762,'The %s was taken by the %s!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -- WTF? why 3 same strings? (763,'The %s was taken by the %s!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (764,'The %s is under attack! If left unchecked, the %s will capture it!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (765,'The %s has taken the %s! Its supplies will now be used for reinforcements!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (766,'Irondeep Mine',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (767,'Coldtooth Mine',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (768,'Stormpike Aid Station',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (769,'Dun Baldar South Bunker',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (770,'Dun Baldar North Bunker',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (771,'Stormpike Graveyard',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (772,'Icewing Bunker',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (773,'Stonehearth Graveyard',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (774,'Stonehearth Bunker',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (775,'Snowfall Graveyard',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (776,'Iceblood Tower',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (777,'Iceblood Graveyard',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (778,'Tower Point',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (779,'Frostwolf Graveyard',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (780,'East Frostwolf Tower',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (781,'West Frostwolf Tower',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (782,'Frostwolf Relief Hut',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (784,'1 minute until the battle for Alterac Valley begins.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (785,'30 seconds until the battle for Alterac Valley begins. Prepare yourselves!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (786,'The battle for Alterac Valley has begun!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (787,'The Alliance Team is running out of reinforcements!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (788,'The Horde Team is running out of reinforcements!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (789,'The Frostwolf General is Dead!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (790,'The Stormpike General is Dead!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (801,'You do not have enough gold',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (802,'You do not have enough free slots',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (803,'Your partner does not have enough free bag slots',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (804,'You do not have permission to perform that function',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (805,'Unknown language',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (806,'You don\'t know that language',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (807,'Please provide character name',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (808,'Player %s not found or offline',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (809,'Account for character %s not found',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (810,'|Hplayer:$N|h[$N]|h has earned the achievement $a!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (811,'Guild Master',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (812,'Officer',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (813,'Veteran',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (814,'Member',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (815,'Initiate',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1000,'Exiting daemon...',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1001,'Account deleted: %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1002,'Account %s NOT deleted (probably sql file format was updated)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1003,'Account %s NOT deleted (unknown error)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1004,'Account created: %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1005,'Account name can\'t be longer than 16 characters (client limit), account not created!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1006,'Account with this name already exist!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1007,'Account %s NOT created (probably sql file format was updated)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1008,'Account %s NOT created (unknown error)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1009,'Player %s (Guid: %u) Account %s (Id: %u) deleted.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1010,'| ID | Account | Character | IP | GM | Expansion |',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1012,'========================================================================================',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1013,'| %10u |%15s| %20s | %15s |%4d| %9d |',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1014,'No online players.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1015,'Used not fully typed quit command, need type it fully (quit), or command used not in RA command line.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1016,'| GUID | Name | Account | Delete Date |',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1017,'| %10u | %20s | %15s (%10u) | %19s |',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1018,'==========================================================================================',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1019,'No characters found.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1020,'Restoring the following characters:',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1021,'Deleting the following characters:',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1022,'ERROR: You can only assign a new name if you have only selected a single character!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1023,'Character \'%s\' (GUID: %u Account %u) can\'t be restored: account not exist!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1024,'Character \'%s\' (GUID: %u Account %u) can\'t be restored: account character list full!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1025,'Character \'%s\' (GUID: %u Account %u) can\'t be restored: new name already used!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1026,'GUID: %u Name: %s Account: %s (%u) Date: %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1027,'Log filters state:',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1028,'All log filters set to: %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1029, 'Command can be called only from RA-console.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1100,'Account %s (Id: %u) have up to %u expansion allowed now.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1101,'Message of the day changed to:\r\n%s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1102,'Message sent to %s: %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1103,'%d - %s %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1104,'%d - %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1105,'%d - %s %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1106,'%d - %s %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1107,'%d - %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1108,'%d - %s %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1109,'%d - %s %s %s %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1110,'%d%s - %s X:%f Y:%f Z:%f MapId:%d',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1111,'%d%s - %s X:%f Y:%f Z:%f MapId:%d',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1112,'Failed to open file: %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1113,'Account %s (%u) have max amount allowed characters (client limit)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1114,'Dump file have broken data!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1115,'Invalid character name!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1116,'Invalid character guid!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1117,'Character guid %u in use!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1118,'%d - guild: %s (guid: %u) %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1119,'You must use male or female as gender.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1120,'You change gender of %s to %s.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1121,'Your gender changed to %s by %s.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1122,'(%u/%u +perm %u +temp %u)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1123,'Not pet found',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1124,'Wrong pet type',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1125,'Your pet learned all talents',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1126,'Your pet talents have been reset.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1127,'Talents of %s\'s pet reset.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1128,'%d - |cffffffff|Htaxinode:%u|h[%s %s]|h|r (Map:%u X:%f Y:%f Z:%f)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1129,'%d - %s %s (Map:%u X:%f Y:%f Z:%f)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1130,'event started %u "%s"',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1131,'event stopped %u "%s"',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1132,' Follow player %s (lowguid %u)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1133,' Follow creature %s (lowguid %u)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1134,' Follow <NULL>',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1135,'List known talents:',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1136,' (Found talents: %u used talent points: %u)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1137,'%d%s - |cffffffff|Hgameobject:%d|h[%s X:%f Y:%f Z:%f MapId:%d]|h|r ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1138,'=================================================================================',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1139,'| GUID | Name | Race | Class | Level |',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1140,'| %10u | %20s | %15s | %15s | %5u |',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1141,'%u - |cffffffff|Hplayer:%s|h[%s]|h|r %s %s %u',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1142,'%u - %s (Online:%s IP:%s GM:%u Expansion:%u)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1143,'Spawned by event %u (%s)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1144,'Despawned by event %u (%s)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1145,'Part of pool %u',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1146,'Part of pool %u, top pool %u',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1147,'The (top)pool %u is spawned by event %u (%s)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1148,'The (top)pool %u is despawned by event %u (%s)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1149,' (Pool %u)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1150,' (Event %i)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1151,' (Pool %u Event %i)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1152,'[usable]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1153,'Get %s bitstr value:[FIELD]:%u [VALUE]:%s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1154,'%s has bitstr value:[FIELD]:%u [VALUE]:%s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1155,'Get %s hex value:[FIELD]:%u [VALUE]:%x',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1156,'%s has hex value:[FIELD]:%u [VALUE]:%x',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1157,'Modify %s hex field:%u %s %x = %x (hex)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1158,'You modify for %s hex field:%u %s %x = %x (hex)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1159,'Modify %s float field:%u to sum with:%f = %f',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1160,'You modify for %s float field:%u to sum with:%f = %f',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1161,'Criteria:',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1162,' [counter]',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1163,'Achievement %u doesn\'t exist.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1164,'Achievement criteria %u doesn\'t exist.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1165,'Spell %u not have auras.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1166,'Scripting library not found or not accessible.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1167,'Scripting library has wrong list functions (outdated?).',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1168,'Scripting library reloaded.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1169,'Scripting library build for different mangosd revision.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1170,'Player selected: %s.\nFaction: %u.\nnpcFlags: %u.\nBase Entry: %u, Spawned Entry %u (Difficulty %u).\nDisplayID: %u (Native: %u).',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1171,'All config are reloaded from ahbot configuration file.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1172,'Error while trying to reload ahbot config.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1173,'==========================================================',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1174,'|--------------------------------------------------------|',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1175,'| | Alliance | Horde | Neutral | Total |',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1176,' Alliance/Horde/Neutral/Total',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1177,'| %-10s | %8u | %8u | %8u | %8u |',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1178,'%-10s = %6u / %6u / %6u / %6u',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1179,'Count',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1180,'Item Ratio',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1181,'| | Alliance | Horde | Neutral | Amount |',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1182,' Alliance/Horde/Neutral/Amount',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1183,'Grey',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1184,'White',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1185,'Green',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1186,'Blue',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1187,'Purple',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1188,'Orange',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1189,'Yellow',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1190,'Amount of %s items is set to %u.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1191,'Items ratio for %s is set to %u.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1200,'You try to view cinemitic %u but it doesn\'t exist.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1201,'You try to view movie %u but it doesn\'t exist.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1202,'Spell %u %s = %f (*1.88 = %f) DB = %f AP = %f',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1203,'direct heal',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1204,'direct damage',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1205,'dot heal',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1206,'dot damage',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1500,'%u - [%s] AutoSpawn: %u MaxLimit: %u Creatures: %u GameObjecs: %u Pools %u Chance: %f %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1501,'%u - |cffffffff|Hpool:%u|h[%s]|h|r AutoSpawn: %u MaxLimit: %u Creatures: %u GameObjecs: %u Pools %u %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1502,'%u - [%s] AutoSpawn: %u MaxLimit: %u Creatures: %u GameObjecs: %u Pools %u %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1503,'Can not add spawn because no free guids for static spawn in reserved guids range. Server restart is required before command can be used. Also look GuidReserveSize.* config options.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1504,'AI-Information for Npc Entry %u',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1505,'AIName: %s (%s) ScriptName: %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1506,'Current phase = %u',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1507,'Combat-Movement is %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), (1508,'Melee attacking is %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL) Error occured at:2011-07-26 02:24:55 Line no.:4147 Error Code: 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 '762,'The %s was taken by the %s!',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL), -- W' at line 1 Query: ALTER TABLE db_version CHANGE COLUMN required_10950_01_mangos_mangos_string required_10951_01_mangos_spell_proc_event bit Error occured at:2011-07-26 03:01:34 Line no.:1 Error Code: 1054 - Unknown column 'required_10950_01_mangos_mangos_string' in 'db_version' Query: ALTER TABLE character_db_version CHANGE COLUMN required_10664_01_characters_arena_team_stats required_10862_01_characters_mail bit Error occured at:2011-07-26 09:58:35 Line no.:1 Error Code: 1054 - Unknown column 'required_10664_01_characters_arena_team_stats' in 'character_db_version' Query: ALTER TABLE db_version CHANGE COLUMN required_10950_01_mangos_mangos_string required_10951_01_mangos_spell_proc_event bit Error occured at:2011-07-26 10:02:07 Line no.:1 Error Code: 1054 - Unknown column 'required_10950_01_mangos_mangos_string' in 'db_version' Query: ALTER TABLE db_version CHANGE COLUMN required_10950_01_mangos_mangos_string required_10951_01_mangos_spell_proc_event bit Error occured at:2011-07-26 10:51:15 Line no.:1 Error Code: 1054 - Unknown column 'required_10950_01_mangos_mangos_string' in 'db_version' Query: ALTER TABLE db_version CHANGE COLUMN required_10950_01_mangos_mangos_string required_10951_01_mangos_spell_proc_event bit Error occured at:2011-07-26 10:52:23 Line no.:1 Error Code: 1146 - Table 'mangos.db_version' doesn't exist Query: ALTER TABLE db_version CHANGE COLUMN required_10950_01_mangos_mangos_string required_10951_01_mangos_spell_proc_event bit Error occured at:2011-07-26 10:56:01 Line no.:1 Error Code: 1054 - Unknown column 'required_10950_01_mangos_mangos_string' in 'db_version' Query: ALTER TABLE character_db_version CHANGE COLUMN required_11117_02_characters_world required_11299_01_characters_character_aura bit Error occured at:2011-07-26 11:16:55 Line no.:1 Error Code: 1054 - Unknown column 'required_11117_02_characters_world' in 'character_db_version' Query: ALTER TABLE character_db_version CHANGE COLUMN required_11391_01_characters_auction required_11436_01_characters_character_queststatus bit Error occured at:2011-07-26 11:17:00 Line no.:1 Error Code: 1054 - Unknown column 'required_11391_01_characters_auction' in 'character_db_version' Query: CREATE DATABASE `scriptdev2` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci Error occured at:2011-07-26 11:48:11 Line no.:1 Error Code: 1007 - Can't create database 'scriptdev2'; database exists Query: CREATE TABLE custom_texts ( entry bigint NOT NULL, content_default text NOT NULL, content_loc1 text, content_loc2 text, content_loc3 text, content_loc4 text, content_loc5 text, content_loc6 text, content_loc7 text, content_loc8 text, sound integer DEFAULT 0 NOT NULL, type smallint DEFAULT (0)::smallint NOT NULL, language smallint DEFAULT (0)::smallint NOT NULL, emote smallint DEFAULT (0)::smallint NOT NULL, comment text, PRIMARY KEY(entry) ) Error occured at:2011-07-26 11:48:20 Line no.:18 Error Code: 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)::smallint NOT NULL, language smallint DEFAULT (0)::smallint NOT NULL, ' at line 13 Query: ALTER TABLE db_version_ytdb CHANGE COLUMN 571_FIX_10675 572_FIX_10709 bit Error occured at:2011-07-26 13:05:04 Line no.:2 Error Code: 1054 - Unknown column '571_FIX_10675' in 'db_version_ytdb' Query: ALTER TABLE db_version CHANGE COLUMN required_10950_01_mangos_mangos_string required_10951_01_mangos_spell_proc_event bit Error occured at:2011-07-26 13:14:59 Line no.:1 Error Code: 1054 - Unknown column 'required_10950_01_mangos_mangos_string' in 'db_version' Query: ALTER TABLE db_version CHANGE COLUMN required_10950_01_mangos_mangos_string required_10951_01_mangos_spell_proc_event bit Error occured at:2011-07-28 08:59:52 Line no.:1 Error Code: 1054 - Unknown column 'required_10950_01_mangos_mangos_string' in 'db_version'
Сообщение # 392 написано 28.07.2011 в 10:01
|
dezertir1, ну ты пойми, что льешь более старые апдейты
ВНИМАТЕЛЬНО прочитай название третьего столбца в таблице db_version Это - ПОСЛЕДНИЙ апдейт, залитый в базу, ты должен найти этот файл в папке updates и залить все, что идет ПОСЛЕ него, а не до него
Сообщение # 393 написано 28.07.2011 в 10:25
|
Спасибо.
Добавлено (28.07.2011, 15:00) Code 2011-07-28 13:57:53 MaNGOS/0.17.0-DEV (* * Revision 10967 - *) for Win32 (little-endian) [world-daemon] 2011-07-28 13:57:53 <Ctrl-C> to stop. MM MM MM MM MMMMM MMMM MMMMM MM MM MM MM MMM MMM MM MM MMM MMM MMM MMM MMM MM MMM MMM MM MM MMM MM M MM MMMM MM MMM MM MM MMM MM M MM MMMMM MM MMMM MMM MM MM MMM MM M MM M MMM MM MMM MMMMMMM MM MM MMM MM MM MMM MM MM MM MMM MM MM MMM MM MM MMMMMMM MM MM MMM MMM MM MM MMM MMM MM MM MM MMM MM MM MMMMMM MMMM MMMMM MM MMM http://getmangos.com MMMMMM 2011-07-28 13:57:53 Using configuration file mangosd.conf. 2011-07-28 13:57:53 World Database: 127.0.0.1;3306;mangos;mangos;mangos 2011-07-28 13:57:53 MySQL client library: 5.1.49 2011-07-28 13:57:53 MySQL server ver: 5.1.40-community 2011-07-28 13:57:53 Character Database: 127.0.0.1;3306;mangos;mangos;characters 2011-07-28 13:57:53 MySQL client library: 5.1.49 2011-07-28 13:57:53 MySQL server ver: 5.1.40-community 2011-07-28 13:57:53 Login Database: 127.0.0.1;3306;mangos;mangos;realmd 2011-07-28 13:57:53 MySQL client library: 5.1.49 2011-07-28 13:57:53 MySQL server ver: 5.1.40-community 2011-07-28 13:57:53 Realm running as realm ID 1 2011-07-28 13:57:53 Using World DB: YTDB_0.14.0_R579_MaNGOS_R10930_SD2_R1917_ACID_R307_RuDB_R38.6 2011-07-28 13:57:53 Using creature EventAI: ACID 3.0.7 - Full Release for Mangos (3.3.5a Client) 2011-07-28 13:57:53 Using DataDir ./ 2011-07-28 13:57:53 ERROR:VMAP height use disabled! Creatures movements and other things will be in broken state. 2011-07-28 13:57:53 WORLD: VMap support included. LineOfSight:0, getHeight:0, indoorCheck:1 2011-07-28 13:57:53 WORLD: VMap data directory is: ./vmaps 2011-07-28 13:57:53 2011-07-28 13:57:53 Loading MaNGOS strings... 2011-07-28 13:57:53 2011-07-28 13:57:53 >> Loaded 759 MaNGOS strings from table mangos_string 2011-07-28 13:57:53 Initialize data stores... 2011-07-28 13:57:53 ERROR:SQL: SELECT * FROM spell_dbc ORDER BY + Id DESC; 2011-07-28 13:57:53 ERROR:query ERROR: Table 'mangos.spell_dbc' doesn't exist 2011-07-28 13:57:54 2011-07-28 13:57:54 >> Initialized 91 data stores 2011-07-28 13:57:54 Using ruRU DBC Locale as default. All available DBC locales: ruRU 2011-07-28 13:57:54 2011-07-28 13:57:54 Loading Script Names... 2011-07-28 13:57:55 2011-07-28 13:57:55 >> Loaded 930 Script Names 2011-07-28 13:57:55 Loading InstanceTemplate... 2011-07-28 13:57:55 >> Loaded 120 Instance Template definitions 2011-07-28 13:57:55 2011-07-28 13:57:55 Loading SkillLineAbilityMultiMap Data... 2011-07-28 13:57:55 2011-07-28 13:57:55 >> Loaded 10219 SkillLineAbility MultiMap Data 2011-07-28 13:57:55 Cleaning up instances... 2011-07-28 13:57:55 2011-07-28 13:57:55 >> Instances cleaned up 2011-07-28 13:57:55 Packing instances... 2011-07-28 13:57:55 >> Instance numbers remapped, next instance id is 1 2011-07-28 13:57:55 2011-07-28 13:57:55 Packing groups... 2011-07-28 13:57:55 >> Group Ids remapped, next group id is 1 2011-07-28 13:57:55 2011-07-28 13:57:55 2011-07-28 13:57:55 Loading Page Texts... 2011-07-28 13:57:55 >> Loaded 1899 page texts 2011-07-28 13:57:55 2011-07-28 13:57:55 Loading Game Object Templates... 2011-07-28 13:57:55 >> Loaded 19335 game object templates 2011-07-28 13:57:55 2011-07-28 13:57:55 Loading Spell Chain Data... 2011-07-28 13:57:56 2011-07-28 13:57:56 >> Loaded 4626 spell chain records (2994 from DBC data with 2 req field updates, and 1632 loaded from table) 2011-07-28 13:57:56 Loading Spell Elixir types... 2011-07-28 13:57:56 2011-07-28 13:57:56 >> Loaded 132 spell elixir definitions 2011-07-28 13:57:56 Loading Spell Learn Skills... 2011-07-28 13:57:56 2011-07-28 13:57:56 >> Loaded 99 Spell Learn Skills from DBC 2011-07-28 13:57:56 Loading Spell Learn Spells... 2011-07-28 13:57:56 2011-07-28 13:57:56 >> Loaded 22 spell learn spells + 572 found in DBC 2011-07-28 13:57:56 Loading Spell Proc Event conditions... 2011-07-28 13:57:56 2011-07-28 13:57:56 >> Loaded 555 extra spell proc event conditions +56 custom proc (inc. +4 custom ranks) 2011-07-28 13:57:56 Loading Spell Bonus Data... 2011-07-28 13:57:56 2011-07-28 13:57:56 >> Loaded 144 extra spell bonus data 2011-07-28 13:57:56 Loading Spell Proc Item Enchant... 2011-07-28 13:57:56 2011-07-28 13:57:56 >> Loaded 8 proc item enchant definitions 2011-07-28 13:57:56 Loading Aggro Spells Definitions... 2011-07-28 13:57:56 2011-07-28 13:57:56 >> Loaded 126 aggro generating spells 2011-07-28 13:57:56 Loading NPC Texts... 2011-07-28 13:57:56 2011-07-28 13:57:56 >> Loaded 6284 npc texts 2011-07-28 13:57:56 Loading Item Random Enchantments Table... 2011-07-28 13:57:56 2011-07-28 13:57:56 >> Loaded 28691 Item Enchantment definitions 2011-07-28 13:57:56 Loading Items... 2011-07-28 13:58:00 >> Loaded 37551 item prototypes 2011-07-28 13:58:00 2011-07-28 13:58:00 Loading Item converts... 2011-07-28 13:58:00 2011-07-28 13:58:00 >> Loaded 10 Item converts 2011-07-28 13:58:00 Loading Creature Model Based Info Data... 2011-07-28 13:58:00 >> Loaded 24155 creature model based info 2011-07-28 13:58:00 2011-07-28 13:58:00 Loading Equipment templates... 2011-07-28 13:58:00 >> Loaded 4218 equipment template 2011-07-28 13:58:00 2011-07-28 13:58:00 Loading Creature templates... 2011-07-28 13:58:02 ERROR:Error in creature_template table, probably sql file format was updated (there should be 90 fields in sql). Добавлено (28.07.2011, 15:08)
Сообщение # 394 написано 28.07.2011 в 15:08
|
Цитата (Houk) что за бред со скриптами? залил все как положено, а сервер выдает Код ERROR:Error in creature_template table, probably sql file format was updated (there should be 90 fields in sql). недозалил апдейты поверх чистых sql (в колонке creature_template больше колонок чем залито у тебя, насколько помню из новых(теперь уже старых) там vehicleId, spell5-8
Сообщение # 400 написано 04.10.2013 в 12:49
|
Цитата Сармат (  )lanc, Вы до сих пор продолжаете заниматься ядрами? да, но после столь долгого перерыва, у меня не осталось прежних исходников. В данный момент собираю все с нуля со всеми наработками минувших лет + наработками разработчиков из открытых источников, успею может через месяцок поделюсь собранным здесь 
|
Данная тема была перемещена из раздела Ядра CMaNGOS.
Причина перемещения: Тема не актуальна. Переместил: Dimitro.
Arcanum Core © Dev.
Для запросов на выдачу наград/снятие замечаний есть темы в Работе Портала. Не пишите по этому поводу в личку.
Сообщение # 403 написано 17.12.2013 в 04:34
|
| |||