can't submit new event when mysql is in strict mode
I had to dive into the code because the agenda was preventing the user to submit new event when mysql is in strict mode.
I found some interesting things, and unfortunately I don't understand everything and can't guess if this is the desired behavior or not.
When submitting a new event, I can have a preview of the event, and every mandatory fields are filled correctly. But I can't submit the event (with the Valider
button) because I get the followgin sql error:
Probleme dans la syntaxe de [SQL statement with
department=69
andregion=''
] : Incorrect integer value: '' for column 'region' at row 1
Here are all the strange things I found.
region setting
Once the region is set (deducted from the department), it is unset: here.
country commented
The country is not saved as the corresponding line is commented twice: here and here
region commented
In order to fix the problem mentioned at the beginning of this issue, I had to comment either the region saving: here.
I need more information on how it should work because I don't know how to fix the problem. I just found a workaround by not saving the region in the database (by commenting the corresponding line).