Kemi Posted March 26, 2008 Share Posted March 26, 2008 This is sort of a long story but to make it short... my hosting company, who is a reseller I found out, did a server upgrade and my store has been broken ever since and they won't fix it. They told me it's a code problem and someone else will have to fix it. Funny it wasn't needing fixing until they did the server upgrade. If someone out there could help please? :( http://www.sacredkiln.com You can see the code error messages on most of the category pages as well I get a similar error when I generate a pdf catalog. Thank you, Kemi Link to comment Share on other sites More sharing options...
web-project Posted March 26, 2008 Share Posted March 26, 2008 try this contribution: http://www.oscommerce.com/community/contributions,4654 Please read this line: Do you want to find all the answers to your questions? click here. As for contribution database it's located here! 8 people out of 10 don't bother to read installation manuals. I can recommend: if you can't read the installation manual, don't bother to install any contribution yourself. Before installing contribution or editing/updating/deleting any files, do the full backup, it will save to you & everyone here on the forum time to fix your issues. Any issues with oscommerce, I am here to help you. Link to comment Share on other sites More sharing options...
Kemi Posted March 26, 2008 Author Share Posted March 26, 2008 try this contribution:http://www.oscommerce.com/community/contributions,4654 Thank you, I will check this out. :thumbsup: Link to comment Share on other sites More sharing options...
Kemi Posted March 26, 2008 Author Share Posted March 26, 2008 Alex thank you very much that worked for most of the issues very nicely. However I still have errors in two places. 1. If you go to this url http://www.sacredkiln.com/product_info.php...products_id=789 and click under manufacturer info on the link to other products. Not working... you should have a pull down menu of other products. 2. Still get errors generating a pdf catalog. 1054 - Unknown column 'p.products_id' in 'on clause' select p.products_id, pd.products_name, pd.products_description, p.products_image, p.products_model, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c where products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id order by p.products_date_added DESC, pd.products_name [TEP STOP] Keep in mind that a former partner of mine has modified much code in here and I have no idea what. Thank you very much for your help. Kemi Link to comment Share on other sites More sharing options...
Kemi Posted March 26, 2008 Author Share Posted March 26, 2008 Cool, I have number 1. error fixed so my drop down menu is working. Just have to fix the pdf catalog now. Link to comment Share on other sites More sharing options...
vectorprint Posted March 26, 2008 Share Posted March 26, 2008 Cool, I have number 1. error fixed so my drop down menu is working. Just have to fix the pdf catalog now. Hi, you have a column missing in your database, there is a subject about how to fix that in this forum, just a simple mysql command will sort it out. Search the forum with that error as the subject and you should find it easy enough Regards. Stephen 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.