View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - SQL error when adding a new object - ProjeQtOr
 
 

SQL error when adding a new object

More
19 Dec 2018 16:20 - 19 Dec 2018 16:24 #1 by esther
Hi,

When I try to add a new object in Projeqtor (project, activity, ticket, meeting, etc.) I get one of the following errors:

- this one about unique constraint violation : SQLSTATE[23505]: Unique violation: 7 ERREUR: la valeur d'une clé dupliquée rompt la contrainte unique « activity_pkey » DETAIL: La clé « (id)=( 8 ) » existe déjà.
- this one about a cancelled transaction : SQLSTATE[25P02]: In failed sql transaction: 7 ERREUR: la transaction est annulée, les commandes sont ignorées jusqu'à la fin du bloc de la transaction

Attached is the log file.
Do you know what could cause this error? I never saw this before. I recently created user accounts so that people can connect to Projeqtor. Could it be that ?

Many thanks.
Attachments:
Last edit: 19 Dec 2018 16:24 by esther.

Please Log in or Create an account to join the conversation.

More
19 Dec 2018 21:15 - 19 Dec 2018 21:16 #2 by babynus
I guess you are using PostgreSql
Try and realign sequences with real data.

You can try and execute updatePgSeq($table)
for instance
updatePgSeq('table')

Babynus
Administrator of ProjeQtOr web site
Last edit: 19 Dec 2018 21:16 by babynus.

Please Log in or Create an account to join the conversation.

More
24 Dec 2018 13:38 #3 by esther
Hi,

Thanks for your reply, it does the job.
However, I get this error quite often on various tables.
Do you think it may be related to how Projeqtor handles sequences?
Are there other users reporting the same issue?
Do you plan to address this issue in further versions?

Thanks

Please Log in or Create an account to join the conversation.

More
24 Dec 2018 13:41 #4 by babynus

Do you think it may be related to how Projeqtor handles sequences?

No, it is related to how PostgreSql handles sequences.

For instance, after import of tables, you must be sure to correctly update sequence, like proposed.

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.039 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.