From the Error Log in the temp directoryMySQL 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 (
'no_picture.gif','123-ABC',
'300',
'1',
CURRENT_TIMESTAMP,
CURRENT_TIMESTAMP,
"0000-00-00 00:00:00",
'1',
'2',
'65',
'200',
'68',
'10')
I can see the duplicate entry in the first error message above for the CURRENT_TIMESTAMP. What I
cannot see is how to correct this. I am assuming that this is what the error message is referring to.
I followed the directions in this post for adding the new field very carefully, double-checking everything as I went along and then checking the whole thing once more after I finished following the directions.
The field that I added was
master_categories_id (it does include the "v_" where as it is suppsed to in the easypopylate.php file).
The easypopulate.php file does not have a duplicate that I can see. The csv file (spreadsheet) does not have duplicate columns. While it doesn't have a column called "current timestamp", it does have "date added", which is the column using the "[FONT=Arial]
[FONT=Arial]0000-00-00 00:00:00" for each product listed.[/FONT][/FONT]
Assuming it is the duplicate timestamp that is being referred to in the error message, I don't know how to remove this duplication or where to look to find it.
BTW, the
new column that I added
DOES appear in EZ Populate when I create the COMPLETE file in the temp directory and download it from there.
Anything you can share that will help me resolve this is appreciated.
Thanks!
Bookmarks