leathersmith Posted June 12, 2008 Share Posted June 12, 2008 now I get a lot of 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 = '41' [TEP STOP] as it happens, no one has maintained an up-to-date backup; the most recent one is from 2005. Its an older version that I stripped the shopping cart from to use more as a content management thing I have no idea who did what to my installation but I would rather have someone well versed help the website owner, as I have too many irons in the fire these days this is actually a paying gig; via paypal here is the website: A Special Event Link to comment Share on other sites More sharing options...
sLaV- Posted June 12, 2008 Share Posted June 12, 2008 Ok was having same issue a while back...this seemed to fix my problem...please make a backup of your files before attempting it: If you get this message it is probably due to your server upgrading to php5 or MySQL5. You get the message when you try a search on your site. The new OSC from around Sept-Oct 2006 or so, doesn't have this problem. You just need to change one section in index.php and one in advance search_result.php. Very simple Good Luck! Ozstar CLICK ME Link to comment Share on other sites More sharing options...
leathersmith Posted June 12, 2008 Author Share Posted June 12, 2008 that makes sense: I have not worked on the website in over 2 years and in the meantime I am told is "something was upgraded" and then it broke! can you specify more about which lines in those 2 pages to modify? Link to comment Share on other sites More sharing options...
sLaV- Posted June 12, 2008 Share Posted June 12, 2008 that makes sense: I have not worked on the website in over 2 years and in the meantime I am told is "something was upgraded" and then it broke! can you specify more about which lines in those 2 pages to modify? goto this page and on the right (next to the date 11 Nov 2006) theres a download button...click that and you will download a .zip file with a txt file explaining all lines that are needed to be updated with what ... follow this and reupload the index.php and advanced_search.php files edited and away you go :) Link to comment Share on other sites More sharing options...
leathersmith Posted June 12, 2008 Author Share Posted June 12, 2008 so cool! Thanks! crossing my fingers now... Link to comment Share on other sites More sharing options...
leathersmith Posted June 12, 2008 Author Share Posted June 12, 2008 no luck will try again tomorrow Link to comment Share on other sites More sharing options...
icelos69 Posted June 13, 2008 Share Posted June 13, 2008 awesome fix! works as promised! situation: certain webhost "upgrades" hosting platform site, but neglects to mention which changes are made. tech support issues support ticket for work with specialist, however problem is not resolves after 24 hours. i guess sometimes ya gotta take care of things yourself. this issue along with random files placed into site from previous versions. full-site back-up restoration fixes rest of problems. BACKUP YOUR FILES OFTEN! 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.