Jump to content
Why are these forums read only? ×
TrinityCore
Why are these forums read only?

fmilioni

Plebs
 View Profile  See their activity

  • Posts

    10

  • Joined

  • Last visited

 Content Type 

Posts posted by fmilioni

  1. "unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page

    in Help and Support

    Posted · Edited by fmilioni

    Do not apply core updates, only 4.3.4 DB files. If you don't know how to do it, then 4.3.4 is not for you, (its for devs not for public server). Just use last core of last sync (Rev b9b57c2d62).

    I did what you said, see above.

     

    First step Take last DB

    Seconde add Update 2 (only)

     

    Third do this query

     

    ALTER TABLE `conditions`
ADD COLUMN `ErrorType` MEDIUMINT(8) UNSIGNED DEFAULT 0 NOT NULL AFTER `NegativeCondition`

     

    START THE SERVER :P

     

    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  :mellow:

  2. "unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page

    in Help and Support

    Posted

    Hi.

     

    Drop world db.

    Apply the https://github.com/downloads/TrinityCore/TrinityCore_4.3.4_DB_Alpha/TDB_full_434.02_2012_08_30.rar to your world db.

    Make one file with updates downloaded in the core source and then apply them to your world db.

     

     

     

     

    That's for your world db.

     

     

     

    Best regards.

    1. 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. "unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page

    in Help and Support

    Posted · Edited by fmilioni

    If you have a 4.3.4 core, you need to use exclusivly this DB https://github.com/downloads/TrinityCore/TrinityCore_4.3.4_DB_Alpha/TDB_full_434.01_2012_08_15.rar + All updates from "updates_02".

     

    When you use the "merge_updates_windows.bat" it create a file named "world_updates.sql". You should apply this file only 1 time, and apply the new sqls one by one after or you will have problems like duplicate column, things like this.

    Sorry, do not works. My steps:

    1. sql/create/drop_mysql.sql and sql/create/create_mysql.sql | OK
    2. sql/base/auth_database.sql (auth db) | OK
    3. sql/base/characters_database.sql (characters db) | OK
    4. TDB_full_434.01_2012_08_15.sql (world db) | OK
    5. 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

  5. "unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page

    in Help and Support

    Posted · Edited by fmilioni

    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',

  6. "unknown column" "missing table" "duplicate column" error / sql problems / SQLDriverLogFile < answer on 1st post of 1st page

    in Help and Support

    Posted · Edited by fmilioni

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