@@ -1086,8 +1086,8 @@ |
||
1086 | 1086 | Database::prepare( |
1087 | 1087 | "REPLACE INTO `##message` (message_id, sender, ip_address, user_id, subject, body, created)" . |
1088 | 1088 | " SELECT m_id, m_from, '127.0.0.1', user_id, m_subject, m_body, (CASE " . |
1089 | - " WHEN CHAR_LENGTH(m_created) = 20 THEN STR_TO_DATE(m_created, '%M %d %Y %H:%i:%s') ". |
|
1090 | - " WHEN CHAR_LENGTH(m_created) = 0 THEN NULL ". |
|
1089 | + " WHEN CHAR_LENGTH(m_created) = 20 THEN STR_TO_DATE(m_created, '%M %d %Y %H:%i:%s') " . |
|
1090 | + " WHEN CHAR_LENGTH(m_created) = 0 THEN NULL " . |
|
1091 | 1091 | " ELSE STR_TO_DATE(LEFT(m_created,25),'%a, %d %M %Y %H:%i:%s')" . |
1092 | 1092 | " END)" . |
1093 | 1093 | " FROM `{$DBNAME}`.`{$TBLPREFIX}messages`" . |