Jump to content

SQL error log change


Wolfie

Recommended Posts

Posted

Okay this is very minor but I imagine would be a very welcome change. For the file name of the log files, instead of having MM_DD_YY, switch it around to be YYYY_MM_DD. As it is now, since the logs are sorted by name in the ACP when going to view them, you could have logs from January appearing even if you happen to be in February. Additionally, doing a reverse sort would work wonders, so that the logs are shown newest first. The reason for having the year shown in 4-digit format is to reduce confusion over what the number stands for. Granted, it should no longer be mistaken for a month, but someone used to a DD_MM_YY format might think it's the 13th day. Having all digits will make it clear that it's the year and not the day. Yes, they can easily look at the "File Date" but that's only if in the ACP. The filename alone isn't much help to them though.


As is now...

SQL Error Logs
File Name			File Date		File Size
sql_error_log_01_01_13.cgi	Jan 01 2013 06:04 PM	53.93K
sql_error_log_01_03_13.cgi	Jan 03 2013 08:10 AM	7.18K
sql_error_log_01_04_13.cgi	Jan 04 2013 11:18 AM	25.75K
sql_error_log_01_05_13.cgi	Jan 05 2013 08:02 AM	2.99K
sql_error_log_01_06_13.cgi	Jan 06 2013 05:10 AM	17.42K
sql_error_log_11_28_12.cgi	Nov 28 2012 06:50 PM	321.41K
sql_error_log_11_29_12.cgi	Nov 29 2012 06:25 PM	317.17K
sql_error_log_11_30_12.cgi	Nov 30 2012 05:29 PM	472.79K
sql_error_log_12_01_12.cgi	Dec 01 2012 06:53 PM	463.86K
sql_error_log_12_02_12.cgi	Dec 02 2012 06:54 PM	146.86K
sql_error_log_12_03_12.cgi	Dec 03 2012 06:21 PM	102.66K
sql_error_log_12_04_12.cgi	Dec 04 2012 06:59 PM	765.86K
sql_error_log_12_05_12.cgi	Dec 05 2012 06:58 PM	1.03MB


Suggested...
SQL Error Logs
File Name			File Date		File Size
sql_error_log_2013_01_06.cgi	Jan 06 2013 05:10 AM	17.42K
sql_error_log_2013_01_05.cgi	Jan 05 2013 08:02 AM	2.99K
sql_error_log_2013_01_04.cgi	Jan 04 2013 11:18 AM	25.75K
sql_error_log_2013_01_03.cgi	Jan 03 2013 08:10 AM	7.18K
sql_error_log_2013_01_01.cgi	Jan 01 2013 06:04 PM	53.93K
sql_error_log_2012_12_05.cgi	Dec 05 2012 06:58 PM	1.03MB
sql_error_log_2012_12_04.cgi	Dec 04 2012 06:59 PM	765.86K
sql_error_log_2012_12_03.cgi	Dec 03 2012 06:21 PM	102.66K
sql_error_log_2012_12_02.cgi	Dec 02 2012 06:54 PM	146.86K
sql_error_log_2012_12_01.cgi	Dec 01 2012 06:53 PM	463.86K
sql_error_log_2012_11_30.cgi	Nov 30 2012 05:29 PM	472.79K
sql_error_log_2012_11_29.cgi	Nov 29 2012 06:25 PM	317.17K
sql_error_log_2012_11_28.cgi	Nov 28 2012 06:50 PM	321.41K


The other idea I had, which I believe would be extremely overkill and less useful, would be to make the name fields (file name, file date, file size) clickable for sorting, along with the options to sort by numerical date (versus alphanumeric) and asc/desc sorting.

Archived

This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...