Guest Posted May 9, 2009 Posted May 9, 2009 Hello I am new here. So Hi!!! Hope someone can assist me in getting this problem resolved. ok, so my clients webpage has this error: 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 = '23' [TEP STOP] Now, I did do a search and came across a fix, you have to change a few lines in index.php and advanced_search_result.php which worked on another clients. However on this particular one, this fix DID NOT work. So I am asking for some advice, guidance etc etc. :) My server is running SQL V5.0.67 with PHP V5. I have root access. What do I need to do in order to get this working? If you need any info, please let me know and I will provide. Thanks Aaron
spooks Posted May 9, 2009 Posted May 9, 2009 have u tried following the rules for joins with sql 5 Sam Remember, What you think I ment may not be what I thought I ment when I said it. Contributions: Auto Backup your Database, Easy way Multi Images with Fancy Pop-ups, Easy way Products in columns with multi buy etc etc Disable any Category or Product, Easy way Secure & Improve your account pages et al.
Guest Posted May 10, 2009 Posted May 10, 2009 have u tried following the rules for joins with sql 5 Hi, No because I am not that fluent with SQL so if you can point me in the right direction I would appreciate it. thanks Aaron
Jan Zonjee Posted May 10, 2009 Posted May 10, 2009 so if you can point me in the right direction I would appreciate it. Perhaps you should take a look at Upgrading osC from 2.2 Milestone 2 to 2.2 RC2a because it will surely not be the last issue you will encounter.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.