Project

General

Profile

Bug #54196

date format invalide envoyée en critère (DataError: date/time field value out of range: "21/05/2021")

Added by Sentry Io over 1 year ago. Updated over 1 year ago.

Status:
Nouveau
Priority:
Normal
Assignee:
-
Target version:
-
Start date:
21 May 2021
Due date:
% Done:

0%

Estimated time:
Patch proposed:
No
Planning:
No

Description

https://sentry.entrouvert.org/entrouvert/publik/issues/46066/

DataError: date/time field value out of range: "21/05/2021" 
LINE 1: ...'3' AND fbo4732c4f2_aac4_483c_9d10_0b5543f08977 = '21/05/202...
                                                             ^
HINT:  Perhaps you need a different "datestyle" setting.

(12 additional frame(s) were not displayed)
...
  File "wcs/forms/backoffice.py", line 57, in listing
    fields, selected_filter, offset, limit, query, order_by, criterias=criterias
  File "wcs/forms/backoffice.py", line 208, in get_listing_items
    selected_filter=selected_filter, query=query, user=user, criterias=criterias, anonymise=anonymise
  File "wcs/forms/backoffice.py", line 166, in get_listing_item_ids
    formdata_class.get_ids_with_indexed_value('status', status_id, **clause_kwargs)
  File "wcs/sql.py", line 472, in f
    return func(*args, **kwargs)
  File "wcs/sql.py", line 2247, in get_ids_with_indexed_value
    cur.execute(sql_statement, parameters)

History

#1

Updated by Frédéric Péters over 1 year ago

Il y a sur la page un critère sur un champ date et <input type=date> donne le format yyyy-mm-dd qui est le bon; mais sur IE11 qui n'a pas de <input type=date> une date dans un mauvais format peut être saisie (sont passés dd/mm/yy et dd/mm/yyyy); il faudrait attraper ça et convertir pour que la requête soit derrière ok.

#4

Updated by Frédéric Péters over 1 year ago

  • Project changed from Suivi des traces to w.c.s.

Also available in: Atom PDF