Помощь Вопросы и решение проблем с Битрикс

Seolink09 · 15 Мар 2016

Прошу помощи при установке малого бинеса такая штука если пропустить то нет местопложений
Повторите установку текущего шага. В случае повторения ошибки пропустите шаг.

Код:

[Bitrix\Main\DB\SqlQueryException] Mysql query error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay (400) SELECT `sale_location_location`.`ID` AS `ID`, `sale_location_location_to_country`.`ID` AS `COUNTRY_ID_`, `sale_location_location_to_region`.`ID` AS `REGION_ID_`, `sale_location_location_to_city`.`ID` AS `CITY_ID_`, `sale_location_location`.`SORT` AS `SORT`, `sale_location_location_country_name_orig_`.`NAME` AS `COUNTRY_NAME_ORIG`, `sale_location_location_country_name_`.`SHORT_NAME` AS `COUNTRY_SHORT_NAME`, `sale_location_location_region_name_orig_`.`NAME` AS `REGION_NAME_ORIG`, `sale_location_location_city_name_orig_`.`NAME` AS `CITY_NAME_ORIG`, `sale_location_location_region_name_`.`SHORT_NAME` AS `REGION_SHORT_NAME`, `sale_location_location_city_name_`.`SHORT_NAME` AS `CITY_SHORT_NAME`, `sale_location_location_country_name_`.`LANGUAGE_ID` AS `COUNTRY_LID`, `sale_location_location_country_name_`.`NAME` AS `COUNTRY_NAME`, `sale_location_location_country_name_`.`NAME` AS `COUNTRY_NAME_LANG`, `sale_location_location_region_name_`.`LANGUAGE_ID` AS `REGION_LID`, `sale_location_location_city_name_`.`LANGUAGE_ID` AS `CITY_LID`, `sale_location_location_region_name_`.`NAME` AS `REGION_NAME`, `sale_location_location_region_name_`.`NAME` AS `REGION_NAME_LANG`, `sale_location_location_city_name_`.`NAME` AS `CITY_NAME`, `sale_location_location_city_name_`.`NAME` AS `CITY_NAME_LANG`, CASE WHEN `sale_location_location_default_id`.`LOCATION_CODE` IS NULL THEN 'N' ELSE 'Y' END AS `LOC_DEFAULT` FROM `b_sale_location` `sale_location_location` LEFT JOIN `b_sale_location` `sale_location_location_to_country` ON `sale_location_location_to_country`.`LEFT_MARGIN` <= `sale_location_location`.`LEFT_MARGIN` AND `sale_location_location_to_country`.`RIGHT_MARGIN` >= `sale_location_location`.`RIGHT_MARGIN` AND `sale_location_location_to_country`.`TYPE_ID` = '1' LEFT JOIN `b_sale_location` `sale_location_location_to_region` ON ( ( `sale_location_location`.`TYPE_ID` = '3' ) OR ( `sale_location_location`.`TYPE_ID` = '4' ) ) AND `sale_location_location_to_region`.`LEFT_MARGIN` <= `sale_location_location`.`LEFT_MARGIN` AND `sale_location_location_to_region`.`RIGHT_MARGIN` >= `sale_location_location`.`RIGHT_MARGIN` AND `sale_location_location_to_region`.`TYPE_ID` = '3' LEFT JOIN `b_sale_location` `sale_location_location_to_city` ON `sale_location_location`.`TYPE_ID` = '4' AND `sale_location_location`.`ID` = `sale_location_location_to_city`.`ID` LEFT JOIN `b_sale_loc_name` `sale_location_location_country_name_` ON `sale_location_location_to_country`.`ID` = `sale_location_location_country_name_`.`LOCATION_ID` LEFT JOIN `b_sale_loc_name` `sale_location_location_region_name_` ON `sale_location_location_to_region`.`ID` = `sale_location_location_region_name_`.`LOCATION_ID` LEFT JOIN `b_sale_loc_name` `sale_location_location_city_name_` ON `sale_location_location_to_city`.`ID` = `sale_location_location_city_name_`.`LOCATION_ID` LEFT JOIN `b_sale_loc_name` `sale_location_location_country_name_orig_` ON `sale_location_location_to_country`.`ID` = `sale_location_location_country_name_orig_`.`LOCATION_ID` AND `sale_location_location_country_name_orig_`.`LANGUAGE_ID` = 'en' LEFT JOIN `b_sale_loc_name` `sale_location_location_region_name_orig_` ON `sale_location_location_to_region`.`ID` = `sale_location_location_region_name_orig_`.`LOCATION_ID` AND `sale_location_location_region_name_orig_`.`LANGUAGE_ID` = 'en' LEFT JOIN `b_sale_loc_name` `sale_location_location_city_name_orig_` ON `sale_location_location_to_city`.`ID` = `sale_location_location_city_name_orig_`.`LOCATION_ID` AND `sale_location_location_city_name_orig_`.`LANGUAGE_ID` = 'en' LEFT JOIN `b_sale_loc_def2site` `sale_location_location_default_id` ON `sale_location_location`.`CODE` = `sale_location_location_default_id`.`LOCATION_CODE` WHERE UPPER(`sale_location_location_city_name_orig_`.`NAME`) like upper('Moscow') AND (`sale_location_location`.`TYPE_ID` in (1,

nononameman · 15 Мар 2016

Seolink09 написал(а):

Прошу помощи при установке малого бинеса такая штука если пропустить то нет местопложений
Повторите установку текущего шага. В случае повторения ошибки пропустите шаг.

Код:

[Bitrix\Main\DB\SqlQueryException] Mysql query error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay (400) SELECT `sale_location_location`.`ID` AS `ID`, `sale_location_location_to_country`.`ID` AS `COUNTRY_ID_`, `sale_location_location_to_region`.`ID` AS `REGION_ID_`, `sale_location_location_to_city`.`ID` AS `CITY_ID_`, `sale_location_location`.`SORT` AS `SORT`, `sale_location_location_country_name_orig_`.`NAME` AS `COUNTRY_NAME_ORIG`, `sale_location_location_country_name_`.`SHORT_NAME` AS `COUNTRY_SHORT_NAME`, `sale_location_location_region_name_orig_`.`NAME` AS `REGION_NAME_ORIG`, `sale_location_location_city_name_orig_`.`NAME` AS `CITY_NAME_ORIG`, `sale_location_location_region_name_`.`SHORT_NAME` AS `REGION_SHORT_NAME`, `sale_location_location_city_name_`.`SHORT_NAME` AS `CITY_SHORT_NAME`, `sale_location_location_country_name_`.`LANGUAGE_ID` AS `COUNTRY_LID`, `sale_location_location_country_name_`.`NAME` AS `COUNTRY_NAME`, `sale_location_location_country_name_`.`NAME` AS `COUNTRY_NAME_LANG`, `sale_location_location_region_name_`.`LANGUAGE_ID` AS `REGION_LID`, `sale_location_location_city_name_`.`LANGUAGE_ID` AS `CITY_LID`, `sale_location_location_region_name_`.`NAME` AS `REGION_NAME`, `sale_location_location_region_name_`.`NAME` AS `REGION_NAME_LANG`, `sale_location_location_city_name_`.`NAME` AS `CITY_NAME`, `sale_location_location_city_name_`.`NAME` AS `CITY_NAME_LANG`, CASE WHEN `sale_location_location_default_id`.`LOCATION_CODE` IS NULL THEN 'N' ELSE 'Y' END AS `LOC_DEFAULT` FROM `b_sale_location` `sale_location_location` LEFT JOIN `b_sale_location` `sale_location_location_to_country` ON `sale_location_location_to_country`.`LEFT_MARGIN` <= `sale_location_location`.`LEFT_MARGIN` AND `sale_location_location_to_country`.`RIGHT_MARGIN` >= `sale_location_location`.`RIGHT_MARGIN` AND `sale_location_location_to_country`.`TYPE_ID` = '1' LEFT JOIN `b_sale_location` `sale_location_location_to_region` ON ( ( `sale_location_location`.`TYPE_ID` = '3' ) OR ( `sale_location_location`.`TYPE_ID` = '4' ) ) AND `sale_location_location_to_region`.`LEFT_MARGIN` <= `sale_location_location`.`LEFT_MARGIN` AND `sale_location_location_to_region`.`RIGHT_MARGIN` >= `sale_location_location`.`RIGHT_MARGIN` AND `sale_location_location_to_region`.`TYPE_ID` = '3' LEFT JOIN `b_sale_location` `sale_location_location_to_city` ON `sale_location_location`.`TYPE_ID` = '4' AND `sale_location_location`.`ID` = `sale_location_location_to_city`.`ID` LEFT JOIN `b_sale_loc_name` `sale_location_location_country_name_` ON `sale_location_location_to_country`.`ID` = `sale_location_location_country_name_`.`LOCATION_ID` LEFT JOIN `b_sale_loc_name` `sale_location_location_region_name_` ON `sale_location_location_to_region`.`ID` = `sale_location_location_region_name_`.`LOCATION_ID` LEFT JOIN `b_sale_loc_name` `sale_location_location_city_name_` ON `sale_location_location_to_city`.`ID` = `sale_location_location_city_name_`.`LOCATION_ID` LEFT JOIN `b_sale_loc_name` `sale_location_location_country_name_orig_` ON `sale_location_location_to_country`.`ID` = `sale_location_location_country_name_orig_`.`LOCATION_ID` AND `sale_location_location_country_name_orig_`.`LANGUAGE_ID` = 'en' LEFT JOIN `b_sale_loc_name` `sale_location_location_region_name_orig_` ON `sale_location_location_to_region`.`ID` = `sale_location_location_region_name_orig_`.`LOCATION_ID` AND `sale_location_location_region_name_orig_`.`LANGUAGE_ID` = 'en' LEFT JOIN `b_sale_loc_name` `sale_location_location_city_name_orig_` ON `sale_location_location_to_city`.`ID` = `sale_location_location_city_name_orig_`.`LOCATION_ID` AND `sale_location_location_city_name_orig_`.`LANGUAGE_ID` = 'en' LEFT JOIN `b_sale_loc_def2site` `sale_location_location_default_id` ON `sale_location_location`.`CODE` = `sale_location_location_default_id`.`LOCATION_CODE` WHERE UPPER(`sale_location_location_city_name_orig_`.`NAME`) like upper('Moscow') AND (`sale_location_location`.`TYPE_ID` in (1,

Пропустите а потом загрузите местоположения отдельно.

Seolink09 · 15 Мар 2016

пробую но потом у меня не работает выбор местопложения хотя они есть

oxothukszt · 15 Мар 2016

Seolink09 написал(а):

Прошу помощи при установке малого бинеса такая штука если пропустить то нет местопложений
Повторите установку текущего шага. В случае повторения ошибки пропустите шаг.

Код:

[Bitrix\Main\DB\SqlQueryException] Mysql query error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay (400) SELECT `sale_location_location`.`ID` AS `ID`, `sale_location_location_to_country`.`ID` AS `COUNTRY_ID_`, `sale_location_location_to_region`.`ID` AS `REGION_ID_`, `sale_location_location_to_city`.`ID` AS `CITY_ID_`, `sale_location_location`.`SORT` AS `SORT`, `sale_location_location_country_name_orig_`.`NAME` AS `COUNTRY_NAME_ORIG`, `sale_location_location_country_name_`.`SHORT_NAME` AS `COUNTRY_SHORT_NAME`, `sale_location_location_region_name_orig_`.`NAME` AS `REGION_NAME_ORIG`, `sale_location_location_city_name_orig_`.`NAME` AS `CITY_NAME_ORIG`, `sale_location_location_region_name_`.`SHORT_NAME` AS `REGION_SHORT_NAME`, `sale_location_location_city_name_`.`SHORT_NAME` AS `CITY_SHORT_NAME`, `sale_location_location_country_name_`.`LANGUAGE_ID` AS `COUNTRY_LID`, `sale_location_location_country_name_`.`NAME` AS `COUNTRY_NAME`, `sale_location_location_country_name_`.`NAME` AS `COUNTRY_NAME_LANG`, `sale_location_location_region_name_`.`LANGUAGE_ID` AS `REGION_LID`, `sale_location_location_city_name_`.`LANGUAGE_ID` AS `CITY_LID`, `sale_location_location_region_name_`.`NAME` AS `REGION_NAME`, `sale_location_location_region_name_`.`NAME` AS `REGION_NAME_LANG`, `sale_location_location_city_name_`.`NAME` AS `CITY_NAME`, `sale_location_location_city_name_`.`NAME` AS `CITY_NAME_LANG`, CASE WHEN `sale_location_location_default_id`.`LOCATION_CODE` IS NULL THEN 'N' ELSE 'Y' END AS `LOC_DEFAULT` FROM `b_sale_location` `sale_location_location` LEFT JOIN `b_sale_location` `sale_location_location_to_country` ON `sale_location_location_to_country`.`LEFT_MARGIN` <= `sale_location_location`.`LEFT_MARGIN` AND `sale_location_location_to_country`.`RIGHT_MARGIN` >= `sale_location_location`.`RIGHT_MARGIN` AND `sale_location_location_to_country`.`TYPE_ID` = '1' LEFT JOIN `b_sale_location` `sale_location_location_to_region` ON ( ( `sale_location_location`.`TYPE_ID` = '3' ) OR ( `sale_location_location`.`TYPE_ID` = '4' ) ) AND `sale_location_location_to_region`.`LEFT_MARGIN` <= `sale_location_location`.`LEFT_MARGIN` AND `sale_location_location_to_region`.`RIGHT_MARGIN` >= `sale_location_location`.`RIGHT_MARGIN` AND `sale_location_location_to_region`.`TYPE_ID` = '3' LEFT JOIN `b_sale_location` `sale_location_location_to_city` ON `sale_location_location`.`TYPE_ID` = '4' AND `sale_location_location`.`ID` = `sale_location_location_to_city`.`ID` LEFT JOIN `b_sale_loc_name` `sale_location_location_country_name_` ON `sale_location_location_to_country`.`ID` = `sale_location_location_country_name_`.`LOCATION_ID` LEFT JOIN `b_sale_loc_name` `sale_location_location_region_name_` ON `sale_location_location_to_region`.`ID` = `sale_location_location_region_name_`.`LOCATION_ID` LEFT JOIN `b_sale_loc_name` `sale_location_location_city_name_` ON `sale_location_location_to_city`.`ID` = `sale_location_location_city_name_`.`LOCATION_ID` LEFT JOIN `b_sale_loc_name` `sale_location_location_country_name_orig_` ON `sale_location_location_to_country`.`ID` = `sale_location_location_country_name_orig_`.`LOCATION_ID` AND `sale_location_location_country_name_orig_`.`LANGUAGE_ID` = 'en' LEFT JOIN `b_sale_loc_name` `sale_location_location_region_name_orig_` ON `sale_location_location_to_region`.`ID` = `sale_location_location_region_name_orig_`.`LOCATION_ID` AND `sale_location_location_region_name_orig_`.`LANGUAGE_ID` = 'en' LEFT JOIN `b_sale_loc_name` `sale_location_location_city_name_orig_` ON `sale_location_location_to_city`.`ID` = `sale_location_location_city_name_orig_`.`LOCATION_ID` AND `sale_location_location_city_name_orig_`.`LANGUAGE_ID` = 'en' LEFT JOIN `b_sale_loc_def2site` `sale_location_location_default_id` ON `sale_location_location`.`CODE` = `sale_location_location_default_id`.`LOCATION_CODE` WHERE UPPER(`sale_location_location_city_name_orig_`.`NAME`) like upper('Moscow') AND (`sale_location_location`.`TYPE_ID` in (1,

Судя по всему это означает превышение значения MySQL у твоего хостинг провайдера на тарифе
Решение use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=#, хотя тут все по умолчанию у нормальных хостеров

можно попробовать пропустить, затем модуль переустановить и отправить на переиндексацию

nononameman · 15 Мар 2016

Seolink09 написал(а):
пробую но потом у меня не работает выбор местопложения хотя они есть

Сделать переиндексацию

Yuryus · 16 Мар 2016

Приветствую.
После обновления Хром возникла проблема в КП (вероятно касается последних и предпоследних версий).
Не создаются задачи.
Создаются по прямой ссылке или открыть ссылку в новом окне.
Ругается на js скрипт

Код:

script.js:109 Uncaught TypeError: Failed to set the 'files' property on 'HTMLInputElement': The provided value is not of type 'FileList'.k @ script.js:109s.callbacks.onBeforePopupShow @ script.js:404BX.Tasks.lwPopup.__runCreateFormCallback @ task-quick-popups.js:184BX.Tasks.lwPopup.showCreateForm @ task-quick-popups.js:266AddQuickPopupTask @ script.js:205onclick @ (index):1881

Может кто подскажет решение?

oxothukszt · 17 Мар 2016

Вопрос такой - у меня есть свеже купленный Аспро шины и диски, как его опубликовать тут и сделать нуллверсию, мб ссылка на тему с инструкцией есть? А вообще я бы поменялся, мне нужен аспро корп. портал, точнее реализация каталога из него, так и нашел Ваш форум

adikWAR · 17 Мар 2016

oxothukszt написал(а):
Вопрос такой - у меня есть свеже купленный Аспро шины и диски, как его опубликовать тут и сделать нуллверсию, мб ссылка на тему с инструкцией есть? А вообще я бы поменялся, мне нужен аспро корп. портал, точнее реализация каталога из него, так и нашел Ваш форум

По логике, Файлы модуля смотрите в папке bitrix/updates. Они и нужны. Но лучше напишите в личку mrLom, он поможет.

m4t · 18 Мар 2016

Добрый день.
Может кто знает, как в правилах обработки настроить для каталога замену разделителей с _ на -

oxothukszt · 18 Мар 2016

m4t написал(а):
Добрый день.
Может кто знает, как в правилах обработки настроить для каталога замену разделителей с _ на -

Помощь Вопросы и решение проблем с Битрикс

Seolink09

Постоялец

nononameman

Мой дом здесь!

Seolink09

Постоялец

oxothukszt

Постоялец

nononameman

Мой дом здесь!

Yuryus

Постоялец

oxothukszt

Постоялец

adikWAR

Постоялец

m4t

Создатель

oxothukszt

Постоялец

Вложения