Cecchetti Posted August 4, 2006 Share Posted August 4, 2006 When I click any category in the left column, I get an error like this in the center column: 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 = '3' and p2c.categories_id = '21' Does any body tell me in wich file do I have to work in? Link to comment Share on other sites More sharing options...
♥Vger Posted August 4, 2006 Share Posted August 4, 2006 It looks like your FTP upload was corrupted. I'd suggest uploading all the web store files/folders again, using a decent FTP programme like FileZilla or WS FTP. Dn't use Smart, Cute, or Dreamweaver FTP to upload files. Make sure you don't overwrite the includes/configure.php file. Vger Link to comment Share on other sites More sharing options...
Jack_mcs Posted August 4, 2006 Share Posted August 4, 2006 When I click any category in the left column, I get an error like this in the center column: 1054 - Unknown column 'p.products_id' in 'on clause' That's a common problem when using php 5. If it was a working site,maybe your host updated php. Take a look at this page. Jack Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
Cecchetti Posted August 4, 2006 Author Share Posted August 4, 2006 It looks like your FTP upload was corrupted. I'd suggest uploading all the web store files/folders again, using a decent FTP programme like FileZilla or WS FTP. Dn't use Smart, Cute, or Dreamweaver FTP to upload files. Make sure you don't overwrite the includes/configure.php file. Vger Thanks a lot I wil wor with it Link to comment Share on other sites More sharing options...
Cecchetti Posted August 4, 2006 Author Share Posted August 4, 2006 That's a common problem when using php 5. If it was a working site,maybe your host updated php. Take a look at this page. Jack Tha?ks a lot Jack Link to comment Share on other sites More sharing options...
tpatwood Posted August 10, 2006 Share Posted August 10, 2006 I'm not sure if I should jump into the middle of this post, but I'll go for it anyway. I'm getting the same type of error - 1054 ..., when trying to query the product list or manufacturer table, it seems. This is occurring on a new install - no contributions added at all. (I'm trying to create a local development environment rather than continually play with the uploading process to my host.) This is running on WXPsp2, a recent (within the last week) download of XAMPP for windows, the latest available osCommerce (oscommerce-2.2ms2-051113) download. XAMPP has a tool that allows me to switch between php4 and 5, and I've selected 4. The implementation I'm using on from my hosting provider functions fine (they do the install though). What have I missed? thx tom Link to comment Share on other sites More sharing options...
tpatwood Posted August 10, 2006 Share Posted August 10, 2006 I apologize - I beleive I've found the problem. I downloaded the recent osCommerce file, made a COPY of my bad one in the same webserver's htdocs folder and did an install, essentially installing the original one again. I copied the catalog from the morning download into the htdocs folder, did an install and things look normal. tom 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.