Jump to content
Sign in to follow this  
LEDestock

Probleme module Gsitemap

Recommended Posts

Salut à tous,

 

Voilà petit soucis dès que j'essaie de générer mon sitemap.xml , j'ai ceci :

 

 

Column 'date_upd' in field list is ambiguous

 

SELECT p.id_product, pl.link_rewrite, DATE_FORMAT(IF(date_upd,date_upd,date_add), '%Y-%m-%d') date_upd, pl.id_lang, cl.`link_rewrite` category, ean13, i.id_image, il.legend legend_image, (

SELECT MIN(level_depth)

FROM ps_product p2

LEFT JOIN ps_category_product cp2 ON p2.id_product = cp2.id_product

LEFT JOIN ps_category c2 ON cp2.id_category = c2.id_category

WHERE p2.id_product = p.id_product AND p2.`active` = 1 AND c2.`active` = 1) AS level_depth

FROM ps_product p

LEFT JOIN ps_product_lang pl ON (p.id_product = pl.id_product)

LEFT JOIN `ps_category_lang` cl ON (p.`id_category_default` = cl.`id_category` AND pl.`id_lang` = cl.`id_lang`)

LEFT JOIN ps_image i ON p.id_product = i.id_product

LEFT JOIN ps_image_lang il ON (i.id_image = il.id_image)

LEFT JOIN ps_lang l ON (pl.id_lang = l.id_lang)

WHERE l.`active` = 1 AND p.`active` = 1 AND i.cover = 1 GROUP BY id_product, id_lang, id_image

 

ORDER BY pl.id_product, pl.id_lang ASC

 

Une idée d'où ça pourrait venir ?

 

J'ai même testé le module fixé par Prestochangeo et toujours le même soucis.

Je suis en 1.4.5.1

 

Merci

Share this post


Link to post
Share on other sites
Guest
This topic is now closed to further replies.
Sign in to follow this  

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More