Jump to content
TrinityCore

fmilioni

Plebs
  • Posts

    10
  • Joined

  • Last visited

Everything posted by fmilioni

  1. I did what you said, see above. Yeahh, works with some errors: Loading Game Object Templates... GameObject (Entry: 126337 GoType: 8) have data0=2061 but SpellFocus (Id: 2061) not exist. GameObject (Entry: 126338 GoType: 8) have data0=2061 but SpellFocus (Id: 2061) not exist. [..] Loading Creature templates... Creature (Entry: 3625) has different `npcflag` in difficulty 1 mode (Entry: 22654). Creature (Entry: 4255) has different `npcflag` in difficulty 1 mode (Entry: 22646). [..] Loading Gameobject Data... Gameobject (GUID: 22417 Entry 182051 GoType: 6) has an invalid displayId (1287), not loaded. Gameobject (GUID: 22418 Entry 182051 GoType: 6) has an invalid displayId (1287), not loaded. [..] >> Loaded 0 hotfix info entries. DB table `hotfix_data` is empty. World initialized in 0 minutes 9 seconds worldserver process priority class set to HIGH TrinityCore rev. 0000-00-00 00:00:00 +0000 (Archived) (Win32, Release) (worldserver-daemon) ready... UpdateAchievementCriteria: Achievement 5689 not found! UpdateAchievementCriteria: Achievement 5689 not found! UpdateAchievementCriteria: Achievement 5689 not found! [..] All quests are visible on map... Perhaps it's better I wait more before try 4.3.4
  2. Dropped World, imported TDB_full_434.02_2012_08_30.sql + all /core/sql/updates/world 03:31:08 INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`) VALUES (@GUID,@ID,0,1,1,0,0,1567.16,-5611,114.19,1.084,900,0,1,26412,35250,2,0,0,0) Error Code: 1062. Duplicate entry '42575' for key 'PRIMARY' 0.000 sec
  3. Sorry, do not works. My steps: sql/create/drop_mysql.sql and sql/create/create_mysql.sql | OK sql/base/auth_database.sql (auth db) | OK sql/base/characters_database.sql (characters db) | OK TDB_full_434.01_2012_08_15.sql (world db) | OK world_updates.sql generated by merge_updates_windows.bat in TrinityCore_4.3.4_DB_Alpha (world db) | FAILED Log: [..] 02:51:44 DELETE FROM `creature_loot_template` WHERE `entry` = @ENTRY 0 row(s) affected 0.000 sec 02:51:44 INSERT INTO `creature_loot_template` VALUES (@ENTRY, 52365, 2, 1, 0, 1, 1), (@ENTRY, 52366, 2, 1, 0, 1, 1), (@ENTRY, 52388, 1.4, 1, 0, 1, 1), (@ENTRY, 67129, 4, 1, 0, 1, 1), (@ENTRY, 67130, 4, 1, 0, 1, 1), (@ENTRY, 67131, 2, 1, 0, 1, 1), (@ENTRY, 67132, 1.8, 1, 0, 1, 1), (@ENTRY, 67133, 1.8, 1, 0, 1, 1), (@ENTRY, 67134, 1.9, 1, 0, 1, 1), (@ENTRY, 67135, 1.4, 1, 0, 1, 1), (@ENTRY, 67136, 3, 1, 0, 1, 1), (@ENTRY, 67137, 1.9, 1, 0, 1, 1), (@ENTRY, 67138, 4, 1, 0, 1, 1), (@ENTRY, 67139, 1.2, 1, 0, 1, 1), (@ENTRY, 67140, 1.6, 1, 0, 1, 1), (@ENTRY, 67141, 1.4, 1, 0, 1, 1), (@ENTRY, 67142, 2, 1, 0, 1, 1), (@ENTRY, 67143, 3, 1, 0, 1, 1), (@ENTRY, 67144, 1.9, 1, 0, 1, 1), (@ENTRY, 67145, 0.9, 1, 0, 1, 1), (@ENTRY, 67146, 1.9, 1, 0, 1, 1), (@ENTRY, 67147, 3, 1, 0, 1, 1), (@ENTRY, 67148, 1.8, 1, 0, 1, 1), (@ENTRY, 67149, 1.9, 1, 0, 1, 1), (@ENTRY, 67150, 1.9, 1, 0, 1, 1), (@ENTRY, 67240, 82, 1, 0, 1, 1), (@ENTRY, 68781, 1.1, 1, 0, 1, 1), (@ENTRY, 68782, 1.1, 1, 0, 1, 1) 28 row(s) affected Records: 28 Duplicates: 0 Warnings: 0 0.000 sec 02:51:44 DELETE FROM `creature` WHERE `id` = 50063 0 row(s) affected 0.000 sec 02:51:44 INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`MovementType`,`npcflag`,`unit_flags`,`dynamicflags`) VALUES (9, 50063, 1, 1, 1, 0, 0, -10517.6, 69.0821, 12.1969, 1.53465, 7200, 0, 0, 14700, 0, 0, 0, 0, 0) Error Code: 1062. Duplicate entry '9' for key 'PRIMARY' 0.015 sec
  4. I tried with MySql cli and works fine: TDB 434.02 + update_02/*.sql... But now another error on Worldserver.exe... [..] >> Loaded 11 phasing definitions in 0 ms. Loading Conditions... [1054] Unknown column 'ErrorType' in 'field list' Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders. I need import TrinityCore/sql/updates/ ? In 2012_09_16_00_world_version.sql shows `db_version`='TDB 335.49',
  5. Hello everyone! I downloaded and installed the full DB (TDB_full_434.02_2012_08_30.sql). After this, trying update with update_02/*.sql this occurs: [..] 15:06:04 UPDATE `creature_template` SET `lootid`=40419 WHERE `entry`=40420 1 row(s) affected Rows matched: 1 Changed: 1 Warnings: 0 0.000 sec 15:06:04 DELETE FROM `disables` WHERE `sourceType`=4 AND `entry`=7323 0 row(s) affected 0.000 sec 15:06:04 DELETE FROM `disables` WHERE `sourceType`=4 AND `entry`=7324 0 row(s) affected 0.000 sec 15:06:04 DELETE FROM `disables` WHERE `sourceType`=4 AND `entry`=7325 0 row(s) affected 0.000 sec 15:06:04 SET @SisterSvalna := 37126 0 row(s) affected 0.000 sec 15:06:04 CALL `sp_get_ref_id`('RAID_CRE',@Reference) Error Code: 1305. PROCEDURE world.sp_get_ref_id does not exist 0.000 sec Details: - Last 4.3.4 branch (VS12 x32) - Last 4.3.4 Alpha DB - MySQL 5.5.28 - DB dropped, created, auth base, character base, world full 434.02 + update_02/*.sql (with error 1305) - Without update_02, worldserver says "DB outdated" What I made wrong?
×
×
  • Create New...