Discount Rocketry

A recent text file will not import. The error is as follows: | AE-91241 | small_imag | medium_ima | big_images | Aerotech R | Aerotech R | | 47.96 | 11.99 | 20 | 59.95 | 0.11 | 0000-00-00 | 0000-00-00 | 0 | 3 | 6 | 40 | Aerotech H | Model Rock | Aerotech R | Aerotech H | Taxable Go | Active Updated | RT-29100C | small_imag | medium_ima | big_images | Rouse-Tech | Rouse-Tech | | 18.86 | 4.79 | 10 | 20.95 | 1 | 0000-00-00 | 0000-00-00 | 1 | 1 | 1 | 42 | Rouse-Tech | Model Rock | Rouse-Tech | | Taxable Go | Active !New Product! 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '', '43')' at line 37 INSERT INTO products ( products_image, products_mediumimage, products_largeimage, products_model, products_price, products_discount, products_percent, products_retail, products_status, products_last_modified, products_date_added, products_date_available, products_tax_class_id, products_weight, products_quantity, products_reorder, products_reorder_to, manufacturers_discount, manufacturers_id) VALUES ( 'small_images/small_rouse-tech.jpg','medium_images/medium_rouse-tech.jpg', 'big_images/big_rouse-tech.jpg','RT-29100C', '18.86', '4.79', '10', '20.95', '1', CURRENT_TIMESTAMP, "0000-00-00 00:00:00", "0000-00-00 00:00:00", '1', '1', '1', '1', '42', 1', '43') [TEP STOP] When I change the model number to be the same as the the first line on all the products, all of them will import as the single model number successfully. This proves there is nothing wrong with the file in general. I then changed the second model number to RT-29100C or any other model number and the error repeats. To me it looks as if there is some limit on the number of products that can be imported into the SQL. The text file only has 37 more products in it, but the current store has about 1000 products in it. I tried the PHP 5 fix with no success. Help!

A recent text file will not import. The error is as follows: | AE-91241 | small_imag | medium_ima | big_images | Aerotech R | Aerotech R | | 47.96 | 11.99 | 20 | 59.95 | 0.11 | 0000-00-00 | 0000-00-00 | 0 | 3 | 6 | 40 | Aerotech H | Model Rock | Aerotech R | Aerotech H | Taxable Go | Active Updated | RT-29100C | small_imag | medium_ima | big_images | Rouse-Tech | Rouse-Tech | | 18.86 | 4.79 | 10 | 20.95 | 1 | 0000-00-00 | 0000-00-00 | 1 | 1 | 1 | 42 | Rouse-Tech | Model Rock | Rouse-Tech | | Taxable Go | Active !New Product! 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '', '43')' at line 37 INSERT INTO products ( products_image, products_mediumimage, products_largeimage, products_model, products_price, products_discount, products_percent, products_retail, products_status, products_last_modified, products_date_added, products_date_available, products_tax_class_id, products_weight, products_quantity, products_reorder, products_reorder_to, manufacturers_discount, manufacturers_id) VALUES ( 'small_images/small_rouse-tech.jpg','medium_images/medium_rouse-tech.jpg', 'big_images/big_rouse-tech.jpg','RT-29100C', '18.86', '4.79', '10', '20.95', '1', CURRENT_TIMESTAMP, "0000-00-00 00:00:00", "0000-00-00 00:00:00", '1', '1', '1', '1', '42', 1', '43') [TEP STOP] When I change the model number to be the same as the the first line on all the products, all of them will import as the single model number successfully. This proves there is nothing wrong with the file in general. I then changed the second model number to RT-29100C or any other model number and the error repeats. To me it looks as if there is some limit on the number of products that can be imported into the SQL. The text file only has 37 more products in it, but the current store has about 1000 products in it. I tried the PHP 5 fix with no success. Help!

I have installed the SEO Category Description contribution. I've been able to add other fields in Easypopulate such as retailprice, discount ect... However, the category name function with the variouse looping SQL calls is a bit over my head at this point. Is there anyone who has already done it or can help me add the the categories_description funtion to Easypopulate?

The v_head_title_tag_1 field downloads but it doesn't upload. This error did not appear in the first install of Easypopulate. It happened after installing Ultra Pics. I know this is not part of your code changes, but it does indicate your code version is based on a flawed version of Easy populate. By the way, thanks for a great contribution. The ultra pic mods work well in the store. Also I found a great site for a freeware thumbnail generator at http://www.fookes.com/index.php.