Guest Posted January 2, 2007 Share Posted January 2, 2007 Hi i keep getting this message after i try to import my .txt file in easy populate, it imports only 32 products out of my 3500 products, the error i keep getting is below 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 'X 16') (58188) (17641)' AND ptoc.categories_id = subc.categories_id' at line 18 SELECT p.products_id as v_products_id, p.products_model as v_products_model, p.products_image as v_products_image, p.products_price as v_products_price, p.products_weight as v_products_weight, p.products_date_added as v_date_avail, p.products_tax_class_id as v_tax_class_id, p.products_quantity as v_products_quantity, p.manufacturers_id as v_manufacturers_id, subc.categories_id as v_categories_id FROM products as p, categories as subc, products_to_categories as ptoc WHERE p.products_id = ptoc.products_id AND p.products_model = '(SPEACIAL) POOL GROUND CLOTH (16' X 16') (58188) (17641)' AND ptoc.categories_id = subc.categories_id [TEP STOP] Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.