problemi star product

[raffy-raffy]

dopo , i vari aggiornamenti dalla versione 4 a 5 , quando attivo , lo start product , sul mio sito , mi da in home page questo errore


1054 - Unknown column 'p.products_id' in 'on clause'

select substring(pd.products_description, 1, 598) as products_description, p.products_id, p.products_image, p.manufacturers_id, p.products_price, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, p.products_tax_class_id, sp.product_id from products p, products_description pd, star_product sp left join specials s on p.products_id = s.products_id where p.products_id = pd.products_id and p.products_status = '1' and pd.products_description != '' and p.products_id=sp.product_id and pd.language_id = '4'

cosa mi consigliate di fare , ho dato un occhio in giro ma non sono riuscita a risolvere il problema.
tnx


disattivando questo , il sito funziona regolarmente

[hsg26]

questo ti può aiutare... la funzione cerca serve:

viewtopic.php?t=9858&highlight=1054

[raffy-raffy]

ti ringrazio per il link e il suggerimento
ma la ricerca lho fatta , prima di creare il post....
ho fatto tutti gli aggiornamenti del caso , ma l'unica cosa che non mi funziona e questa.....
mi potresti spiegare come interpretare questi errori?
grazie ....

[raffy-raffy]

soluzione

da cosi
$star_products_query = tep_db_query("select substring(pd.products_description, 1, 598) as products_description, p.products_id, p.products_image, p.manufacturers_id, p.products_price, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, p.products_tax_class_id, sp.product_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_STAR_PRODUCT . " sp left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_id = pd.products_id and p.products_status = '1' and pd.products_description != '' and p.products_id=sp.product_id and pd.language_id = '" . $languages_id . "'");



a cosi
$star_products_query = tep_db_query("select substring(pd.products_description, 1, 598) as products_description, p.products_id, p.products_image, p.manufacturers_id, p.products_price, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, p.products_tax_class_id, sp.product_id from ( " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_STAR_PRODUCT . " sp ) left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_id = pd.products_id and p.products_status = '1' and pd.products_description != '' and p.products_id=sp.product_id and pd.language_id = '" . $languages_id . "'");

semplice basta saperlo.......
e diventare un po' matta a capirlo...
tnx a tutti...

[hsg26]

ti ringrazio per aver messo la soluzione ben fatto!

[raffy-raffy]

ti ringrazio per aver messo la soluzione ben fatto!

come si dice :
una mano lava l'altra.
grazie a voi