View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on 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 Log in 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 Log in 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 Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 5.067 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.