contribution,4654 problem

[marcino]

Hi, I think, I've found contribution which supposed to help me to solve my problem but... I don't know how to use that contribution :/ There is no instruction, nothing. Can you help me. That's regarding contribution,4654. Apparently, I ve got this error:

 

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'

 

Additionally, none of the pictures seems to appear on the main page. It's weird because everything is working perfect on my local machine. It' doesn't work when I transfer my website to the server.

 

Many Thanks.

[♥geoffreywalton]

Try checking the version of mysql you are using on both machines.

 

If you are using 4 on 1 and 5 on another try this link

 

http://addons.oscommerce.com/info/3727

[marcino]

Thank You geoffreywalton :) You are very helpful. This is what I was looking for! There is no 1054 errors anymore! Finally database work perfect.

 

Another problem I have is that when I transfer my page to the server all pictures on the page are broken. None of the pictures seems to appear: heading pictures, logos, products image, etc. Only text comes up on the page. If you guys know what causes that problem, please reply.

Many Thanks