That SQL works fine for me. However, your version appears unwilling to treat the empty string as a null value. First off try replacing the relevant line in the patch (line 21 about half way down) withIf that doesn't work for you tryINSERT INTO product_types VALUES (NULL, 'Product - Auction', 'product_auction', '1', 'N', '', now(), now());You will also need to check whether the statements after this executed successfully. If so your database will already have that data in and executing them again would cause duplicates. But my guess would be that they will have suffered from the same problem and need similar approaches to make them work.INSERT INTO product_types set type_name='Product - Auction', type_handler='product_auction', type_master_type='1', allow_add_to_cart='N', default_image='', date_added=now(), last_modified=now();


Reply With Quote
