При попытке открыть форум, галерею, добавить инфоблок и прочих операциях вылетает ошибка mySQL.
Например на форуме:
File: /var/www/v-7621/data/www/prohunt.kz/bitrix/modules/forum/classes/general/forum_new.php
Line: 1177
MySQL Query Error: SEL ECT F_FORUM.*, F.FORUM_GROUP_ID, F.NAME, F.DESCRIPTION, F.SORT, F.ACTIVE, F.ALLOW_HTML, F.ALLOW_ANCHOR, F.ALLOW_BIU, F.ALLOW_IMG, F.ALLOW_VIDEO, F.ALLOW_LIST, F.ALLOW_QUOTE, F.ALLOW_CODE, F.ALLOW_FONT, F.ALLOW_SMILES, F.ALLOW_UPLOAD, F.ALLOW_UPLOAD_EXT, F.ALLOW_MOVE_TOPIC, F.ALLOW_NL2BR, F.ALLOW_TABLE, F.ALLOW_TOPIC_TITLED, F.ALLOW_KEEP_AMP, '' as PATH2FORUM_MESSAGE, F.ASK_GUEST_EMAIL, F.USE_CAPTCHA, F.MODERATION, F.INDEXATION, F.ORDER_BY, F.ORDER_DIRECTION, '' as LID, '' as DIR, F.TOPICS, F.POSTS, F.LAST_POSTER_ID, F.LAST_POSTER_NAME, DATE_FORMAT(F.LAST_POST_DATE, '%d.%m.%Y %H:%i:%s') as LAST_POST_DATE, F.LAST_MESSAGE_ID, FM.TOPIC_ID as TID, F.LAST_MESSAGE_ID as MID, F.POSTS_UNAPPROVED, F.ABS_LAST_POSTER_ID, F.ABS_LAST_POSTER_NAME, DATE_FORMAT(F.ABS_LAST_POST_DATE, '%d.%m.%Y %H:%i:%s') as ABS_LAST_POST_DATE, F.ABS_LAST_MESSAGE_ID, FM_ABS.TOPIC_ID as ABS_TID, F.EVENT1, F.EVENT2, F.EVENT3, FT.TITLE, FT_ABS.TITLE as ABS_TITLE, F.HTML, FT.HTML AS TOPIC_HTML, FT_ABS.HTML AS ABS_TOPIC_HTML FR OM ( SEL ECT F.ID , MAX(BFF.TCRENEW) AS TCRENEW FR b_forum F LEFT JOIN ( SELECT BF.ID AS RENEW_FORUM_ID, COUNT(FT_RENEW.ID) TCRENEW FR b_forum BF LEFT JOIN b_forum_user_forum FUF ON (FUF.USER_ID=1546 AND FUF.FORUM_ID = BF.ID) LEFT JOIN b_forum_user_forum FUF_ALL ON (FUF_ALL.USER_ID=1546 AND FUF_ALL.FORUM_ID = 0) LEFT JOIN b_forum_topic FT_RENEW ON (BF.ID = FT_RENEW.FORUM_ID AND FT_RENEW.STATE != 'L' AND (FUF_ALL.LAST_VISIT IS NULL OR FT_RENEW.ABS_LAST_POST_DATE > FUF_ALL.LAST_VISIT)) LEFT JOIN b_forum_user_topic FUT_RENEW ON (FUT_RENEW.FORUM_ID = BF.ID AND FUT_RENEW.TOPIC_ID = FT_RENEW.ID AND FUT_RENEW.USER_ID=1546) WHERE ( FUT_RENEW.LAST_VISIT IS NULL AND ( (FUF_ALL.LAST_VISIT IS NULL AND FUF.LAST_VISIT IS NULL) OR ( FUF.LAST_VISIT IS NOT NULL AND (FUF.LAST_VISIT < FT_RENEW.ABS_LAST_POST_DATE OR FUF.LAST_VISIT < FT_RENEW.LAST_POST_DATE) ) OR ( FUF.LAST_VISIT IS NULL AND FUF_ALL.LAST_VISIT IS NOT NULL AND ( (FUF_ALL.LAST_VISIT < FT_RENEW.ABS_LAST_POST_DATE OR FUF_ALL.LAST_VISIT < FT_RENEW.LAST_POST_DATE) ) ) ) ) OR ( FUT_RENEW.LAST_VISIT IS NOT NULL AND (FUT_RENEW.LAST_VISIT < FT_RENEW.ABS_LAST_POST_DATE OR FUT_RENEW.LAST_VISIT < FT_RENEW.LAST_POST_DATE) ) GROUP BY BF.ID ) BFF ON (BFF.RENEW_FORUM_ID = F.ID) WH (1=1 ) GROUP BY F.ID ) F_FORUM INNER JOIN b_forum F ON (F_FORUM.ID = F.ID) LEFT JOIN b_forum_group FG ON F.FORUM_GROUP_ID = FG.ID LEFT JOIN b_forum_message FM ON F.LAST_MESSAGE_ID = FM.ID LEFT JOIN b_forum_topic FT ON FM.TOPIC_ID = FT.ID LEFT JOIN b_forum_message FM_ABS ON F.ABS_LAST_MESSAGE_ID = FM_ABS.ID LEFT JOIN b_forum_topic FT_ABS ON FM_ABS.TOPIC_ID = FT_ABS.ID ORDER BY FG.SORT ASC, F.FORUM_GROUP_ID ASC, F.SORT ASC, F.NAME ASC[Unknown column 'F.ALLOW_TABLE' in 'field list']
DB query error.
Please try later
Базу не трогали, поля вроде какие-то незнакомые совсем.
база тестируется и просматривается нормально.
В чем может быть проблема? Все-таки глюк базы или mySQL на сервере? Хостеры открещиваются, говорят, раз выдает ошибку в базе, разбирайтесь с базой.
Заранее спасибо за помощь.
Например на форуме:
File: /var/www/v-7621/data/www/prohunt.kz/bitrix/modules/forum/classes/general/forum_new.php
Line: 1177
MySQL Query Error: SEL ECT F_FORUM.*, F.FORUM_GROUP_ID, F.NAME, F.DESCRIPTION, F.SORT, F.ACTIVE, F.ALLOW_HTML, F.ALLOW_ANCHOR, F.ALLOW_BIU, F.ALLOW_IMG, F.ALLOW_VIDEO, F.ALLOW_LIST, F.ALLOW_QUOTE, F.ALLOW_CODE, F.ALLOW_FONT, F.ALLOW_SMILES, F.ALLOW_UPLOAD, F.ALLOW_UPLOAD_EXT, F.ALLOW_MOVE_TOPIC, F.ALLOW_NL2BR, F.ALLOW_TABLE, F.ALLOW_TOPIC_TITLED, F.ALLOW_KEEP_AMP, '' as PATH2FORUM_MESSAGE, F.ASK_GUEST_EMAIL, F.USE_CAPTCHA, F.MODERATION, F.INDEXATION, F.ORDER_BY, F.ORDER_DIRECTION, '' as LID, '' as DIR, F.TOPICS, F.POSTS, F.LAST_POSTER_ID, F.LAST_POSTER_NAME, DATE_FORMAT(F.LAST_POST_DATE, '%d.%m.%Y %H:%i:%s') as LAST_POST_DATE, F.LAST_MESSAGE_ID, FM.TOPIC_ID as TID, F.LAST_MESSAGE_ID as MID, F.POSTS_UNAPPROVED, F.ABS_LAST_POSTER_ID, F.ABS_LAST_POSTER_NAME, DATE_FORMAT(F.ABS_LAST_POST_DATE, '%d.%m.%Y %H:%i:%s') as ABS_LAST_POST_DATE, F.ABS_LAST_MESSAGE_ID, FM_ABS.TOPIC_ID as ABS_TID, F.EVENT1, F.EVENT2, F.EVENT3, FT.TITLE, FT_ABS.TITLE as ABS_TITLE, F.HTML, FT.HTML AS TOPIC_HTML, FT_ABS.HTML AS ABS_TOPIC_HTML FR OM ( SEL ECT F.ID , MAX(BFF.TCRENEW) AS TCRENEW FR b_forum F LEFT JOIN ( SELECT BF.ID AS RENEW_FORUM_ID, COUNT(FT_RENEW.ID) TCRENEW FR b_forum BF LEFT JOIN b_forum_user_forum FUF ON (FUF.USER_ID=1546 AND FUF.FORUM_ID = BF.ID) LEFT JOIN b_forum_user_forum FUF_ALL ON (FUF_ALL.USER_ID=1546 AND FUF_ALL.FORUM_ID = 0) LEFT JOIN b_forum_topic FT_RENEW ON (BF.ID = FT_RENEW.FORUM_ID AND FT_RENEW.STATE != 'L' AND (FUF_ALL.LAST_VISIT IS NULL OR FT_RENEW.ABS_LAST_POST_DATE > FUF_ALL.LAST_VISIT)) LEFT JOIN b_forum_user_topic FUT_RENEW ON (FUT_RENEW.FORUM_ID = BF.ID AND FUT_RENEW.TOPIC_ID = FT_RENEW.ID AND FUT_RENEW.USER_ID=1546) WHERE ( FUT_RENEW.LAST_VISIT IS NULL AND ( (FUF_ALL.LAST_VISIT IS NULL AND FUF.LAST_VISIT IS NULL) OR ( FUF.LAST_VISIT IS NOT NULL AND (FUF.LAST_VISIT < FT_RENEW.ABS_LAST_POST_DATE OR FUF.LAST_VISIT < FT_RENEW.LAST_POST_DATE) ) OR ( FUF.LAST_VISIT IS NULL AND FUF_ALL.LAST_VISIT IS NOT NULL AND ( (FUF_ALL.LAST_VISIT < FT_RENEW.ABS_LAST_POST_DATE OR FUF_ALL.LAST_VISIT < FT_RENEW.LAST_POST_DATE) ) ) ) ) OR ( FUT_RENEW.LAST_VISIT IS NOT NULL AND (FUT_RENEW.LAST_VISIT < FT_RENEW.ABS_LAST_POST_DATE OR FUT_RENEW.LAST_VISIT < FT_RENEW.LAST_POST_DATE) ) GROUP BY BF.ID ) BFF ON (BFF.RENEW_FORUM_ID = F.ID) WH (1=1 ) GROUP BY F.ID ) F_FORUM INNER JOIN b_forum F ON (F_FORUM.ID = F.ID) LEFT JOIN b_forum_group FG ON F.FORUM_GROUP_ID = FG.ID LEFT JOIN b_forum_message FM ON F.LAST_MESSAGE_ID = FM.ID LEFT JOIN b_forum_topic FT ON FM.TOPIC_ID = FT.ID LEFT JOIN b_forum_message FM_ABS ON F.ABS_LAST_MESSAGE_ID = FM_ABS.ID LEFT JOIN b_forum_topic FT_ABS ON FM_ABS.TOPIC_ID = FT_ABS.ID ORDER BY FG.SORT ASC, F.FORUM_GROUP_ID ASC, F.SORT ASC, F.NAME ASC[Unknown column 'F.ALLOW_TABLE' in 'field list']
DB query error.
Please try later
Базу не трогали, поля вроде какие-то незнакомые совсем.
база тестируется и просматривается нормально.
В чем может быть проблема? Все-таки глюк базы или mySQL на сервере? Хостеры открещиваются, говорят, раз выдает ошибку в базе, разбирайтесь с базой.
Заранее спасибо за помощь.