MySQL Query Error: SELECT FS.ID, FS.USER_ID, FS.FORUM_ID, FS.TOPIC_ID, FS.LAST_SEND, FS.NEW_TOPIC_ONLY, FS.SITE_ID, DATE_FORMAT(FS.START_DATE, '%d.%m.%Y %H:%i:%s') as START_DATE, U.EMAIL, U.LOGIN, U.NAME, U.LAST_NAME, FT.TITLE, F.NAME AS FORUM_NAME, FU.SUBSC_GROUP_MESSAGE, FU.SUBSC_GET_MY_MESSAGE FR OM b_forum_subscribe FS INNER JOIN b_user U ON (FS.USER_ID = U.ID) LEFT JOIN b_forum_topic FT ON (FS.TOPIC_ID = FT.ID) LEFT JOIN b_forum F ON (FS.FORUM_ID = F.ID) LEFT JOIN b_forum_user FU ON (U.ID = FU.USER_ID) LEFT JOIN b_user_group UG ON (U.ID = UG.USER_ID) LEFT JOIN b_forum_perms FP ON (FP.FORUM_ID = FS.FORUM_ID AND FP.GROUP_ID=UG.GROUP_ID) LEFT JOIN b_forum_perms FP1 ON (FP1.FORUM_ID = FS.FORUM_ID AND FP1.GROUP_ID=2) WHERE 1 = 1 AND ((FS.FORUM_ID = 2 )) AND ((FS.TOPIC_ID = 10 OR FS.TOPIC_ID = 0 OR FS.TOPIC_ID IS NULL)) AND ((U.ACTIVE = 'Y' )) AND (( (FP.PERMISSION >= 'E') OR (FP1.PERMISSION >= 'E') OR ((FP.ID IS NULL) AND (UG.GROUP_ID = 1)))) AND ((FS.LAST_SEND IS NULL OR FS.LAST_SEND = 0 OR FS.LAST_SEND < 19)) AND (FS.SOCNET_GROUP_ID IS NULL) GROUP BY FS.ID, FS.USER_ID, FS.FORUM_ID, FS.TOPIC_ID, FS.LAST_SEND, FS.NEW_TOPIC_ONLY, FS.SITE_ID, DATE_FORMAT(FS.START_DATE, '%d.%m.%Y %H:%i:%s'), U.EMAIL, U.LOGIN, U.NAME, U.LAST_NAME, FT.TITLE, F.NAME, FU.SUBSC_GROUP_MESSAGE, FU.SUBSC_GET_MY_MESSAGE ORDER BY FS.USER_ID ASC[Unknown column 'FS.SOCNET_GROUP_ID' in 'wh ere clause'] |
При этом в журнале проверки есть список запросов для ручного исправления.