Database Settings Editor

Discuss all aspects of editing the data and databases in EHM here. Have a question about the EHM Editor, EHM Assistant, editing the .cfg files, hex editing the .dat or .db files? Want to tweak the EHM exe file to change league rules/structure, start date etc? This is the place!
Forum rules
This is the forum to discuss all aspects of editing the EHM data and tweaking the game.

Have a bug or feature request for the EHM Editor? Post them in the EHM Editor thread. Please start a new thread or post in another thread if you have a question about how to use the EHM Editor.

Given the large number of questions on similar topics, we ask that you start a new thread for a new question unless you can locate a similar question in an existing thread. This will hopefully ensure that similar questions do not get buried in large threads.

Useful links: EHM 1 Assistant (Download) | EHM 1 Editor (Download) | EHM 1 Editor Tutorials | Editing Rules & Structures Guide | Converting EHM 2004 / 2005 DBs to EHM 1 | Converting an EHM 2007 DB to EHM 1 | Extra_config.cfg | Import_config.cfg | Player Roles
Post Reply
User avatar
Javs
Minor League
Posts: 238
Joined: Mon Mar 07, 2005 11:48 pm
Location: Ontario

Database Settings Editor

Post by Javs »

I tried the 'Database Settings Editor' but it doesn't appear to work and now my game is corrupt it appears? Any chance to recover it?? Had done a lot of work with North American juniors and was making great progress.
User avatar
xECK29x
TBL Rosters Researcher
Posts: 1010
Joined: Sun May 03, 2015 2:52 pm
Custom Rank: Premier Pivot Rosters Man
Favourite Team: New York Islanders

EHM 1 Database & Saved Game Editor

Post by xECK29x »

Javs wrote: Tue Sep 08, 2020 3:23 am I tried the 'Database Settings Editor' but it doesn't appear to work and now my game is corrupt it appears? Any chance to recover it?? Had done a lot of work with North American juniors and was making great progress.
When you open your database, if you go into Competitions -> Transfer Rules do they all say Out of Range? If so Archi does have a fix for this.
User avatar
Javs
Minor League
Posts: 238
Joined: Mon Mar 07, 2005 11:48 pm
Location: Ontario

EHM 1 Database & Saved Game Editor

Post by Javs »

Yes that is what happens, sometimes the database just freezes at financial rules when loading in the editor. Like I said I tried the database settings editor, but it hasn't worked
User avatar
xECK29x
TBL Rosters Researcher
Posts: 1010
Joined: Sun May 03, 2015 2:52 pm
Custom Rank: Premier Pivot Rosters Man
Favourite Team: New York Islanders

EHM 1 Database & Saved Game Editor

Post by xECK29x »

Ping me on Steam/Discord and I can fix it for you, long story short do the following:

1) Make sure you have the latest version of the editor which addresses this issue.
2) Make sure your database version is set to 1025 (under Home)
3) Under Settings -> General - ensure 'Always save database using the latest EHM version' is UNCHECKED.

Number 3 was the cause of the issue, when the Editor was released with support for the 1.5 DB version (1033) it was auto-updating database versions, also the league structure export/import functionality had some issues that needed to be addressed. Basically what is happening is the DB thinks you have a DB of one version where some tables are in a different versions format. Archi created a tool that fixes the database when this happens.
User avatar
archibalduk
TBL Admin Team
Posts: 20372
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:

Database Settings Editor

Post by archibalduk »

Javs wrote: Tue Sep 08, 2020 3:23 am I tried the 'Database Settings Editor' but it doesn't appear to work and now my game is corrupt it appears? Any chance to recover it?? Had done a lot of work with North American juniors and was making great progress.
What exactly did you try with the Database Settings Editor ("DSE")? When you loaded the DB in the DSE, did it state 1025 for each of the Created With Version and Database Version settings? If it does, change both of these to 1033 and save the DB. Then load it in the Editor and everything should be back to normal. Then on the Home screen of the Editor, change the Version drop-down menu setting to EHM 1025 and save the database.
User avatar
Javs
Minor League
Posts: 238
Joined: Mon Mar 07, 2005 11:48 pm
Location: Ontario

Database Settings Editor

Post by Javs »

Yeah I tried that, it freezes on financial rules when loading in the newest editor now. At first i would go through the steps and it would be fine but the game would crash when loading a new game and then the database would be back to corrupt, but now it won't load in the editor
User avatar
archibalduk
TBL Admin Team
Posts: 20372
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:

Database Settings Editor

Post by archibalduk »

If you upload your DB then I'll take a look.
User avatar
Javs
Minor League
Posts: 238
Joined: Mon Mar 07, 2005 11:48 pm
Location: Ontario

Database Settings Editor

Post by Javs »

Yeah will do, where/how do I upload it?
User avatar
archibalduk
TBL Admin Team
Posts: 20372
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:

Database Settings Editor

Post by archibalduk »

Javs wrote: Mon Sep 14, 2020 8:32 pm Yeah will do, where/how do I upload it?
Any file sharing site you like e.g. Dropbox or wetransfer.com and just post the link in here. I'm working long days right now so it might take me a week or so to look, so give me a nudge if you don't hear within a week of uploading.
Post Reply