приветствую господа. утром появилась проблема. ряд пользователей заходя на КорПортале в раздел "Задачи" ловит вот такую вот загагулину:
при этом есть пользователи которые вполне себе ходят без ошибок. подскажите пжлст куда копать? в битриксе не силён.
Скрытый текст |
---|
MySQL Query Error: SEL ECT COUNT(T.ID) as C FR OM b_tasks T INNER JOIN (SEL ECT `tasks_internals_task`.`ID` AS `TASK_ID` FR OM `b_tasks` `tasks_internals_task` INNER JOIN `b_tasks_member` `tasks_internals_task_tm` ON `tasks_internals_task`.`ID` = `tasks_internals_task_tm`.`TASK_ID` AND `tasks_internals_task_tm`.`USER_ID` = '183' UNI ON SELECT `tasks_internals_task`.`ID` AS `TASK_ID` FR OM `b_tasks` `tasks_internals_task` WH ERE (`tasks_internals_task`.`GROUP_ID` in (12, 13, 21)) UNION SEL ECT `tasks_internals_task`.`ID` AS `TASK_ID` FR OM `b_tasks` `tasks_internals_task` INNER JOIN `b_tasks_member` `tasks_internals_task_tm` ON `tasks_internals_task`.`ID` = `tasks_internals_task_tm`.`TASK_ID` INNER JOIN `b_intranet_usersubord` `tasks_internals_task_isb` ON `tasks_internals_task_isb`.`DIRECTOR_ID` = '183' AND `tasks_internals_task_isb`.`SUBORDINATE_ID` = `tasks_internals_task_tm`.`USER_ID`) as ACCESS on ACCESS.TASK_ID = T.ID INNER JOIN b_user CU ON CU.ID = T.CREATED_BY INNER JOIN b_user RU ON RU.ID = T.RESPONSIBLE_ID LEFT JOIN b_tasks_viewed TV ON TV.TASK_ID = T.ID AND TV.USER_ID = 183 LEFT JOIN b_tasks_sorting SRT ON SRT.TASK_ID = T.ID and SRT.USER_ID = 183 LEFT JOIN b_tasks_favorite FVT ON FVT.TASK_ID = T.ID and FVT.USER_ID = '183' LEFT JOIN b_forum_topic FT ON FT.ID = T.FORUM_TOPIC_ID LEFT JOIN b_uts_tasks_task BUF ON BUF.VALUE_ID = T.ID WH ERE ((T.RESPONSIBLE_ID = 183) AND ((T.STATUS = '1') OR (T.STATUS = '2') OR (T.STATUS = '3'))) AND T.ZOMBIE = 'N' [Table 'sitemanager0.b_intranet_usersubord' doesn't exist] |