Problem with recurring calls (duplicating, multiplying several of the same) 9.5.6 latest version.

[bmarquinhoss]

Code of Conduct

• I agree to follow this project's Code of Conduct

Is there an existing issue for this?

• I have searched the existing issues

Version

9.5.6

Bug description

Hello friends,
I detected a bug in version 9.5.6 , it is infinitely multiplying the recurring calls.
ex: if I have a recurring call to be opened at 10 am, it creates infinitely several calls of the same.

anyone with this problem? already have correction?

I noticed that even creating the call, it makes a new schedule and when it runs, it makes a new schedule, with a difference of a few minutes.

Relevant log output

No response

Page URL

No response

Steps To reproduce

1 - create a ticket template
2- make the same call a recurrence, add a start and end date and a time to open the recurring call.
3- Note that after he creates the ticket, he will schedule a new creation in a few minutes and this is repeated (polluting the dashboard of the tickets)

Your GLPI setup information

versão 9.5.6

Anything else?

No response

[trasher]

Please write in english only.

[bmarquinhoss]

Hello friends,
I detected a bug in version 9.5.6 , it is infinitely multiplying the recurring calls.
ex: if I have a recurring call to be opened at 10 am, it creates infinitely several calls of the same.

anyone with this problem? already have correction?

I noticed that even creating the call, it makes a new schedule and when it runs, it makes a new schedule, with a difference of a few minutes.

[cedric-anne]

Hi,

Could you ensure that timezone defined in PHP settings is the same as the one defined on MySQL server ?

Regards

[bmarquinhoss]

I made one

"select now();"

I found a divergence of 3 hours.

I made direct adjustment via sql and solved only the momentary schedule.

I restarted the server and the divergence returned.

so I adjusted the timezone directly in the my.cnf file and now the times are the same.

now the mysql time is the same as the system.

the problem was this? the database with a different system time?

I will observe, hopefully resolve!

thank you, I'll be back to give feedback if it was resolved.

[bmarquinhoss]

I made the change as we speak, and until today it has not doubled, has not multiplied more.

so far resolved! I appreciate the tip!

Thank you very much

[cedric-anne]

Hi,

Problem is that the code is using both PHP current time and MySQL current time. It has to be refactored, but it is currently not in our priorities.

Regards

[bmarquinhoss]

everything worked out after the requested adjustment.

thank you!

[RheOliveira]

Hello friends

im with the same problem on GLPI 9.5.5

i has created a recurrent ticket and this was duplicated exactly 1 hour after the first ticket has created

i configure the local time zone on MySQL in command line database, I set time zone on CentOs directly and do double check on php.ini

everywhere is correct configuration local time Zone is america/Sao Paulo -3

[RheOliveira]

anyone know any action more to do ?

[bmarquinhoss]

caso ainda não resolveu, chama ai no telegram @bmarquinhoss,
posso te ajudar , tive o mesmo problema.

[trasher]

@bmarquinhoss english only please.

[trasher]

Please also translate ticket title to english...

[bmarquinhoss]

sorry, now in english...
if you still haven't solved it, call on telegram @bmarquinhoss,
I can help you, I had the same problem.

[grego1981]

Same for me in 10.0.5 version.. Is there even a fix to apply? I have set timezone in system, mariadb and GLPi and still occurs...

[cedric-anne]

A new field must be added to store the last date a ticket was created. Then the computation of next creation date should use this last date as a reference.

[hdep]

Hello,

it seems that we have the same issue with glpi 10.0.16.
However our database uses the SYSTEM, PHP uses the right timezone, so I'm not 100% sure on how to identify if we face this bug but we started to have duplicate reccurent ticket creation.

[Ludo-code]

Hello,

I have a similar problem but i have same timezone in database than linux system than php:

sql querry php my admin

vps screen time

vps screen php time conf