agenda-libre-php issueshttps://framagit.org/agenda-libre/agenda-libre-php/-/issues2022-04-24T22:03:22Zhttps://framagit.org/agenda-libre/agenda-libre-php/-/issues/64map marker is not loaded from current theme folder2022-04-24T22:03:22ZLoïc DAYOTmap marker is not loaded from current theme folderThe marker.png is always loaded from adl/image/ path ; adl is the old default theme.
In fact, the path is hard coded in js/displayMap.jsThe marker.png is always loaded from adl/image/ path ; adl is the old default theme.
In fact, the path is hard coded in js/displayMap.jsLoïc DAYOTLoïc DAYOThttps://framagit.org/agenda-libre/agenda-libre-php/-/issues/63No filter adding localgroup role in event form2022-04-24T22:03:21ZLoïc DAYOTNo filter adding localgroup role in event formIn event edit form, we can add localgroup role like organizer.
To do this, we can find localgroup in list typing characters, but list is never filtered.In event edit form, we can add localgroup role like organizer.
To do this, we can find localgroup in list typing characters, but list is never filtered.Loïc DAYOTLoïc DAYOThttps://framagit.org/agenda-libre/agenda-libre-php/-/issues/62Error when transfer tag2022-04-24T22:03:21ZLoïc DAYOTError when transfer tagError in sql query when transfering a tag.
The query string needs a "," between values.Error in sql query when transfering a tag.
The query string needs a "," between values.Loïc DAYOTLoïc DAYOThttps://framagit.org/agenda-libre/agenda-libre-php/-/issues/61error adding localgroup2022-04-24T22:03:22ZLoïc DAYOTerror adding localgroupError in query string after send localgroup edit form.
Problem could be lack of default value to decision_time field of localgroups table.Error in query string after send localgroup edit form.
Problem could be lack of default value to decision_time field of localgroups table.Loïc DAYOTLoïc DAYOThttps://framagit.org/agenda-libre/agenda-libre-php/-/issues/59can't submit new event when mysql is in strict mode2020-08-06T21:53:45ZPloccan't submit new event when mysql is in strict modeI 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 des...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` and `region=''`] : 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](https://framagit.org/agenda-libre/agenda-libre-php/-/blob/e487fa0cfe4f50127a93b21cd29a2b6f70b9d30c/www/inc/class.event.inc.php#L104-105).
# country commented
The country is not saved as the corresponding line is commented twice: [here](https://framagit.org/agenda-libre/agenda-libre-php/-/blob/e487fa0cfe4f50127a93b21cd29a2b6f70b9d30c/www/inc/class.event.inc.php#L109) and [here](https://framagit.org/agenda-libre/agenda-libre-php/-/blob/e487fa0cfe4f50127a93b21cd29a2b6f70b9d30c/www/inc/class.event.inc.php#L160)
# region commented
In order to fix the problem mentioned at the beginning of this issue, I had to comment either the region saving: [here](https://framagit.org/agenda-libre/agenda-libre-php/-/blob/e487fa0cfe4f50127a93b21cd29a2b6f70b9d30c/www/inc/class.event.inc.php#L159).
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).https://framagit.org/agenda-libre/agenda-libre-php/-/issues/49the determination of the region should take into account the country in addit...2018-01-25T21:23:40ZPlocthe determination of the region should take into account the country in addition to the postal codeThe region is determined from the postal code, even when the postal code is located outside France.
Example of an event in Belgium whose address is :
> à 16, Rue de la Loi - Wetstraat, Quartier Royal - Koninklijke Wijk -
1000 Vill...The region is determined from the postal code, even when the postal code is located outside France.
Example of an event in Belgium whose address is :
> à 16, Rue de la Loi - Wetstraat, Quartier Royal - Koninklijke Wijk -
1000 Ville de Bruxelles - Stad Brussel, Auvergne-Rhône-Alpes
The determination of the region should take into account the country in addition to the postal code.3.6https://framagit.org/agenda-libre/agenda-libre-php/-/issues/47improve session management2017-04-30T08:25:24ZPlocimprove session managementThe session management should be improved as it is now creating countless cookies in the session directoy:
```bash
>ls -l tmp/sessions/
total 0
-rw------- 1 www-data www-data 0 avril 30 10:16 sess_4tke3fvmaju79r6fc9b7mbn5g0
-rw------- 1...The session management should be improved as it is now creating countless cookies in the session directoy:
```bash
>ls -l tmp/sessions/
total 0
-rw------- 1 www-data www-data 0 avril 30 10:16 sess_4tke3fvmaju79r6fc9b7mbn5g0
-rw------- 1 www-data www-data 0 avril 30 10:22 sess_8q59jqo3mdmuidqi37qlebtle6
-rw------- 1 www-data www-data 0 avril 30 10:22 sess_9oanm07e9lmktccnrfec72lpk7
-rw------- 1 www-data www-data 0 avril 30 10:20 sess_fuvuo0ilrsmjdkig6bvp6to7m6
-rw------- 1 www-data www-data 0 avril 30 10:23 sess_gf0v9jmln995fvjdmg68g1j435
-rw------- 1 www-data www-data 0 avril 30 10:23 sess_i6hdmgkpuljjbskpia5aheoev3
-rw------- 1 www-data www-data 0 avril 30 10:17 sess_sv53mm07ahvdal0cqos7dnrnl4
[...]
```
In the end, the filesystem is overloaded with cookie file, and it ends with no more inode available.https://framagit.org/agenda-libre/agenda-libre-php/-/issues/41the tag field should be stripped from double spaces or trailing spaces2018-01-25T21:24:00ZPlocthe tag field should be stripped from double spaces or trailing spacesAdding a double spaces or trailing spaces generates an empty tag.
The tag field should be stripped from double spaces or trailing spaces in order to avoid empty tag.Adding a double spaces or trailing spaces generates an empty tag.
The tag field should be stripped from double spaces or trailing spaces in order to avoid empty tag.3.6