Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

a bastardized version I installed is now kaput


Recommended Posts

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'





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

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!





Link to comment
Share on other sites

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

awesome fix! works as promised!



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.



Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...