Cannot add athletes to existing competition

Welcome User Forums Knowledgebase Cannot add athletes to existing competition

This topic contains 0 replies, has 1 voice, and was last updated by  Chris 2 months, 2 weeks ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #645

    Chris
    Keymaster

    This problem has been seen once when moving competition databases between vifferent versions of PostgreSQL (8/9/10).
    A unique index sequence gets lost. TScore continues to work ok, until you try adding any more entrants to the database, when it just refuses.
    If you check the TScoreX/TStemp folder, you’l see the TScore SQL error log in there has entries in complaining about ‘null value in column “id” violates not-null constraint”‘.

    You need to use the PGAdmin tool to fix one at present – recreating the sequence item and the default value for the Entrants.ID column.
    Full instructions are in this file:
    https://tscore.co.uk/Downloads/UnableToAddEntrantsToDatabase.docx

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.