File: C:\inetpub\wwwroot\cdo.iro23.ru\bitrix\modules\im\classes\general\im_notify.php
Line: 203
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.NOTIFY_TYPE,
M.NOTIFY_MODULE,
M.NOTIFY_EVENT,
M.NOTIFY_TITLE,
M.NOTIFY_BUTTONS,
M.NOTIFY_TAG,
M.NOTIFY_SUB_TAG,
M.EMAIL_TEMPLATE,
R.LAST_SEND_ID,
R.USER_ID TO_USER_ID,
U1.LOGIN TO_USER_LOGIN,
U1.NAME TO_USER_NAME,
U1.LAST_NAME TO_USER_LAST_NAME,
U1.SECOND_NAME TO_USER_SECOND_NAME,
U1.EMAIL TO_USER_EMAIL,
U1.ACTIVE TO_USER_ACTIVE,
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,
U2.SECOND_NAME FROM_USER_SECOND_NAME
FROM b_im_relation R
INNER JOIN b_im_message M ON M.NOTIFY_READ = 'N' AND M.ID > R.LAST_SEND_ID AND M.CHAT_ID = R.CHAT_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 = 'S' AND R.STATUS < 1
ORDER BY DATE_CREATE DESC, ID DESC
[Got error 28 from storage engine]
DB query error.
Please try later.
|
|