SQL Error in Custom Date Format

Post here if you have a problem with your account.
Something_Smart
Somewhat_Balanced
 
User avatar
Joined: November 17, 2015
Location: Rochester Institute of Technology
Pronoun: He

Post Post #0  (ISO)  » Wed Mar 07, 2018 5:02 pm

This is a totally inconsequential thing but I figured it'd be better to post it than to not. :P

In the Custom Date Format field (Control Panel -> Board Preferences -> Global Settings), the character limit is 30 characters.

However, if you enter a double quote (") or an ampersand (&), it is counted as more than one character, which causes an SQL error if the total is over 30. Presumably this is because it is converted to " or & before the string is stored.


[ + ]

Return to Help!