Auction Product Type

[enigma666666]

That's perfect!
Just what I've been looking for

[What To Get]

Good morning all,

I was wondering if you could help me, I am trying to install Zen Auction 1.2 into my Zen Cart.

All files transfered ok but when I try and run the SQL script through SQL patches from Zen Cart tools, I get a full screen of errors as follows:

1062 Duplicate entry 'SHOW_PRODUCT_AUCTION_INFO_MODEL' for key 2
in:
[INSERT INTO zen_product_type_layout VALUES ('','Show Model Number', 'SHOW_PRODUCT_AUCTION_INFO_MODEL', '1', 'Display Model Number on Product Info 0= off 1= on', @t4, '1', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Show Weight', 'SHOW_PRODUCT_AUCTION_INFO_WEIGHT', '1', 'Display Weight on Product Info 0= off 1= on', @t4, '2', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Show Attribute Weight', 'SHOW_PRODUCT_AUCTION_INFO_WEIGHT_ATTRIBUTES', '1', 'Display Attribute Weight on Product Info 0= off 1= on', @t4, '3', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Show Manufacturer', 'SHOW_PRODUCT_AUCTION_INFO_MANUFACTURER', '1', 'Display Manufacturer Name on Product Info 0= off 1= on', @t4, '4', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Show Quantity in Shopping Cart', 'SHOW_PRODUCT_AUCTION_INFO_IN_CART_QTY', '1', 'Display Quantity in Current Shopping Cart on Product Info 0= off 1= on', @t4, '5', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Show Quantity in Stock', 'SHOW_PRODUCT_AUCTION_INFO_QUANTITY', '1', 'Display Quantity in Stock on Product Info 0= off 1= on', @t4, '6', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Show Product Reviews Count', 'SHOW_PRODUCT_AUCTION_INFO_REVIEWS_COUNT', '1', 'Display Product Reviews Count on Product Info 0= off 1= on', @t4, '7', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Show Product Reviews Button', 'SHOW_PRODUCT_AUCTION_INFO_REVIEWS', '1', 'Display Product Reviews Button on Product Info 0= off 1= on', @t4, '8', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Show Date Available', 'SHOW_PRODUCT_AUCTION_INFO_DATE_AVAILABLE', '1', 'Display Date Available on Product Info 0= off 1= on', @t4, '9', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Show Date Added', 'SHOW_PRODUCT_AUCTION_INFO_DATE_ADDED', '1', 'Display Date Added on Product Info 0= off 1= on', @t4, '10', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Show Product URL', 'SHOW_PRODUCT_AUCTION_INFO_URL', '1', 'Display URL on Product Info 0= off 1= on', @t4, '11', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Show Starting At text on Price', 'SHOW_PRODUCT_AUCTION_INFO_STARTING_AT', '1', 'Display Starting At text on products with attributes Product Info 0= off 1= on', @t4, '12', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Show Product Tell a Friend button', 'SHOW_PRODUCT_AUCTION_INFO_TELL_A_FRIEND', '1', 'Display the Tell a Friend button on Product Info

Note: Turning this setting off does not affect the Tell a Friend box in the columns and turning off the Tell a Friend box does not affect the button
0= off 1= on', @t4, '13', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Product Free Shipping Image Status - Catalog', 'SHOW_PRODUCT_AUCTION_INFO_ALWAYS_FREE_SHIPPING_IMAGE_SWITCH', '0', 'Show the Free Shipping image/text in the catalog?', @t4, '14', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''Yes''), array(''id''=>''0'', ''text''=>''No'')), '), ('','Show Reserve Price or not!', 'SHOW_PRODUCT_RESERVE_INFO', '1', 'Display Reserve price Info 0= off 1= on', @t4, '15', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')), '), ('','Product Price Tax Class Default - When adding new products?', 'DEFAULT_PRODUCT_AUCTION_TAX_CLASS_ID', '0', 'What should the Product Price Tax Class Default ID be when adding new products?', @t4, '16', now(), now(), NULL, ''), ('','Product Virtual Default Status - Skip Shipping Address - When adding new products?', 'DEFAULT_PRODUCT_AUCTION_PRODUCTS_VIRTUAL', '0', 'Default Virtual Product status to be ON when adding new products?', @t4, '17', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Product Free Shipping Default Status - Normal Shipping Rules - When adding new products?', 'DEFAULT_PRODUCT_AUCTION_PRODUCTS_IS_ALWAYS_FREE_SHIPPING', '0', 'What should the Default Free Shipping status be when adding new products?', @t4, '18', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('','Show Product Additional Images', 'SHOW_PRODUCT_AUCTION_INFO_ADDITIONAL_IMAGES', '1', 'Display Additional Images on Product Info 0= off 1= on', @t4, '19', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')), '), ('','Show Product Additional Shipping Images', 'SHOW_PRODUCT_AUCTION_FREE_SHIPPING_INFO_ADDITIONAL_IMAGES', '1', 'Display Additional Free shipping Images on Product Info 0= off 1= on', @t4, '20', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')), '), ('','Show Metatags Title Default - Product Title', 'SHOW_PRODUCT_AUCTION_INFO_METATAGS_TITLE_STATUS', '1', 'Display Product Title in Meta Tags Title 0= off 1= on', @t4, '21', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')), '), ('','Show Metatags Title Default - Product Name', 'SHOW_PRODUCT_AUCTION_INFO_METATAGS_PRODUCTS_NAME_STATUS', '1', 'Display Product Name in Meta Tags Title 0= off 1= on', @t4, '22', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')), '), ('','Show Metatags Title Default - Product Model', 'SHOW_PRODUCT_AUCTION_INFO_METATAGS_MODEL_STATUS', '1', 'Display Product Model in Meta Tags Title 0= off 1= on', @t4, '23', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')), '), ('','Show Metatags Title Default - Product Price', 'SHOW_PRODUCT_AUCTION_INFO_METATAGS_PRICE_STATUS', '1', 'Display Product Price in Meta Tags Title 0= off 1= on', @t4, '24', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')), '), ('','Show Metatags Title Default - Product Tagline', 'SHOW_PRODUCT_AUCTION_INFO_METATAGS_TITLE_TAGLINE_STATUS', '1', 'Display Product Tagline in Meta Tags Title 0= off 1= on', @t4, '25', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')), ');]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I have tried un-installing the script several times and had a look inside the SQL DB but still no joy. Can you please help? :

Thanks

Martin

[davewest]

I have tried un-installing the script several times and had a look inside the SQL DB but still no joy. Can you please help?

The sql is finding the key already there is why the error... The uninstall sql should have removed the auction form your database. Try the update sql, it should clean up the database and install the right keys.

[What To Get]

The sql is finding the key already there is why the error... The uninstall sql should have removed the auction form your database. Try the update sql, it should clean up the database and install the right keys.

Hi

I have tried that a few times and the Update SQL comes up with error:-

1146 Table 'whattoge_shop.zen_product_auction_extra' doesn't exist
in:
[show fields from zen_product_auction_extra]

I have tried almost everything but I am hitting a brick wall (and loosing a lot of hair!)

Any ideas??

Cheers

Martin

[davewest]

Hi

I have tried that a few times and the Update SQL comes up with error:-

1146 Table 'whattoge_shop.zen_product_auction_extra' doesn't exist
in:
[show fields from zen_product_auction_extra]

I have tried almost everything but I am hitting a brick wall (and loosing a lot of hair!)

Any ideas??

Cheers

Martin

I couldn't get your error to come up.... After some time of trying to recreate your error I was able to force a double install of the product_type entry, which in itself is a problem. The best way to see what's going on is to look at your tables with something like phpmyadmin.

[ksookma]

Thanks for the mod Dave. We are having one issue that we can't seem to get past. When shipping an item that needs tax applied I get a blank screen with tax rate and bid amount. Any ideas? Thanks.

[davewest]

Thanks for the mod Dave. We are having one issue that we can't seem to get past. When shipping an item that needs tax applied I get a blank screen with tax rate and bid amount. Any ideas? Thanks.

Your welcome...
Little more info or I been out in the sun to long today... I pickup the mod on version 1, around then we was having problems with the tax added with each bid. So that piece of code I commented out which stop it. I do tax at checkout by shipping address and that still works. Once the auction completes or a buy now completes, the final price is inserted into the product table and the cart does it normal magic with the tax and so on.... with the new version 1.2 no edits to any of the core cart files such as the \includes\classes\shopping_cart.php file at all. The one on my blog that is, not sure if the addon section one was updated right....

Guess I'm getting a bit lost... If its to do with the checkout page, it maybe something else or a problem I haven't seen, if its on the product page! then its something I'll have to look into more. If you need tax added for each bid.... then I'll have to put that back in with a switch to turn it off/on.