http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5476 Summary: Harcoded date format en Members.pm -> GetMessages Change sponsored?: --- Product: Koha Version: rel_3_2 Platform: All OS/Version: All Status: NEW Severity: minor Priority: P5 Component: Patrons AssignedTo: kyle.m.hall@gmail.com ReportedBy: jmlongo@uncu.edu.ar QAContact: koha-bugs@lists.koha-community.org CC: gmcharlt@gmail.com Estimated Hours: 0.0 I have came across a problem with the messages system, as it displays the messages for the borrowers with a date format that is not the format chosen for the system in SysPrefs... We use the dd/mm/yyyy date format system wide, and the messages have their dates in the mm/dd/yyyy format. I backtraced the date that is printed with the message and found that this problematic format is harcoded in the GetMessage routine, inside the module Messages.pm, as can be seen in the following chunk of code... my $query = "SELECT branches.branchname, messages.*, DATE_FORMAT( message_date, '%m/%d/%Y' ) AS message_date_formatted, messages.branchcode LIKE '$branchcode' AS can_delete FROM messages, branches WHERE borrowernumber = ? AND message_type LIKE ? AND messages.branchcode = branches.branchcode ORDER BY message_date DESC"; -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug.