database error 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 'asc, product_id ASC LIMIT 0, 24' at line 1 (1064)
i get this message in logs, from the admin panel, do you think this has something to do with my issue, i can access all the other section for admin, categories too, only when i click the products i get the error in my first message,
Before you go digging too deep, disalble any 3rd party addons and see if problem goes away. If so, enable 1 by 1 till problem returns and then contact the vendor of that addon.
This is the whole error i get in the logs continuosly:
Database (error) 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 'asc, product_id ASC LIMIT 0, 24' at line 1 (1064) Query:SELECT SQL_CALC_FOUND_ROWS products.product_id, descr1.product as product, companies.company as company_name, IF(images_links.detailed_id IS NULL OR images_links.detailed_id=0, 0, 1) as images FROM cscart_products as products LEFT JOIN cscart_images_links AS images_links ON products.product_id = images_links.object_id AND images_links.type="M" AND images_links.object_type="product" LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'en' 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') WHERE 1 AND companies.status = '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 products.approved = 'Y' AND IF(images_links.detailed_id IS NULL OR images_links.detailed_id=0, 1, 0)=0 GROUP BY products.product_id ORDER BY images desc, asc, product_id ASC LIMIT 0, 24
Before you go digging too deep, disalble any 3rd party addons and see if problem goes away. If so, enable 1 by 1 till problem returns and then contact the vendor of that addon.
Did you also disable my_changes addon? Many times developers will use it instead of a separate addon if they consider the change to be smallish. You're obviosouly missing a column name in the ORDER BY clause. Generally internal cs-cart SQL will NOT use lower case for SQL keywords.
ORDER BY images desc, asc, product_id ASC LIMIT 0, 24
Did you also disable my_changes addon? Many times developers will use it instead of a separate addon if they consider the change to be smallish. You're obviosouly missing a column name in the ORDER BY clause. Generally internal cs-cart SQL will NOT use lower case for SQL keywords.
ORDER BY images desc, asc, product_id ASC LIMIT 0, 24
Before you go digging too deep, disalble any 3rd party addons and see if problem goes away. If so, enable 1 by 1 till problem returns and then contact the vendor of that addon.
Hi all
I disable all addons
after i work something else, i click ENABLE all addon ... and broke with same 500 error
if i rename ADDONS folder name i can login to admin and see all my orders and details of them
but i don`t have top menu with settings, design, etc