Auction Product Type

[AndyII]

it cant find that table, either there is no table or your table prefix is different?

[bramnick]

make that http://gracefulhosting.com/samplecar...&products_id=3

ANDYII is correct. It appears that the SQL install was wither not done or not done properly. The easiest way to install the DB side of the mods is from the ZEN ADMIN screens (SQL PATCH).
Cut and Paste the SQL install into the box and hit RUN.

[agrace90]

ANDYII is correct. It appears that the SQL install was wither not done or not done properly. The easiest way to install the DB side of the mods is from the ZEN ADMIN screens (SQL PATCH).
Cut and Paste the SQL install into the box and hit RUN.

That is exactly what I did. I even went in and checked to see if it created that table (it did not) and rewrote the php file so that it would. Help.............

[agrace90]

Here is the text I get after doing an sql patch. Am I supposed to be seeing all of this???

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', last_insert_id(), '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', last_insert_id(), '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', last_insert_id(), '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', last_insert_id(), '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', last_insert_id(), '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', last_insert_id(), '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', last_insert_id(), '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', last_insert_id(), '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', last_insert_id(), '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', last_insert_id(), '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', last_insert_id(), '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', last_insert_id(), '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', last_insert_id(), '15', 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?', last_insert_id(), '16', now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''Yes''), array(''id''=>''0'', ''text''=>''No'')), '), ('','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?', last_insert_id(), '100', 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?', last_insert_id(), '101', 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?', last_insert_id(), '102', 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.

[agrace90]

Yes!!! I got it to work. I just started the install over from the beginnning (for the fourth time!!)

[agrace90]

How do I turn on the buy it now function??

[bramnick]

How do I turn on the buy it now function??

When you build (or modify) an auction product, you need to specify a "Buy it now" price.

if it has a BIN price and the current bid does not already exceed it, a button should show up.

Arnold

[agrace90]

I doesn't though..

[AndyII]

bramnick,
can you recall what was changed to stop the bidders name from showing?
I was thinking about the possibility of using the forum nick, and if the data could be pulled from that table instead...

I just uploaded 0.97 It contains a published fix for mooncavecrystals request for 0.01 starting bid (down from 1.00)

Also prints previous bidder's ID instead of first and last names.

No other fixes or enhancements in here.

No DB changes required

ZC team is looking at the upload and once blessed they will place in download area.

[bramnick]

I would have to diff the source code for those 2 versions and see where it is. The change was small, it uses a different DB field is all.