Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

Tickets ID
 
Notifications
Clear all

Tickets ID

9 Posts
3 Users
0 Reactions
6,544 Views
(@ysabro)
Posts: 5
Active Member
Topic starter
 
[#5232]

Hi all,

I just noticed that ProjeQtor increments my tickets ID by 2, and not by 1. can anyone see where the problem is from ?

Thank you !


 
Posted : 20 Jun 2018 13H39
(@alain-fourastie)
Posts: 366
Active Member Moderator
 

Hi, welcome to Projeqtor.

Have you checked in the database if the ID of all tickets is incremented only and systematically by "+2" or normally by + 1 ?
Do other people use ProjeQtor into your firm? If so, other users may be creating tickets, not necessarily for your projects, and you may not know about them. In this case, the identifier of each ticket is always incremented by "+1" to each creation regardless of the project for which it was created. In other words, you would create a ticket each time another had been created by someone else, which could explain +2.
Please tell us.
Best regards.


 
Posted : 21 Jun 2018 13H46
(@ysabro)
Posts: 5
Active Member
Topic starter
 

Hi,
Thank you for your reply.
I checked the ticket table in the database, the tickets id is incremented by +2 automatically.
is it configurable?

Best regards.


 
Posted : 21 Jun 2018 15H07
babynus
(@babynus)
Posts: 14953
Main Contributor Admin
 

Wich version of ProjeQtOr are you using.
Similar behavior can be found on V7.1.1, fixed on V7.1.2


 
Posted : 21 Jun 2018 15H57
(@ysabro)
Posts: 5
Active Member
Topic starter
 

We are using ProjeQtor V7.0.9


 
Posted : 21 Jun 2018 16H02
babynus
(@babynus)
Posts: 14953
Main Contributor Admin
 

Cannot reproduce.
Only possibility I can imagine, is that you use postgreSql and sequence has increment_by=2

What is your DB ?


 
Posted : 21 Jun 2018 20H04
(@ysabro)
Posts: 5
Active Member
Topic starter
 

Hi, Thank you for reply.

We actually use MariaDB 10.2.6


 
Posted : 21 Jun 2018 20H08
babynus
(@babynus)
Posts: 14953
Main Contributor Admin
 

Check value for auto-increment-increment in my.cnf file


 
Posted : 21 Jun 2018 21H01
(@ysabro)
Posts: 5
Active Member
Topic starter
 

You are right: auto_increment_increment=2
Thank you very much


 
Posted : 21 Jun 2018 21H14
Share:

Scroll to Top