English Chess Forum

I've created the four sections for the Hampshire Junior Open in Swiss Manager.

Sadly, only three of them can appear at anyone time on chess-results.com

For some reason two of them (U18 and U12) share the same DataBaseKey of 687690

I've no idea if I can update the key for one to make it unique.

Any suggestions please?

I would be interested to know how you managed that.

I would suggest that you reload one of the sections (egU12) with a slightly different name and as a new event and link that.

You can delete tournaments from Chess Results but be careful that you don't delete the wrong one.

Usually, with multiple sections I create the youngest category first and then its DataBaseKey as the Master for all of the others to link to.

Having created this initial section I then create the next new and use the "Copy Tournament Data" utility to avoid entering common data more than once. Perhaps this operation did it but then again, I've one this before with success.

Puzzling....

I'm grateful to Paul M. who provided a solution.

In SM take the second duplicate section and blank the databasekey

Then upload to chess-results.com

CR will then allocate a fresh DBK and all is working nicely.

Thanks Paul!

Alex McFarlane wrote: ↑

Sun Oct 23, 2022 12:02 pm

I would be interested to know how you managed that.

There is a bug whereby if you are in SM with tournament A loaded which already has a DBKey (having been uploaded to chess-results) and you create a new tournament B then the DBKey that was there for A is not cleared. You then upload tournament B and chess-results replaces A with B.

As pointed out the solution is to blank out the DBKey in the tournament setup and reload whereupon chess-results will assign a new DBKey.

Brian Towers wrote: ↑

Sun Oct 23, 2022 11:53 pm

Alex McFarlane wrote: ↑

Sun Oct 23, 2022 12:02 pm

I would be interested to know how you managed that.

There is a bug whereby if you are in SM with tournament A loaded which already has a DBKey (having been uploaded to chess-results) and you create a new tournament B then the DBKey that was there for A is not cleared. You then upload tournament B and chess-results replaces A with B.

As pointed out the solution is to blank out the DBKey in the tournament setup and reload whereupon chess-results will assign a new DBKey.

Thanks Brian. I think above is exactly the bug I managed to recreate!

John Upham wrote: ↑

Mon Oct 24, 2022 9:39 am

Thanks Brian. I think above is exactly the bug I managed to recreate!

It does sound like a very easy one to fall into if you are not a Swiss Manager specialist.

John Upham wrote: ↑

Sun Oct 23, 2022 2:04 pm

I'm grateful to Paul M. who provided a solution.
...
Thanks Paul!

Glad to be of assistance.

The important thing to understand is that the tournament key is actually a key into the chess-results.com database. It is generated by chess-results.com, not by Swiss Manager. All perfectly logical, of course, as the key has to be unique across all the tournaments which use chess-results.com to display entry, pairings, results and standings. The key is obviously created by an append to the database (or rather to a sequentially ordered key table), whenever a tournament is uploaded to chess-results.com with a blank key field. The key is then used to produce an unique url for the tournament - for example in your U12 tournament, http://chess-results.com/tnr688238.aspx, the tournament key is 688238, and that should match the value in the SM file for the same tournament.

(If you borked a SM file, you could even copy the key to a corrected SM file, upload and carry on as if nothing untoward had ever happened. That is, assuming you couldn't recover by finding the last correct backup file that SM had produced, and renaming it to blah.TUNx or blah.TURx, as appropriate.)