Hi, we have a site www.scontolo.net developed on prestashop 1.6.1.20.
From 26 September we have a big problem on a this qery:
"SELECT s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM ps_shop_url su
LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'www.scontolo.net' OR su.domain_ssl = 'www.scontolo.net')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC"
this query lock tables and db crashed.
Can you help me???