Results 1 to 10 of 740

Threaded View

  1. #11
    Join Date
    Apr 2006
    Location
    London, UK
    Posts
    10,569
    Plugin Contributions
    25

    Default Re: Auction Product Type

    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) with
    INSERT INTO product_types VALUES (NULL, 'Product - Auction', 'product_auction', '1', 'N', '', now(), now());
    If that doesn't work for you try
    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();
    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.
    Last edited by kuroi; 27 Sep 2007 at 06:58 AM.
    Kuroi Web Design and Development | Twitter

    (Questions answered in the forum only - so that any forum member can benefit - not by personal message)

 

 

Similar Threads

  1. Auction Product type
    By Andreas1211 in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 14 Aug 2014, 02:13 PM
  2. Auction Product Type: Can't add a product of the type.
    By sw0rdz in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 5 Sep 2009, 02:11 AM
  3. Auction Product Type
    By chinthana in forum All Other Contributions/Addons
    Replies: 0
    Last Post: 18 Jun 2009, 10:33 AM
  4. Auction Mod. Product Type
    By wilt in forum All Other Contributions/Addons
    Replies: 5
    Last Post: 15 Feb 2007, 07:35 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg