Не генерится Yml. использую модуль yml export, старый я.маркет удален.
При попытке начать генерацию 503 ошибка и в логах cs-cart
База данных (Ошибка) Ошибка: Unknown column 'p.yml2_fee' in 'field list' (1054) Запрос: SELECT p.product_id, p.product_code, d.lang_code, pc.category_id, cd.category, pp.price, p.list_price, p.status, p.amount, p.weight, p.shipping_freight, p.shipping_params, p.free_shipping, d.product, d.short_description, d.full_description, p.company_id, p.tracking, p.list_price, p.is_edp, p.yml2_brand, p.yml2_origin_country, p.yml2_store, p.yml2_pickup, p.yml2_delivery, p.yml2_delivery_options, p.yml2_bid, p.yml2_cbid, p.yml2_fee, p.yml2_model, p.yml2_sales_notes, p.yml2_type_prefix, p.yml2_offer_type, p.yml2_market_category, p.yml2_manufacturer_warranty, p.yml2_expiry, p.yml2_purchase_price, p.yml2_description, p.yml2_cpa, ( SELECT GROUP_CONCAT(IF(pc2.link_type = 'M', CONCAT(pc2.category_id, 'M'), pc2.category_id)) FROM cscart_products_categories as pc2 WHERE product_id = p.product_id ) as category_ids FROM cscart_products as p LEFT JOIN cscart_product_descriptions as d ON d.product_id = p.product_id AND d.lang_code = 'ru' LEFT JOIN cscart_product_prices as pp ON pp.product_id = p.product_id AND pp.lower_limit = 1 AND pp.usergroup_id = 0 LEFT JOIN cscart_products_categories as pc ON pc.product_id = p.product_id AND pc.link_type = 'M' LEFT JOIN cscart_category_descriptions as cd ON cd.category_id = pc.category_id AND cd.lang_code = 'ru' WHERE p.product_id IN(7, 6, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 108) GROUP BY p.product_id Отслеживание››index.php (fn_dispatch): 25
app/functions/fn.control.php (fn_run_controller): 456
app/functions/fn.control.php (include): 700
app/addons/yml_export/controllers/frontend/yml.php (generate): 59
app/addons/yml_export/Tygh/Ym/Yml2.php (body): 255
app/addons/yml_export/Tygh/Ym/Yml2.php (generateOffers): 375
app/addons/yml_export/Tygh/Ym/Yml2.php (db_get_array): 716
app/functions/fn.database.php (call_user_func_array): 28
app/Tygh/Database/Connection.php (getArray): 229
app/Tygh/Database/Connection.php (query): 488
При попытке выгрузить в csv через экспорт ИД товара + все отвечающее за экспорт в yml
База данных (Ошибка)
Ошибка: Unknown column 'products.yml2_fee' in 'field list' (1054)
Запрос: SELECT products.product_id, products.product_code as "Product code", product_descriptions.lang_code as "Language", products.product_id as "Product id", products.yml2_brand as "YML Brand", products.yml2_origin_country as "YML Country of origin", products.yml2_store as "YML Allow retail store purchase", products.yml2_pickup as "YML Allow booking and self delivery", products.yml2_adult as "YML Adult", products.yml2_delivery as "YML Allow delivery", products.yml2_delivery_options as "YML Allow delivery options", products.yml2_bid as "YML Basic bid", products.yml2_cbid as "YML Card bid", products.yml2_fee as "YML Fee", products.yml2_model as "YML Model", products.yml2_sales_notes as "YML Sales notes", products.yml2_type_prefix as "YML typePrefix", products.yml2_offer_type as "YML Offer type", products.yml2_market_category as "YML Market category", products.yml2_manufacturer_warranty as "YML Manufacturer warranty", products.yml2_expiry as "YML Lifetime", products.yml2_cpa as "YML Market Ordering", products.yml2_description as "YML Description" FROM cscart_products as products LEFT JOIN cscart_product_descriptions as product_descriptions ON product_descriptions.product_id = products.product_id AND product_descriptions.lang_code IN ('ru') LEFT JOIN cscart_product_prices as product_prices ON product_prices.product_id = products.product_id AND product_prices.lower_limit = 1 AND product_prices.usergroup_id = 0 LEFT JOIN cscart_images_links as images_links ON images_links.object_id = products.product_id AND images_links.object_type = 'product' AND images_links.type = 'M' LEFT JOIN cscart_companies as companies ON companies.company_id = products.company_id LEFT JOIN cscart_seo_names as seo_names ON seo_names.object_id = products.product_id AND seo_names.type = 'p' AND seo_names.dispatch = '' AND seo_names.lang_code = product_descriptions.lang_code AND seo_names.company_id = products.company_id WHERE products.company_id = 1 LIMIT 0, 30
Отслеживание››
admin.php (fn_dispatch): 27
app/functions/fn.control.php (fn_run_controller): 456
app/functions/fn.control.php (include): 700
app/controllers/backend/exim.php (fn_export): 105
app/functions/fn.exim.php (db_get_array): 152
app/functions/fn.database.php (call_user_func_array): 28
app/Tygh/Database/Connection.php (getArray): 229
app/Tygh/Database/Connection.php (query): 488
В логах на сервере нет ни каких ошибок.
Подскажите, пожалуйста, куда лезть смотреть?
