hbalint Posted January 31, 2007 Share Posted January 31, 2007 Hi, I moved a totally success and working webshop from the old place to the new server. I changed the sql and directory datas in config files. I can log in the webshop, I can see the start page. The problem is that when I click one of the product the next error message will appear: 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 = '5' and p2c.categories_id = '32' I don't know where is the problem. Could you help me? The DB contain products.products_id. All tables are same in the new MYSQL than the old one. Thank you for your help. Best Regards Balint Link to comment Share on other sites More sharing options...
GulSar Ray's Posted January 31, 2007 Share Posted January 31, 2007 Hi, I moved a totally success and working webshop from the old place to the new server. I changed the sql and directory datas in config files. I can log in the webshop, I can see the start page. The problem is that when I click one of the product the next error message will appear: 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 = '5' and p2c.categories_id = '32' I don't know where is the problem. Could you help me? The DB contain products.products_id. All tables are same in the new MYSQL than the old one. Thank you for your help. Best Regards Balint I also stuck up with this problem , not remember the soultion eaxctly, but just try tis query select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id , products_to_categories p2cwhere p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '5' and p2c.categories_id = '32' Will find and lwt u know the exact solution in ashort while Thanks Hard Work Is The Simplest Way Of Success Link to comment Share on other sites More sharing options...
satish Posted January 31, 2007 Share Posted January 31, 2007 Apply the latest oscommerce patch.That should take care. Satish Mantri Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site. Check My About US For who am I and what My company does. Link to comment Share on other sites More sharing options...
hbalint Posted January 31, 2007 Author Share Posted January 31, 2007 I also stuck up with this problem , not remember the soultion eaxctly, but just try tis query select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id , products_to_categories p2cwhere p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '5' and p2c.categories_id = '32' Will find and lwt u know the exact solution in ashort while Thanks Thank you for your idea. I will try it. I have another problem, I don't know which file contains this code. The url address is index.php?....... I can't see. Could you write me exactly which file is? I haven't used this webshop solution before. Unfortunatelly I don't know the structure because I see it the first time. I hoped that I moved everything in the new server, I just correct the configs and everything will working properly. But not. A lot of users would use this shop, so this is very urgently that the shop working again soon. I don't understand that why it worked in the old place and why not works in the new? Maybe php and Mysql version, or something in php.ini. Thank you: Balint Link to comment Share on other sites More sharing options...
wheeloftime Posted January 31, 2007 Share Posted January 31, 2007 Thank you for your idea. I will try it. I have another problem, I don't know which file contains this code. The url address is index.php?....... I can't see. Could you write me exactly which file is? I haven't used this webshop solution before. Unfortunatelly I don't know the structure because I see it the first time. I hoped that I moved everything in the new server, I just correct the configs and everything will working properly. But not. A lot of users would use this shop, so this is very urgently that the shop working again soon.I don't understand that why it worked in the old place and why not works in the new? Maybe php and Mysql version, or something in php.ini. Thank you: Balint As Satish remarked; look into the latest download package and read the provided update text file. At the end you will find directions how to make it work with MySql5 which is the base of your problem. Link to comment Share on other sites More sharing options...
hbalint Posted January 31, 2007 Author Share Posted January 31, 2007 As Satish remarked; look into the latest download package and read the provided update text file. At the end you will find directions how to make it work with MySql5 which is the base of your problem. Thank you for your help. I corrected all of the marked rows. The shop is working properly. Thanks everybody. I have only 1 problem with admin page. When I try to enter admin page I received the next error message: Fatal error: Cannot re-assign $this in /home/services/www/www.crystalnails.hu/html/bolt/admin/includes/classes/upload.php on line 31 Do I write something in php.ini? I think need something php settings. Please write me what is the reason that the admin page is not working. Once more thanks. Regards Balint Link to comment Share on other sites More sharing options...
hbalint Posted January 31, 2007 Author Share Posted January 31, 2007 Thank you for your help. I corrected all of the marked rows. The shop is working properly. Thanks everybody. I have only 1 problem with admin page. When I try to enter admin page I received the next error message: Fatal error: Cannot re-assign $this in /home/services/www/www.crystalnails.hu/html/bolt/admin/includes/classes/upload.php on line 31 Do I write something in php.ini? I think need something php settings. Please write me what is the reason that the admin page is not working. Once more thanks. Regards Balint Thank you I found in the text file 375 row. Now it's working. Link to comment Share on other sites More sharing options...
interlocken Posted January 31, 2007 Share Posted January 31, 2007 Apply the latest oscommerce patch.That should take care. Satish Mantri where can i find this patch? and install info. Link to comment Share on other sites More sharing options...
Jack_mcs Posted January 31, 2007 Share Posted January 31, 2007 See the above menu: Solutions->Downloads. 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...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.