gaspower Posted July 27, 2007 Share Posted July 27, 2007 File uploaded. Temporary filename: /tmp/phpEWZ1Ye User filename: Test Upload Small.txt Size: 1474 | AIRM11 | rrp.gif | M11 | M11 Radio | | 150 | 5 | | 7/27/2007 | 10 | Airtronics | Radios | Systems | | Taxable Go | Active | 10 | 100 Updated | DYN2000 | dyn2000.jp | Turbo Fuel | Turbo Fuel | | 8.49 | 0.3 | | 7/26/2007 | 10 | Dynamite | Accessorie | Fuel Bottl | | Taxable Go | Active | 4.99 | 9.95 !New Product! 1136 - Column count doesn't match value count at row 1 INSERT INTO products ( products_model, products_image, products_price, products_cost, products_msrp, products_status, products_last_modified, products_date_added, products_date_available, products_tax_class_id, products_weight, products_quantity, manufacturers_id) VALUES ( 'dyn2000.jpg', 'DYN2000', '8.49', '1', CURRENT_TIMESTAMP, "7/26/2007 14:26", NULL, '1', '0.3', '10', '4.99' '9.95' '3') Hello, I did a download from the sit with EP to get the layout and had one item on the site (AIRM11). As soon as I add any other items, approx ten items to test, I get the above error? I am dowlnoading in Tab format, and saving as Tab format. I changed the value in products_model to (20) to allow for larger names. Thank you JR Quote Link to comment Share on other sites More sharing options...
gaspower Posted July 27, 2007 Author Share Posted July 27, 2007 Hello, I see the error, missing "," on cost and msrp. Sorry about that, JR 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.