Jump to content

comp818

Members
  • Content count

    3
  • Joined

  • Last visited

  1. Settings & Info EP vers: 2.76h-MS2 osCommerce Online Merchant v2.2 RC2a OS: Linux 2.6.18-92.1.10.el5PAE HTTP: Apache DB: MySQL 4.1.22-max-log PHP: 5.2.8 (Zend: 2.2.0) I succesfully installed easypopulate and uploaded the file into temp folder. But when I click insert into db I get the following error. Please let me know how to fix it. Filename: data.csv 1054 - Unknown column 'p.products_subimage1' in 'field list' SELECT p.products_id as v_products_id, p.products_model as v_products_model, p.products_image as v_products_image, p.products_subimage1 as v_products_subimage1,p.products_subimage2 as v_products_subimage2,p.products_subimage3 as v_products_subimage3,p.products_subimage4 as v_products_subimage4,p.products_subimage5 as v_products_subimage5,p.products_subimage6 as v_products_subimage6, p.products_price as v_products_price, p.products_weight as v_products_weight, p.products_date_available as v_date_avail, p.products_date_added as v_date_added, 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, p.products_status as v_status_current FROM products as p, categories as subc, products_to_categories as ptoc WHERE p.products_model = 'DHRQ2102' AND p.products_id = ptoc.products_id AND ptoc.categories_id = subc.categories_id LIMIT 1 [TEP STOP]
  2. Hello, I succesfully installed easypopulate and uploaded the file into temp folder. But when I click insert into db I get the following error. Please let me know how to fix it. Filename: data.csv 1054 - Unknown column 'p.products_subimage1' in 'field list' SELECT p.products_id as v_products_id, p.products_model as v_products_model, p.products_image as v_products_image, p.products_subimage1 as v_products_subimage1,p.products_subimage2 as v_products_subimage2,p.products_subimage3 as v_products_subimage3,p.products_subimage4 as v_products_subimage4,p.products_subimage5 as v_products_subimage5,p.products_subimage6 as v_products_subimage6, p.products_price as v_products_price, p.products_weight as v_products_weight, p.products_date_available as v_date_avail, p.products_date_added as v_date_added, 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, p.products_status as v_status_current FROM products as p, categories as subc, products_to_categories as ptoc WHERE p.products_model = 'DHRQ2102' AND p.products_id = ptoc.products_id AND ptoc.categories_id = subc.categories_id LIMIT 1 [TEP STOP]
  3. Hello, I succesfully installed easypopulate and uploaded the file into temp folder. But when I click insert into db I get the following error. Please let me know how to fix it. Filename: data.csv 1054 - Unknown column 'p.products_subimage1' in 'field list' SELECT p.products_id as v_products_id, p.products_model as v_products_model, p.products_image as v_products_image, p.products_subimage1 as v_products_subimage1,p.products_subimage2 as v_products_subimage2,p.products_subimage3 as v_products_subimage3,p.products_subimage4 as v_products_subimage4,p.products_subimage5 as v_products_subimage5,p.products_subimage6 as v_products_subimage6, p.products_price as v_products_price, p.products_weight as v_products_weight, p.products_date_available as v_date_avail, p.products_date_added as v_date_added, 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, p.products_status as v_status_current FROM products as p, categories as subc, products_to_categories as ptoc WHERE p.products_model = 'DHRQ2102' AND p.products_id = ptoc.products_id AND ptoc.categories_id = subc.categories_id LIMIT 1 [TEP STOP]
×