Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

!!NEED HELP WITH EASY POPULATE IMPORT


Guest

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...