RainDrop Tech Posted August 15, 2006 Share Posted August 15, 2006 Ok, in addition to my problem I listed before with the admin panel (you can find it HERE), I am now getting this error when trying to browse my catalog. Any help would be greatly appreciated. I am willing to pay to have this fixed. 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 = '19' [TEP STOP] I know that the admin panel problem has something to do with my .htaccess, but I have no clue how to fix that. Again, someone please help as this is hindering process on starting my store. Thanks! Link to comment Share on other sites More sharing options...
mtechama Posted August 15, 2006 Share Posted August 15, 2006 Ok, in addition to my problem I listed before with the admin panel (you can find it HERE), I am now getting this error when trying to browse my catalog. Any help would be greatly appreciated. I am willing to pay to have this fixed. 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 = '19' [TEP STOP] I know that the admin panel problem has something to do with my .htaccess, but I have no clue how to fix that. Again, someone please help as this is hindering process on starting my store. Thanks! hey see if this might help you I am using this and I love it http://www.oscommerce.com/community/contri...in+login+logoff Wade Morris Amarillo, Texas Before you do any changes on your site you need to do BACKUP! BACKUP! Link to comment Share on other sites More sharing options...
RainDrop Tech Posted August 15, 2006 Author Share Posted August 15, 2006 You're awesome. I will install it now. Thanks for the help! Link to comment Share on other sites More sharing options...
Guest Posted August 15, 2006 Share Posted August 15, 2006 Yeah, I agree. It's nice and safe. I use both. Be careful who you trust because they'll need access to sensitive areas in order to fix your troubles. If you saved a backup, you can go back to it and try whatever contribution you were adding again. Link to comment Share on other sites More sharing options...
RainDrop Tech Posted August 15, 2006 Author Share Posted August 15, 2006 Unfortunately, that did not work either. I can still gain acess without a user/pass. Any other suggestions? Link to comment Share on other sites More sharing options...
Guest Posted August 15, 2006 Share Posted August 15, 2006 why not try this? http://www.freewebmasterhelp.com/tutorials/htaccess/3 it will protect EVERYTHING in /admin not just whatever that contribution tells you to protect. there's a link to generate an encrypted password as well of course, if you have cpanel, don't use this. password protect /admin via cpanel instead - it's safer. Link to comment Share on other sites More sharing options...
RainDrop Tech Posted August 15, 2006 Author Share Posted August 15, 2006 You know, I'm sure if it wasn't almost midnight, I would have remembered to do that. Thanks for the swift kick... Link to comment Share on other sites More sharing options...
RainDrop Tech Posted August 16, 2006 Author Share Posted August 16, 2006 OK, got the password problem fixed, anyone care to help on the SQL error? Link to comment Share on other sites More sharing options...
Wendy James Posted August 16, 2006 Share Posted August 16, 2006 http://www.oscommerce.com/community/bugs,3...+Unknown+column Wendy James Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep. Link to comment Share on other sites More sharing options...
RainDrop Tech Posted August 16, 2006 Author Share Posted August 16, 2006 Thanks for the link...lol. I looked at that once before and have no clue what any of that means... Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.