View Issue Details

IDProjectCategoryView StatusLast Update
0037375mantisbtsqlpublic2026-09-08 09:03
ReporterBGASNIER Assigned To 
PrioritynormalSeverityminorReproducibilityalways
Status newResolutionopen 
Product Version2.28.3 
Summary0037375: Date format problem when adding a version
Description

When adding a new version or modifying an existing one, the "Sort by date" field is in the wrong format: YYYY-MM-DD HH:hh.
For example, if a new version is added with a date of 08/09/2026, it will be displayed as 0008-09-20 11:13.
How can I change the format of this field to DD-MM-YYYY HH:hh?
If I submit the field as is, without modifying it, I get an SQL error, which is expected:
Database query failed. The error returned by the database was 1: ERROR: value "-61986730140" is out of range for type integer


Original report (French)

Bonjour,
Lorsque l'on souhaite ajouter une nouvelle version ou modifier une version existante le champ "Tri par date" est au mauvais format YYYY-MM-DD HH:hh.
Par exemple si on ajoute une nouvelle version en date du 08/09/2026 il sera affiché 0008-09-20 11:13.
Comment fait-on pour modifier le format de ce champ afin qu'il prenne le format DD-MM-YYYY HH:hh ?
Si on valide en l'état sans modifier le champ on tombe sur une erreur SQL ce qui est logique :
Échec de la requête de base de données. L’erreur renvoyée par la base de données était nº -1 : ERROR: value "-61986730140" is out of range for type integer
CONTEXT: unnamed portal parameter $4 = '...' pour la requête : UPDATE mantis_project_version_table
SET version=$1,
description=$2,
released=$3,
date_order=$4,
obsolete=$5
WHERE id=$6.

TagsNo tags attached.
Attached Files
mantis_bug_versionDate_KO.png (20,842 bytes)   
mantis_bug_versionDate_KO.png (20,842 bytes)   
mantis_bug_versionDate.png (32,631 bytes)   
mantis_bug_versionDate.png (32,631 bytes)   

Activities

dregad

dregad

2026-09-08 07:24

developer   ~0071420

Again, please post in English.

Problem is likely caused by mismatch in date formats. Please read the documentation, in particular the warning box under $g_datetime_picker_format.