Jump to content
TrinityCore

StormByte

Members
  • Posts

    132
  • Joined

  • Last visited

  • Days Won

    7

Posts posted by StormByte

  1. Nay, I located the issue in the config file.

    It is caused by this option: 

    Quests.IgnoreAutoAccept = 1 (not the default though)

    So either, this needs a bit of checking, to enable take the quest, when clicking on "accept" if this is ignored auto accept, or either, put a comment in the config file, that setting this to 1 can break some quests, so users are not confused.

    What do you think?

  2. These are the columns I have:

    SHOW COLUMNS FROM character_aura;
    +-----------------+-----------------------+------+-----+---------+-------+
    | Field           | Type                  | Null | Key | Default | Extra |
    +-----------------+-----------------------+------+-----+---------+-------+
    | guid            | int(10) unsigned      | NO   | PRI | 0       |       |
    | casterGuid      | bigint(20) unsigned   | NO   | PRI | 0       |       |
    | itemGuid        | bigint(20) unsigned   | NO   | PRI | 0       |       |
    | spell           | mediumint(8) unsigned | NO   | PRI | 0       |       |
    | effectMask      | tinyint(3) unsigned   | NO   | PRI | 0       |       |
    | recalculateMask | tinyint(3) unsigned   | NO   |     | 0       |       |
    | stackCount      | tinyint(3) unsigned   | NO   |     | 1       |       |
    | amount0         | int(11)               | NO   |     | 0       |       |
    | amount1         | int(11)               | NO   |     | 0       |       |
    | amount2         | int(11)               | NO   |     | 0       |       |
    | base_amount0    | int(11)               | NO   |     | 0       |       |
    | base_amount1    | int(11)               | NO   |     | 0       |       |
    | base_amount2    | int(11)               | NO   |     | 0       |       |
    | maxDuration     | int(11)               | NO   |     | 0       |       |
    | remainTime      | int(11)               | NO   |     | 0       |       |
    | remainCharges   | tinyint(3) unsigned   | NO   |     | 0       |       |
    +-----------------+-----------------------+------+-----+---------+-------+

     

    Seems that the update is already included on latests base/characters_database.sql as I've read the update and the data seems correct inside db

    Also, world fails to start with:

    Updating Character database...
    >> Reapplying update "2015_06_26_00_characters_335.sql" 'f8230a5' -> 'C2CC6E5' (it changed)...
    Warning: Using a password on the command line interface can be insecure.
    ERROR 1054 (42S22) at line 2: Unknown column 'caster_guid' in 'character_aura'
    Applying of file '/data/TrinityCore/3.3.5a/sources//sql/updates/characters/2015_06_26_00_characters_335.sql' to database 'Auschwitz_characters' failed! If you are an user pull the latest revision from the repository. If you are a developer fix your sql query.
    Could not update the Character database, see log for details.

     

    Due to the update seems already applied in base.

     

    EDIT2: Also if I update manually, worldserver fails to start when it tries to apply over again the updates (if it has the autoupdate flag set) Is that normal? SHouldn't the updates record themselves when applied?

    EDIT3: Finished installing from scratch, and the result is the same, I created a rogue undead, and can't take initial quest, quest mark is visible, and I can read it, but just can't accept it. Testing now to NOT install any update..

    EDIT4: Located the issue down to the config file, with a new one it does not happen... Very weird though

  3. I am trying to install from scratch, not finished yet, but when applying updates over a clean database, I got an error in updates/characters/2015_06_26_00_characters_335.sql:

    ERROR 1054 (42S22) at line 2: Unknown column 'caster_guid' in 'character_aura'

     

    Maybe the update is wrong? I am continuing meanwhile..

  4. I see that you are focusing now in 6.x, which is great, but to advance too much without even resolving the "old" world is a good idea?

     

    I just want you to ask if you are still maintaining 3.3.5a for bugfixes and so, or if it is archived permanently.

    Thanks, but I could not find info about this :)

×
×
  • Create New...