Guest Posted October 24, 2006 Posted October 24, 2006 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]
ComicWisdom Posted October 24, 2006 Posted October 24, 2006 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!
crash3903 Posted October 24, 2006 Posted October 24, 2006 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
Guest Posted October 24, 2006 Posted October 24, 2006 Try this thread. And remember, search features and Google are your friends. ;)
Guest Posted October 24, 2006 Posted October 24, 2006 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
Guest Posted October 24, 2006 Posted October 24, 2006 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]
ComicWisdom Posted October 25, 2006 Posted October 25, 2006 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!
Guest Posted October 25, 2006 Posted October 25, 2006 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
Guest Posted October 25, 2006 Posted October 25, 2006 I honestly do not know where to check, I am a cut and paste specialist, I really dont evenknow where to begin Joe anyone?????
Guest Posted October 25, 2006 Posted October 25, 2006 anyone????? Mate, did you check the earlier posts offering suggestions in this thread from myself and Crash??
Guest Posted October 25, 2006 Posted October 25, 2006 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
Guest Posted October 25, 2006 Posted October 25, 2006 SOLVED!!! THANK YOU Bennstein -- the thread you posted was the solution Joe
Guest Posted October 25, 2006 Posted October 25, 2006 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?
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.