Jump to content
Sign in to follow this  
gaspower

Help With 1136 - Column count doesn't match error

Recommended Posts

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×