Jump to content
Sign in to follow this  

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



Share this post

Link to post
Share on other sites
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