bmw000 Posted April 22, 2007 Share Posted April 22, 2007 I am getting this error message when trying to import a file with easy populate. I seached the forum and found this same error message, but the fix didn't seem to work for me. Probably because it was for another contribution. Any ideas? Easy Populate 2.76d-MS2 - Default Language : English(1) File uploaded. Temporary filename: /tmp/phpJd2MX3 User filename: qryJEWELRY01.txt Size: 101607 | 416769 | 29-173-548 | SL2020 Con | Controls 1 | 38.75 | 1.00 | 1 | Famous Tra | Jewelry | Watches | Famous Tra | --none-- | Active !New Product! 1136 - Column count doesn't match value count at row 1 INSERT INTO products ( products_ship_price, 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, manufacturers_id) VALUES ( '29-173-548-416769.jpg', '416769', '38.75', '1', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, NULL, '--none--', '1.00', '1', '' '10') [TEP STOP] Quote Link to comment Share on other sites More sharing options...
bmw000 Posted April 22, 2007 Author Share Posted April 22, 2007 (edited) I found out what was causing this error. It seems I was using and old version of the instructions for adding a new field to easy populate. I got that error fixed, but now I get a new error. Easy Populate 2.76d-MS2 - Default Language : English(1) File uploaded. Temporary filename: /tmp/phppyWATW User filename: qryJEWELRY01.txt Size: 102804 | 416769a | 29-173-548 | SL2020 Con | Controls 1 | 38.75 | 1.00 | 2007-04-22 | 1 | Famous Tra | Jewelry | Watches | Famous Tra | --none-- | Active | 0 !New Product! 1048 - Column 'products_date_added' cannot be null INSERT INTO products ( products_ship_price, 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, manufacturers_id) VALUES ( '29-173-548-416769.jpg', '416769a', '38.75', '1', CURRENT_TIMESTAMP, "2007-04-22", NULL, '', '1.00', '1', '0', '10') [TEP STOP] Anyone have any ideas? Edited April 22, 2007 by bmw000 Quote Link to comment Share on other sites More sharing options...
steffanih Posted July 21, 2011 Share Posted July 21, 2011 In my programming I have to remove the quotes surrounding CURRENT_TIMESTAMP to get things to work properly. Maybe you need to do the reverse. It's a SQL version issue I think. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.