Troubleshooting Online Store

[Alexcordy32]

Hey guys, i have a website, BoxingFanaticz.com. A friend of mine help me put it together. Recently I cannot browse the site and I have no idea why. The error message is the following:

 

Let's See What We Have Here

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

 

select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '27'

 

[TEP STOP]'

 

I have very little knowledge of how to go about fixing this so any information would be greatly appreciated. Thank You.

[bill110]

Hey guys, i have a website, BoxingFanaticz.com. A friend of mine help me put it together. Recently I cannot browse the site and I have no idea why. The error message is the following:

 

Let's See What We Have Here

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

 

select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '27'

 

[TEP STOP]'

 

I have very little knowledge of how to go about fixing this so any information would be greatly appreciated. Thank You.

maybe this will help you

http://www.oscommerce.com/community/bugs,3171

[desidil4ever]

Guess u fixed it:)

nice design...simple yet very eye catching:)

[Alexcordy32]

Thanks for the help. I read almost all of the post and i'm still very confused as to how to fix this. Would there be someplace I could go to have a webdesigner maybe look over the code and fix it for a fee?

[Gameprodigy]

this article might help you a little better

 

http://www.oscommerce.com/community/bugs,3259

 

before making any changes I recommend making a back up copy of any file you intend to change, so that you can always upload them over again if something goes terribly wrong.

 

On every bug report i saw it said this was corrected in the 2.2 milestone version you may have to update but don't just take my advice keep poking around until you find sufficient help.