Error After Update

General General Questions
1

Happy new year all !

After some versions update, every looks fine ....but i can`t acces the product pages... i reciev "Sorry, service is temporarily unavailable." even on admin or front

Similar with this :

https://forum.cs-cart.com/topic/57135-sorry-service-is-temporarily-unavailable/

this is my error source

---------------------------

Tygh\Exceptions\AException

Message

Unknown column ‘cscart_products_categories.category_position’ in ‘field list’ (1054)SELECT

cscart_products., cscart_product_descriptions., MIN(IF(cscart_product_prices.percentage

_discount = 0, cscart_product_prices.price, cscart_product_prices.price - (cscart_product

_prices.price * cscart_product_prices.percentage_discount)/100)) as price, GROUP_CONCAT(

CASE   WHEN (cscart_products_categories.link_type = ‘M’) THEN CONCAT(cscart_products_cate

gories.category_id, ‘M’)   ELSE cscart_products_categories.category_id END ORDER BY cscar

t_categories.company_id = 0 DESC, (cscart_products_categories.link_type = ‘M’) DESC, cscart

products_categories.category_position ASC, cscart_products_categories.category_id ASC) as

category_ids, popularity.total as popularity, cscart_product_sales.amount as sales_amount,

cscart_seo_names.name as seo_name, cscart_seo_names.path as seo_path, cscart_discussion.

type as discussion_type FROM cscart_products LEFT JOIN cscart_product_prices ON cscart

product_prices.product_id = cscart_products.product_id AND cscart_product_prices.lower_limit

= 1  AND cscart_product_prices.usergroup_id IN (0)  LEFT JOIN cscart_product_descriptions

ON cscart_product_descriptions.product_id = cscart_products.product_id AND cscart_product

descriptions.lang_code = ‘ro’ INNER JOIN cscart_products_categories ON cscart_products

categories.product_id = cscart_products.product_id INNER JOIN cscart_categories ON cscart

_categories.category_id = cscart_products_categories.category_id  LEFT JOIN cscart_product

_popularity as popularity ON popularity.product_id = cscart_products.product_id LEFT JOIN

cscart_product_sales ON cscart_product_sales.product_id = cscart_products.product_id AND

cscart_product_sales.category_id = 72 LEFT JOIN cscart_seo_names ON cscart_seo_names.object

_id = 7420 AND cscart_seo_names.type = ‘p’ AND cscart_seo_names.dispatch = ‘’ AND cscart_seo

_names.lang_code = ‘ro’ AND cscart_seo_names.company_id = cscart_products.company_id LEFT

JOIN cscart_discussion ON cscart_discussion.object_id = cscart_products.product_id AND

cscart_discussion.object_type = ‘P’ WHERE cscart_products.product_id = 7420  GROUP BY

cscart_products.product_id


Error at

app/Tygh/Database/Connection.php, line: 1127


Backtrace

File:app/Tygh/Database/Connection.php

Line:491

Function:throwError


File:app/Tygh/Database/Connection.php

Line:271

Function:query


File:app/functions/fn.database.php

Line:56

Function:getRow


File:app/functions/fn.catalog.php

Line:196

Function:db_get_row


File:app/controllers/backend/products.php

Line:665

Function:fn_get_product_data


File:app/functions/fn.control.php

Line:679

Function:include


File:app/functions/fn.control.php

Line:430

Function:fn_run_controller


File:my_admin_page.php

Line:27

Function:fn_dispatch


 →

-----------------------------------------

But: - i disable all dddons

- i repair database

still don`t work

Can anyone another sugestions cause ?!
Thanks

2

found this

..or maybe is not from issue

2020-01-01 18_06_10-Window.png

3

The error suggests that the field "category_position" doesn't exist in table "cscart_products_categories".

If it doesn't exist, run the following query.

ALTER TABLE `cscart_products_categories` ADD `category_position` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0' AFTER `position`;

4

Thanks

This was need

unfortunately I had no patience and i make restore

i disable all addon and start update again

with succes this time