Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Error on View product page ***HELP***


Guest

Recommended Posts

Hey can anyone help me.... here is what is showing up on my view products page

 

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 = '21'

 

[TEP STOP]

Link to comment
Share on other sites

Hey can anyone help me.... here is what is showing up on my view products page

 

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 = '21'

 

[TEP STOP]

 

 

Did you install any contributions?

 

And one post will usually get you your answer.

Just between us, remember there are only 10 kinds of people in the world; those who understand binary and those who don't!!

 

Remember, learning is a "do-it-yourself" experience; although, not necessarily a "do-it-BY-yourself" experience.

 

The quickest way to learn is to forget to BACKUP!

Link to comment
Share on other sites

Hey can anyone help me.... here is what is showing up on my view products page

 

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 = '21'

 

[TEP STOP]

 

change this

 

p.products_id

 

to this

 

p2c.products_id

 

And see if that solves the problem

Regards

 

Mark A Reynolds

Link to comment
Share on other sites

Did you install any contributions?

 

And one post will usually get you your answer.

I didnt mean to multiple post, my computer seems to take forever to load this site.

 

Yes there are several contributions, this is on my development server, I downloaded a what was supposed to be a complete package and well its complete excepr for the view product detail

 

would anyone be wiling to login and check it out or me please? I am new to all this

 

Joe

Link to comment
Share on other sites

I didnt mean to multiple post, my computer seems to take forever to load this site.

 

Yes there are several contributions, this is on my development server, I downloaded a what was supposed to be a complete package and well its complete excepr for the view product detail

 

would anyone be wiling to login and check it out or me please? I am new to all this

 

Joe

would someone be willing to log into m dev serverand check ths problem out, I will send somethin form my store for the one who helps me fix this problem -- email me for details

[email protected]

Link to comment
Share on other sites

This sounds like a contribution problem. You installed a contribution that has fields in it that are not in your database. Continue to attempt to run the program, every time it gives you in error, go into the program and comment out all references to that particular field.

 

Run it again. It will probably come up with the same error but a different field. Do the same as above.

 

My guess is that after about 8 times through and commenting out the fields not relevant to your setup, all will be fine.

 

Or you can lookup that last contribution in the contributions section and there might be a suggested fix.

Just between us, remember there are only 10 kinds of people in the world; those who understand binary and those who don't!!

 

Remember, learning is a "do-it-yourself" experience; although, not necessarily a "do-it-BY-yourself" experience.

 

The quickest way to learn is to forget to BACKUP!

Link to comment
Share on other sites

This sounds like a contribution problem. You installed a contribution that has fields in it that are not in your database. Continue to attempt to run the program, every time it gives you in error, go into the program and comment out all references to that particular field.

 

Run it again. It will probably come up with the same error but a different field. Do the same as above.

 

My guess is that after about 8 times through and commenting out the fields not relevant to your setup, all will be fine.

 

Or you can lookup that last contribution in the contributions section and there might be a suggested fix.

 

I honestly do not know where to check, I am a cut and paste specialist, I really dont evenknow where to begin

 

Joe

Link to comment
Share on other sites

Mate, did you check the earlier posts offering suggestions in this thread from myself and Crash??

yes, I went through the entire site and couldnt find it anywhere

 

dev.fournierelectronics.com

 

Joe

Link to comment
Share on other sites

crap

I lost the image on the right side

 

look at dev.fournierelectronics.com/catalog

 

the HOME page should look like the MEMBERS page

 

anyoneknow how to get the image back?

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...