Здравствуйте. Не показываются товары в категориях. Где то показываются, а где то нет. А где то только часть показывается. Товары естественно привязаны к категории, кеш по 1000 раз очищен.
Вот простой пример - веб-камеры. Сайт говорит что камер нет.
Однако админка говорит, что есть такой товар.
Ну так вот, если взять, зайти в эту каждую вебкамеру и ничего не меняя открыть и закрыть, нажимая кнопку Сохранить, то товар начинает показываться в категории.
Почему в админке 5 камер, а на сайте 3? Потому что у меня не показывается отсутствующий товар.
В журнале из последних вот такие записи.
1–19 из 19
Контент Пользователь IP Время
База данных (Ошибка)
Ошибка: 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 ‘’ at line 1 (1064)
Запрос: INSERT INTO cscart_product_bundle_product_links () VALUES
Отслеживание››
ppsultan.php (fn_dispatch): 27
app/functions/fn.control.php (fn_run_controller): 458
app/functions/fn.control.php (include): 722
app/controllers/backend/upgrade_center.php (install): 134
app/Tygh/UpgradeCenter/App.php (installUpgradePackage): 466
app/Tygh/UpgradeCenter/App.php (include_once): 818
var/upgrade/packages/core/content/scripts/post_script.php (db_query): 97
app/functions/fn.database.php (query): 138
app/Tygh/Database/Connection.php (throwError): 699
Главный Андрей — 11.12.2022, 22:23
База данных (Ошибка)
Ошибка: Unknown column ‘desc1.product_id’ in ‘where clause’ (1054)
Запрос: SELECT SQL_CALC_FOUND_ROWS products.product_id, descr1.product as product, companies.company as company_name, products.product_type, products.parent_product_id, descr1.cp_st_h1, descr1.cp_st_custom_bc, IF(COUNT(IF(cscart_categories.company_id = products.company_id, NULL, cscart_categories.company_id)), ‘Y’, ‘N’) as is_shared_product FROM cscart_products as products LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = ‘ru’ LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_id INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id LEFT JOIN cscart_ult_product_descriptions as descr_ult ON descr_ult.product_id = products.product_id AND descr_ult.lang_code = ‘ru’ LEFT JOIN cscart_ult_product_descriptions as descr_copy1 ON descr_copy1.product = descr_ult.product AND descr_copy1.lang_code = ‘ru’ WHERE 1 AND prices.usergroup_id IN (0) AND (desc1.product_id != descr_copy1.product_id OR descr_ult.product_id != descr_copy1.product_id) GROUP BY products.product_id ORDER BY products.list_price desc, products.product_id ASC LIMIT 0, 250
Отслеживание››
ppsultan.php (fn_dispatch): 27
app/functions/fn.control.php (fn_run_controller): 458
app/functions/fn.control.php (include): 722
app/controllers/backend/products.php (fn_get_products): 629
app/functions/fn.products.php ({closure}): 2371
app/functions/fn.products.php (db_get_array): 2288
app/functions/fn.database.php (getArray): 35
app/Tygh/Database/Connection.php (query): 316
app/Tygh/Database/Connection.php (throwError): 699
Главный Андрей — 21.11.2022, 18:47
База данных (Ошибка)
Ошибка: Unknown column ‘desc1.product_id’ in ‘where clause’ (1054)
Запрос: SELECT SQL_CALC_FOUND_ROWS products.product_id, descr1.product as product, companies.company as company_name, products.product_type, products.parent_product_id, descr1.cp_st_h1, descr1.cp_st_custom_bc, IF(COUNT(IF(cscart_categories.company_id = products.company_id, NULL, cscart_categories.company_id)), ‘Y’, ‘N’) as is_shared_product FROM cscart_products as products LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = ‘ru’ LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_id INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id LEFT JOIN cscart_ult_product_descriptions as descr_ult ON descr_ult.product_id = products.product_id AND descr_ult.lang_code = ‘ru’ LEFT JOIN cscart_ult_product_descriptions as descr_copy1 ON descr_copy1.product = descr_ult.product AND descr_copy1.lang_code = ‘ru’ WHERE 1 AND prices.usergroup_id IN (0) AND (desc1.product_id != descr_copy1.product_id OR descr_ult.product_id != descr_copy1.product_id) GROUP BY products.product_id ORDER BY products.list_price desc, products.product_id ASC LIMIT 0, 250
Отслеживание››
ppsultan.php (fn_dispatch): 27
app/functions/fn.control.php (fn_run_controller): 458
app/functions/fn.control.php (include): 722
app/controllers/backend/products.php (fn_get_products): 629
app/functions/fn.products.php ({closure}): 2371
app/functions/fn.products.php (db_get_array): 2288
app/functions/fn.database.php (getArray): 35
app/Tygh/Database/Connection.php (query): 316
app/Tygh/Database/Connection.php (throwError): 699
Главный Андрей — 21.11.2022, 18:47
База данных (Ошибка)
Ошибка: Unknown column ‘desc1.product_id’ in ‘where clause’ (1054)
Запрос: SELECT SQL_CALC_FOUND_ROWS products.product_id, descr1.product as product, companies.company as company_name, products.product_type, products.parent_product_id, descr1.cp_st_h1, descr1.cp_st_custom_bc, IF(COUNT(IF(cscart_categories.company_id = products.company_id, NULL, cscart_categories.company_id)), ‘Y’, ‘N’) as is_shared_product FROM cscart_products as products LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = ‘ru’ LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_id INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id LEFT JOIN cscart_ult_product_descriptions as descr_ult ON descr_ult.product_id = products.product_id AND descr_ult.lang_code = ‘ru’ LEFT JOIN cscart_ult_product_descriptions as descr_copy1 ON descr_copy1.product = descr_ult.product AND descr_copy1.lang_code = ‘ru’ WHERE 1 AND prices.usergroup_id IN (0) AND (desc1.product_id != descr_copy1.product_id OR descr_ult.product_id != descr_copy1.product_id) GROUP BY products.product_id ORDER BY products.list_price desc, products.product_id ASC LIMIT 0, 250
Отслеживание››
ppsultan.php (fn_dispatch): 27
app/functions/fn.control.php (fn_run_controller): 458
app/functions/fn.control.php (include): 722
app/controllers/backend/products.php (fn_get_products): 629
app/functions/fn.products.php ({closure}): 2371
app/functions/fn.products.php (db_get_array): 2288
app/functions/fn.database.php (getArray): 35
app/Tygh/Database/Connection.php (query): 316
app/Tygh/Database/Connection.php (throwError): 699
База данных (Ошибка)
Ошибка: Table ‘cl72201_qvadrar.cscart_product_options_inventory’ doesn’t exist (1146)
Запрос: SELECT SQL_CALC_FOUND_ROWS products.product_id, IF(shared_descr.product_id IS NOT NULL, shared_descr.product, descr1.product) as product, companies.company as company_name, products.product_type, products.parent_product_id, 1 as instock_marker, IF( products.product_type = ‘C’, (SELECT MAX(amount) FROM cscart_products WHERE parent_product_id = products.product_id) > 0, IF( IF( products.tracking = ‘O’, (SELECT MAX(amount) FROM cscart_product_options_inventory s_inventory WHERE s_inventory.product_id = products.product_id) > 0, products.amount > 0 ), 1, IF( products.tracking = ‘D’, 1, 0 ) ) ) as instock_sorting FROM cscart_products as products LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = ‘ru’ LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_id INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = ‘’ OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN (‘A’, ‘H’) AND cscart_categories.storefront_id IN (0, 1) LEFT JOIN cscart_ult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id AND shared_descr.company_id = 1 AND shared_descr.lang_code = ‘ru’ LEFT JOIN cscart_product_required_products ON products.product_id = cscart_product_required_products.required_id LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = products.product_id WHERE 1 AND companies.status IN (‘A’) AND (products.usergroup_ids = ‘’ OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN (‘A’) AND prices.usergroup_id IN (0, 0, 1) AND cscart_product_required_products.product_id = 22750 GROUP BY products.product_id ORDER BY instock_sorting DESC, popularity.total desc, products.product_id ASC
Отслеживание››
index.php (fn_dispatch): 25
app/functions/fn.control.php (fn_run_controller): 458
app/functions/fn.control.php (include): 722
app/controllers/frontend/products.php (fn_get_product_data): 103
app/functions/fn.products.php (fn_set_hook): 376
app/functions/fn.control.php (fn_required_products_get_product_data_post): 123
app/addons/required_products/func.php (fn_get_products): 35
app/functions/fn.products.php ({closure}): 2371
app/functions/fn.products.php (db_get_array): 2288
app/functions/fn.database.php (getArray): 35
app/Tygh/Database/Connection.php (query): 316
app/Tygh/Database/Connection.php (throwError): 699
— — 11.11.2022, 00:11
База данных (Ошибка)
Ошибка: Table ‘cl72201_qvadrar.cscart_product_options_inventory’ doesn’t exist (1146)
Запрос: SELECT SQL_CALC_FOUND_ROWS products.product_id, IF(shared_descr.product_id IS NOT NULL, shared_descr.product, descr1.product) as product, companies.company as company_name, products.product_type, products.parent_product_id, 1 as instock_marker, IF( products.product_type = ‘C’, (SELECT MAX(amount) FROM cscart_products WHERE parent_product_id = products.product_id) > 0, IF( IF( products.tracking = ‘O’, (SELECT MAX(amount) FROM cscart_product_options_inventory s_inventory WHERE s_inventory.product_id = products.product_id) > 0, products.amount > 0 ), 1, IF( products.tracking = ‘D’, 1, 0 ) ) ) as instock_sorting FROM cscart_products as products LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = ‘ru’ LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN cscart_companies AS companies ON companies.company_id = products.company_id INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = ‘’ OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND cscart_categories.status IN (‘A’, ‘H’) AND cscart_categories.storefront_id IN (0, 1) LEFT JOIN cscart_ult_product_descriptions shared_descr ON shared_descr.product_id = products.product_id AND shared_descr.company_id = 1 AND shared_descr.lang_code = ‘ru’ LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = products.product_id WHERE 1 AND companies.status IN (‘A’) AND products.product_id IN (11868, 11873, 11883, 12136, 15143, 15263, 15340, 11784, 15386, 15383, 15397, 15399, 12658, 12909, 15712) AND (products.usergroup_ids = ‘’ OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND products.status IN (‘A’) AND prices.usergroup_id IN (0, 0, 1) GROUP BY products.product_id ORDER BY instock_sorting DESC, popularity.total desc, products.product_id ASC
Обновите модуль сортировки по наличию
Этот модуль сортировки по наличию вообще у меня не заработал, я его поставил, у меня сайт высветился как на Обеде, че то там Авалибл, мол не работает, и я сразу же вообще его отключил.
В общем он тут не причем.
А проблема по теме еще задолго до этого появилась. Я просто как то не обращал внимание, тем более что у меня показ по наличию. То ли там в наличии временно скйчас нет, то ли еще чего.
Вот еще что хотел добавить. Эта проблема связана вероятно не напрямую с категориями.
У меня на главной сделаны слайдеры и они вручную заполнены товарами. И вот вчера смотрю, а товаров в этих слайдерах стало маловато.
Сначала решил что может их нет в наличии, потому пусто. Но нет, я так же зашел в каждый и закрыл его, сохранив и ничего не меняя. И товар снова стал показываться.
Где у товара хранится информация где и кому показываться? Такое ощущение что эта информация устаревает а при пересохранении она как бы обновляется, эта инфа.
По крайней мере ошибка, которую вы постили точно связана с этим модулем (причем со старой версией)
Насчет ошибки с модулем.
Вчера решил снова его поставить. Ставится номер 1,9. Новее нет. Если он и есть ничего не прилетало в центр обновления. Ошибка в журнале снова возникла.
Оставьте заявку у нас на сайте, посмотрим