Здравствуйте. Пару дней назад обмен перестал выгружать картинки.
Лог такой
Вообщем, повторяется несколько раз и все. Обмен завершен - результата нет.
Когда пробуешь выгружаться локально - все выгружает. Когда делаешь обмен с сайтом без картинок -также выгружает все без проблем.
Куда копать, подскажите?
Лог такой
Код |
---|
Отправка запроса на авторизацию. Отправка запроса на инициализацию, для определения версии обмена данных. Процес выполнения обмена: Распаковка архива завершена. Процес выполнения обмена: Временные таблицы удалены. Процес выполнения обмена: Временные таблицы созданы. Процес выполнения обмена: Файл импорта прочитан. Процес выполнения обмена: Временные таблицы проиндексированы. Процес выполнения обмена: Метаданные импортированы успешно. Процес выполнения обмена: Группы импортированы. Процес выполнения обмена: Деактивация/удаление групп завершено. import___8bcf94b2-215e-4b5b-84c3-2d437d4a25f1.xml: Произошла ошибка на стороне сервера. Получен неизвестный статус импорта. Ответ сервера: <br><font color=#ff0000>MySQL Query Error: SEL ECT `p`.`ID` as `PROP_ID`, `f`.* FR OM `b_iblock_element_property` as `p` LEFT JOIN `b_file` as `f` ON(`p`.`VALUE` = `f`.`ID`) WHERE `p`.`ID` IN() AND `IBLOCK_PROPERTY_ID` = 166</font>[[1064] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND `IBLOCK_PROPERTY_ID` = 166' at line 4]<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> <fo rm method="post" action="/bitrix/admin/site_checker.php?tabControl_active_tab=edit5#edit5"> <input type="hidden" name="last_error_query" value="File: /var/www/vhosts/vps-justinkids.host4g.ru/justin-kids.ru/bitrix/modules/main/include/dbquery_error.php Query: SEL ECT `p`.`ID` as `PROP_ID`, `f`.* FR OM `b_iblock_element_property` as `p` LEFT JOIN `b_file` as `f` ON(`p`.`VALUE` = `f`.`ID`) WHERE `p`.`ID` IN() AND `IBLOCK_PROPERTY_ID` = 166 [[1064] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND `IBLOCK_PROPERTY_ID` = 166' at line 4] debug_backtrace: Array ( [0] => Array ( [file] => /var/www/vhosts/vps-justinkids.host4g.ru/justin-kids.ru/bitrix/modules/main/classes/mysql/database.php [line] => 194 [class] => [function] => include [args] => Array ( [0] => /var/www/vhosts/vps-justinkids.host4g.ru/justin-kids.ru/bitrix/modules/main/include/dbquery_error.php ) ) [1] => Array ( [file] => /var/www/vhosts/vps-justinkids.host4g.ru/justin-kids.ru/bitrix/php_interface/init.php [line] => 170 [class] => CDatabaseMysql [function] => Query [args] => ) [2] => Array ( [file] => /var/www/vhosts/vps-justinkids.host4g.ru/justin-kids.ru/bitrix/modules/main/classes/general/module.php [line] => 475 [class] => ElementBloka [function] => OnBeforeIBlockElementUpdate [args] => ) [3] => Array ( [file] => /var/www/vhosts/vps-justinkids.host4g.ru/justin-kids.ru/bitrix/modules/iblock/classes/general/iblockelement.php [line] => 4614 [class] => [function] => ExecuteModuleEventEx [args] => ) [4] => Array ( [file] => /var/www/vhosts/vps-justinkids.host4g.ru/justin-kids.ru/bitrix/modules/iblock/classes/mysql/iblockelement.php [line] => 1289 [class] => CAllIBlockElement [function] => CheckFields [args] => ) [5] => Array ( [file] => /var/www/vhosts/vps-justinkids.host4g.ru/justin-kids.ru/bitrix/modules/iblock/classes/general/cml2.php [line] => 3619 [class] => CIBlockElement [function] => Update [args] => ) [6] => Array ( [file] => /var/www/vhosts/vps-justinkids.host4g.ru/justin-kids.ru/bitrix/modules/iblock/classes/general/cml2.php [line] => 2577 [class] => CIBlockCMLImport [function] => ImportElement [args] => ) [7] => Array ( [file] => /var/www/vhosts/vps-justinkids.host4g.ru/justin-kids.ru/bitrix/components/bitrix/catalog.import.1c/component.php [line] => 493 [class] => CIBlockCMLImport [function] => ImportElements [args] => ) [8] => Array ( [file] => /var/www/vhosts/vps-justinkids.host4g.ru/justin-kids.ru/bitrix/modules/main/classes/general/component.php [line] => 594 [class] => [function] => include [args] => Array ( [0] => /var/www/vhosts/vps-justinkids.host4g.ru/justin-kids.ru/bitrix/components/bitrix/catalog.import.1c/component.php ) ) [9] => Array ( [file] => /var/www/vhosts/vps-justinkids.host4g.ru/justin-kids.ru/bitrix/modules/main/classes/general/component.php [line] => 102 [class] => CBitrixComponent [function] => __includeComponent [args] => ) [10] => Array ( [file] => /var/www/vhosts/vps-justinkids.host4g.ru/justin-kids.ru/bitrix/modules/main/classes/general/component.php [line] => 638 [class] => CBitrixComponent [function] => executeComponent [args] => ) [11] => Array ( [file] => /var/www/vhosts/vps-justinkids.host4g.ru/justin-kids.ru/bitrix/modules/main/classes/general/main.php [line] => 1038 [class] => CBitrixComponent [function] => includeComponent [args] => ) [12] => Array ( [file] => /var/www/vhosts/vps-justinkids.host4g.ru/justin-kids.ru/bitrix/modules/sale/admin/1c_exchange.php [line] => 90 [class] => CAllMain [function] => IncludeComponent [args] => ) [13] => Array ( [file] => /var/www/vhosts/vps-justinkids.host4g.ru/justin-kids.ru/bitrix/admin/1c_exchange.php [line] => 2 [class] => [function] => require_once [args] => Array ( [0] => /var/www/vhosts/vps-justinkids.host4g.ru/justin-kids.ru/bitrix/modules/sale/admin/1c_exchange.php ) ) ) "> <input type="hidden" name="sessid" id="sessid" value="672c986b04dd5223d9927616254c09d0" /> <input type="submit" value="Send error report to support"> </form> </td> </tr> </table></td> </tr> </table> <br><br><br> Ответ сервера: <br><font color=#ff0000>MySQL Query Error: SELECT `p`.`ID` as `PROP_ID`, `f`.* FR OM `b_iblock_element_property` as `p` LEFT JOIN `b_file` as `f` ON(`p`.`VALUE` = `f`.`ID`) WH ERE `p`.`ID` IN() AND `IBLOCK_PROPERTY_ID` = 166</font>[[1064] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND `IBLOCK_PROPERTY_ID` = 166' at line 4]<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> <fo rm method="post" action="/bitrix/admin/site_checker.php?tabControl_active_tab=edit5#edit5"> <input type="hidden" name="last_error_query" value="File: /var/www/vhosts/vps-justinkids.host4g.ru/justin-kids.ru/bitrix/modules/main/include/dbquery_error.php Query: SELECT `p`.`ID` as `PROP_ID`, `f`.* FR OM `b_iblock_element_property` as `p` LEFT JOIN `b_file` as `f` ON(`p`.`VALUE` = `f`.`ID`) WH ERE `p`.`ID` IN() AND `IBLOCK_PROPERTY_ID` = 166 [[1064] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND `IBLOCK_PROPERTY_ID` = 166' at line 4] debug_backtrace: Array ( [0] => Array ( [file] => /var/www/vhosts/vps-justinkids.host4g.ru/justin-kids.ru/bitrix/modules/main/classes/mysql/database.php [line] => 194 [class] => [function] => include [args] => Array ( [0] => /var/www/vhosts/vps-justinkids.host4g.ru/justin-kids.ru/bitrix/modules/main/include/dbquery_error.php ) ) [1] => Array ( [file] => /var/www/vhosts/vps-justinkids.host4g.ru/justin-kids.ru/bitrix/php_interface/init.php [line] => 170 [class] => CDatabaseMysql [function] => Query [args] => ) [2] => Array ( [file] => /var/www/vhosts/vps-justinkids.host4g.ru/justin-kids.ru/bitrix/modules/main/classes/general/module.php [line] => 475 [class] => ElementBloka [function] => OnBeforeIBlockElementUpdate [args] => ) [3] => Array ( [file] => /var/www/vhosts/vps-justinkids.host4g.ru/justin-kids.ru/bitrix/modules/iblock/classes/general/iblockelement.php [line] => 4614 [class] => [function] => ExecuteModuleEventEx [args] => ) [4] => Array ( [file] => /var/www/vhosts/vps-justinkids.host4g.ru/justin-kids.ru/bitrix/modules/iblock/classes/mysql/iblockelement.php [line] => 1289 [class] => CAllIBlockElement [function] => CheckFields [args] => ) [5] => Array ( [file] => /var/www/vhosts/vps-justinkids.host4g.ru/justin-kids.ru/bitrix/modules/iblock/classes/general/cml2.php [line] => 3619 [class] => CIBlockElement [function] => Update [args] => ) [6] => Array ( [file] => /var/www/vhosts/vps-justinkids.host4g.ru/justin-kids.ru/bitrix/modules/iblock/classes/general/cml2.php [line] => 2577 [class] => CIBlockCMLImport [function] => ImportElement [args] => ) [7] => Array ( [file] => /var/www/vhosts/vps-justinkids.host4g.ru/justin-kids.ru/bitrix/components/bitrix/catalog.import.1c/component.php [line] => 493 [class] => CIBlockCMLImport [function] => ImportElements [args] => ) [8] => Array ( [file] => /var/www/vhosts/vps-justinkids.host4g.ru/justin-kids.ru/bitrix/modules/main/classes/general/component.php [line] => 594 [class] => [function] => include [args] => Array ( [0] => /var/www/vhosts/vps-justinkids.host4g.ru/justin-kids.ru/bitrix/components/bitrix/catalog.import.1c/component.php ) ) [9] => Array ( [file] => /var/www/vhosts/vps-justinkids.host4g.ru/justin-kids.ru/bitrix/modules/main/classes/general/component.php [line] => 102 [class] => CBitrixComponent [function] => __includeComponent [args] => ) [10] => Array ( [file] => /var/www/vhosts/vps-justinkids.host4g.ru/justin-kids.ru/bitrix/modules/main/classes/general/component.php [line] => 638 [class] => CBitrixComponent [function] => executeComponent [args] => ) [11] => Array ( [file] => /var/www/vhosts/vps-justinkids.host4g.ru/justin-kids.ru/bitrix/modules/main/classes/general/main.php [line] => 1038 [class] => CBitrixComponent [function] => includeComponent [args] => ) [12] => Array ( [file] => /var/www/vhosts/vps-justinkids.host4g.ru/justin-kids.ru/bitrix/modules/sale/admin/1c_exchange.php [line] => 90 [class] => CAllMain [function] => IncludeComponent [args] => ) [13] => Array ( [file] => /var/www/vhosts/vps-justinkids.host4g.ru/justin-kids.ru/bitrix/admin/1c_exchange.php [line] => 2 [class] => [function] => require_once [args] => Array ( [0] => /var/www/vhosts/vps-justinkids.host4g.ru/justin-kids.ru/bitrix/modules/sale/admin/1c_exchange.php ) ) ) "> <input type="hidden" name="sessid" id="sessid" value="672c986b04dd5223d9927616254c09d0" /> <input type="submit" value="Send error report to support"> </form> </td> </tr> </table></td> </tr> </table> <br><br><br> Отправка запроса на авторизацию. Отправка запроса на инициализацию, для определения версии обмена данных. Процес выполнения обмена: Распаковка архива завершена. |
Когда пробуешь выгружаться локально - все выгружает. Когда делаешь обмен с сайтом без картинок -также выгружает все без проблем.
Куда копать, подскажите?