needs_a_nap Posted May 30, 2009 Posted May 30, 2009 I am getting the 1064 error upon upload of my client's CSV file, my EP file has been modified for the Big Images mod. There seems to be a comma out of place but I can't see it - can anyone else? The error I get is: 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 'products_weight='1', products_tax_class_id='1'' at line 6 UPDATE products SET products_price='120', products_image='Carnelion1A.JPG', products_bimage='lg-Carnelion1A.jpg,' products_weight='1', products_tax_class_id='1', products_date_available='1999-11-30 00:00:00', products_date_added='1969-12-31 19:00:00', products_last_modified='2009-05-30 02:29:55', products_quantity = 1, manufacturers_id = NULL, products_status = 1 WHERE (products_id = 1) LIMIT 1" It's showing it's with a line modified for Big Images, products_bimage='lg-Carnelion1A.jpg,' and of course should be products_bimage='lg-Carnelion1A.jpg', but I can't find it in the easypopulate.php file. As the whole file is too long to post, below is where I beleive the offending code is coming from: $query = "UPDATE ".TABLE_PRODUCTS." SET products_price='$v_products_price', products_image=".(!empty($v_products_image)?"'".$v_products_image."'":'NULL').", $ep_additional_updates products_weight='$v_products_weight', products_tax_class_id='$v_tax_class_id', products_date_available=".$v_date_avail.", products_date_added=".$v_date_added.", products_last_modified='".date("Y-m-d H:i:s")."', products_quantity = $v_products_quantity, manufacturers_id = ".(!empty($v_manufacturer_id)?$v_manufacturer_id:'NULL').", products_status = $v_db_status WHERE (products_id = $v_products_id) LIMIT 1"; tep_db_query($query); } } I have tried adding the line products_bimage=".(!empty($v_products_bimage)?"'".$v_products_bimage."'":'NULL').", below the similar one above for products_image to no avail. That statement is the only one I have not duplicated & altered for bimage throughout the file. Thanks :) Quote
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.