PRoblem afgter upgrade to 1.5.6.2

[mirekcerno]

Hi guys, I need little help..

After upgrade I got one problem with database queries - they can not be finished.

 

I can not open 1 category in the shop, other categories works good...

 

An clue how to fix it?

 

1886633 Query kontaktoma Copying to tmp table 133 SELECT p., productshop., productshop.idcategorydefault, pl., MAX(imageshop.idimage) idimage, il.legend, m.name manufacturername, MAX(pa.idproductattribute) idproductattribute, DATEDIFF(productshop.dateadd, DATESUB(NOW(), INTERVAL 20 DAY)) > 0 AS new, stock.outofstock, IFNULL(stock.quantity, 0) as quantity FROM pscategoryproduct cp LEFT JOIN pscategory c ON (c.idcategory = cp.idcategory) LEFT JOIN psproduct p ON p.idproduct = cp.idproduct INNER JOIN psproductshop productshop ON (productshop.idproduct = p.idproduct AND productshop.idshop = 1) LEFT JOIN psstockavailable stock ON (stock.idproduct = p.idproduct AND stock.idshop = 1 ) LEFT JOIN psproductlang pl ON (pl.idproduct = p.idproduct AND pl.idshop = 1 AND pl.idlang = 6) LEFT JOIN psimage i ON (i.idproduct = p.idproduct) LEFT JOIN psimageshop imageshop ON (imageshop.idimage = i.idimage AND imageshop.idshop = 1 AND imageshop.cover=1) LEFT JOIN psimagelang il ON (imageshop.idimage = il.idimage AND il.idlang = 6) LEFT JOIN psmanufacturer m ON (m.idmanufacturer = p.idmanufacturer) LEFT JOIN psproductattribute pa ON (p.idproduct = pa.idproduct) WHERE productshop.active = 1 AND productshop.visibility IN ("both", "catalog") AND c.nleft >= 3 AND c.nright <= 26 AND c.active = 1 AND p.idproduct IN (74,75,76,77,81,82,83,86,94,95,96,102,103,104,115,121,122,123,125,128,144,145,146,147,148,149,265,272,285,286,382,384,408,409,410,416,417,421,450,451,465,500,501,502,503,574,576,577,578,579,580,581,582,583,584,585,586,587,597,598) GROUP BY productshop.idproduct ORDER BY p.price asc LIMIT 0,100

 

Thx Mirek

 

 

[mirekcerno]

www.kontaktomat.cz is the page....