View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Error When changing status in opportunity, the status has a event notification - ProjeQtOr
 

Error When changing status in opportunity, the status has a event notification

More
22 Jan 2026 14:19 - 22 Jan 2026 14:20 #1 by karl.binet
Hello,I’m using version V12.4.1. I’m working in an opportunity. I’m able to create the opportunity successfully, but when I change its status—for example, to “In Progress”—I get an error.Please note that I have an event notification configured for this status, so it seems to crash when it tries to send an email during the status change.

i tried V12.4.2, i get the same issue

Here is the error in Projeqtor Log File

 2026-01-22 08:12:57.867 ***** ERROR ***** [V12.4.1] [27] ERROR *****
2026-01-22 08:12:57.867 ***** ERROR ***** [V12.4.1] [27] on file '/var/www/html/model/persistence/SqlElement.php' at line (6741)
2026-01-22 08:12:57.868 ***** ERROR ***** [V12.4.1] [27] cause = Undefined index:
2026-01-22 08:13:12.542 ***** ERROR ***** [V12.4.1] [27] ERROR *****
2026-01-22 08:13:12.542 ***** ERROR ***** [V12.4.1] [27] on file '/var/www/html/model/persistence/SqlElement.php' at line (6741)
2026-01-22 08:13:12.542 ***** ERROR ***** [V12.4.1] [27] cause = Undefined index:

see attach for browser console log, if this can help

i Tried deleting/recreate the event notification, it did not help.

Regards
Attachments:
Last edit: 22 Jan 2026 14:20 by karl.binet.

Please Connexion or Create an account to join the conversation.

More
26 Jan 2026 08:52 #2 by maxca
Hello,
I can not reproduce your problem. Please explain your case step by step, providing as much detail as possible. 
Can you reproduce your case on the demo? Link to demo  
Have a nice day,

Please Connexion or Create an account to join the conversation.

More
26 Jan 2026 12:23 #3 by karl.binet
Hello, unfortunately i can not reproduce on the demo, none of the users have enough rights to complete the tests.

Here are the detail,

First test,

Hi have this Event notification

 

when i try to create a new activity, type "Cessation d'emploi" i enter the details, when i hit SAVE (the first status is "ENREGISTRER" that corresponds to the first state when i hit save" i get a red message at the top

Here is the log2026-01-26 05:56:37.379 ***** ERROR ***** [V12.4.1] [27] ERROR *****
2026-01-26 05:56:37.379 ***** ERROR ***** [V12.4.1] [27] on file '/var/www/html/model/persistence/SqlElement.php' at line (6754)
2026-01-26 05:56:37.379 ***** ERROR ***** [V12.4.1] [27] cause = Undefined index:

Second test

Hi have this event notification



NOTE : there is a template in the event notification, i get the error even if there is no template.

I'm creating a new opportunity, i'm entering all the details, the first status is "Recorded" so when i hit save everything is ok because there is no event notification for this state.

If i change the state for "go-no-go" i get this error, here is the log file
NOTE : the "go-no-go" state triggers the event notification

2026-01-26 06:10:28.032 ***** ERROR ***** [V12.4.1] [27] ERROR *****
2026-01-26 06:10:28.032 ***** ERROR ***** [V12.4.1] [27] on file '/var/www/html/model/persistence/SqlElement.php' at line (6741)
2026-01-26 06:10:28.032 ***** ERROR ***** [V12.4.1] [27] cause = Undefined index:

i also got these error in the log file, but i don't know what trigered these error

2026-01-26 05:53:52.525 ***** ERROR ***** [V12.4.1] [27] Error on SqlElement to get 'mailToselectedReceivers' for Class 'StatusMailPerProject' : field 'mailToselectedReceivers' not found in Database on table statusmail
2026-01-26 05:53:52.525 ***** ERROR ***** [V12.4.1] [27] Error on SqlElement to get 'mailToselectedReceivers' for Class 'StatusMailPerProject' : field 'mailToselectedReceivers' not found in Database on table statusmail
2026-01-26 05:54:17.768 ***** ERROR ***** [V12.4.1] [27] Error on SqlElement to get 'mailToselectedReceivers' for Class 'StatusMailPerProject' : field 'mailToselectedReceivers' not found in Database on table statusmail

I hope you have all the needed information, please contact me if you need more precision

Regards


 
Attachments:

Please Connexion or Create an account to join the conversation.

More
02 Fév 2026 09:34 - 02 Fév 2026 09:34 #4 by maxca
Hello,
Thank you for the details. Unfortunately, I have not been able to reproduce your problem.
Ticket recorded  #11164 
Have a nice day,
 
Last edit: 02 Fév 2026 09:34 by maxca.

Please Connexion or Create an account to join the conversation.

More
21 Fév 2026 19:05 #5 by babynus
This issue is fixed 
and fix is available through subscription service.

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.056 seconds

Paramétrages de cookies

×

Cookies fonctionnels

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

Veuillez vous connecter pour voir vos activités!

Autres cookies

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