Добрый день, при выгрузке на сайт 1с стал выдавать ошибку, причём днём ранее выгрузка проходила нормально, никаких изменений на сайте и в 1с не было, Mysql сервер перезапускали, тех поддерка хостинга сказала что с их стороны все нормально.Так же при авторизации на сайте под админом появляется ошибка в пользовательской части сайта. Подскажите пожалуйста в чём может быть дело?
Ошибка в пользовательской части сайта при авторизации админа:
File: /home/t/tdczar/tdczar.tmweb.ru/public_html/bitrix/modules/catalog/mysql/product.php
Line: 424
MySQL Query Error: SEL ECT CAT_CG.ID, CAT_CGL.NAME as CATALOG_GROUP_NAME, IF(CAT_CGG.ID IS NULL, 'N', 'Y') as CATALOG_CAN_ACCESS, IF(CAT_CGG1.ID IS NULL, 'N', 'Y') as CATALOG_CAN_BUY FR OM b_catalog_group CAT_CG LEFT JOIN b_catalog_group2group CAT_CGG ON (CAT_CG.ID = CAT_CGG.CATALOG_GROUP_ID AND CAT_CGG.GROUP_ID IN (,1,2,8,12,13,14) AND CAT_CGG.BUY <> 'Y') LEFT JOIN b_catalog_group2group CAT_CGG1 ON (CAT_CG.ID = CAT_CGG1.CATALOG_GROUP_ID AND CAT_CGG1.GROUP_ID IN (,1,2,8,12,13,14) AND CAT_CGG1.BUY = 'Y') LEFT JOIN b_catalog_group_lang CAT_CGL ON (CAT_CG.ID = CAT_CGL.CATALOG_GROUP_ID AND CAT_CGL.LANG = 'ru') WH ERE CAT_CG.ID IN (16) GROUP BY CAT_CG.ID [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1,2,8,12,13,14) AND CAT_CGG.BUY <> 'Y') LEFT JOIN b_catalog_group2group CAT_CGG' at line 1]
Сама ошибка в 1с при выгрузке:
Интерактивный обмен06.04.2016 15:33:12 Запуск выгрузки товаров
06.04.2016 16:13:52 Завершено формирование файлов выгрузки товаров
Выгружено товаров: 10 272
предложений: 13 350
картинок: 12 498
файлов: 13
В том числе для каталога Основной каталог товаров:
товаров: 10 272
предложений: 13 350
картинок: 12 498
файлов: 13
06.04.2016 16:48:04 Выгрузка на сайт завершилась с ошибками.
import.xml: 5 Произошла ошибка на стороне сервера. Получен неизвестный статус импорта.
Ответ сервера:
File: /home/t/tdczar/tdczar.tmweb.ru/public_html/bitrix/modules/catalog/mysql/cataloggroup.php<br>Line: 384<br><font color=#ff0000>MySQL Query Error: SEL ECT CG.ID as ID, CG.NAME as NAME, CG.BASE as BASE, CG.SORT as SORT, CGL.NAME as NAME_LANG, IF(CGG.ID IS NULL, 'N', 'Y') as CAN_ACCESS, IF(CGG1.ID IS NULL, 'N', 'Y') as CAN_BUY, CG.XML_ID as XML_ID, CG.MODIFIED_BY as MODIFIED_BY, CG.CREATED_BY as CREATED_BY, DATE_FORMAT(CG.DATE_CREATE, '%d.%m.%Y %H:%i:%s') as DATE_CREATE, DATE_FORMAT(CG.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X, COUNT( CG.ID) as CNT FR OM b_catalog_group CG LEFT JOIN b_catalog_group_lang CGL ON (CG.ID = CGL.CATALOG_GROUP_ID AND CGL.LANG = 'ru') LEFT JOIN b_catalog_group2group CGG ON (CG.ID = CGG.CATALOG_GROUP_ID AND CGG.GROUP_ID IN (,1,2,8,12,13,14) AND CGG.BUY <> 'Y') LEFT JOIN b_catalog_group2group CGG1 ON (CG.ID = CGG1.CATALOG_GROUP_ID AND CGG1.GROUP_ID IN (,1,2,8,12,13,14) AND CGG1.BUY = 'Y') GROUP BY CG.ID, CG.NAME, CG.BASE, CG.SORT, CG.XML_ID, CG.MODIFIED_BY, CG.CREATED_BY, CG.DATE_CREATE, CG.TIMESTAMP_X, CGL.NAME</font>[You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1,2,8,12,13,14) AND CGG.BUY <> 'Y') LEFT JOIN b_catalog_group2group CGG1 ON (CG.' at line 1]<br><br>
<table cellpadding="1" cellspacing="0" width="35%" bgcolor="#9C9A9C">
<tr>
<td><table cellpadding="5" cellspacing="0" width="100%">
<tr>
<td bgcolor="#FFFFFF" align="center">
<FONT face="Verdana, Arial, Helvetica, sans-serif" size="-1">
<font color="#FF0000"><b>DB query error.</b></font><br>
Please try later.
</font><br>
</form>
<form method="post" action="/bitrix/admin/site_checker.php?tabControl_active_tab=edit5#edit5">
<input type="hidden" name="last_error_query" value="File: /home/t/tdczar/tdczar.tmweb.ru/public_html/bitrix/modules/main/include/dbquery_error.php
[File: /home/t/tdczar/tdczar.tmweb.ru/public_html/bitrix/modules/catalog/mysql/cataloggroup.php
Line: 384]
Query: SELECT CG.ID as ID, CG.NAME as NAME, CG.BASE as BASE, CG.SORT as SORT, CGL.NAME as NAME_LANG, IF(CGG.ID IS NULL, 'N', 'Y') as CAN_ACCESS, IF(CGG1.ID IS NULL, 'N', 'Y') as CAN_BUY, CG.XML_ID as XML_ID, CG.MODIFIED_BY as MODIFIED_BY, CG.CREATED_BY as CREATED_BY, DATE_FORMAT(CG.DATE_CREATE, '%d.%m.%Y %H:%i:%s') as DATE_CREATE, DATE_FORMAT(CG.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X, COUNT( CG.ID) as CNT FR OM b_catalog_group CG LEFT JOIN b_catalog_group_lang CGL ON (CG.ID = CGL.CATALOG_GROUP_ID AND CGL.LANG = 'ru') LEFT JOIN b_catalog_group2group CGG ON (CG.ID = CGG.CATALOG_GROUP_ID AND CGG.GROUP_ID IN (,1,2,8,12,13,14) AND CGG.BUY <> 'Y') LEFT JOIN b_catalog_group2group CGG1 ON (CG.ID = CGG1.CATALOG_GROUP_ID AND CGG1.GROUP_ID IN (,1,2,8,12,13,14) AND CGG1.BUY = 'Y') GROUP BY CG.ID, CG.NAME, CG.BASE, CG.SORT, CG.XML_ID, CG.MODIFIED_BY, CG.CREATED_BY, CG.DATE_CREATE, CG.TIMESTAMP_X, CGL.NAME
[You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1,2,8,12,13,14) AND CGG.BUY <> 'Y') LEFT JOIN b_catalog_group2group CGG1 ON (CG.' at line 1]
debug_backtrace:
Array
(
[0] => Array
(
[file] => /home/t/tdczar/tdczar.tmweb.ru/public_html/bitrix/modules/main/classes/mysql/database.php
[line] => 194
[class] =>
[function] => include
[args] => Array
(
[0] => /home/t/tdczar/tdczar.tmweb.ru/public_html/bitrix/modules/main/include/dbquery_error.php
)
)
[1] => Array
(
[file] => /home/t/tdczar/tdczar.tmweb.ru/public_html/bitrix/modules/catalog/mysql/cataloggroup.php
[line] => 384
[class] => CDatabaseMysql
[function] => Query
[args] =>
)
[2] => Array
(
[file] => /home/t/tdczar/tdczar.tmweb.ru/public_html/bitrix/modules/iblock/classes/general/cml2.php
[line] => 2229
[class] => CCatalogGroup
[function] => GetList
[args] =>
)
[3] => Array
(
[file] => /home/t/tdczar/tdczar.tmweb.ru/public_html/bitrix/components/bitrix/catalog.import.1c/component.php
[line] => 524
[class] => CIBlockCMLImport
[function] => ReadCatalogData
[args] =>
)
[4] => Array
(
[file] => /home/t/tdczar/tdczar.tmweb.ru/public_html/bitrix/modules/main/classes/general/component.php
[line] => 535
[class] =>
[function] => include
[args] => Array
(
[0] => /home/t/tdczar/tdczar.tmweb.ru/public_html/bitrix/components/bitrix/catalog.import.1c/component.php
)
)
[5] => Array
(
[file] => /home/t/tdczar/tdczar.tmweb.ru/public_html/bitrix/modules/main/classes/general/component.php
[line] => 94
[class] => CBitrixComponent
[function] => __includeComponent
[args] =>
)
[6] => Array
(
[file] => /home/t/tdczar/tdczar.tmweb.ru/public_html/bitrix/modules/main/classes/general/component.php
[line] => 569
[class] => CBitrixComponent
[function] => executeComponent
[args] =>
)
[7] => Array
(
[file] => /home/t/tdczar/tdczar.tmweb.ru/public_html/bitrix/modules/main/classes/general/main.php
[line] => 1050
[class] => CBitrixComponent
[function] => includeComponent
[args] =>
)
[8] => Array
(
[file] => /home/t/tdczar/tdczar.tmweb.ru/public_html/bitrix/modules/sale/admin/1c_exchange.php
[line] => 91
[class] => CAllMain
[function] => IncludeComponent
[args] =>
)
[9] => Array
(
[file] => /home/t/tdczar/tdczar.tmweb.ru/public_html/bitrix/admin/1c_exchange.php
[line] => 2
[class] =>
[function] => require_once
[args] => Array
(
[0] => /home/t/tdczar/tdczar.tmweb.ru/public_html/bitrix/modules/sale/admin/1c_exchange.php
)
)
)
">
<input type="hidden" name="sessid" id="sessid" value="49eb3d4f4d2d08e7bc2779d24e75fc7e" /> <input type="submit" value="Send error report to support">
</form>
</td>
</tr>
</table></td>
</tr>
</table>
<br><br><br>
06.04.2016 16:48:04 Завершена выгрузка товаров
Ошибка в пользовательской части сайта при авторизации админа:
File: /home/t/tdczar/tdczar.tmweb.ru/public_html/bitrix/modules/catalog/mysql/product.php
Line: 424
MySQL Query Error: SEL ECT CAT_CG.ID, CAT_CGL.NAME as CATALOG_GROUP_NAME, IF(CAT_CGG.ID IS NULL, 'N', 'Y') as CATALOG_CAN_ACCESS, IF(CAT_CGG1.ID IS NULL, 'N', 'Y') as CATALOG_CAN_BUY FR OM b_catalog_group CAT_CG LEFT JOIN b_catalog_group2group CAT_CGG ON (CAT_CG.ID = CAT_CGG.CATALOG_GROUP_ID AND CAT_CGG.GROUP_ID IN (,1,2,8,12,13,14) AND CAT_CGG.BUY <> 'Y') LEFT JOIN b_catalog_group2group CAT_CGG1 ON (CAT_CG.ID = CAT_CGG1.CATALOG_GROUP_ID AND CAT_CGG1.GROUP_ID IN (,1,2,8,12,13,14) AND CAT_CGG1.BUY = 'Y') LEFT JOIN b_catalog_group_lang CAT_CGL ON (CAT_CG.ID = CAT_CGL.CATALOG_GROUP_ID AND CAT_CGL.LANG = 'ru') WH ERE CAT_CG.ID IN (16) GROUP BY CAT_CG.ID [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1,2,8,12,13,14) AND CAT_CGG.BUY <> 'Y') LEFT JOIN b_catalog_group2group CAT_CGG' at line 1]
Сама ошибка в 1с при выгрузке:
Интерактивный обмен06.04.2016 15:33:12 Запуск выгрузки товаров
06.04.2016 16:13:52 Завершено формирование файлов выгрузки товаров
Выгружено товаров: 10 272
предложений: 13 350
картинок: 12 498
файлов: 13
В том числе для каталога Основной каталог товаров:
товаров: 10 272
предложений: 13 350
картинок: 12 498
файлов: 13
06.04.2016 16:48:04 Выгрузка на сайт завершилась с ошибками.
import.xml: 5 Произошла ошибка на стороне сервера. Получен неизвестный статус импорта.
Ответ сервера:
File: /home/t/tdczar/tdczar.tmweb.ru/public_html/bitrix/modules/catalog/mysql/cataloggroup.php<br>Line: 384<br><font color=#ff0000>MySQL Query Error: SEL ECT CG.ID as ID, CG.NAME as NAME, CG.BASE as BASE, CG.SORT as SORT, CGL.NAME as NAME_LANG, IF(CGG.ID IS NULL, 'N', 'Y') as CAN_ACCESS, IF(CGG1.ID IS NULL, 'N', 'Y') as CAN_BUY, CG.XML_ID as XML_ID, CG.MODIFIED_BY as MODIFIED_BY, CG.CREATED_BY as CREATED_BY, DATE_FORMAT(CG.DATE_CREATE, '%d.%m.%Y %H:%i:%s') as DATE_CREATE, DATE_FORMAT(CG.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X, COUNT( CG.ID) as CNT FR OM b_catalog_group CG LEFT JOIN b_catalog_group_lang CGL ON (CG.ID = CGL.CATALOG_GROUP_ID AND CGL.LANG = 'ru') LEFT JOIN b_catalog_group2group CGG ON (CG.ID = CGG.CATALOG_GROUP_ID AND CGG.GROUP_ID IN (,1,2,8,12,13,14) AND CGG.BUY <> 'Y') LEFT JOIN b_catalog_group2group CGG1 ON (CG.ID = CGG1.CATALOG_GROUP_ID AND CGG1.GROUP_ID IN (,1,2,8,12,13,14) AND CGG1.BUY = 'Y') GROUP BY CG.ID, CG.NAME, CG.BASE, CG.SORT, CG.XML_ID, CG.MODIFIED_BY, CG.CREATED_BY, CG.DATE_CREATE, CG.TIMESTAMP_X, CGL.NAME</font>[You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1,2,8,12,13,14) AND CGG.BUY <> 'Y') LEFT JOIN b_catalog_group2group CGG1 ON (CG.' at line 1]<br><br>
<table cellpadding="1" cellspacing="0" width="35%" bgcolor="#9C9A9C">
<tr>
<td><table cellpadding="5" cellspacing="0" width="100%">
<tr>
<td bgcolor="#FFFFFF" align="center">
<FONT face="Verdana, Arial, Helvetica, sans-serif" size="-1">
<font color="#FF0000"><b>DB query error.</b></font><br>
Please try later.
</font><br>
</form>
<form method="post" action="/bitrix/admin/site_checker.php?tabControl_active_tab=edit5#edit5">
<input type="hidden" name="last_error_query" value="File: /home/t/tdczar/tdczar.tmweb.ru/public_html/bitrix/modules/main/include/dbquery_error.php
[File: /home/t/tdczar/tdczar.tmweb.ru/public_html/bitrix/modules/catalog/mysql/cataloggroup.php
Line: 384]
Query: SELECT CG.ID as ID, CG.NAME as NAME, CG.BASE as BASE, CG.SORT as SORT, CGL.NAME as NAME_LANG, IF(CGG.ID IS NULL, 'N', 'Y') as CAN_ACCESS, IF(CGG1.ID IS NULL, 'N', 'Y') as CAN_BUY, CG.XML_ID as XML_ID, CG.MODIFIED_BY as MODIFIED_BY, CG.CREATED_BY as CREATED_BY, DATE_FORMAT(CG.DATE_CREATE, '%d.%m.%Y %H:%i:%s') as DATE_CREATE, DATE_FORMAT(CG.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X, COUNT( CG.ID) as CNT FR OM b_catalog_group CG LEFT JOIN b_catalog_group_lang CGL ON (CG.ID = CGL.CATALOG_GROUP_ID AND CGL.LANG = 'ru') LEFT JOIN b_catalog_group2group CGG ON (CG.ID = CGG.CATALOG_GROUP_ID AND CGG.GROUP_ID IN (,1,2,8,12,13,14) AND CGG.BUY <> 'Y') LEFT JOIN b_catalog_group2group CGG1 ON (CG.ID = CGG1.CATALOG_GROUP_ID AND CGG1.GROUP_ID IN (,1,2,8,12,13,14) AND CGG1.BUY = 'Y') GROUP BY CG.ID, CG.NAME, CG.BASE, CG.SORT, CG.XML_ID, CG.MODIFIED_BY, CG.CREATED_BY, CG.DATE_CREATE, CG.TIMESTAMP_X, CGL.NAME
[You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1,2,8,12,13,14) AND CGG.BUY <> 'Y') LEFT JOIN b_catalog_group2group CGG1 ON (CG.' at line 1]
debug_backtrace:
Array
(
[0] => Array
(
[file] => /home/t/tdczar/tdczar.tmweb.ru/public_html/bitrix/modules/main/classes/mysql/database.php
[line] => 194
[class] =>
[function] => include
[args] => Array
(
[0] => /home/t/tdczar/tdczar.tmweb.ru/public_html/bitrix/modules/main/include/dbquery_error.php
)
)
[1] => Array
(
[file] => /home/t/tdczar/tdczar.tmweb.ru/public_html/bitrix/modules/catalog/mysql/cataloggroup.php
[line] => 384
[class] => CDatabaseMysql
[function] => Query
[args] =>
)
[2] => Array
(
[file] => /home/t/tdczar/tdczar.tmweb.ru/public_html/bitrix/modules/iblock/classes/general/cml2.php
[line] => 2229
[class] => CCatalogGroup
[function] => GetList
[args] =>
)
[3] => Array
(
[file] => /home/t/tdczar/tdczar.tmweb.ru/public_html/bitrix/components/bitrix/catalog.import.1c/component.php
[line] => 524
[class] => CIBlockCMLImport
[function] => ReadCatalogData
[args] =>
)
[4] => Array
(
[file] => /home/t/tdczar/tdczar.tmweb.ru/public_html/bitrix/modules/main/classes/general/component.php
[line] => 535
[class] =>
[function] => include
[args] => Array
(
[0] => /home/t/tdczar/tdczar.tmweb.ru/public_html/bitrix/components/bitrix/catalog.import.1c/component.php
)
)
[5] => Array
(
[file] => /home/t/tdczar/tdczar.tmweb.ru/public_html/bitrix/modules/main/classes/general/component.php
[line] => 94
[class] => CBitrixComponent
[function] => __includeComponent
[args] =>
)
[6] => Array
(
[file] => /home/t/tdczar/tdczar.tmweb.ru/public_html/bitrix/modules/main/classes/general/component.php
[line] => 569
[class] => CBitrixComponent
[function] => executeComponent
[args] =>
)
[7] => Array
(
[file] => /home/t/tdczar/tdczar.tmweb.ru/public_html/bitrix/modules/main/classes/general/main.php
[line] => 1050
[class] => CBitrixComponent
[function] => includeComponent
[args] =>
)
[8] => Array
(
[file] => /home/t/tdczar/tdczar.tmweb.ru/public_html/bitrix/modules/sale/admin/1c_exchange.php
[line] => 91
[class] => CAllMain
[function] => IncludeComponent
[args] =>
)
[9] => Array
(
[file] => /home/t/tdczar/tdczar.tmweb.ru/public_html/bitrix/admin/1c_exchange.php
[line] => 2
[class] =>
[function] => require_once
[args] => Array
(
[0] => /home/t/tdczar/tdczar.tmweb.ru/public_html/bitrix/modules/sale/admin/1c_exchange.php
)
)
)
">
<input type="hidden" name="sessid" id="sessid" value="49eb3d4f4d2d08e7bc2779d24e75fc7e" /> <input type="submit" value="Send error report to support">
</form>
</td>
</tr>
</table></td>
</tr>
</table>
<br><br><br>
06.04.2016 16:48:04 Завершена выгрузка товаров