File: /var/www/www-root/data/www/www/wwwall-tyresru/bitrix/modules/im/classes/general/im_message.php Line: 517 MySQL Query Error:
SELECT
M.ID,
M.CHAT_ID,
M.MESSAGE,
M.MESSAGE_OUT,
DATE_FORMAT(M.DATE_CREATE, '%d.%m.%Y %H:%i:%s') DATE_CREATE,
M.EMAIL_TEMPLATE,
R.LAST_SEND_ID,
R.USER_ID TO_USER_ID,
U1.ACTIVE TO_USER_ACTIVE,
U1.LOGIN TO_USER_LOGIN,
U1.NAME TO_USER_NAME,
U1.LAST_NAME TO_USER_LAST_NAME,
U1.EMAIL TO_USER_EMAIL,
U1.LID TO_USER_LID,
M.AUTHOR_ID FROM_USER_ID,
U2.LOGIN FROM_USER_LOGIN,
U2.NAME FROM_USER_NAME,
U2.LAST_NAME FROM_USER_LAST_NAME
FROM b_im_relation R
INNER JOIN b_im_message M ON M.ID > R.LAST_ID AND M.ID > R.LAST_SEND_ID AND M.CHAT_ID = R.CHAT_ID AND IMPORT_ID IS NULL AND R.USER_ID != M.AUTHOR_ID
LEFT JOIN b_user U1 ON U1.ID = R.USER_ID
LEFT JOIN b_user U2 ON U2.ID = M.AUTHOR_ID
WHERE R.MESSAGE_TYPE = 'P' AND R.STATUS < 1
[Lost connection to MySQL server during query]