AndyWill Posted September 3, 2006 Share Posted September 3, 2006 I've installed the advanced search into a brand new oscommerce installation (everything is working fine) the advanced search appears fine, but when it searches I get the following error. Any thoughts ? FYI mySQL v 5.0.18 php 4.4.1 Andy 1054 - Unknown column 'p.products_id' in 'on clause' select count(distinct p.products_id) as total from products p left join manufacturers m using(manufacturers_id), products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c,products_attributes pa where p.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 Quote Link to comment Share on other sites More sharing options...
Guest Posted September 11, 2006 Share Posted September 11, 2006 I have just installed it and I have the same problem I even tried all the updated versions that says on its contribution apparantly its the mysql version that we are using that is not compatible with the sql query. what version of mysql you are using? and did you try the update version that he has posted for the one that it says it gives mysql errors? I have searched every where and i havent found an answer we just need somebody who knows sql queries well enough to customize this sql query. If you find an answer please let me know Quote Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.