View Issue Details

IDProjectCategoryView StatusLast Update
0019611phpList 3 applicationInternationalization (l18n)public19-07-19 16:45
Reporterduncanc Assigned To 
Status resolvedResolutionfixed 
Product Version3.3.6 
Target Version3.3.8Fixed in Version3.3.8 
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.



05-12-18 21:50


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


05-12-18 21:56

administrator   ~0061522

Can't that be resolved by localising Mysql instead?


06-12-18 10:24

updater   ~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.