Метод | Статус | |
Список упражнений |
Работает |
|
Список Клиентов |
Работает |
|
Список продуктов |
Не работает |
503|Ошибка при выполнении запроса в БД|constructor|products_list2|getFilteredProductsList_2_2 Error SQL "
SELECT
v2_products.id as item_id,
v2_products.expert_id,
v2_products.org_id,
v2_products.categ,
v2_products.caption,
v2_products.caption_alias,
v2_products.proteins_in_gr,
v2_products.fats_in_gr,
v2_products.carbs_in_gr,
v2_products.cellulose_in_gr,
v2_products.kkal,
v2_products.img,
v2_products.picture,
v2_products.picture_orig,
v2_products.picture_local,
v2_products.timestamp as date_add,
v2_products.calc_used,
v2_products.calc_vit_fullness,
(SELECT GROUP_CONCAT( `season_id`) FROM v2_products_seasonality WHERE `product_id`= item_id) as seasonality
FROM v2_products
WHERE v2_products.is_deleted=0 AND v2_products.org_id IN (44,5) ORDER BY calcOrder ASC LIMIT -25,25"; error="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 '-25,25' at line 25" [#1064]
|
Список блюд |
Не работает |
503|Ошибка при выполнении запроса в БД|constructor|dishes_list2|getFilteredDishesList_2_2 Error SQL "
SELECT
v2_dishes.id as item_id,
v2_dishes.expert_id,
v2_dishes.caption,
v2_dishes.org_id,
v2_dishes.categ,
v2_dishes.recipe,
v2_dishes.proteins_on_100,
v2_dishes.fats_on_100,
v2_dishes.carbs_on_100,
v2_dishes.cellulose_on_100,
v2_dishes.kkal_on_100,
v2_dishes.img,
v2_dishes.picture,
v2_dishes.picture_orig,
v2_dishes.picture_local,
v2_dishes.prepare_time,
v2_dishes.calc_used,
v2_dishes.timestamp as date_add,
(
SELECT GROUP_CONCAT(v2_dishes_destinations.id SEPARATOR '|') FROM v2_dishes_TO_destinations
LEFT JOIN v2_dishes_destinations ON (v2_dishes_destinations.id=v2_dishes_TO_destinations.destination_id)
WHERE v2_dishes_TO_destinations.dish_id=item_id
) AS destination,
(SELECT GROUP_CONCAT(v2_dishes_dietaries.id SEPARATOR '|') FROM v2_dishes_TO_dietaries
RIGHT JOIN v2_dishes_dietaries ON (v2_dishes_dietaries.id=v2_dishes_TO_dietaries.dietary_id)
WHERE v2_dishes_TO_dietaries.dish_id=item_id) AS dietary,
(SELECT GROUP_CONCAT(v2_dishes_prepare_methods.id SEPARATOR '|') FROM v2_dishes_TO_prepare_methods
RIGHT JOIN v2_dishes_prepare_methods ON (v2_dishes_prepare_methods.id=v2_dishes_TO_prepare_methods.prepare_method_id)
WHERE v2_dishes_TO_prepare_methods.dish_id=item_id) AS prepare_method
FROM v2_dishes
WHERE v2_dishes.is_deleted=0 AND v2_dishes.org_id IN (44,5) ORDER BY calcOrder ASC LIMIT -25,25"; error="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 '-25,25' at line 43" [#1064]
|