sporkalicious Posted February 23, 2008 Share Posted February 23, 2008 I have installed the xml UPS module, the Price Breakdown By Product module, and the Maximum order quantity module, all was working well after ups module was installed, after the Price breakdown module when i would click to edit a product it would come up with all the fields empty like a new product, and after the max order quantity module i recieve this error when attempting to edit a product, i'm sure this is my fault, can anyone help me fix it 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' p.maxorder, products p, products_description pd where p.products_id = '29' and ' at line 1 select pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_price1, p.products_price2, p.products_price3, p.products_price4, p.products_price5, p.products_price6, p.products_price7, p.products_price8, p.products_price1_qty, p.products_price2_qty, p.products_price3_qty, p.products_price4_qty, p.products_price5_qty, p.products_price6_qty, p.products_price7_qty, p.products_price8_qty, p.products_qty_blocks, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id from, p.maxorder, products p, products_description pd where p.products_id = '29' and p.products_id = pd.products_id and pd.language_id = '1' [TEP STOP] Thanks in advance Quote Link to comment Share on other sites More sharing options...
alexrebs Posted February 23, 2008 Share Posted February 23, 2008 search for updates in the forum, there's a bugfix for mysql5 Quote Link to comment Share on other sites More sharing options...
sporkalicious Posted February 23, 2008 Author Share Posted February 23, 2008 is the update for oscommerce itself or for one of the modules? Quote Link to comment Share on other sites More sharing options...
Jan Zonjee Posted February 23, 2008 Share Posted February 23, 2008 is the update for oscommerce itself or for one of the modules? Better fix your queries: p.manufacturers_id from, p.maxorder, products p, products_description pd Should be: p.manufacturers_id, p.maxorder from products p, products_description pd Quote Link to comment Share on other sites More sharing options...
sporkalicious Posted February 25, 2008 Author Share Posted February 25, 2008 Better fix your queries: p.manufacturers_id from, p.maxorder, products p, products_description pd Should be: p.manufacturers_id, p.maxorder from products p, products_description pd That took care of the error i was getting, thanks for that but i still have blank fields when i edit an existing product Quote Link to comment Share on other sites More sharing options...
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.