Erreur 413 & 500 pour un post // Pas de preview #92

Coucou,

J'ai voulu créer un nouveau topic sur la v5, dans la catégorie discussion et j'ai eu quelques petits soucis :

La toggle preview (l'oeil tout à droite dans l'éditeur) ne fonctionnait pas, selon Eragon elle est censée fonctionner...
J'ai voulu joindre une capture vidéo de 2.4 Mo (la capture en question xD) et j'ai eu une erreur 413 Request Entity Too Large. La limite est à combien ?
En voulant re-poster mais sans la PJ, j'ai eu une erreur 500 Internal Server Error.

J'utilise Firefox 78.10.0esr (64 bits) à jour si jamais

Merci ! ^^

PS : je n'ai plus d'erreur en postant maintenant

Les logs extraits par Breizh

[pid: 2933485|app: 0|req: 2452/2452] 2a01:cb04:938:d400:b3e5:cf47:49cf:63d4 () {58 vars in 1317 bytes} [Sun Apr 25 21:14:43 2021] GET /forum/ => generated 18524 bytes in 123 msecs (HTTP/2.0 200) 4 headers in 289 bytes (1 switches on core 0)
[pid: 2933485|app: 0|req: 2453/2453] 185.25.192.150 () {58 vars in 1373 bytes} [Sun Apr 25 21:14:45 2021] POST /sondages/10/voter => generated 355 bytes in 42 msecs (HTTP/2.0 302) 5 headers in 579 bytes (1 switches on core 0)
[pid: 2933485|app: 0|req: 2454/2454] 185.25.192.150 () {52 vars in 1241 bytes} [Sun Apr 25 21:14:45 2021] GET /forum/aide/autres/5951/fin/etre-ou-ne-pas-etre => generated 31098 bytes in 277 msecs (HTTP/2.0 200) 4 headers in 417 bytes (1 switches on core 0)
[pid: 2933485|app: 0|req: 2455/2455] 90.32.199.138 () {52 vars in 1143 bytes} [Sun Apr 25 21:14:47 2021] GET /forum/aide/autres/5951/fin/etre-ou-ne-pas-etre => generated 28843 bytes in 194 msecs (HTTP/2.0 200) 4 headers in 269 bytes (2 switches on core 0)
[pid: 2933485|app: 0|req: 2456/2456] 185.25.192.150 () {52 vars in 1152 bytes} [Sun Apr 25 21:14:56 2021] GET /forum/projets/outils/5931/fin/tests-xss => generated 22891 bytes in 270 msecs (HTTP/2.0 200) 3 headers in 96 bytes (1 switches on core 0)
[pid: 2933485|app: 0|req: 2457/2457] 185.25.192.150 () {50 vars in 1080 bytes} [Sun Apr 25 21:14:57 2021] GET /forum/projets/outils/5931/fin/%22%20onmouseover=%22alert( => generated 16328 bytes in 79 msecs (HTTP/2.0 404) 3 headers in 103 bytes (1 switches on core 0)
[pid: 2933485|app: 0|req: 2458/2458] 185.25.192.150 () {50 vars in 1092 bytes} [Sun Apr 25 21:14:57 2021] GET /forum/projets/outils/5931/fin/%22%20onmouseover=%22alert('lol') => generated 16328 bytes in 63 msecs (HTTP/2.0 404) 3 headers in 103 bytes (1 switches on core 0)
[pid: 2933485|app: 0|req: 2459/2459] 185.25.192.150 () {50 vars in 1034 bytes} [Sun Apr 25 21:14:57 2021] GET /forum/projets/outils/5931/fin/& => generated 16328 bytes in 57 msecs (HTTP/2.0 404) 3 headers in 103 bytes (1 switches on core 0)
[pid: 2933485|app: 0|req: 2460/2460] 90.32.199.138 () {58 vars in 1097 bytes} [Sun Apr 25 21:15:09 2021] POST /connexion => generated 355 bytes in 10 msecs (HTTP/2.0 302) 5 headers in 449 bytes (2 switches on core 0)
[pid: 2933485|app: 0|req: 2461/2461] 90.32.199.138 () {52 vars in 1105 bytes} [Sun Apr 25 21:15:09 2021] GET /forum/aide/autres/5951/fin/etre-ou-ne-pas-etre => generated 29248 bytes in 222 msecs (HTTP/2.0 200) 4 headers in 289 bytes (1 switches on core 0)
[pid: 2933485|app: 0|req: 2462/2462] 185.25.192.150 () {52 vars in 1091 bytes} [Sun Apr 25 21:15:13 2021] GET /membre/FKite => generated 23525 bytes in 90 msecs (HTTP/2.0 200) 3 headers in 96 bytes (1 switches on core 0)
[pid: 2933485|app: 0|req: 2463/2463] 185.25.192.150 () {52 vars in 1052 bytes} [Sun Apr 25 21:15:25 2021] GET /forum/ => generated 20130 bytes in 129 msecs (HTTP/2.0 200) 3 headers in 96 bytes (2 switches on core 0)
[pid: 2933485|app: 0|req: 2464/2464] 185.25.192.150 () {52 vars in 1066 bytes} [Sun Apr 25 21:15:28 2021] GET /forum/discussion => generated 297 bytes in 5 msecs (HTTP/2.0 308) 3 headers in 153 bytes (1 switches on core 0)
[pid: 2933485|app: 0|req: 2465/2465] 185.25.192.150 () {52 vars in 1068 bytes} [Sun Apr 25 21:15:28 2021] GET /forum/discussion/ => generated 27316 bytes in 269 msecs (HTTP/2.0 200) 3 headers in 96 bytes (1 switches on core 0)
[pid: 2933485|app: 0|req: 2466/2466] 90.32.199.138 () {58 vars in 1117 bytes} [Sun Apr 25 21:15:33 2021] POST /connexion => generated 355 bytes in 28 msecs (HTTP/2.0 302) 5 headers in 504 bytes (2 switches on core 0)
[pid: 2933485|app: 0|req: 2467/2467] 90.32.199.138 () {52 vars in 1160 bytes} [Sun Apr 25 21:15:34 2021] GET /forum/aide/autres/5951/fin/etre-ou-ne-pas-etre => generated 35498 bytes in 305 msecs (HTTP/2.0 200) 3 headers in 96 bytes (1 switches on core 0)
[pid: 2933485|app: 0|req: 2468/2468] 185.25.192.150 () {52 vars in 1085 bytes} [Sun Apr 25 21:15:34 2021] GET /forum/discussion/p/8 => generated 22118 bytes in 103 msecs (HTTP/2.0 200) 3 headers in 96 bytes (1 switches on core 0)
[pid: 2933485|app: 0|req: 2469/2469] 66.249.65.39 () {44 vars in 860 bytes} [Sun Apr 25 21:15:35 2021] GET /forum/discussion/p/1+message => generated 14686 bytes in 34 msecs (HTTP/1.1 404) 4 headers in 276 bytes (2 switches on core 0)
[pid: 2933485|app: 0|req: 2470/2470] 185.25.192.150 () {52 vars in 1146 bytes} [Sun Apr 25 21:15:38 2021] GET /forum/discussion/14/1/propositions-d-amelioration => generated 32165 bytes in 269 msecs (HTTP/2.0 200) 3 headers in 96 bytes (1 switches on core 0)
[pid: 2933485|app: 0|req: 2471/2471] 90.32.199.138 () {52 vars in 1078 bytes} [Sun Apr 25 21:15:43 2021] GET /admin => generated 17476 bytes in 64 msecs (HTTP/2.0 200) 3 headers in 96 bytes (1 switches on core 0)
[pid: 2933485|app: 0|req: 2472/2472] 185.25.192.150 () {52 vars in 1088 bytes} [Sun Apr 25 21:15:48 2021] GET /forum/discussion/p/1 => generated 27319 bytes in 311 msecs (HTTP/2.0 200) 3 headers in 96 bytes (1 switches on core 0)
[pid: 2933485|app: 0|req: 2473/2473] 90.32.199.138 () {52 vars in 1053 bytes} [Sun Apr 25 21:16:06 2021] GET /admin/membres => generated 34726 bytes in 177 msecs (HTTP/2.0 200) 3 headers in 96 bytes (2 switches on core 0)
[pid: 2933485|app: 0|req: 2474/2474] 185.25.192.150 () {58 vars in 1200 bytes} [Sun Apr 25 21:16:51 2021] POST /api/markdown => generated 59 bytes in 17 msecs (HTTP/2.0 200) 3 headers in 93 bytes (2 switches on core 0)
[pid: 2933485|app: 0|req: 2475/2475] 185.25.192.150 () {58 vars in 1200 bytes} [Sun Apr 25 21:16:56 2021] POST /api/markdown => generated 59 bytes in 7 msecs (HTTP/2.0 200) 3 headers in 93 bytes (1 switches on core 0)
[pid: 2933485|app: 0|req: 2476/2476] 185.25.192.150 () {58 vars in 1200 bytes} [Sun Apr 25 21:16:56 2021] POST /api/markdown => generated 59 bytes in 11 msecs (HTTP/2.0 200) 3 headers in 93 bytes (1 switches on core 0)
[pid: 2933485|app: 0|req: 2477/2477] 185.25.192.150 () {58 vars in 1200 bytes} [Sun Apr 25 21:16:57 2021] POST /api/markdown => generated 59 bytes in 9 msecs (HTTP/2.0 200) 3 headers in 93 bytes (2 switches on core 0)
[pid: 2933485|app: 0|req: 2478/2478] 185.25.192.150 () {58 vars in 1200 bytes} [Sun Apr 25 21:16:58 2021] POST /api/markdown => generated 59 bytes in 6 msecs (HTTP/2.0 200) 3 headers in 93 bytes (1 switches on core 0)
[pid: 2933485|app: 0|req: 2479/2479] 185.25.192.150 () {58 vars in 1200 bytes} [Sun Apr 25 21:17:17 2021] POST /api/markdown => generated 59 bytes in 9 msecs (HTTP/2.0 200) 3 headers in 93 bytes (2 switches on core 0)
[pid: 2933485|app: 0|req: 2480/2480] 185.25.192.150 () {58 vars in 1200 bytes} [Sun Apr 25 21:17:17 2021] POST /api/markdown => generated 59 bytes in 6 msecs (HTTP/2.0 200) 3 headers in 93 bytes (2 switches on core 0)
[pid: 2933485|app: 0|req: 2481/2481] 185.25.192.150 () {58 vars in 1200 bytes} [Sun Apr 25 21:17:18 2021] POST /api/markdown => generated 59 bytes in 6 msecs (HTTP/2.0 200) 3 headers in 93 bytes (1 switches on core 0)
[pid: 2933485|app: 0|req: 2482/2482] 185.25.192.150 () {58 vars in 1200 bytes} [Sun Apr 25 21:17:19 2021] POST /api/markdown => generated 59 bytes in 9 msecs (HTTP/2.0 200) 3 headers in 93 bytes (1 switches on core 0)
[pid: 2933485|app: 0|req: 2483/2483] 54.36.148.172 () {38 vars in 594 bytes} [Sun Apr 25 21:17:29 2021] GET /post/4492?r=%2Fforum%2Fdiscussion%2F764%2F184%2Ftopic-auto-199 => generated 401 bytes in 4 msecs (HTTP/2.0 302) 5 headers in 440 bytes (2 switches on core 0)
[pid: 2933485|app: 0|req: 2484/2484] 185.25.192.150 () {58 vars in 1200 bytes} [Sun Apr 25 21:18:39 2021] POST /api/markdown => generated 59 bytes in 7 msecs (HTTP/2.0 200) 3 headers in 93 bytes (2 switches on core 0)
[pid: 2933485|app: 0|req: 2485/2485] 185.25.192.150 () {58 vars in 1200 bytes} [Sun Apr 25 21:18:40 2021] POST /api/markdown => generated 59 bytes in 7 msecs (HTTP/2.0 200) 3 headers in 93 bytes (1 switches on core 0)
[pid: 2933485|app: 0|req: 2486/2486] 185.25.192.150 () {58 vars in 1200 bytes} [Sun Apr 25 21:18:40 2021] POST /api/markdown => generated 59 bytes in 7 msecs (HTTP/2.0 200) 3 headers in 93 bytes (1 switches on core 0)
[pid: 2933485|app: 0|req: 2487/2487] 185.25.192.150 () {58 vars in 1200 bytes} [Sun Apr 25 21:18:41 2021] POST /api/markdown => generated 59 bytes in 10 msecs (HTTP/2.0 200) 3 headers in 93 bytes (1 switches on core 0)
[pid: 2933485|app: 0|req: 2488/2488] 90.32.199.138 () {58 vars in 1220 bytes} [Sun Apr 25 21:18:45 2021] POST /api/markdown => generated 0 bytes in 3 msecs (HTTP/2.0 200) 3 headers in 92 bytes (1 switches on core 0)
[pid: 2933485|app: 0|req: 2489/2489] 90.32.199.138 () {58 vars in 1220 bytes} [Sun Apr 25 21:18:48 2021] POST /api/markdown => generated 0 bytes in 3 msecs (HTTP/2.0 200) 3 headers in 92 bytes (2 switches on core 0)
[pid: 2933485|app: 0|req: 2490/2490] 90.32.199.138 () {58 vars in 1220 bytes} [Sun Apr 25 21:18:55 2021] POST /api/markdown => generated 29 bytes in 6 msecs (HTTP/2.0 200) 3 headers in 93 bytes (1 switches on core 0)
[pid: 2933485|app: 0|req: 2491/2491] 185.25.192.150 () {58 vars in 1200 bytes} [Sun Apr 25 21:19:32 2021] POST /api/markdown => generated 59 bytes in 10 msecs (HTTP/2.0 200) 3 headers in 93 bytes (1 switches on core 0)
[pid: 2933485|app: 0|req: 2492/2492] 90.32.199.138 () {44 vars in 665 bytes} [Sun Apr 25 21:19:44 2021] GET /forum/aide/autres/5951/fin/etre-ou-ne-pas-etre => generated 28843 bytes in 283 msecs (HTTP/2.0 200) 4 headers in 269 bytes (2 switches on core 0)
[pid: 2933485|app: 0|req: 2493/2493] 90.32.199.138 () {54 vars in 1191 bytes} [Sun Apr 25 21:19:46 2021] GET /forum/aide/autres/5951/fin/etre-ou-ne-pas-etre => generated 35498 bytes in 352 msecs (HTTP/2.0 200) 3 headers in 96 bytes (2 switches on core 0)
[pid: 2933485|app: 0|req: 2494/2494] 185.25.192.150 () {58 vars in 1200 bytes} [Sun Apr 25 21:20:09 2021] POST /api/markdown => generated 59 bytes in 17 msecs (HTTP/2.0 200) 3 headers in 93 bytes (2 switches on core 0)
[pid: 2933485|app: 0|req: 2495/2495] 185.25.192.150 () {58 vars in 1200 bytes} [Sun Apr 25 21:20:10 2021] POST /api/markdown => generated 59 bytes in 7 msecs (HTTP/2.0 200) 3 headers in 93 bytes (1 switches on core 0)
[pid: 2933485|app: 0|req: 2496/2496] 185.25.192.150 () {58 vars in 1200 bytes} [Sun Apr 25 21:20:11 2021] POST /api/markdown => generated 59 bytes in 7 msecs (HTTP/2.0 200) 3 headers in 93 bytes (1 switches on core 0)
[pid: 2933485|app: 0|req: 2497/2497] 185.25.192.150 () {58 vars in 1200 bytes} [Sun Apr 25 21:20:12 2021] POST /api/markdown => generated 59 bytes in 7 msecs (HTTP/2.0 200) 3 headers in 93 bytes (1 switches on core 0)
[pid: 2933485|app: 0|req: 2498/2498] 185.25.192.150 () {58 vars in 1200 bytes} [Sun Apr 25 21:20:14 2021] POST /api/markdown => generated 59 bytes in 6 msecs (HTTP/2.0 200) 3 headers in 93 bytes (1 switches on core 0)
[pid: 2933485|app: 0|req: 2499/2499] 185.25.192.150 () {58 vars in 1200 bytes} [Sun Apr 25 21:20:16 2021] POST /api/markdown => generated 59 bytes in 7 msecs (HTTP/2.0 200) 3 headers in 93 bytes (1 switches on core 0)
[pid: 2933485|app: 0|req: 2500/2500] 54.36.148.62 () {38 vars in 713 bytes} [Sun Apr 25 21:21:25 2021] GET /post/supprimer/2461?csrf_token=IjM4NWFhYjdlMGViZjg3ZjU3MjUxMzNiYzdiNDc4ZWFiOWU4OWEwNGMi.X6QcQA.sCWAe5zXyxk55TMI9o7DkVXBWCA => generated 505 bytes in 4 msecs (HTTP/2.0 302) 5 headers in 492 bytes (2 switches on core 0)
[pid: 2933485|app: 0|req: 2501/2501] 185.25.192.150 () {52 vars in 1078 bytes} [Sun Apr 25 21:21:41 2021] GET /compte/sondages => generated 17635 bytes in 85 msecs (HTTP/2.0 200) 3 headers in 96 bytes (2 switches on core 0)
[pid: 2933485|app: 0|req: 2502/2502] 54.36.149.79 () {38 vars in 713 bytes} [Sun Apr 25 21:22:11 2021] GET /post/supprimer/5236?csrf_token=ImJkYWQzOTdjZjk5NWMwMGRlN2NiYjg3NGJlNTMwM2ZlNTQ3OWVmYjYi.X6XrxQ.kTHpra8RUqV-seNekD8z9QtFnQI => generated 505 bytes in 7 msecs (HTTP/2.0 302) 5 headers in 492 bytes (2 switches on core 0)
[pid: 2933485|app: 0|req: 2503/2503] 185.25.192.150 () {58 vars in 1232 bytes} [Sun Apr 25 21:22:37 2021] POST /compte/sondages => generated 18845 bytes in 110 msecs (HTTP/2.0 200) 4 headers in 417 bytes (1 switches on core 0)
[pid: 2933485|app: 0|req: 2504/2504] 185.25.192.150 () {58 vars in 1342 bytes} [Sun Apr 25 21:22:43 2021] POST /sondages/17/voter => generated 293 bytes in 14 msecs (HTTP/2.0 302) 5 headers in 548 bytes (1 switches on core 0)
[pid: 2933485|app: 0|req: 2505/2505] 185.25.192.150 () {52 vars in 1148 bytes} [Sun Apr 25 21:22:44 2021] GET /compte/sondages => generated 18745 bytes in 62 msecs (HTTP/2.0 200) 4 headers in 417 bytes (1 switches on core 0)
[pid: 2933485|app: 0|req: 2506/2506] 185.25.192.150 () {52 vars in 1082 bytes} [Sun Apr 25 21:23:15 2021] GET /rechercher?q=sondage => generated 16653 bytes in 68 msecs (HTTP/2.0 200) 3 headers in 96 bytes (2 switches on core 0)
[pid: 2933485|app: 0|req: 2507/2507] 185.25.192.150 () {52 vars in 1155 bytes} [Sun Apr 25 21:23:17 2021] GET /rechercher?q=sondage&date=&submit=Affiner+la+recherche => generated 16653 bytes in 51 msecs (HTTP/2.0 200) 3 headers in 96 bytes (1 switches on core 0)
[pid: 2933485|app: 0|req: 2508/2508] 54.36.148.20 () {38 vars in 711 bytes} [Sun Apr 25 21:23:32 2021] GET /post/supprimer/844?csrf_token=IjIwMTRlOGE4YTZhOThiZWVlZjgxYzNlYTA0MjUyYmU4MDY2OTFlMzki.X4MnDw.N_tpiBOdFEh5drLkOTKUk1HKQGI => generated 503 bytes in 3 msecs (HTTP/2.0 302) 5 headers in 491 bytes (2 switches on core 0)
[pid: 2933485|app: 0|req: 2509/2509] 54.36.148.201 () {38 vars in 714 bytes} [Sun Apr 25 21:23:53 2021] GET /post/supprimer/4952?csrf_token=ImI2YjFkZDA3ZmUyZjNiNjhjNTAwMjZiMzNhZDIyYTMzMjVhMTc5ZWIi.YBIgLQ.3OyTg_ekF9nFzEYetfYhFye3R-k => generated 505 bytes in 3 msecs (HTTP/2.0 302) 5 headers in 492 bytes (2 switches on core 0)
[pid: 2933485|app: 0|req: 2510/2510] 185.25.192.150 () {50 vars in 1044 bytes} [Sun Apr 25 21:23:58 2021] GET /forum/discussion/5923/fin/test => generated 23849 bytes in 248 msecs (HTTP/2.0 200) 3 headers in 96 bytes (2 switches on core 0)
[pid: 2933485|app: 0|req: 2511/2511] 54.36.149.79 () {38 vars in 713 bytes} [Sun Apr 25 21:24:04 2021] GET /post/supprimer/4552?csrf_token=ImRiZjVkMDRmODg5ZjQ0N2U3YjJjZTM0NmZjMmZmNjM4MTUxMzMxNGEi.YAZUMw.9KaD37xt2-8_8fG9ispv_K5Pwrk => generated 505 bytes in 2 msecs (HTTP/2.0 302) 5 headers in 492 bytes (2 switches on core 0)
[pid: 2933485|app: 0|req: 2512/2512] 185.25.192.150 () {52 vars in 1144 bytes} [Sun Apr 25 21:24:05 2021] GET /forum/actus/projets/2/fin/avancees-de-la-v5 => generated 32856 bytes in 257 msecs (HTTP/2.0 200) 3 headers in 96 bytes (1 switches on core 0)
[pid: 2933485|app: 0|req: 2513/2513] 185.25.192.150 () {52 vars in 1153 bytes} [Sun Apr 25 21:24:13 2021] GET /forum/actus/projets/2/6/avancees-de-la-v5 => generated 54090 bytes in 507 msecs (HTTP/2.0 200) 3 headers in 96 bytes (1 switches on core 0)
[pid: 2933485|app: 0|req: 2514/2514] 185.25.192.150 () {52 vars in 1151 bytes} [Sun Apr 25 21:24:39 2021] GET /forum/actus/projets/2/5/avancees-de-la-v5 => generated 52655 bytes in 594 msecs (HTTP/2.0 200) 3 headers in 96 bytes (2 switches on core 0)
[pid: 2933485|app: 0|req: 2515/2515] 185.25.192.150 () {52 vars in 1099 bytes} [Sun Apr 25 21:25:11 2021] GET /compte/sondages => generated 18322 bytes in 77 msecs (HTTP/2.0 200) 3 headers in 96 bytes (1 switches on core 0)
[pid: 2933485|app: 0|req: 2516/2516] 185.25.192.150 () {48 vars in 911 bytes} [Sun Apr 25 21:25:35 2021] GET /favicon.ico => generated 16328 bytes in 81 msecs (HTTP/2.0 404) 3 headers in 103 bytes (1 switches on core 0)
[pid: 2933485|app: 0|req: 2517/2517] 54.36.148.182 () {38 vars in 714 bytes} [Sun Apr 25 21:26:43 2021] GET /post/supprimer/1295?csrf_token=IjhiNjFjNTViMjJjOTEyYWNhMzgxNDI2MWRhZGMwNzVkNDBkNGVkZDIi.YAP0sw.kB5cN6608RZ7elNlZ8-z2o6Zvkg => generated 505 bytes in 6 msecs (HTTP/2.0 302) 5 headers in 492 bytes (2 switches on core 0)
[pid: 2933485|app: 0|req: 2518/2518] 54.36.149.40 () {38 vars in 579 bytes} [Sun Apr 25 21:27:16 2021] GET /post/212?r=%2Fforum%2Fdiscussion%2F80%2F7%2Fstress-test => generated 387 bytes in 2 msecs (HTTP/2.0 302) 5 headers in 433 bytes (1 switches on core 0)
[pid: 2933485|app: 0|req: 2519/2519] 185.25.192.150 () {52 vars in 1088 bytes} [Sun Apr 25 21:27:49 2021] GET /forum/discussion/p/1 => generated 27319 bytes in 409 msecs (HTTP/2.0 200) 3 headers in 96 bytes (2 switches on core 0)
[2021-04-25 21:27:57,011] ERROR in app: Exception on /forum/discussion/p/1 [POST]
Traceback (most recent call last):
  File "/usr/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
    self.dialect.do_execute(
  File "/usr/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute
    cursor.execute(statement, parameters)
psycopg2.errors.StringDataRightTruncation: ERREUR:  valeur trop longue pour le type character varying(32)
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
  File "/usr/lib/python3.9/site-packages/flask/app.py", line 2447, in wsgi_app
    response = self.full_dispatch_request()
  File "/usr/lib/python3.9/site-packages/flask/app.py", line 1952, in full_dispatch_request
    rv = self.handle_user_exception(e)
  File "/usr/lib/python3.9/site-packages/flask/app.py", line 1821, in handle_user_exception
    reraise(exc_type, exc_value, tb)
  File "/usr/lib/python3.9/site-packages/flask/_compat.py", line 39, in reraise
    raise value
  File "/usr/lib/python3.9/site-packages/flask/app.py", line 1950, in full_dispatch_request
    rv = self.dispatch_request()
  File "/usr/lib/python3.9/site-packages/flask/app.py", line 1936, in dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "./app/routes/forum/index.py", line 57, in forum_page
    db.session.commit()
  File "/usr/lib/python3.9/site-packages/sqlalchemy/orm/scoping.py", line 163, in do
    return getattr(self.registry(), name)(*args, **kwargs)
  File "/usr/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1046, in commit
    self.transaction.commit()
  File "/usr/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 504, in commit
    self._prepare_impl()
  File "/usr/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 483, in _prepare_impl
    self.session.flush()
  File "/usr/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2540, in flush
    self._flush(objects)
  File "/usr/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2682, in _flush
    transaction.rollback(_capture_exception=True)
  File "/usr/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
    compat.raise_(
  File "/usr/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
    raise exception
  File "/usr/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2642, in _flush
    flush_context.execute()
  File "/usr/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 419, in execute
    n.execute_aggregate(self, set_)
  File "/usr/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 697, in execute_aggregate
    persistence.save_obj(
  File "/usr/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 239, in save_obj
    _emit_insert_statements(
  File "/usr/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1083, in _emit_insert_statements
    c = cached_connections[connection].execute(statement, multiparams)
  File "/usr/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1011, in execute
    return meth(self, multiparams, params)
  File "/usr/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/usr/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement
    ret = self._execute_context(
  File "/usr/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context
    self._handle_dbapi_exception(
  File "/usr/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception
    util.raise_(
  File "/usr/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
    raise exception
  File "/usr/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
    self.dialect.do_execute(
  File "/usr/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute
    cursor.execute(statement, parameters)
sqlalchemy.exc.DataError: (psycopg2.errors.StringDataRightTruncation) ERREUR:  valeur trop longue pour le type character varying(32)
[SQL: INSERT INTO topic (id, promotion_id, title, forum_id, thread_id, views) VALUES (%(id)s, %(promotion_id)s, %(title)s, %(forum_id)s, %(thread_id)s, %(views)s)]
[parameters: {'id': 5988, 'promotion_id': None, 'title': "P'tits tests parce que c'est sympa les tests xD", 'forum_id': 16, 'thread_id': 239, 'views': 0}]
(Background on this error at: http://sqlalche.me/e/13/9h9h)
[pid: 2933485|app: 0|req: 2520/2520] 185.25.192.150 () {58 vars in 1351 bytes} [Sun Apr 25 21:27:56 2021] POST /forum/discussion/p/1 => generated 290 bytes in 142 msecs (HTTP/2.0 500) 3 headers in 113 bytes (2 switches on core 0)
Sun Apr 25 21:27:57 2021 - SIGPIPE: writing to a closed pipe/socket/fd (probably the client disconnected) on request /favicon.ico (ip 185.25.192.150) !!!
Sun Apr 25 21:27:57 2021 - uwsgi_response_writev_headers_and_body_do(): Broken pipe [core/writer.c line 306] during GET /favicon.ico (185.25.192.150)
OSError: write error
[pid: 2933485|app: 0|req: 2521/2521] 185.25.192.150 () {48 vars in 911 bytes} [Sun Apr 25 21:27:57 2021] GET /favicon.ico => generated 0 bytes in 66 msecs (HTTP/2.0 404) 3 headers in 0 bytes (0 switches on core 0)
[pid: 2933485|app: 0|req: 2522/2522] 54.36.148.152 () {38 vars in 592 bytes} [Sun Apr 25 21:29:32 2021] GET /post/2784?r=%2Fforum%2Fdiscussion%2F764%2F98%2Ftopic-auto-199 => generated 399 bytes in 7 msecs (HTTP/2.0 302) 5 headers in 439 bytes (2 switches on core 0)
[pid: 2933485|app: 0|req: 2523/2523] 54.36.149.84 () {38 vars in 713 bytes} [Sun Apr 25 21:30:47 2021] GET /post/supprimer/4335?csrf_token=ImZhNzMxZjU0OTM4MmMyZTNiMjVkNzlmNWI1N2Q4NDA2Zjg0OGFiZjMi.YA2pWA.th7SZBWF_AJPNcFq1RW4jBmCuLU => generated 505 bytes in 8 msecs (HTTP/2.0 302) 5 headers in 492 bytes (2 switches on core 0)
[pid: 2933485|app: 0|req: 2524/2524] 54.36.149.62 () {38 vars in 593 bytes} [Sun Apr 25 21:33:19 2021] GET /post/5815?r=%2Fforum%2Fdiscussion%2F764%2F250%2Ftopic-auto-199 => generated 401 bytes in 11 msecs (HTTP/2.0 302) 5 headers in 440 bytes (2 switches on core 0)
[pid: 2933485|app: 0|req: 2525/2525] 54.36.148.59 () {38 vars in 713 bytes} [Sun Apr 25 21:33:26 2021] GET /post/supprimer/2379?csrf_token=IjA3OTYyYzM1NDMxNmM5YzA4YTViODNhYmRhYmMzNmJhY2I3MTYxYTAi.X_X0vQ.fzn8RZUE4wU1SHd3mevjyYSV1Do => generated 505 bytes in 3 msecs (HTTP/2.0 302) 5 headers in 492 bytes (2 switches on core 0)
[pid: 2933485|app: 0|req: 2526/2526] 54.36.148.175 () {38 vars in 714 bytes} [Sun Apr 25 21:33:36 2021] GET /post/supprimer/1329?csrf_token=IjUyODRlZmRkNWZmY2MyZjIyNjQzYzhhMjIxZjcyZTAzMjdiNzNiYmUi.X6cTLg.8ydbS_aFc_sVM15PocFZH7NoMGQ => generated 505 bytes in 4 msecs (HTTP/2.0 302) 5 headers in 492 bytes (2 switches on core 0)
[pid: 2933485|app: 0|req: 2527/2527] 78.249.199.38 () {58 vars in 1257 bytes} [Sun Apr 25 21:34:00 2021] GET /forum/aide/autres/5951/fin/etre-ou-ne-pas-etre => generated 28843 bytes in 428 msecs (HTTP/2.0 200) 4 headers in 269 bytes (2 switches on core 0)
[pid: 2933485|app: 0|req: 2528/2528] 54.36.149.71 () {38 vars in 713 bytes} [Sun Apr 25 21:35:13 2021] GET /post/supprimer/4297?csrf_token=ImZhYjY4NzQ0MGYwY2U2MWQzNzJhMzkxZTAxYzVmYTQ3MzM0MTNjZDEi.X6F44g.zLzEOXquRD5vb2uvpi_GbV6_lDM => generated 505 bytes in 3 msecs (HTTP/2.0 302) 5 headers in 492 bytes (2 switches on core 0)

EDIT: Les PJ sont buggés ici aussi.

Les logs extraits par Breizh ``` [pid: 2933485|app: 0|req: 2452/2452] 2a01:cb04:938:d400:b3e5:cf47:49cf:63d4 () {58 vars in 1317 bytes} [Sun Apr 25 21:14:43 2021] GET /forum/ => generated 18524 bytes in 123 msecs (HTTP/2.0 200) 4 headers in 289 bytes (1 switches on core 0) [pid: 2933485|app: 0|req: 2453/2453] 185.25.192.150 () {58 vars in 1373 bytes} [Sun Apr 25 21:14:45 2021] POST /sondages/10/voter => generated 355 bytes in 42 msecs (HTTP/2.0 302) 5 headers in 579 bytes (1 switches on core 0) [pid: 2933485|app: 0|req: 2454/2454] 185.25.192.150 () {52 vars in 1241 bytes} [Sun Apr 25 21:14:45 2021] GET /forum/aide/autres/5951/fin/etre-ou-ne-pas-etre => generated 31098 bytes in 277 msecs (HTTP/2.0 200) 4 headers in 417 bytes (1 switches on core 0) [pid: 2933485|app: 0|req: 2455/2455] 90.32.199.138 () {52 vars in 1143 bytes} [Sun Apr 25 21:14:47 2021] GET /forum/aide/autres/5951/fin/etre-ou-ne-pas-etre => generated 28843 bytes in 194 msecs (HTTP/2.0 200) 4 headers in 269 bytes (2 switches on core 0) [pid: 2933485|app: 0|req: 2456/2456] 185.25.192.150 () {52 vars in 1152 bytes} [Sun Apr 25 21:14:56 2021] GET /forum/projets/outils/5931/fin/tests-xss => generated 22891 bytes in 270 msecs (HTTP/2.0 200) 3 headers in 96 bytes (1 switches on core 0) [pid: 2933485|app: 0|req: 2457/2457] 185.25.192.150 () {50 vars in 1080 bytes} [Sun Apr 25 21:14:57 2021] GET /forum/projets/outils/5931/fin/%22%20onmouseover=%22alert( => generated 16328 bytes in 79 msecs (HTTP/2.0 404) 3 headers in 103 bytes (1 switches on core 0) [pid: 2933485|app: 0|req: 2458/2458] 185.25.192.150 () {50 vars in 1092 bytes} [Sun Apr 25 21:14:57 2021] GET /forum/projets/outils/5931/fin/%22%20onmouseover=%22alert('lol') => generated 16328 bytes in 63 msecs (HTTP/2.0 404) 3 headers in 103 bytes (1 switches on core 0) [pid: 2933485|app: 0|req: 2459/2459] 185.25.192.150 () {50 vars in 1034 bytes} [Sun Apr 25 21:14:57 2021] GET /forum/projets/outils/5931/fin/& => generated 16328 bytes in 57 msecs (HTTP/2.0 404) 3 headers in 103 bytes (1 switches on core 0) [pid: 2933485|app: 0|req: 2460/2460] 90.32.199.138 () {58 vars in 1097 bytes} [Sun Apr 25 21:15:09 2021] POST /connexion => generated 355 bytes in 10 msecs (HTTP/2.0 302) 5 headers in 449 bytes (2 switches on core 0) [pid: 2933485|app: 0|req: 2461/2461] 90.32.199.138 () {52 vars in 1105 bytes} [Sun Apr 25 21:15:09 2021] GET /forum/aide/autres/5951/fin/etre-ou-ne-pas-etre => generated 29248 bytes in 222 msecs (HTTP/2.0 200) 4 headers in 289 bytes (1 switches on core 0) [pid: 2933485|app: 0|req: 2462/2462] 185.25.192.150 () {52 vars in 1091 bytes} [Sun Apr 25 21:15:13 2021] GET /membre/FKite => generated 23525 bytes in 90 msecs (HTTP/2.0 200) 3 headers in 96 bytes (1 switches on core 0) [pid: 2933485|app: 0|req: 2463/2463] 185.25.192.150 () {52 vars in 1052 bytes} [Sun Apr 25 21:15:25 2021] GET /forum/ => generated 20130 bytes in 129 msecs (HTTP/2.0 200) 3 headers in 96 bytes (2 switches on core 0) [pid: 2933485|app: 0|req: 2464/2464] 185.25.192.150 () {52 vars in 1066 bytes} [Sun Apr 25 21:15:28 2021] GET /forum/discussion => generated 297 bytes in 5 msecs (HTTP/2.0 308) 3 headers in 153 bytes (1 switches on core 0) [pid: 2933485|app: 0|req: 2465/2465] 185.25.192.150 () {52 vars in 1068 bytes} [Sun Apr 25 21:15:28 2021] GET /forum/discussion/ => generated 27316 bytes in 269 msecs (HTTP/2.0 200) 3 headers in 96 bytes (1 switches on core 0) [pid: 2933485|app: 0|req: 2466/2466] 90.32.199.138 () {58 vars in 1117 bytes} [Sun Apr 25 21:15:33 2021] POST /connexion => generated 355 bytes in 28 msecs (HTTP/2.0 302) 5 headers in 504 bytes (2 switches on core 0) [pid: 2933485|app: 0|req: 2467/2467] 90.32.199.138 () {52 vars in 1160 bytes} [Sun Apr 25 21:15:34 2021] GET /forum/aide/autres/5951/fin/etre-ou-ne-pas-etre => generated 35498 bytes in 305 msecs (HTTP/2.0 200) 3 headers in 96 bytes (1 switches on core 0) [pid: 2933485|app: 0|req: 2468/2468] 185.25.192.150 () {52 vars in 1085 bytes} [Sun Apr 25 21:15:34 2021] GET /forum/discussion/p/8 => generated 22118 bytes in 103 msecs (HTTP/2.0 200) 3 headers in 96 bytes (1 switches on core 0) [pid: 2933485|app: 0|req: 2469/2469] 66.249.65.39 () {44 vars in 860 bytes} [Sun Apr 25 21:15:35 2021] GET /forum/discussion/p/1+message => generated 14686 bytes in 34 msecs (HTTP/1.1 404) 4 headers in 276 bytes (2 switches on core 0) [pid: 2933485|app: 0|req: 2470/2470] 185.25.192.150 () {52 vars in 1146 bytes} [Sun Apr 25 21:15:38 2021] GET /forum/discussion/14/1/propositions-d-amelioration => generated 32165 bytes in 269 msecs (HTTP/2.0 200) 3 headers in 96 bytes (1 switches on core 0) [pid: 2933485|app: 0|req: 2471/2471] 90.32.199.138 () {52 vars in 1078 bytes} [Sun Apr 25 21:15:43 2021] GET /admin => generated 17476 bytes in 64 msecs (HTTP/2.0 200) 3 headers in 96 bytes (1 switches on core 0) [pid: 2933485|app: 0|req: 2472/2472] 185.25.192.150 () {52 vars in 1088 bytes} [Sun Apr 25 21:15:48 2021] GET /forum/discussion/p/1 => generated 27319 bytes in 311 msecs (HTTP/2.0 200) 3 headers in 96 bytes (1 switches on core 0) [pid: 2933485|app: 0|req: 2473/2473] 90.32.199.138 () {52 vars in 1053 bytes} [Sun Apr 25 21:16:06 2021] GET /admin/membres => generated 34726 bytes in 177 msecs (HTTP/2.0 200) 3 headers in 96 bytes (2 switches on core 0) [pid: 2933485|app: 0|req: 2474/2474] 185.25.192.150 () {58 vars in 1200 bytes} [Sun Apr 25 21:16:51 2021] POST /api/markdown => generated 59 bytes in 17 msecs (HTTP/2.0 200) 3 headers in 93 bytes (2 switches on core 0) [pid: 2933485|app: 0|req: 2475/2475] 185.25.192.150 () {58 vars in 1200 bytes} [Sun Apr 25 21:16:56 2021] POST /api/markdown => generated 59 bytes in 7 msecs (HTTP/2.0 200) 3 headers in 93 bytes (1 switches on core 0) [pid: 2933485|app: 0|req: 2476/2476] 185.25.192.150 () {58 vars in 1200 bytes} [Sun Apr 25 21:16:56 2021] POST /api/markdown => generated 59 bytes in 11 msecs (HTTP/2.0 200) 3 headers in 93 bytes (1 switches on core 0) [pid: 2933485|app: 0|req: 2477/2477] 185.25.192.150 () {58 vars in 1200 bytes} [Sun Apr 25 21:16:57 2021] POST /api/markdown => generated 59 bytes in 9 msecs (HTTP/2.0 200) 3 headers in 93 bytes (2 switches on core 0) [pid: 2933485|app: 0|req: 2478/2478] 185.25.192.150 () {58 vars in 1200 bytes} [Sun Apr 25 21:16:58 2021] POST /api/markdown => generated 59 bytes in 6 msecs (HTTP/2.0 200) 3 headers in 93 bytes (1 switches on core 0) [pid: 2933485|app: 0|req: 2479/2479] 185.25.192.150 () {58 vars in 1200 bytes} [Sun Apr 25 21:17:17 2021] POST /api/markdown => generated 59 bytes in 9 msecs (HTTP/2.0 200) 3 headers in 93 bytes (2 switches on core 0) [pid: 2933485|app: 0|req: 2480/2480] 185.25.192.150 () {58 vars in 1200 bytes} [Sun Apr 25 21:17:17 2021] POST /api/markdown => generated 59 bytes in 6 msecs (HTTP/2.0 200) 3 headers in 93 bytes (2 switches on core 0) [pid: 2933485|app: 0|req: 2481/2481] 185.25.192.150 () {58 vars in 1200 bytes} [Sun Apr 25 21:17:18 2021] POST /api/markdown => generated 59 bytes in 6 msecs (HTTP/2.0 200) 3 headers in 93 bytes (1 switches on core 0) [pid: 2933485|app: 0|req: 2482/2482] 185.25.192.150 () {58 vars in 1200 bytes} [Sun Apr 25 21:17:19 2021] POST /api/markdown => generated 59 bytes in 9 msecs (HTTP/2.0 200) 3 headers in 93 bytes (1 switches on core 0) [pid: 2933485|app: 0|req: 2483/2483] 54.36.148.172 () {38 vars in 594 bytes} [Sun Apr 25 21:17:29 2021] GET /post/4492?r=%2Fforum%2Fdiscussion%2F764%2F184%2Ftopic-auto-199 => generated 401 bytes in 4 msecs (HTTP/2.0 302) 5 headers in 440 bytes (2 switches on core 0) [pid: 2933485|app: 0|req: 2484/2484] 185.25.192.150 () {58 vars in 1200 bytes} [Sun Apr 25 21:18:39 2021] POST /api/markdown => generated 59 bytes in 7 msecs (HTTP/2.0 200) 3 headers in 93 bytes (2 switches on core 0) [pid: 2933485|app: 0|req: 2485/2485] 185.25.192.150 () {58 vars in 1200 bytes} [Sun Apr 25 21:18:40 2021] POST /api/markdown => generated 59 bytes in 7 msecs (HTTP/2.0 200) 3 headers in 93 bytes (1 switches on core 0) [pid: 2933485|app: 0|req: 2486/2486] 185.25.192.150 () {58 vars in 1200 bytes} [Sun Apr 25 21:18:40 2021] POST /api/markdown => generated 59 bytes in 7 msecs (HTTP/2.0 200) 3 headers in 93 bytes (1 switches on core 0) [pid: 2933485|app: 0|req: 2487/2487] 185.25.192.150 () {58 vars in 1200 bytes} [Sun Apr 25 21:18:41 2021] POST /api/markdown => generated 59 bytes in 10 msecs (HTTP/2.0 200) 3 headers in 93 bytes (1 switches on core 0) [pid: 2933485|app: 0|req: 2488/2488] 90.32.199.138 () {58 vars in 1220 bytes} [Sun Apr 25 21:18:45 2021] POST /api/markdown => generated 0 bytes in 3 msecs (HTTP/2.0 200) 3 headers in 92 bytes (1 switches on core 0) [pid: 2933485|app: 0|req: 2489/2489] 90.32.199.138 () {58 vars in 1220 bytes} [Sun Apr 25 21:18:48 2021] POST /api/markdown => generated 0 bytes in 3 msecs (HTTP/2.0 200) 3 headers in 92 bytes (2 switches on core 0) [pid: 2933485|app: 0|req: 2490/2490] 90.32.199.138 () {58 vars in 1220 bytes} [Sun Apr 25 21:18:55 2021] POST /api/markdown => generated 29 bytes in 6 msecs (HTTP/2.0 200) 3 headers in 93 bytes (1 switches on core 0) [pid: 2933485|app: 0|req: 2491/2491] 185.25.192.150 () {58 vars in 1200 bytes} [Sun Apr 25 21:19:32 2021] POST /api/markdown => generated 59 bytes in 10 msecs (HTTP/2.0 200) 3 headers in 93 bytes (1 switches on core 0) [pid: 2933485|app: 0|req: 2492/2492] 90.32.199.138 () {44 vars in 665 bytes} [Sun Apr 25 21:19:44 2021] GET /forum/aide/autres/5951/fin/etre-ou-ne-pas-etre => generated 28843 bytes in 283 msecs (HTTP/2.0 200) 4 headers in 269 bytes (2 switches on core 0) [pid: 2933485|app: 0|req: 2493/2493] 90.32.199.138 () {54 vars in 1191 bytes} [Sun Apr 25 21:19:46 2021] GET /forum/aide/autres/5951/fin/etre-ou-ne-pas-etre => generated 35498 bytes in 352 msecs (HTTP/2.0 200) 3 headers in 96 bytes (2 switches on core 0) [pid: 2933485|app: 0|req: 2494/2494] 185.25.192.150 () {58 vars in 1200 bytes} [Sun Apr 25 21:20:09 2021] POST /api/markdown => generated 59 bytes in 17 msecs (HTTP/2.0 200) 3 headers in 93 bytes (2 switches on core 0) [pid: 2933485|app: 0|req: 2495/2495] 185.25.192.150 () {58 vars in 1200 bytes} [Sun Apr 25 21:20:10 2021] POST /api/markdown => generated 59 bytes in 7 msecs (HTTP/2.0 200) 3 headers in 93 bytes (1 switches on core 0) [pid: 2933485|app: 0|req: 2496/2496] 185.25.192.150 () {58 vars in 1200 bytes} [Sun Apr 25 21:20:11 2021] POST /api/markdown => generated 59 bytes in 7 msecs (HTTP/2.0 200) 3 headers in 93 bytes (1 switches on core 0) [pid: 2933485|app: 0|req: 2497/2497] 185.25.192.150 () {58 vars in 1200 bytes} [Sun Apr 25 21:20:12 2021] POST /api/markdown => generated 59 bytes in 7 msecs (HTTP/2.0 200) 3 headers in 93 bytes (1 switches on core 0) [pid: 2933485|app: 0|req: 2498/2498] 185.25.192.150 () {58 vars in 1200 bytes} [Sun Apr 25 21:20:14 2021] POST /api/markdown => generated 59 bytes in 6 msecs (HTTP/2.0 200) 3 headers in 93 bytes (1 switches on core 0) [pid: 2933485|app: 0|req: 2499/2499] 185.25.192.150 () {58 vars in 1200 bytes} [Sun Apr 25 21:20:16 2021] POST /api/markdown => generated 59 bytes in 7 msecs (HTTP/2.0 200) 3 headers in 93 bytes (1 switches on core 0) [pid: 2933485|app: 0|req: 2500/2500] 54.36.148.62 () {38 vars in 713 bytes} [Sun Apr 25 21:21:25 2021] GET /post/supprimer/2461?csrf_token=IjM4NWFhYjdlMGViZjg3ZjU3MjUxMzNiYzdiNDc4ZWFiOWU4OWEwNGMi.X6QcQA.sCWAe5zXyxk55TMI9o7DkVXBWCA => generated 505 bytes in 4 msecs (HTTP/2.0 302) 5 headers in 492 bytes (2 switches on core 0) [pid: 2933485|app: 0|req: 2501/2501] 185.25.192.150 () {52 vars in 1078 bytes} [Sun Apr 25 21:21:41 2021] GET /compte/sondages => generated 17635 bytes in 85 msecs (HTTP/2.0 200) 3 headers in 96 bytes (2 switches on core 0) [pid: 2933485|app: 0|req: 2502/2502] 54.36.149.79 () {38 vars in 713 bytes} [Sun Apr 25 21:22:11 2021] GET /post/supprimer/5236?csrf_token=ImJkYWQzOTdjZjk5NWMwMGRlN2NiYjg3NGJlNTMwM2ZlNTQ3OWVmYjYi.X6XrxQ.kTHpra8RUqV-seNekD8z9QtFnQI => generated 505 bytes in 7 msecs (HTTP/2.0 302) 5 headers in 492 bytes (2 switches on core 0) [pid: 2933485|app: 0|req: 2503/2503] 185.25.192.150 () {58 vars in 1232 bytes} [Sun Apr 25 21:22:37 2021] POST /compte/sondages => generated 18845 bytes in 110 msecs (HTTP/2.0 200) 4 headers in 417 bytes (1 switches on core 0) [pid: 2933485|app: 0|req: 2504/2504] 185.25.192.150 () {58 vars in 1342 bytes} [Sun Apr 25 21:22:43 2021] POST /sondages/17/voter => generated 293 bytes in 14 msecs (HTTP/2.0 302) 5 headers in 548 bytes (1 switches on core 0) [pid: 2933485|app: 0|req: 2505/2505] 185.25.192.150 () {52 vars in 1148 bytes} [Sun Apr 25 21:22:44 2021] GET /compte/sondages => generated 18745 bytes in 62 msecs (HTTP/2.0 200) 4 headers in 417 bytes (1 switches on core 0) [pid: 2933485|app: 0|req: 2506/2506] 185.25.192.150 () {52 vars in 1082 bytes} [Sun Apr 25 21:23:15 2021] GET /rechercher?q=sondage => generated 16653 bytes in 68 msecs (HTTP/2.0 200) 3 headers in 96 bytes (2 switches on core 0) [pid: 2933485|app: 0|req: 2507/2507] 185.25.192.150 () {52 vars in 1155 bytes} [Sun Apr 25 21:23:17 2021] GET /rechercher?q=sondage&date=&submit=Affiner+la+recherche => generated 16653 bytes in 51 msecs (HTTP/2.0 200) 3 headers in 96 bytes (1 switches on core 0) [pid: 2933485|app: 0|req: 2508/2508] 54.36.148.20 () {38 vars in 711 bytes} [Sun Apr 25 21:23:32 2021] GET /post/supprimer/844?csrf_token=IjIwMTRlOGE4YTZhOThiZWVlZjgxYzNlYTA0MjUyYmU4MDY2OTFlMzki.X4MnDw.N_tpiBOdFEh5drLkOTKUk1HKQGI => generated 503 bytes in 3 msecs (HTTP/2.0 302) 5 headers in 491 bytes (2 switches on core 0) [pid: 2933485|app: 0|req: 2509/2509] 54.36.148.201 () {38 vars in 714 bytes} [Sun Apr 25 21:23:53 2021] GET /post/supprimer/4952?csrf_token=ImI2YjFkZDA3ZmUyZjNiNjhjNTAwMjZiMzNhZDIyYTMzMjVhMTc5ZWIi.YBIgLQ.3OyTg_ekF9nFzEYetfYhFye3R-k => generated 505 bytes in 3 msecs (HTTP/2.0 302) 5 headers in 492 bytes (2 switches on core 0) [pid: 2933485|app: 0|req: 2510/2510] 185.25.192.150 () {50 vars in 1044 bytes} [Sun Apr 25 21:23:58 2021] GET /forum/discussion/5923/fin/test => generated 23849 bytes in 248 msecs (HTTP/2.0 200) 3 headers in 96 bytes (2 switches on core 0) [pid: 2933485|app: 0|req: 2511/2511] 54.36.149.79 () {38 vars in 713 bytes} [Sun Apr 25 21:24:04 2021] GET /post/supprimer/4552?csrf_token=ImRiZjVkMDRmODg5ZjQ0N2U3YjJjZTM0NmZjMmZmNjM4MTUxMzMxNGEi.YAZUMw.9KaD37xt2-8_8fG9ispv_K5Pwrk => generated 505 bytes in 2 msecs (HTTP/2.0 302) 5 headers in 492 bytes (2 switches on core 0) [pid: 2933485|app: 0|req: 2512/2512] 185.25.192.150 () {52 vars in 1144 bytes} [Sun Apr 25 21:24:05 2021] GET /forum/actus/projets/2/fin/avancees-de-la-v5 => generated 32856 bytes in 257 msecs (HTTP/2.0 200) 3 headers in 96 bytes (1 switches on core 0) [pid: 2933485|app: 0|req: 2513/2513] 185.25.192.150 () {52 vars in 1153 bytes} [Sun Apr 25 21:24:13 2021] GET /forum/actus/projets/2/6/avancees-de-la-v5 => generated 54090 bytes in 507 msecs (HTTP/2.0 200) 3 headers in 96 bytes (1 switches on core 0) [pid: 2933485|app: 0|req: 2514/2514] 185.25.192.150 () {52 vars in 1151 bytes} [Sun Apr 25 21:24:39 2021] GET /forum/actus/projets/2/5/avancees-de-la-v5 => generated 52655 bytes in 594 msecs (HTTP/2.0 200) 3 headers in 96 bytes (2 switches on core 0) [pid: 2933485|app: 0|req: 2515/2515] 185.25.192.150 () {52 vars in 1099 bytes} [Sun Apr 25 21:25:11 2021] GET /compte/sondages => generated 18322 bytes in 77 msecs (HTTP/2.0 200) 3 headers in 96 bytes (1 switches on core 0) [pid: 2933485|app: 0|req: 2516/2516] 185.25.192.150 () {48 vars in 911 bytes} [Sun Apr 25 21:25:35 2021] GET /favicon.ico => generated 16328 bytes in 81 msecs (HTTP/2.0 404) 3 headers in 103 bytes (1 switches on core 0) [pid: 2933485|app: 0|req: 2517/2517] 54.36.148.182 () {38 vars in 714 bytes} [Sun Apr 25 21:26:43 2021] GET /post/supprimer/1295?csrf_token=IjhiNjFjNTViMjJjOTEyYWNhMzgxNDI2MWRhZGMwNzVkNDBkNGVkZDIi.YAP0sw.kB5cN6608RZ7elNlZ8-z2o6Zvkg => generated 505 bytes in 6 msecs (HTTP/2.0 302) 5 headers in 492 bytes (2 switches on core 0) [pid: 2933485|app: 0|req: 2518/2518] 54.36.149.40 () {38 vars in 579 bytes} [Sun Apr 25 21:27:16 2021] GET /post/212?r=%2Fforum%2Fdiscussion%2F80%2F7%2Fstress-test => generated 387 bytes in 2 msecs (HTTP/2.0 302) 5 headers in 433 bytes (1 switches on core 0) [pid: 2933485|app: 0|req: 2519/2519] 185.25.192.150 () {52 vars in 1088 bytes} [Sun Apr 25 21:27:49 2021] GET /forum/discussion/p/1 => generated 27319 bytes in 409 msecs (HTTP/2.0 200) 3 headers in 96 bytes (2 switches on core 0) [2021-04-25 21:27:57,011] ERROR in app: Exception on /forum/discussion/p/1 [POST] Traceback (most recent call last): File "/usr/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context self.dialect.do_execute( File "/usr/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute cursor.execute(statement, parameters) psycopg2.errors.StringDataRightTruncation: ERREUR: valeur trop longue pour le type character varying(32) The above exception was the direct cause of the following exception: Traceback (most recent call last): File "/usr/lib/python3.9/site-packages/flask/app.py", line 2447, in wsgi_app response = self.full_dispatch_request() File "/usr/lib/python3.9/site-packages/flask/app.py", line 1952, in full_dispatch_request rv = self.handle_user_exception(e) File "/usr/lib/python3.9/site-packages/flask/app.py", line 1821, in handle_user_exception reraise(exc_type, exc_value, tb) File "/usr/lib/python3.9/site-packages/flask/_compat.py", line 39, in reraise raise value File "/usr/lib/python3.9/site-packages/flask/app.py", line 1950, in full_dispatch_request rv = self.dispatch_request() File "/usr/lib/python3.9/site-packages/flask/app.py", line 1936, in dispatch_request return self.view_functions[rule.endpoint](**req.view_args) File "./app/routes/forum/index.py", line 57, in forum_page db.session.commit() File "/usr/lib/python3.9/site-packages/sqlalchemy/orm/scoping.py", line 163, in do return getattr(self.registry(), name)(*args, **kwargs) File "/usr/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1046, in commit self.transaction.commit() File "/usr/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 504, in commit self._prepare_impl() File "/usr/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 483, in _prepare_impl self.session.flush() File "/usr/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2540, in flush self._flush(objects) File "/usr/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2682, in _flush transaction.rollback(_capture_exception=True) File "/usr/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__ compat.raise_( File "/usr/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 182, in raise_ raise exception File "/usr/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2642, in _flush flush_context.execute() File "/usr/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 419, in execute n.execute_aggregate(self, set_) File "/usr/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 697, in execute_aggregate persistence.save_obj( File "/usr/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 239, in save_obj _emit_insert_statements( File "/usr/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1083, in _emit_insert_statements c = cached_connections[connection].execute(statement, multiparams) File "/usr/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1011, in execute return meth(self, multiparams, params) File "/usr/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/usr/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement ret = self._execute_context( File "/usr/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context self._handle_dbapi_exception( File "/usr/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception util.raise_( File "/usr/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 182, in raise_ raise exception File "/usr/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context self.dialect.do_execute( File "/usr/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.DataError: (psycopg2.errors.StringDataRightTruncation) ERREUR: valeur trop longue pour le type character varying(32) [SQL: INSERT INTO topic (id, promotion_id, title, forum_id, thread_id, views) VALUES (%(id)s, %(promotion_id)s, %(title)s, %(forum_id)s, %(thread_id)s, %(views)s)] [parameters: {'id': 5988, 'promotion_id': None, 'title': "P'tits tests parce que c'est sympa les tests xD", 'forum_id': 16, 'thread_id': 239, 'views': 0}] (Background on this error at: http://sqlalche.me/e/13/9h9h) [pid: 2933485|app: 0|req: 2520/2520] 185.25.192.150 () {58 vars in 1351 bytes} [Sun Apr 25 21:27:56 2021] POST /forum/discussion/p/1 => generated 290 bytes in 142 msecs (HTTP/2.0 500) 3 headers in 113 bytes (2 switches on core 0) Sun Apr 25 21:27:57 2021 - SIGPIPE: writing to a closed pipe/socket/fd (probably the client disconnected) on request /favicon.ico (ip 185.25.192.150) !!! Sun Apr 25 21:27:57 2021 - uwsgi_response_writev_headers_and_body_do(): Broken pipe [core/writer.c line 306] during GET /favicon.ico (185.25.192.150) OSError: write error [pid: 2933485|app: 0|req: 2521/2521] 185.25.192.150 () {48 vars in 911 bytes} [Sun Apr 25 21:27:57 2021] GET /favicon.ico => generated 0 bytes in 66 msecs (HTTP/2.0 404) 3 headers in 0 bytes (0 switches on core 0) [pid: 2933485|app: 0|req: 2522/2522] 54.36.148.152 () {38 vars in 592 bytes} [Sun Apr 25 21:29:32 2021] GET /post/2784?r=%2Fforum%2Fdiscussion%2F764%2F98%2Ftopic-auto-199 => generated 399 bytes in 7 msecs (HTTP/2.0 302) 5 headers in 439 bytes (2 switches on core 0) [pid: 2933485|app: 0|req: 2523/2523] 54.36.149.84 () {38 vars in 713 bytes} [Sun Apr 25 21:30:47 2021] GET /post/supprimer/4335?csrf_token=ImZhNzMxZjU0OTM4MmMyZTNiMjVkNzlmNWI1N2Q4NDA2Zjg0OGFiZjMi.YA2pWA.th7SZBWF_AJPNcFq1RW4jBmCuLU => generated 505 bytes in 8 msecs (HTTP/2.0 302) 5 headers in 492 bytes (2 switches on core 0) [pid: 2933485|app: 0|req: 2524/2524] 54.36.149.62 () {38 vars in 593 bytes} [Sun Apr 25 21:33:19 2021] GET /post/5815?r=%2Fforum%2Fdiscussion%2F764%2F250%2Ftopic-auto-199 => generated 401 bytes in 11 msecs (HTTP/2.0 302) 5 headers in 440 bytes (2 switches on core 0) [pid: 2933485|app: 0|req: 2525/2525] 54.36.148.59 () {38 vars in 713 bytes} [Sun Apr 25 21:33:26 2021] GET /post/supprimer/2379?csrf_token=IjA3OTYyYzM1NDMxNmM5YzA4YTViODNhYmRhYmMzNmJhY2I3MTYxYTAi.X_X0vQ.fzn8RZUE4wU1SHd3mevjyYSV1Do => generated 505 bytes in 3 msecs (HTTP/2.0 302) 5 headers in 492 bytes (2 switches on core 0) [pid: 2933485|app: 0|req: 2526/2526] 54.36.148.175 () {38 vars in 714 bytes} [Sun Apr 25 21:33:36 2021] GET /post/supprimer/1329?csrf_token=IjUyODRlZmRkNWZmY2MyZjIyNjQzYzhhMjIxZjcyZTAzMjdiNzNiYmUi.X6cTLg.8ydbS_aFc_sVM15PocFZH7NoMGQ => generated 505 bytes in 4 msecs (HTTP/2.0 302) 5 headers in 492 bytes (2 switches on core 0) [pid: 2933485|app: 0|req: 2527/2527] 78.249.199.38 () {58 vars in 1257 bytes} [Sun Apr 25 21:34:00 2021] GET /forum/aide/autres/5951/fin/etre-ou-ne-pas-etre => generated 28843 bytes in 428 msecs (HTTP/2.0 200) 4 headers in 269 bytes (2 switches on core 0) [pid: 2933485|app: 0|req: 2528/2528] 54.36.149.71 () {38 vars in 713 bytes} [Sun Apr 25 21:35:13 2021] GET /post/supprimer/4297?csrf_token=ImZhYjY4NzQ0MGYwY2U2MWQzNzJhMzkxZTAxYzVmYTQ3MzM0MTNjZDEi.X6F44g.zLzEOXquRD5vb2uvpi_GbV6_lDM => generated 505 bytes in 3 msecs (HTTP/2.0 302) 5 headers in 492 bytes (2 switches on core 0) ``` EDIT: Les PJ sont buggés ici aussi.

La migration 2a1165f6ad0a_restructure_forum_models.py où j'ai restructuré les modèles du forum donne au champ titre la taille V5Config.THREAD_NAME_MAXLEN qui était initialement définie à 32. J'ai changé ça dans d3f137b9 à 128 après qu'on ait supprimé la variable de configuration.

Le truc c'est que Alembic ne détecte pas les changements de longueur de champs par défaut. D'après la documentation il faut activer compare_type=True pour avoir ce comportement.

J'ai fait ça dans le commit 4be0e1572c qui est accompagné d'une migration avec les changements de longueur en retard, 44c2e37ef899_update_trailing_field_lengths.py.

Une fois migré ça devrait déjà résoudre le problème qui est dans les logs, pour les PJs faut voir avec Darks. La limite est de 5 Mo pour un utilisateur connecté, 500 ko pour un invité.

Pour la toggle preview, elle marche très bien. C'est juste que les formules ne sont pas encore gérées, vu qu'on a pas statué sur la lib à utiliser pour ça. Tu peux déjà tester avec du gras ou de l'italique,

Merci Lephe pour le fix sur les noms de topic.

C'est chelou cette histoire de PJ qui ne passe pas. La 413 c'est Nginx qui refuse, sûrement car la taille max d'une requête est configurée à moins. Je vais regarder de mon coté, mais de mémoire on avait pas trop de problèmes.

C'est corrigé. Ça venait effectivement de Nginx qui par défaut n'accepte que les requêtes de 1 Mo ou moins.

La limite de 5 Mo est maintenant effective pour les membres, mais la dépasser provoquera toujours une erreur 413 de la part de Nginx (c'est normal).

c753b11faf

Faut dire que ce que fait ZdS, même si pas pratique (faut d’abord uploader le fichier dans la galerie, puis l’inclure dans ton post après coup) a un gros avantage : ça permet l’upload spécifiquement de fichiers avec une certaine taille tout en limitant les posts de forum ridiculement énormes (pour limite le DOS, notamment).

Ouaip, à voir mais ça peut être une piste. Enfin ce sera à envisager le jour où on se prendra du DoS dans la figure ^^

Autre avantage : ça permet d'avoir une galerie (comme TI-Planet) où les images peuvent être organisées et conservées, quelque chose qui nous fait défaut, comme les images manquantes sur l'article de Cake qui ont été pointées ce soir le montrent.

Faut dire que ce que fait ZdS, même si pas pratique (faut d’abord uploader le fichier dans la galerie, puis l’inclure dans ton post après coup) a un gros avantage : ça permet l’upload spécifiquement de fichiers avec une certaine taille tout en limitant les posts de forum ridiculement énormes (pour limite le DOS, notamment).

C'est pas con comme méthode, Ce qu'il faudrait c'est pouvoir upload depuis la page de post… mais ça demande un peu de JS pour faire ça sans devoir recharger la page. Et je sait pas si c'est compatible avec l'architecture actuelle.

Je pense que les deux systèmes sont complémentaires (c'est d'ailleurs le fonctionnement de Misskey, j'y reviendrais) : dans le cas où t'as un bug/truc rapide à montrer, tu n'as pas forcément envie d'aller poster les captures dans la gallerie, et de copier coller les liens à la main. Ça marche aussi pour les fichiers (on n'a pas que des images à partager).

Ce que fait Misskey, et que je trouve pas mal, c'est cela :

création d'une galerie de médias pour chaque compte
toute image postée dans un status est ajoutée à la galerie
tu peux ajouter des fichiers manuellement à la galerie
tu peux ajouter des images à un status depuis la galerie (ce qui évite de poster en double une image si tu l'avais déjà uploadée)

Avantage, on peut facilement retrouver un fichier posté. Inconvénient, c'est une gallerie fourre-tout mal organisée.

Reste à savoir ce qu'on implémente, mais ça vaut le coup de faire un autre ticket.

Edit : au passage pour le DoS, ça change pas des masses les choses : le forumulaire d'upload doit rester public pour pouvoir poster des fichiers, un bot qui cherche à taper dessus peut toujours envoyer des requêtes à la con.

Avantage, on peut facilement retrouver un fichier posté. Inconvénient, c'est une gallerie fourre-tout mal organisée.

Ça c'est possible de l'améliorer simplement en ajoutan un concept de «dossiers» dans la gallerie. Et éventuellement des galeries partagés, entre plusieurs auteurs, sur un thème, ou pour un utijlisateur supprimé mais qui veut garder les images (à ctondition de voir les histoires de droits d'auteurs dans le tas)