Having some problems adding new products via Easy Populate 1.2.5.4. and zc 1.3.8a
Everything works fine when i update my current products already in the DB.
Problem is when i try and add a new product.
Here are my steps on how i was doing it.
1: Download Complete tab-delimited .txt file to edit (Attributes Not Included)
2. open with Open Office
3. in the correct fields i add my v_products_model, v_products_image, v_products_name_1, v_manufacturers_name, v_categories_name_1, v_categories_name_2, v_categories_name_3, v_tax_class_title, v_status, EOREOR
4. save and upload back to easy populate.
Easy Populate gives me this error:
An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer
my log file says this
Code:
MySQL error 1136: Column count doesn't match value count at row 1
When executing:
INSERT INTO products (
products_image,
products_model,
products_price,
products_status,
products_last_modified,
products_date_added,
products_date_available,
products_tax_class_id,
products_weight,
products_quantity,
master_categories_id,
manufacturers_id)
VALUES (
'products/KLA161_1.jpg','KLA161',
'',
'1',
CURRENT_TIMESTAMP,
CURRENT_TIMESTAMP,
NULL,
'1',
'',
'',
'',
'0',
'140',
'65')
any suggestions on what is wrong?
Bookmarks