netnerd85 Posted January 9, 2006 Posted January 9, 2006 Hey all, First of all I installed oscommerce on a SSL server. Then I installed Osc on my PC with no SSL. I edited the UI of Osc completely. I copied the edited files over to the server with SSL (not the config files) and dropped the previous db then replaced it with the one from my pc. Every works except I get this error when I visit a category on the index.php 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 = '21' [TEP STOP] :blink: I have no idea why it is doing this, please help I'm on the verge of a break-down :o
buzuc Posted January 9, 2006 Posted January 9, 2006 It's an error with mysql. check your versions (local and remote) MS2 2.2 fr + Manufacturer copy (5 manufacturers - modified to make it works) + More pics 6 + FCK Editor + zones shipping (modified without weight) + My contribution : Shopping Cart Management for Unique Products I apologize in advance for my poor English I'm French !
netnerd85 Posted January 9, 2006 Author Posted January 9, 2006 5.0.15 :blush: doh! Thanks, forgot about that issue.
flashtor Posted January 20, 2006 Posted January 20, 2006 and how to fixed it ? sorry i'm newbie :( i got the same error too
GraphicsGuy Posted January 20, 2006 Posted January 20, 2006 and how to fixed it ?sorry i'm newbie :( i got the same error too http://www.oscommerce.com/forums/index.php?s=&...ndpost&p=780781 Rule #1: Without exception, backup your database and files before making any changes to your files or database. Rule #2: Make sure there are no exceptions to Rule #1.
GraphicsGuy Posted January 20, 2006 Posted January 20, 2006 P.S. The upgrade instructions are included in the installatiion download found here. Rule #1: Without exception, backup your database and files before making any changes to your files or database. Rule #2: Make sure there are no exceptions to Rule #1.
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.