product module issue after upgrade.

[tonyg]

hi,
i just upgraded to 1.11.7 and product module 2.19.5. after the upgrade, pages with tags like this

Code: Select all

{Products action="default" hierarchy="Wideband Receivers" summarytemplate="Fl-Main-Summary"}

show this error

INTERNAL ERROR: Query failed - SELECT SQL_CALC_FOUND_ROWS C.*,PH.hierarchy_id FROM cms_module_products C LEFT JOIN cms_module_products_prodtohier PH ON PH.product_id = C.id LEFT JOIN cms_module_products_prodtohier ph ON ph.product_id = C.id WHERE C.status = 'published' AND ph.hierarchy_id IN (3) ORDER BY product_name asc LIMIT 0, 10000 -- Not unique table/alias: 'ph'

here is an example
http://www.ultra-fei.com/receivers

any help would be greatly appreciated!!

[tonyg]

ok, i see the note in the changelog about the upgrade to 2.19.5 breaking things, but i don't see anything about HOW to upgrade. Is there a way to convert so i can upgrade, or are you saying i have to delete all products and re-create?

please point me in the right direction

thanks

[tonyg]

hi, i just tried to upgrade products module again and am getting the same results.

has anyone had this issue? can anyone give me a hand with getting this working?

thanks much!!!