Upgrade from old *resolved*

[Terrafyde]

Hi, The last Intersect version I had was 0.6.2.457 !
How can I upgrade/migrate to the latest version ? The only available downloads don't upgrade, they seem to have an error when they do the upgrade. Should I use an older version as a stepping stone to get up to date. If so which version and where are the downloads for them ? github seems to have no release pre-2023.

[Smoot]

Yeah I think you will need to step up like you said. Have you done any code changes? You would be breaking those if so, but you would probably already know that if you did

[panda]

In addition to what @Smoot said:

1. Try the last 0.7.2-beta build (0.7.2-beta.65)

2. Please include the logs (and screenshots of the error in the server console if there are no logs) with any future reports.
3. There are no compiled downloads for before 0.7.2-beta as they were hosted on our TeamCity server that has been since shut down (but the source is still available on GitHub to compile from, not that I recommend doing so).

[Terrafyde]

I had already tried that version as the lowest available to download.

 

There was only one line in the error log

2023-10-14 05:28:59.102 [Error] Received unhandled exception from System.Threading.Thread.

 

and here is the db server log

2023-10-14 05:28:59.086 [Error] GAMEDB: 20102 - Failed executing DbCommand (260ms) [Parameters=[], CommandType='Text', CommandTimeout='30']

PRAGMA foreign_keys = 0;

CREATE TABLE sqlitestudio_temp_table AS SELECT *
                                          FROM Items;

DROP TABLE Items;

CREATE TABLE Items (
    Id                      BLOB    NOT NULL
                                    CONSTRAINT PK_Items PRIMARY KEY,
    TimeCreated             INTEGER NOT NULL,
    Name                    TEXT,
    Animation               BLOB    NOT NULL,
    AttackAnimation         BLOB    NOT NULL,
    EquipmentAnimation      BLOB    NOT NULL,
    Bound                   INTEGER NOT NULL,
    CritChance              INTEGER NOT NULL,
    CritMultiplier          REAL    NOT NULL,
    Cooldown                INTEGER NOT NULL,
    Damage                  INTEGER NOT NULL,
    DamageType              INTEGER NOT NULL,
    AttackSpeedModifier     INTEGER NOT NULL,
    AttackSpeedValue        INTEGER NOT NULL,
    Consumable_Type         INTEGER NOT NULL,
    Consumable_Value        INTEGER NOT NULL,
    EquipmentSlot           INTEGER NOT NULL,
    TwoHanded               INTEGER NOT NULL,
    Effects                 TEXT,
    SlotCount               INTEGER NOT NULL,
    Spell                   BLOB    NOT NULL,
    Event                   BLOB    NOT NULL,
    Description             TEXT,
    FemalePaperdoll         TEXT,
    ItemType                INTEGER NOT NULL,
    MalePaperdoll           TEXT,
    Icon                    TEXT,
    Price                   INTEGER NOT NULL,
    Projectile              BLOB    NOT NULL,
    Scaling                 INTEGER NOT NULL,
    ScalingStat             INTEGER NOT NULL,
    Speed                   INTEGER NOT NULL,
    Stackable               INTEGER NOT NULL,
    StatGrowth              INTEGER NOT NULL,
    Tool                    INTEGER NOT NULL,
    VitalsGiven             TEXT,
    StatsGiven              TEXT,
    UsageRequirements       TEXT,
    DestroySpell            INTEGER NOT NULL
                                    DEFAULT 0,
    QuickCast               INTEGER NOT NULL
                                    DEFAULT 0,
    Rarity                  INTEGER NOT NULL
                                    DEFAULT 0,
    Folder                  TEXT,
    Consumable_Percentage   INTEGER NOT NULL
                                    DEFAULT 0,
    PercentageStatsGiven    TEXT,
    PercentageVitalsGiven   TEXT,
    VitalsRegen             TEXT,
    CooldownGroup           TEXT    NOT NULL
                                    DEFAULT '',
    IgnoreGlobalCooldown    INTEGER NOT NULL
                                    DEFAULT 0,
    Color                   TEXT,
    IgnoreCooldownReduction INTEGER NOT NULL
                                    DEFAULT 0,
    CanBag                  INTEGER NOT NULL
                                    DEFAULT 1,
    CanBank                 INTEGER NOT NULL
                                    DEFAULT 1,
    DropChanceOnDeath       INTEGER NOT NULL
                                    DEFAULT 0,
    CanSell                 INTEGER NOT NULL
                                    DEFAULT 1,
    CanTrade                INTEGER NOT NULL
                                    DEFAULT 1,
    MaxBankStack            INTEGER NOT NULL
                                    DEFAULT 2147483647,
    MaxInventoryStack       INTEGER NOT NULL
                                    DEFAULT 2147483647,
    CanGuildBank            INTEGER NOT NULL
                                    DEFAULT 0,
    CannotUseMessage        TEXT,
    BlockAbsorption         INTEGER NOT NULL
                                    DEFAULT 0,
    BlockAmount             INTEGER NOT NULL
                                    DEFAULT 0,
    BlockChance             INTEGER NOT NULL
                                    DEFAULT 0,
    WeaponSpriteOverride    TEXT,
    DespawnTime             INTEGER NOT NULL
                                    DEFAULT 0
);

INSERT INTO Items (
                      Id,
                      TimeCreated,
                      Name,
                      Animation,
                      AttackAnimation,
                      EquipmentAnimation,
                      Bound,
                      CritChance,
                      CritMultiplier,
                      Cooldown,
                      Damage,
                      DamageType,
                      AttackSpeedModifier,
                      AttackSpeedValue,
                      Consumable_Type,
                      Consumable_Value,
                      EquipmentSlot,
                      TwoHanded,
                      Effects,
                      SlotCount,
                      Spell,
                      Event,
                      Description,
                      FemalePaperdoll,
                      ItemType,
                      MalePaperdoll,
                      Icon,
                      Price,
                      Projectile,
                      Scaling,
                      ScalingStat,
                      Speed,
                      Stackable,
                      StatGrowth,
                      Tool,
                      VitalsGiven,
                      StatsGiven,
                      UsageRequirements,
                      DestroySpell,
                      QuickCast,
                      Rarity,
                      Folder,
                      Consumable_Percentage,
                      PercentageStatsGiven,
                      PercentageVitalsGiven,
                      VitalsRegen,
                      CooldownGroup,
                      IgnoreGlobalCooldown,
                      Color,
                      IgnoreCooldownReduction,
                      CanBag,
                      CanBank,
                      DropChanceOnDeath,
                      CanSell,
                      CanTrade,
                      MaxBankStack,
                      MaxInventoryStack,
                      CanGuildBank,
                      CannotUseMessage,
                      BlockAbsorption,
                      BlockAmount,
                      BlockChance,
                      WeaponSpriteOverride,
                      DespawnTime
                  )
                  SELECT Id,
                         TimeCreated,
                         Name,
                         Animation,
                         AttackAnimation,
                         EquipmentAnimation,
                         Bound,
                         CritChance,
                         CritMultiplier,
                         Cooldown,
                         Damage,
                         DamageType,
                         AttackSpeedModifier,
                         AttackSpeedValue,
                         Consumable_Type,
                         Consumable_Value,
                         EquipmentSlot,
                         TwoHanded,
                         Effects,
                         SlotCount,
                         Spell,
                         Event,
                         Description,
                         FemalePaperdoll,
                         ItemType,
                         MalePaperdoll,
                         Icon,
                         Price,
                         Projectile,
                         Scaling,
                         ScalingStat,
                         Speed,
                         Stackable,
                         StatGrowth,
                         Tool,
                         VitalsGiven,
                         StatsGiven,
                         UsageRequirements,
                         DestroySpell,
                         QuickCast,
                         Rarity,
                         Folder,
                         Consumable_Percentage,
                         PercentageStatsGiven,
                         PercentageVitalsGiven,
                         VitalsRegen,
                         CooldownGroup,
                         IgnoreGlobalCooldown,
                         Color,
                         IgnoreCooldownReduction,
                         CanBag,
                         CanBank,
                         DropChanceOnDeath,
                         CanSell,
                         CanTrade,
                         MaxBankStack,
                         MaxInventoryStack,
                         CanGuildBank,
                         CannotUseMessage,
                         BlockAbsorption,
                         BlockAmount,
                         BlockChance,
                         WeaponSpriteOverride,
                         DespawnTime
                    FROM sqlitestudio_temp_table;

DROP TABLE sqlitestudio_temp_table;

PRAGMA foreign_keys = 1;

--------------------------------------------------------------------------------

 

 

[panda]

@TerrafydeIs this error log from trying 0.7.2-beta.65, or 0.8.0-beta.#?

[Terrafyde]

Definatley 0.7.2-beta.65

 

[panda]

@TerrafydeCan you please send your DBs to pandacoder@pm.me so I can examine them and debug why the crash is occurring?

[Terrafyde]

I found a 0.7.0 version, upgrading from 0.6.2 to 0.7.0 first has eliminated the errors when upgrading to 0.7.2 and above.