View Issue Details

IDProjectCategoryView StatusLast Update
0019611phpList 3 applicationInternationalization (l18n)public06-12-18 10:24
Reporterduncanc 
PrioritynormalSeverityminorReproducibilitysometimes
Status newResolutionopen 
Product Version3.3.6 
Target VersionFixed in Version 
Summary0019611: Some dates always have the month in English
DescriptionOn some pages dates are formatted within a mysql query instead of phplist, which means the month name is in English instead of the admin's selected language. For example the uclicks page has the month of first click translated but the month of the latest click is in English, see screenshot.

I think that most of the problem areas can be found by grep'ing for "DATE_FORMAT(", the mysql function to format a date. Then review those and where possible move the date formatting to php code using the functions formatDate() or formatDateTime();
TagsNo tags attached.

Activities

duncanc

05-12-18 21:50

developer  

date_format.png (14,783 bytes)
date_format.png (14,783 bytes)

michiel

05-12-18 21:56

manager   ~0061522

Can't that be resolved by localising Mysql instead?

duncanc

06-12-18 10:24

developer   ~0061530

From what I can see most dates are formatted with php, it is only a few cases, such as the page I mentioned, that format some dates through mysql.