tmorgan03 Posted November 7, 2005 Share Posted November 7, 2005 When I upload i reciever the folowing error Easy Populate 2.76-MS2 - Default Language : English(1) File uploaded. Temporary filename: /tmp/php441seW User filename: EP2005Nov07New-0909.txt Size: 30198 | 111905 | icon1.gif | Nov. 19th | Showcase a | | | | | | | | | | | | | | | | 87.5 | 0 | | 10/30/2005 | 40 | 1 | Street Add | 2 | City | 3 | State | 15 | TN | | 16 | MS | | 4 | Area | 1 | Bartlett | | 2 | Colliervil | | 3 | Cordova | | 4 | Downtown | | 5 | East Memph | | 6 | Frayser | | 7 | Germantown | | 8 | Hickory Hi | | 9 | Midtown | | 10 | Raleigh | | 13 | Southaven | | 14 | Whitehaven | | 5 | Asking Pri | 17 | | | 6 | Contact na | 7 | Company Na | 8 | Office Num | 9 | Cell Numbe | 10 | Text | 18 | | | 19 | Text | | | HomeShowca | Nov-05 | | | | | | | | | | | --none-- | Active Updated | 112605 | icon3.gif | Nov. 26th | Showcase a | | | | | | | | | | | | | | | | 87.5 | 0 | | 10/30/2005 | 40 | 1 | Street Add | 2 | City | 3 | State | 15 | TN | | 16 | MS | | 4 | Area | 1 | Bartlett | | 2 | Colliervil | | 3 | Cordova | | 4 | Downtown | | 5 | East Memph | | 6 | Frayser | | 7 | Germantown | | 8 | Hickory Hi | | 9 | Midtown | | 10 | Raleigh | | 13 | Southaven | | 14 | Whitehaven | | 5 | Asking Pri | 17 | | | 6 | Contact na | 7 | Company Na | 8 | Office Num | 9 | Cell Numbe | 10 | Text | 18 | | | 19 | Text | | | HomeShowca | Nov-05 | | | | | | | | | | | --none-- | Active Updated | 120305 | icon5.gif | Dec. 3rd S | Showcase a | | | | | | | | | | | | | | | | 87.5 | 0 | | 10/30/2005 | 40 | 1 | Street Add | 2 | City | 3 | State | 15 | TN | | 16 | MS | | 4 | Area | 1 | Bartlett | | 2 | Colliervil | | 3 | Cordova | | 4 | Downtown | | 5 | East Memph | | 6 | Frayser | | 7 | Germantown | | 8 | Hickory Hi | | 9 | Midtown | | 10 | Raleigh | | 13 | Southaven | | 14 | Whitehaven | | 5 | Asking Pri | 17 | | | 6 | Contact na | 7 | Company Na | 8 | Office Num | 9 | Cell Numbe | 10 | Text | 18 | | | 19 | Text | | | HomeShowca | Dec-05 | | | | | | | | | | | --none-- | Active !New Product! 1136 - Column count doesn't match value count at row 1 INSERT INTO products ( products_image, products_image_med, products_image_lrg, products_image_sm_1, products_image_xl_1, products_image_sm_2, products_image_xl_2, products_image_sm_3, products_image_xl_3, products_image_sm_4, products_image_xl_4, products_image_sm_5, products_image_xl_5, products_image_sm_6, products_image_xl_6, 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 ( 'icon5.gif',", "", "", "", "", "", "", "", "", "", "", "", "", "", " '120305', '87.5', '1', CURRENT_TIMESTAMP, "10/30/2005 17:30", NULL, '', '0', '40', 'NULL') [TEP STOP] No products are update so what do I need to do? Thank you Quote Link to comment Share on other sites More sharing options...
justdf Posted November 8, 2005 Share Posted November 8, 2005 When I upload i reciever the folowing errorNo products are update so what do I need to do? Thank you I got the same problem . any help ? thanks. Quote Link to comment Share on other sites More sharing options...
justdf Posted November 8, 2005 Share Posted November 8, 2005 hi, i got the answer . for mysql in WIN2000, we need change single quotes ' to \' . when i delete all single quotes , we can update or insert . Quote Link to comment Share on other sites More sharing options...
tmorgan03 Posted November 8, 2005 Author Share Posted November 8, 2005 I still having the smae problem. My products do not update after an upload b/c of the error mentioned in previous post. It says that 1136 - Column count doesn't match value count at row 1 Thanks for advice and any help Quote Link to comment Share on other sites More sharing options...
New 
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.