lunesse Posted January 25, 2006 Posted January 25, 2006 I removed the basic categories today in a new store and put in three new ones. I noticed when I saved an error came up the corner that there was no file upload. when I click on a category, I get this: 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] Are the two connected? My install was clean with no problems, but it seems like something is not connecting. I can add products and see them just fine...but click on a category header and boom. http://www.artisanbeads.com/index.php?cPath=21 Never had this issue before. Help? I'm not the strongest at databases. Thank you!
Gil_e_n Posted January 25, 2006 Posted January 25, 2006 I just got that error too, oddly enough. Just after importing my database into my testing area on my computer. I'm currently in the process of looking over my database to see any errors, but outside input would be welcome. Always BACK UP your files and your database before making any changes. Before asking questions, check out the Knowledge Base. Check out the contributions to see if your problem's solved there. Search the forums. Useful threads: Store Speed Optimization How to make a horrible shop Basics for design change How to search the forums Useful contributions: Easypopulate Fast, Easy Checkout Header Tag Controller
programcimusti Posted January 25, 2006 Posted January 25, 2006 I just got that error too, oddly enough. Just after importing my database into my testing area on my computer. I'm currently in the process of looking over my database to see any errors, but outside input would be welcome. Sorry I have same problem can you describe as detail, how can we satisfy our problem... you can see from here http://www.kaner.net:8080/catalog/index.ph...35186e920afa1d9
lunesse Posted January 25, 2006 Author Posted January 25, 2006 Sorry I have same problem can you describe as detail, how can we satisfy our problem... you can see from here http://www.kaner.net:8080/catalog/index.ph...35186e920afa1d9 I just ran a sql check and it can't find products_id select count(products_id) from 'product_description' yielded: #1054 - Unknown column 'products_id' in 'field list'
Guest Posted January 25, 2006 Posted January 25, 2006 See Mike's notes and follow the links: http://www.oscommerce.com/forums/index.php?s=&...ndpost&p=780781
lunesse Posted January 25, 2006 Author Posted January 25, 2006 See Mike's notes and follow the links:http://www.oscommerce.com/forums/index.php?s=&...ndpost&p=780781 wow, thanks, that fixed it. =)
lunesse Posted January 25, 2006 Author Posted January 25, 2006 wow, thanks, that fixed it. =) or not. Crap. Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /home/.doubleday/photoboy/artisanbeads.com/admin/includes/functions/database.php on line 19 Unable to connect to database server! how on earth could that get screwed up? great.
Guest Posted January 25, 2006 Posted January 25, 2006 double check the mods you've made. The update works and addresses that particular problem. Becareful with contributions you may have and some of the queries may have been changed.
lunesse Posted January 25, 2006 Author Posted January 25, 2006 double check the mods you've made. The update works and addresses that particular problem. Becareful with contributions you may have and some of the queries may have been changed. hm I only had 2 and they were just cosmetic. I moved the files over, all of them, since I barely touched any of them, anything that would have been overwritten is small. My stuff is on dreamhost. If the sql instance died I can't restart it.
lunesse Posted January 25, 2006 Author Posted January 25, 2006 hm I only had 2 and they were just cosmetic. I moved the files over, all of them, since I barely touched any of them, anything that would have been overwritten is small. My stuff is on dreamhost. If the sql instance died I can't restart it. Ok, finally got that going. And now all my links have no / so it's like www.artisanbeads.comaccount.php every time I think I have got it all working...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.