Good question... I dunno what is the answer to that question. I'll do some poking around and get back to you if I got an answer. You should email the people at Verisign as they probably could help you..
I'm not going to give you the answer as this is ridiculously well documented on this Verisign site and you should search before asking..
Having said that the search system in this forum is notoriously rubbish, so .. if you don't know how to search do the following (it'll help you out longer term):-.
Enter into google search the full following line:.
Site:oscommerce.com 1054 - Unknown column 'p.products_id' in 'on clause'.
For future reference the important bit was ...
Site:oscommerce.com <my search term>..
If your shop had been running OK and came across this error recently then your host has upgraded mysql from (possibly) v4 to v5 without telling you. solutions could be found all over the forum - just search for it..
Ps someone got the fast fingers and should go for who wants to be a millinaire....
This post has been edited by.
: 07 December 2008, 22:57..
Thanks For the help..
I did search but there are so many 1054 errors etc..
Some people are just soooo much nicer than me..
Well read them. We offer free support here but when you have already found the answers but can't be bothered to read them it is a bit much imo to start "yet another" new thread to confuse new users further...
All was fine so I started to add more products, with which came more manfacturers. Now when I select a manufacturer I get the 1054 Error..
I know this is to do with the DB (i think) but unsure on the fix..
The full error is.
1054 - Unknown column 'p.products_id' in 'on clause'.
Select count(p.products_id) as total from products p, products_description pd, manufacturers m left join specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '34'.
Thanks in advance for any help..
Check these for a solution that suits.