Добрый день ув. форумчане! Помогите пожалуйста, вот такая вот ошибка.
Class: CUser
File: /home/bitrix/www/bitrix/modules/main/classes/mysql/user.php
Function: GetList
Line: 533
MySQL Query Error: SELECT DISTINCT U.*, DATE_FORMAT(DATE_ADD(U.TIMESTAMP_X, INTERVAL -7200 SECOND), '%d.%m.%Y %H:%i:%s') TIMESTAMP_X, IF(U.LAST_ACTIVITY_DATE > DATE_SUB(NOW(), INTERVAL 120 SECOND), 'Y', 'N') IS_ONLINE, DATE_FORMAT(DATE_ADD(U.DATE_REGISTER, INTERVAL -7200 SECOND), '%d.%m.%Y %H:%i:%s') DATE_REGISTER, DATE_FORMAT(DATE_ADD(U.LAST_LOGIN, INTERVAL -7200 SECOND), '%d.%m.%Y %H:%i:%s') LAST_LOGIN, DATE_FORMAT(U.PERSONAL_BIRTHDAY, '%d.%m.%Y') PERSONAL_BIRTHDAY , BUF.UF_DEPARTMENT, BUF.UF_PHONE_INNER, BUF.UF_1C, BUF.UF_INN, BUF.UF_DISTRICT, BUF.UF_SKYPE, BUF.UF_TWITTER, BUF.UF_FACEBOOK, BUF.UF_LINKEDIN, BUF.UF_XING, BUF.UF_WEB_SITES, BUF.UF_SKILLS, BUF.UF_INTERESTS, IF(EXTRACT(HOUR_SECOND FROM BUF.UF_BXDAVEX_CALSYNC)>0, DATE_FORMAT(DATE_ADD(BUF.UF_BXDAVEX_CALSYNC, INTERVAL -7200 SECOND), '%d.%m.%Y %H:%i:%s'), DATE_FORMAT(BUF.UF_BXDAVEX_CALSYNC, '%d.%m.%Y')) UF_BXDAVEX_CALSYNC, BUF.UF_PUBLIC, BUF.UF_WORK_BINDING, BUF.UF_IM_SEARCH, BUF.UF_TIMEMAN, BUF.UF_TM_MAX_START, BUF.UF_TM_MIN_FINISH, BUF.UF_TM_MIN_DURATION, BUF.UF_TM_REPORT_REQ, BUF.UF_TM_REPORT_TPL, BUF.UF_TM_FREE, BUF.UF_TM_TIME, BUF.UF_TM_DAY, BUF.UF_TM_REPORT_DATE, BUF.UF_REPORT_PERIOD, BUF.UF_DELAY_TIME, BUF.UF_LAST_REPORT_DATE, BUF.UF_SETTING_DATE, BUF.UF_TM_ALLOWED_DELTA FROM b_user U INNER JOIN b_utm_user BUF1 ON BUF1.FIELD_ID = 41 AND BUF1.VALUE_ID = U.ID LEFT JOIN b_uts_user BUF ON BUF.VALUE_ID = U.ID WHERE (1=1 AND ( U.ACTIVE='Y' ) AND ( (BUF1.VALUE_INT IS NOT NULL AND BUF1.VALUE_INT <> 0) ) ) ORDER BY IF(ISNULL(PERSONAL_BIRTHDAY), '9999-99-99', IF ( DATE_FORMAT(U.PERSONAL_BIRTHDAY, '2014-%m-%d') < DATE_FORMAT(CURDATE(), '%Y-%m-%d'), DATE_FORMAT(U.PERSONAL_BIRTHDAY, '2015-%m-%d'), DATE_FORMAT(U.PERSONAL_BIRTHDAY, '2014-%m-%d') )) asc LIMIT 5[Got error 28 from storage engine]
Class: CUser
File: /home/bitrix/www/bitrix/modules/main/classes/mysql/user.php
Function: GetList
Line: 533
MySQL Query Error: SELECT DISTINCT U.*, DATE_FORMAT(DATE_ADD(U.TIMESTAMP_X, INTERVAL -7200 SECOND), '%d.%m.%Y %H:%i:%s') TIMESTAMP_X, IF(U.LAST_ACTIVITY_DATE > DATE_SUB(NOW(), INTERVAL 120 SECOND), 'Y', 'N') IS_ONLINE, DATE_FORMAT(DATE_ADD(U.DATE_REGISTER, INTERVAL -7200 SECOND), '%d.%m.%Y %H:%i:%s') DATE_REGISTER, DATE_FORMAT(DATE_ADD(U.LAST_LOGIN, INTERVAL -7200 SECOND), '%d.%m.%Y %H:%i:%s') LAST_LOGIN, DATE_FORMAT(U.PERSONAL_BIRTHDAY, '%d.%m.%Y') PERSONAL_BIRTHDAY , BUF.UF_DEPARTMENT, BUF.UF_PHONE_INNER, BUF.UF_1C, BUF.UF_INN, BUF.UF_DISTRICT, BUF.UF_SKYPE, BUF.UF_TWITTER, BUF.UF_FACEBOOK, BUF.UF_LINKEDIN, BUF.UF_XING, BUF.UF_WEB_SITES, BUF.UF_SKILLS, BUF.UF_INTERESTS, IF(EXTRACT(HOUR_SECOND FROM BUF.UF_BXDAVEX_CALSYNC)>0, DATE_FORMAT(DATE_ADD(BUF.UF_BXDAVEX_CALSYNC, INTERVAL -7200 SECOND), '%d.%m.%Y %H:%i:%s'), DATE_FORMAT(BUF.UF_BXDAVEX_CALSYNC, '%d.%m.%Y')) UF_BXDAVEX_CALSYNC, BUF.UF_PUBLIC, BUF.UF_WORK_BINDING, BUF.UF_IM_SEARCH, BUF.UF_TIMEMAN, BUF.UF_TM_MAX_START, BUF.UF_TM_MIN_FINISH, BUF.UF_TM_MIN_DURATION, BUF.UF_TM_REPORT_REQ, BUF.UF_TM_REPORT_TPL, BUF.UF_TM_FREE, BUF.UF_TM_TIME, BUF.UF_TM_DAY, BUF.UF_TM_REPORT_DATE, BUF.UF_REPORT_PERIOD, BUF.UF_DELAY_TIME, BUF.UF_LAST_REPORT_DATE, BUF.UF_SETTING_DATE, BUF.UF_TM_ALLOWED_DELTA FROM b_user U INNER JOIN b_utm_user BUF1 ON BUF1.FIELD_ID = 41 AND BUF1.VALUE_ID = U.ID LEFT JOIN b_uts_user BUF ON BUF.VALUE_ID = U.ID WHERE (1=1 AND ( U.ACTIVE='Y' ) AND ( (BUF1.VALUE_INT IS NOT NULL AND BUF1.VALUE_INT <> 0) ) ) ORDER BY IF(ISNULL(PERSONAL_BIRTHDAY), '9999-99-99', IF ( DATE_FORMAT(U.PERSONAL_BIRTHDAY, '2014-%m-%d') < DATE_FORMAT(CURDATE(), '%Y-%m-%d'), DATE_FORMAT(U.PERSONAL_BIRTHDAY, '2015-%m-%d'), DATE_FORMAT(U.PERSONAL_BIRTHDAY, '2014-%m-%d') )) asc LIMIT 5[Got error 28 from storage engine]