Auction Product Type

Printable View

Show 100 post(s) from this thread on one page

4 Oct 2013, 07:45 PM
Hooley

2 Attachment(s)

Re: Auction Product Type

Hi I'm quite new to this so please don't call me stupid (that's one thing I already know)lol.
I have installed this mod and it is working great, but I've noticed some issues with the display now.
Here are 2 screenshots of the problems.
Anyone help me out here as I've looked through some files but to me it's like looking at a bucket of jumbled letters and numbers. :shocking:
Attachment 13140 Attachment 13141
any help would be hugely appreciated.
4 Oct 2013, 08:09 PM
Hooley

Re: Auction Product Type

Also this is what I get as the "help pop-up"
HEADING_AUCTION_HELP
TEXT_AUCTION_HELP

TEXT_CLOSE_AUCTION_HELP_WINDOW
4 Oct 2013, 11:51 PM
Hooley

Re: Auction Product Type

Sorted :)
20 Jan 2014, 03:16 AM
countrycharm

Re: Auction Product Type

Quote:

Originally Posted by Hooley

Sorted :)

And you did what just in case someone else runs into this problem and needs help.
19 Jul 2014, 12:24 AM
jsarwar

Re: Auction Product Type

Tried

Code:

DROP TABLE IF EXISTS product_auction_extra; CREATE TABLE product_auction_extra ( products_id int(11) NOT NULL default '0', auction_clock tinyint(1) NOT NULL default '0', bid_expire_date date NOT NULL default '0000-00-00', bid_expire_hour tinyint(2) NOT NULL default '0', bid_reserve_price decimal(10,2) NOT NULL default '0.00', bid_buynow_price decimal(10,4) NOT NULL default '0.0000', bid_start_price DECIMAL( 10, 2 ) NOT NULL, auction_closed VARCHAR( 1 ) DEFAULT 'N' NOT NULL, last_auction_winner_email_sent DATETIME NOT NULL, auction_closed_email_sent VARCHAR( 1 ) DEFAULT 'N' NOT NULL, bid_minimum_increase decimal(10,2) NOT NULL default '0.00', auction_start int(1) NOT NULL default '0', PRIMARY KEY (products_id) ) ENGINE=MyISAM; # ADD some indicies TO make the queries RUN faster looking FOR closed auctions ALTER TABLE product_auction_extra ADD INDEX (bid_expire_date); ALTER TABLE product_auction_extra ADD INDEX (bid_expire_hour); ALTER TABLE product_auction_extra ADD INDEX (auction_closed); # Table structure for table products_auctions DROP TABLE IF EXISTS products_auctions; CREATE TABLE products_auctions ( `bid_id` int(11) NOT NULL auto_increment, `customers_id` int(11) NOT NULL default '0', `products_id` int(11) NOT NULL default '0', `customers_bid` decimal(15,4) NOT NULL default '0.0000', `date_of_bid` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`bid_id`), KEY (`date_of_bid`) ) ENGINE=MyISAM; SET @t3=0; SELECT @t3:=type_id FROM product_types WHERE type_name = 'Product - Auction' LIMIT 1; DELETE FROM product_type_layout WHERE product_type_id = @t3; DELETE FROM product_types WHERE type_id = @t3; INSERT INTO product_types VALUES ('', 'Product - Auction', 'product_auction', '1', 'N', '', now(), now()); SET @t4=0; SELECT (@t4:=type_id) as t4 FROM product_types WHERE type_handler= 'product_auction'; INSERT INTO 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'')), '), #admin defaults ('','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'')),'), #added for image and meta tags ('','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'')), '); INSERT INTO configuration_group VALUES ('', 'Auction Manager', 'Set Auction Options', '1', '1'); UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id(); SET @t4=0; SELECT (@t4:=configuration_group_id) as t4 FROM configuration_group WHERE configuration_group_title= 'Auction Manager'; INSERT INTO configuration VALUES ('', 'Display previous bids to logged in users', 'AUCTION_INFO_DISPLAY_PREVIOUS_BIDS', '1', 'Allow logged in users see previous bids', @t4, 1, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('', 'Display previous bid count', 'AUCTION_INFO_DISPLAY_PREVIOUS_BIDS_COUNT', '1', 'Display previous bid count', @t4, 2, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('', 'Display reserve not met message', 'AUCTION_INFO_DISPLAY_RESERVE_NOT_MET', '1', 'Display reserve not met message', @t4, 3, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('', 'Display buy it now button', 'AUCTION_INFO_DISPLAY_BUY_NOW', '1', 'Display buy it now button for items that have not met their reserve', @t4, 4, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('', 'Remove winning auction item from cart', 'AUCTION_INFO_DISPLAY_CART_REMOVE', '0', 'Allow customer to remove won aution item from shopping cart', @t4, 5, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('', 'Display winning bidders name', 'AUCTION_INFO_DISPLAY_WIN_BID_NAME', '1', 'Display winning bidders name', @t4, 6, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('', 'Display winning bidders bid', 'AUCTION_INFO_DISPLAY_WIN_BID_BID', '1', 'Display winning bidders bid', @t4, 7, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('', 'Use CRON detection of auction close', 'AUCTION_CRON_ENABLE', '0', 'When Disabled (0=False), detecting closed auctions accrues during each page load. Enabling (1=True), will speed up your entire zen site BUT you must add a cron job or your auctions will never be detected as closed. Check with your host for instructions on the right way to set CRON jobs php -f /YOUR STORE PATH/cron.php >> /dev/null', @t4, 8, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('', 'Display Pay Now button to winners', 'AUCTION_INFO_DISPLAY_PAY_NOW', '1', 'Display the Pay Now button or auto add to cart', @t4, 9, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('', 'Max bid for any product', 'MAX_AUCTION_BID_AMOUNT', '200', 'Enter the largest amount one can bid for a auction, whole numbers only (5000)?', @t4, 10, now(), now(), NULL, NULL), #added for auction sidebox ('','Number of Products Auction SideBox', 'MAX_AUCTION_SIDEBOX_PRODUCTS', '2', 'Number of random Auction products to rotate in the sidebox Enter the number of products to display in this sidebox at one time. How many products do you want to display in this sidebox?', @t4, 11, now(), now(), NULL, NULL), ('','Image - Auction SideBox Products Width', 'IMAGE_AUCTION_SIDEBOX_PRODUCTS_LISTING_WIDTH', '100', 'Default = 100', @t4, 12, now(), now(), NULL, NULL), ('','Image - Auction SideBox Products Height', 'IMAGE_AUCTION_SIDEBOX_PRODUCTS_LISTING_HEIGHT', '80', 'Default = 80', @t4, 13, now(), now(), NULL, NULL), ('','Display Auction SideBox Product Image', 'PRODUCT_AUCTION_SIDEBOX_LIST_IMAGE', '1', 'Do you want to display the Product Image? 0= off 1= on', @t4, 14, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')), '), ('','Display Auction SideBox Product Name', 'PRODUCT_AUCTION_SIDEBOX_NAME', '1', 'Do you want to display the Product Name? 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'')), '), ('','Display Auction SideBox Product Price', 'PRODUCT_AUCTION_SIDEBOX_PRICE', '1', 'Do you want to display the Product Price 0= off 1= on', @t4, 16, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')), '), ('','Display Auction SideBox Product Time Left', 'PRODUCT_AUCTION_SIDEBOX_DATE_ADDED', '1', 'Do you want to display the Product Time left? 0= off 1= on', @t4, 17, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')), '), ('','Display Auction SideBox Product Description', 'PRODUCT_AUCTION_SIDEBOX_DESCRIPTION', '150', 'How many characters do you want to display of the Product Description? 0= OFF 150= Suggested Length, or enter the maximum number of characters to display', @t4, 18, now(), now(), NULL, NULL), #added for the information sidebox ('','Display Auction Information link in the Information sidebox', 'DEFINE_AUCTION_STATUS', '1', 'Display Auction Information link in the Information sidebox! 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'')), '), #added for the auction manager ('','Number of Bids, Content Box', 'DISPLAY_AUCTION_BIDS', '2', 'How Many bids to display in the Auction Manager Content Box! Default is 2', @t4, 20, now(), now(), NULL, NULL); # ADD Auctions Manager menu items to admin menus INSERT INTO admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order) VALUES ('configAuctionManager','BOX_CONFIGURATION_AUCTION_MANAGER','FILENAME_CONFIGURATION', CONCAT('gID=',@t4),'configuration','Y',@t4), ('auctions','BOX_CATALOG_AUCTIONS_MANAGER','FILENAME_AUCTIONS_PRODUCTS','','catalog','Y','18'), ('convertType','BOX_TOOLS_CONVERT_TYPE','FILENAME_CONVERT_TYPE','','tools','Y','14');

and getting following error:

Code:

1136 Column count doesn't match value count at row 1 in: [INSERT INTO zen_configuration VALUES ('', 'Display previous bids to logged in users', 'AUCTION_INFO_DISPLAY_PREVIOUS_BIDS', '1', 'Allow logged in users see previous bids', @t4, 1, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('', 'Display previous bid count', 'AUCTION_INFO_DISPLAY_PREVIOUS_BIDS_COUNT', '1', 'Display previous bid count', @t4, 2, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('', 'Display reserve not met message', 'AUCTION_INFO_DISPLAY_RESERVE_NOT_MET', '1', 'Display reserve not met message', @t4, 3, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('', 'Display buy it now button', 'AUCTION_INFO_DISPLAY_BUY_NOW', '1', 'Display buy it now button for items that have not met their reserve', @t4, 4, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('', 'Remove winning auction item from cart', 'AUCTION_INFO_DISPLAY_CART_REMOVE', '0', 'Allow customer to remove won aution item from shopping cart', @t4, 5, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('', 'Display winning bidders name', 'AUCTION_INFO_DISPLAY_WIN_BID_NAME', '1', 'Display winning bidders name', @t4, 6, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('', 'Display winning bidders bid', 'AUCTION_INFO_DISPLAY_WIN_BID_BID', '1', 'Display winning bidders bid', @t4, 7, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('', 'Use CRON detection of auction close', 'AUCTION_CRON_ENABLE', '0', 'When Disabled (0=False), detecting closed auctions accrues during each page load. Enabling (1=True), will speed up your entire zen site BUT you must add a cron job or your auctions will never be detected as closed. Check with your host for instructions on the right way to set CRON jobs php -f /YOUR STORE PATH/cron.php >> /dev/null', @t4, 8, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('', 'Display Pay Now button to winners', 'AUCTION_INFO_DISPLAY_PAY_NOW', '1', 'Display the Pay Now button or auto add to cart', @t4, 9, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('', 'Max bid for any product', 'MAX_AUCTION_BID_AMOUNT', '200', 'Enter the largest amount one can bid for a auction, whole numbers only (5000)?', @t4, 10, now(), now(), NULL, NULL), ('','Number of Products Auction SideBox', 'MAX_AUCTION_SIDEBOX_PRODUCTS', '2', 'Number of random Auction products to rotate in the sidebox Enter the number of products to display in this sidebox at one time. How many products do you want to display in this sidebox?', @t4, 11, now(), now(), NULL, NULL), ('','Image - Auction SideBox Products Width', 'IMAGE_AUCTION_SIDEBOX_PRODUCTS_LISTING_WIDTH', '100', 'Default = 100', @t4, 12, now(), now(), NULL, NULL), ('','Image - Auction SideBox Products Height', 'IMAGE_AUCTION_SIDEBOX_PRODUCTS_LISTING_HEIGHT', '80', 'Default = 80', @t4, 13, now(), now(), NULL, NULL), ('','Display Auction SideBox Product Image', 'PRODUCT_AUCTION_SIDEBOX_LIST_IMAGE', '1', 'Do you want to display the Product Image? 0= off 1= on', @t4, 14, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')), '), ('','Display Auction SideBox Product Name', 'PRODUCT_AUCTION_SIDEBOX_NAME', '1', 'Do you want to display the Product Name? 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'')), '), ('','Display Auction SideBox Product Price', 'PRODUCT_AUCTION_SIDEBOX_PRICE', '1', 'Do you want to display the Product Price 0= off 1= on', @t4, 16, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')), '), ('','Display Auction SideBox Product Time Left', 'PRODUCT_AUCTION_SIDEBOX_DATE_ADDED', '1', 'Do you want to display the Product Time left? 0= off 1= on', @t4, 17, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')), '), ('','Display Auction SideBox Product Description', 'PRODUCT_AUCTION_SIDEBOX_DESCRIPTION', '150', 'How many characters do you want to display of the Product Description? 0= OFF 150= Suggested Length, or enter the maximum number of characters to display', @t4, 18, now(), now(), NULL, NULL), ('','Display Auction Information link in the Information sidebox', 'DEFINE_AUCTION_STATUS', '1', 'Display Auction Information link in the Information sidebox! 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'')), '), ('','Number of Bids, Content Box', 'DISPLAY_AUCTION_BIDS', '2', 'How Many bids to display in the Auction Manager Content Box! Default is 2', @t4, 20, now(), now(), NULL, NULL);]

Can you please correct this issue in sql for me?
2 May 2015, 01:32 AM
dfontana

Re: Auction Product Type

Quote:

Originally Posted by web1kreativ

Hi Insenterprises,
here is the sidebox information.php with the auction info as the second from top. Copy this file in your sideboxes folder without merging.
I took your "previous" information.php and added the auction info link.
Thanks,
Richard

Thanks for the zip file as well, it fixed my issue as well but still see BOX_INFORMATION_AUCTION in the Information box. can you tell me what to change to fix that display item?
2 May 2015, 10:14 PM
davewest

Re: Auction Product Type

Quote:

Originally Posted by dfontana

Thanks for the zip file as well, it fixed my issue as well but still see BOX_INFORMATION_AUCTION in the Information box. can you tell me what to change to fix that display item?

you need to have the BOX_INFORMATION_AUCTION defined somewhere like
languages/english/extra_definitions/YOUR_TEMPLATE/auctions_random_defines.php

which is where mine is..

Code:

//for information sidebox define('BOX_INFORMATION_AUCTION', 'Auction Information');

I'm not using it there, but moved to the megamenu in the info drop down... however, the define is in the file above...
18 Sep 2015, 09:50 PM
jodean

Re: Auction Product Type

Is the current 1.5.0 version compatible with 1.5.1?
19 Sep 2015, 06:22 PM
davewest

Re: Auction Product Type

Quote:

Originally Posted by jodean

Is the current 1.5.0 version compatible with 1.5.1?

If you install on a test site and do a comparison using Meld or Beyond compare you should be able to make it work. I'm no longer using the current plugin, but a more modified version on a ZC1.5.4 site...
19 Sep 2015, 08:26 PM
jodean

1 Attachment(s)

Re: Auction Product Type

I did a merge using Beyond 4. Most of the pages work but the product_auction_info page has some problems with some data definitions. I have attached a snip of the page highlighting the problems. If you have any guidance it would be appreciated.
19 Sep 2015, 10:30 PM
jodean

Re: Auction Product Type

I found that product_auction_info.php was not getting executed in the \includes\languages\english\<my override folder>. I moved the code to \includes\languages\english\ folder. Now the product_auction_info.php is executed.
13 Feb 2017, 04:38 AM
BuddyS

Re: Auction Product Type

Hers what it does when we try to list items for auction:

TEXT_AUCTION_TAG_LINE
Auction HelpMOON, STAR GOLD ORNAMENT
larger image
MOON, STAR GOLD ORNAMENT
Auction ends on 2/26/2017
at 1:00 AM Local Time
0 AUCTION_BIDS
Time left: 13 days, 2 hours, 29 minutes, 30 seconds
Starting Bid! $0.00
TEXT_PRODUCT_MODELC-0173
TEXT_PRODUCT_WEIGHT0.5lbs
10TEXT_PRODUCT_QUANTITY
Sign In to Bid!
BUY_NOW_PRICE $34.97 Quantity in Cart: 2 BUTTON_AUCTION_BUY_NOW_ALT

Any ideas on fixing it? Also once you get it in Shopping Cart for BUY NOW - You can't get out. :blink:
13 Feb 2017, 11:12 PM
davewest

1 Attachment(s)

Re: Auction Product Type

Quote:

Originally Posted by BuddyS

Hers what it does when we try to list items for auction:

TEXT_AUCTION_TAG_LINE
Auction HelpMOON, STAR GOLD ORNAMENT
larger image
MOON, STAR GOLD ORNAMENT
Auction ends on 2/26/2017
at 1:00 AM Local Time
0 AUCTION_BIDS
Time left: 13 days, 2 hours, 29 minutes, 30 seconds
Starting Bid! $0.00
TEXT_PRODUCT_MODELC-0173
TEXT_PRODUCT_WEIGHT0.5lbs
10TEXT_PRODUCT_QUANTITY
Sign In to Bid!
BUY_NOW_PRICE $34.97 Quantity in Cart: 2 BUTTON_AUCTION_BUY_NOW_ALT

Any ideas on fixing it? Also once you get it in Shopping Cart for BUY NOW - You can't get out. :blink:

Check your language file that it was placed and readable, 644. Should be in your template over ride system. ( product_auction_info.php )

I see in this current mod that the return to stock was never fixed.. It's another script that should be in the extra cart actions folder to remove the item, correct the price and place it back in stock. I'm not sure my version will work but you can give it a try!
7 May 2018, 02:33 PM
jodean

Re: Auction Product Type

I upgraded to v1.5.5f. I really like the new Responsive Template in the current release. Do you have any ideas how can I use the Product Auction with the Responsive Template?
9 May 2018, 04:45 PM
mc12345678

Re: Auction Product Type

Quote:

Originally Posted by jodean

I upgraded to v1.5.5f. I really like the new Responsive Template in the current release. Do you have any ideas how can I use the Product Auction with the Responsive Template?

Regardless the plugin, typically by merging the changes made to a template file supporting operation with the "alternate" template will offer continued operation, whether the template(s) were responsive or not. If the application uses html tags to present information such as <table... or <span..., the tags may need to be modified/changed to integrate with the specific template. Generally speaking and as memory serves, the template related files from this plugin would need to be incorporated into the template override directory for the responsive template similar to above.
9 May 2018, 05:42 PM
dbltoe

Re: Auction Product Type

The stylesheet is standalone to the template and should have no effect.

My main concern would be whether or not PHP versions might be a problem. The mod was last updated in the PHP 5.3 era and 1.5.5f will run on that version IF you haven't added a mod that conflicts with PHP 5.3.

Depending on your capabilities, you could check out the mod for PHP version compatibility or make a PHP 5.3 test site with a copy of the module. Then, gradually up the PHP till a problem occurs.
18 Aug 2018, 08:36 PM
jodean

Re: Auction Product Type

Is Auction Product Type supposed to be compatible with ver 1.5.5f?
18 Aug 2018, 10:50 PM
davewest

Re: Auction Product Type

Quote:

Originally Posted by jodean

Is Auction Product Type supposed to be compatible with ver 1.5.5f?

Not at all compatible..

I have something like it running on a ZC1.5.5f with php7.1.14 but its not the same version as this mod.
19 Aug 2018, 04:08 PM
jodean

Re: Auction Product Type

What are you running?
Is it available for download?
20 Aug 2018, 04:21 AM
davewest

Re: Auction Product Type

Quote:

What are you running?

My own code..

Quote:

Is it available for download?

Not at this time.. As I work through the mods I use and get ready for the next upgrade, it could be done too. This mod is hard to KISS install so its not high on my to do list for uploading right now...
3 Sep 2018, 01:49 PM
jodean

Re: Auction Product Type

I have been looking for several weeks now for a replacement. Unfortunately there is nothing out there which comes close to the simplicity of your plugin let alone it integrating with Zen Cart. I hope you will find some time someday to upgrade it to 1.5.5f.
24 Oct 2018, 06:14 PM
sjdeines

Re: Auction Product Type

If you have the same product on eBay, you can embed the URL for the 'Make Offer' button on eBay within the Product on ZenCart. Just right click on eBay's Make Offer button and select copy, then paste the http link in the following code located within your ZenCart's description of the item: <a target="_blank" href="http://offer.ebay.com/ws/eBayISAPI.dll?MakeBestOffer&rev=6&itemId=xxxxxxxx">Make Offer</a>
27 Apr 2021, 12:44 PM
LilleyPadGifts

Re: Auction Product Type

Does this plugin allow a Auction “option”? Meaning you can still list inventory the regular way but have the option to list auctions as well?

Is anyone using this successfully in their site and willing to share a link so I can see what it looks like from the customer view?
Thanks!
27 Apr 2021, 01:16 PM
mc12345678

Re: Auction Product Type

Quote:

Originally Posted by LilleyPadGifts

Does this plugin allow a Auction “option”? Meaning you can still list inventory the regular way but have the option to list auctions as well?

Is anyone using this successfully in their site and willing to share a link so I can see what it looks like from the customer view?
Thanks!

I haven't tried this software in some time, but what it does is offer an additional product type (rather than the default general product, document product, document only, music etc) so that the designated product may be offered as an auction type. That meaning, the product created as an auction type are the only offered for auction and the remaining product "work" as designed. So you don't "lose" the ability for the store to work as normal, but gain the ability of offering product via auction.

As such, I don't have a link to demonstrate its perspective; however, perhaps in your development location you could try it out?
22 Jul 2021, 04:30 AM
LilleyPadGifts

Re: Auction Product Type
I'm trying to install this using the instructions that come with it.
The first steps is:
1. Open the sql file copy and paste into install sql patches
but I get this ...

WARNING: An Error occurred, please refresh the page and try again.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.

No clue what to do with that as its not specific enough for me to know where the issue is.
Anybody?
23 Jul 2021, 08:51 PM
lat9

Re: Auction Product Type
Quote:
Originally Posted by LilleyPadGifts

I'm trying to install this using the instructions that come with it.
The first steps is:

Open the sql file copy and paste into install sql patches

but I get this ...

WARNING: An Error occurred, please refresh the page and try again.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.

No clue what to do with that as its not specific enough for me to know where the issue is.
Anybody?
There's a myDEBUG-adm-*.log file present in the site's /logs sub-directory waiting to let you know what the underlying issue is. Since it's an admin-generated log, be mindful to change the admin directory name which will be present in the file's contents prior to posting!
24 Jul 2021, 01:19 AM
LilleyPadGifts

Re: Auction Product Type

Quote:

Originally Posted by lat9

There's a myDEBUG-adm-*.log file present in the site's /logs sub-directory waiting to let you know what the underlying issue is. Since it's an admin-generated log, be mindful to change the admin directory name which will be present in the file's contents prior to posting!

Is this it ?

[22-Jul-2021 19:57:05 America/New_York] Request URI: /CarlsComics/MYADMINNAME/index.php?cmd=sqlpatch&action=execute, IP address: 66.27.190.49
#1 trigger_error() called at [/home/my2xjapd1vrv/acomiccon.thedesertcactus.com/CarlsComics/includes/classes/db/mysql/query_factory.php:170]
#2 queryFactory->show_error() called at [/home/my2xjapd1vrv/acomiccon.thedesertcactus.com/CarlsComics/includes/classes/db/mysql/query_factory.php:142]
#3 queryFactory->set_error() called at [/home/my2xjapd1vrv/acomiccon.thedesertcactus.com/CarlsComics/includes/classes/db/mysql/query_factory.php:269]
#4 queryFactory->Execute() called at [/home/my2xjapd1vrv/acomiccon.thedesertcactus.com/CarlsComics/MYADMINNAME/sqlpatch.php:291]
#5 executeSql() called at [/home/my2xjapd1vrv/acomiccon.thedesertcactus.com/CarlsComics/MYADMINNAME/sqlpatch.php:736]
#6 require(/home/my2xjapd1vrv/acomiccon.thedesertcactus.com/CarlsComics/MYADMINNAME/sqlpatch.php) called at [/home/my2xjapd1vrv/acomiccon.thedesertcactus.com/CarlsComics/MYADMINNAME/index.php:11]
--> PHP Fatal error: 1136:Column count doesn't match value count at row 1 :: INSERT INTO configuration VALUES ('', 'Display previous bids to logged in users', 'AUCTION_INFO_DISPLAY_PREVIOUS_BIDS', '1', 'Allow logged in users see previous bids', @t4, 1, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('', 'Display previous bid count', 'AUCTION_INFO_DISPLAY_PREVIOUS_BIDS_COUNT', '1', 'Display previous bid count', @t4, 2, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('', 'Display reserve not met message', 'AUCTION_INFO_DISPLAY_RESERVE_NOT_MET', '1', 'Display reserve not met message', @t4, 3, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('', 'Display buy it now button', 'AUCTION_INFO_DISPLAY_BUY_NOW', '1', 'Display buy it now button for items that have not met their reserve', @t4, 4, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('', 'Remove winning auction item from cart', 'AUCTION_INFO_DISPLAY_CART_REMOVE', '0', 'Allow customer to remove won aution item from shopping cart', @t4, 5, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('', 'Display winning bidders name', 'AUCTION_INFO_DISPLAY_WIN_BID_NAME', '1', 'Display winning bidders name', @t4, 6, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('', 'Display winning bidders bid', 'AUCTION_INFO_DISPLAY_WIN_BID_BID', '1', 'Display winning bidders bid', @t4, 7, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('', 'Use CRON detection of auction close', 'AUCTION_CRON_ENABLE', '0', 'When Disabled (0=False), detecting closed auctions accrues during each page load. Enabling (1=True), will speed up your entire zen site BUT you must add a cron job or your auctions will never be detected as closed. Check with your host for instructions on the right way to set CRON jobs php -f /YOUR STORE PATH/cron.php >> /dev/null', @t4, 8, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('', 'Display Pay Now button to winners', 'AUCTION_INFO_DISPLAY_PAY_NOW', '1', 'Display the Pay Now button or auto add to cart', @t4, 9, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('', 'Max bid for any product', 'MAX_AUCTION_BID_AMOUNT', '200', 'Enter the largest amount one can bid for a auction, whole numbers only (5000)?', @t4, 10, now(), now(), NULL, NULL), ('','Number of Products Auction SideBox', 'MAX_AUCTION_SIDEBOX_PRODUCTS', '2', 'Number of random Auction products to rotate in the sidebox Enter the number of products to display in this sidebox at one time. How many products do you want to display in this sidebox?', @t4, 11, now(), now(), NULL, NULL), ('','Image - Auction SideBox Products Width', 'IMAGE_AUCTION_SIDEBOX_PRODUCTS_LISTING_WIDTH', '100', 'Default = 100', @t4, 12, now(), now(), NULL, NULL), ('','Image - Auction SideBox Products Height', 'IMAGE_AUCTION_SIDEBOX_PRODUCTS_LISTING_HEIGHT', '80', 'Default = 80', @t4, 13, now(), now(), NULL, NULL), ('','Display Auction SideBox Product Image', 'PRODUCT_AUCTION_SIDEBOX_LIST_IMAGE', '1', 'Do you want to display the Product Image? 0= off 1= on', @t4, 14, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')), '), ('','Display Auction SideBox Product Name', 'PRODUCT_AUCTION_SIDEBOX_NAME', '1', 'Do you want to display the Product Name? 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'')), '), ('','Display Auction SideBox Product Price', 'PRODUCT_AUCTION_SIDEBOX_PRICE', '1', 'Do you want to display the Product Price 0= off 1= on', @t4, 16, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')), '), ('','Display Auction SideBox Product Time Left', 'PRODUCT_AUCTION_SIDEBOX_DATE_ADDED', '1', 'Do you want to display the Product Time left? 0= off 1= on', @t4, 17, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')), '), ('','Display Auction SideBox Product Description', 'PRODUCT_AUCTION_SIDEBOX_DESCRIPTION', '150', 'How many characters do you want to display of the Product Description? 0= OFF 150= Suggested Length, or enter the maximum number of characters to display', @t4, 18, now(), now(), NULL, NULL), ('','Display Auction Information link in the Information sidebox', 'DEFINE_AUCTION_STATUS', '1', 'Display Auction Information link in the Information sidebox! 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'')), '), ('','Number of Bids, Content Box', 'DISPLAY_AUCTION_BIDS', '2', 'How Many bids to display in the Auction Manager Content Box! Default is 2', @t4, 20, now(), now(), NULL, NULL); ==> (as called by) /home/my2xjapd1vrv/acomiccon.thedesertcactus.com/CarlsComics/MYADMINNAME/sqlpatch.php on line 291 <== in /home/my2xjapd1vrv/acomiccon.thedesertcactus.com/CarlsComics/includes/classes/db/mysql/query_factory.php on line 170.
24 Jul 2021, 04:19 PM
lat9

Re: Auction Product Type

The underlying issue here is that the SQL is performing a blind insert, i.e. it's not specifying which columns should receive which values. There is now an additional field (val_function) in the configuration table and that's where the column-count mismatch comes from.

If you would, post that SQL in a 'CODE' block so it's easier to see and I'll provide an update that will work with zc156 and later.
24 Jul 2021, 11:05 PM
LilleyPadGifts

Re: Auction Product Type

Quote:

Originally Posted by lat9

The underlying issue here is that the SQL is performing a blind insert, i.e. it's not specifying which columns should receive which values. There is now an additional field (val_function) in the configuration table and that's where the column-count mismatch comes from.

If you would, post that SQL in a 'CODE' block so it's easier to see and I'll provide an update that will work with zc156 and later.

Code:

DROP TABLE IF EXISTS product_auction_extra;CREATE TABLE product_auction_extra ( products_id int(11) NOT NULL default '0', auction_clock tinyint(1) NOT NULL default '0', bid_expire_date date NOT NULL default '0000-00-00', bid_expire_hour tinyint(2) NOT NULL default '0', bid_reserve_price decimal(10,2) NOT NULL default '0.00', bid_buynow_price decimal(10,4) NOT NULL default '0.0000', bid_start_price DECIMAL( 10, 2 ) NOT NULL, auction_closed VARCHAR( 1 ) DEFAULT 'N' NOT NULL, last_auction_winner_email_sent DATETIME NOT NULL, auction_closed_email_sent VARCHAR( 1 ) DEFAULT 'N' NOT NULL, bid_minimum_increase decimal(10,2) NOT NULL default '0.00', auction_start int(1) NOT NULL default '0', PRIMARY KEY (products_id) ) ENGINE=MyISAM; # ADD some indicies TO make the queries RUN faster looking FOR closed auctions ALTER TABLE product_auction_extra ADD INDEX (bid_expire_date); ALTER TABLE product_auction_extra ADD INDEX (bid_expire_hour); ALTER TABLE product_auction_extra ADD INDEX (auction_closed); # Table structure for table products_auctions DROP TABLE IF EXISTS products_auctions; CREATE TABLE products_auctions ( `bid_id` int(11) NOT NULL auto_increment, `customers_id` int(11) NOT NULL default '0', `products_id` int(11) NOT NULL default '0', `customers_bid` decimal(15,4) NOT NULL default '0.0000', `date_of_bid` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`bid_id`), KEY (`date_of_bid`) ) ENGINE=MyISAM; SET @t3=0; SELECT @t3:=type_id FROM product_types WHERE type_name = 'Product - Auction' LIMIT 1; DELETE FROM product_type_layout WHERE product_type_id = @t3; DELETE FROM product_types WHERE type_id = @t3; INSERT INTO product_types VALUES ('', 'Product - Auction', 'product_auction', '1', 'N', '', now(), now()); SET @t4=0; SELECT (@t4:=type_id) as t4 FROM product_types WHERE type_handler= 'product_auction'; INSERT INTO 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'')), '), #admin defaults ('','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'')),'), #added for image and meta tags ('','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'')), '); INSERT INTO configuration_group VALUES ('', 'Auction Manager', 'Set Auction Options', '1', '1'); UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id(); SET @t4=0; SELECT (@t4:=configuration_group_id) as t4 FROM configuration_group WHERE configuration_group_title= 'Auction Manager'; INSERT INTO configuration VALUES ('', 'Display previous bids to logged in users', 'AUCTION_INFO_DISPLAY_PREVIOUS_BIDS', '1', 'Allow logged in users see previous bids', @t4, 1, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('', 'Display previous bid count', 'AUCTION_INFO_DISPLAY_PREVIOUS_BIDS_COUNT', '1', 'Display previous bid count', @t4, 2, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('', 'Display reserve not met message', 'AUCTION_INFO_DISPLAY_RESERVE_NOT_MET', '1', 'Display reserve not met message', @t4, 3, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('', 'Display buy it now button', 'AUCTION_INFO_DISPLAY_BUY_NOW', '1', 'Display buy it now button for items that have not met their reserve', @t4, 4, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('', 'Remove winning auction item from cart', 'AUCTION_INFO_DISPLAY_CART_REMOVE', '0', 'Allow customer to remove won aution item from shopping cart', @t4, 5, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('', 'Display winning bidders name', 'AUCTION_INFO_DISPLAY_WIN_BID_NAME', '1', 'Display winning bidders name', @t4, 6, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('', 'Display winning bidders bid', 'AUCTION_INFO_DISPLAY_WIN_BID_BID', '1', 'Display winning bidders bid', @t4, 7, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('', 'Use CRON detection of auction close', 'AUCTION_CRON_ENABLE', '0', 'When Disabled (0=False), detecting closed auctions accrues during each page load. Enabling (1=True), will speed up your entire zen site BUT you must add a cron job or your auctions will never be detected as closed. Check with your host for instructions on the right way to set CRON jobs php -f /YOUR STORE PATH/cron.php >> /dev/null', @t4, 8, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('', 'Display Pay Now button to winners', 'AUCTION_INFO_DISPLAY_PAY_NOW', '1', 'Display the Pay Now button or auto add to cart', @t4, 9, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('', 'Max bid for any product', 'MAX_AUCTION_BID_AMOUNT', '200', 'Enter the largest amount one can bid for a auction, whole numbers only (5000)?', @t4, 10, now(), now(), NULL, NULL), #added for auction sidebox ('','Number of Products Auction SideBox', 'MAX_AUCTION_SIDEBOX_PRODUCTS', '2', 'Number of random Auction products to rotate in the sidebox Enter the number of products to display in this sidebox at one time. How many products do you want to display in this sidebox?', @t4, 11, now(), now(), NULL, NULL), ('','Image - Auction SideBox Products Width', 'IMAGE_AUCTION_SIDEBOX_PRODUCTS_LISTING_WIDTH', '100', 'Default = 100', @t4, 12, now(), now(), NULL, NULL), ('','Image - Auction SideBox Products Height', 'IMAGE_AUCTION_SIDEBOX_PRODUCTS_LISTING_HEIGHT', '80', 'Default = 80', @t4, 13, now(), now(), NULL, NULL), ('','Display Auction SideBox Product Image', 'PRODUCT_AUCTION_SIDEBOX_LIST_IMAGE', '1', 'Do you want to display the Product Image? 0= off 1= on', @t4, 14, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')), '), ('','Display Auction SideBox Product Name', 'PRODUCT_AUCTION_SIDEBOX_NAME', '1', 'Do you want to display the Product Name? 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'')), '), ('','Display Auction SideBox Product Price', 'PRODUCT_AUCTION_SIDEBOX_PRICE', '1', 'Do you want to display the Product Price 0= off 1= on', @t4, 16, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')), '), ('','Display Auction SideBox Product Time Left', 'PRODUCT_AUCTION_SIDEBOX_DATE_ADDED', '1', 'Do you want to display the Product Time left? 0= off 1= on', @t4, 17, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')), '), ('','Display Auction SideBox Product Description', 'PRODUCT_AUCTION_SIDEBOX_DESCRIPTION', '150', 'How many characters do you want to display of the Product Description? 0= OFF 150= Suggested Length, or enter the maximum number of characters to display', @t4, 18, now(), now(), NULL, NULL), #added for the information sidebox ('','Display Auction Information link in the Information sidebox', 'DEFINE_AUCTION_STATUS', '1', 'Display Auction Information link in the Information sidebox! 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'')), '), #added for the auction manager ('','Number of Bids, Content Box', 'DISPLAY_AUCTION_BIDS', '2', 'How Many bids to display in the Auction Manager Content Box! Default is 2', @t4, 20, now(), now(), NULL, NULL); # ADD Auctions Manager menu items to admin menus INSERT INTO admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order) VALUES ('configAuctionManager','BOX_CONFIGURATION_AUCTION_MANAGER','FILENAME_CONFIGURATION', CONCAT('gID=',@t4),'configuration','Y',@t4), ('auctions','BOX_CATALOG_AUCTIONS_MANAGER','FILENAME_AUCTIONS_PRODUCTS','','catalog','Y','18'), ('convertType','BOX_TOOLS_CONVERT_TYPE','FILENAME_CONVERT_TYPE','','tools','Y','14');
25 Jul 2021, 01:10 PM
lat9

Re: Auction Product Type

Here's my suggested update.

1. Within the two tables inserted, there were 0000-00-00 formatted date/datetime fields that will wreak havoc with now-current versions of mySQL (i.e. those default values will generate errors, if defaulted). I've changed them to 0001-01-01 default date values. Note that you'll need to review the plugin's use of those values to make sure that it's not looking for the 0000-00-00 values specifically.

2. For the configuration table, I've added the table field-names for the inserts. I also removed the (unneeded) first element which would result in the auto-numbered configuration_id value.

Code:

DROP TABLE IF EXISTS product_auction_extra;CREATE TABLE product_auction_extra ( products_id int(11) NOT NULL default '0', auction_clock tinyint(1) NOT NULL default '0', bid_expire_date date NOT NULL default '0001-01-01', bid_expire_hour tinyint(2) NOT NULL default '0', bid_reserve_price decimal(10,2) NOT NULL default '0.00', bid_buynow_price decimal(10,4) NOT NULL default '0.0000', bid_start_price DECIMAL( 10, 2 ) NOT NULL, auction_closed VARCHAR( 1 ) DEFAULT 'N' NOT NULL, last_auction_winner_email_sent DATETIME NOT NULL, auction_closed_email_sent VARCHAR( 1 ) DEFAULT 'N' NOT NULL, bid_minimum_increase decimal(10,2) NOT NULL default '0.00', auction_start int(1) NOT NULL default '0', PRIMARY KEY (products_id) ) ENGINE=MyISAM; # ADD some indicies TO make the queries RUN faster looking FOR closed auctions ALTER TABLE product_auction_extra ADD INDEX (bid_expire_date); ALTER TABLE product_auction_extra ADD INDEX (bid_expire_hour); ALTER TABLE product_auction_extra ADD INDEX (auction_closed); # Table structure for table products_auctions DROP TABLE IF EXISTS products_auctions; CREATE TABLE products_auctions ( `bid_id` int(11) NOT NULL auto_increment, `customers_id` int(11) NOT NULL default '0', `products_id` int(11) NOT NULL default '0', `customers_bid` decimal(15,4) NOT NULL default '0.0000', `date_of_bid` datetime NOT NULL default '0001-01-01 00:00:00', PRIMARY KEY (`bid_id`), KEY (`date_of_bid`) ) ENGINE=MyISAM; SET @t3=0; SELECT @t3:=type_id FROM product_types WHERE type_name = 'Product - Auction' LIMIT 1; DELETE FROM product_type_layout WHERE product_type_id = @t3; DELETE FROM product_types WHERE type_id = @t3; INSERT INTO product_types VALUES ('', 'Product - Auction', 'product_auction', '1', 'N', '', now(), now()); SET @t4=0; SELECT (@t4:=type_id) as t4 FROM product_types WHERE type_handler= 'product_auction'; INSERT INTO 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'')), '), #admin defaults ('','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'')),'), #added for image and meta tags ('','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'')), '); INSERT INTO configuration_group VALUES ('', 'Auction Manager', 'Set Auction Options', '1', '1'); UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id(); SET @t4=0; SELECT (@t4:=configuration_group_id) as t4 FROM configuration_group WHERE configuration_group_title= 'Auction Manager'; INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Display previous bids to logged in users', 'AUCTION_INFO_DISPLAY_PREVIOUS_BIDS', '1', 'Allow logged in users see previous bids', @t4, 1, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('Display previous bid count', 'AUCTION_INFO_DISPLAY_PREVIOUS_BIDS_COUNT', '1', 'Display previous bid count', @t4, 2, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('Display reserve not met message', 'AUCTION_INFO_DISPLAY_RESERVE_NOT_MET', '1', 'Display reserve not met message', @t4, 3, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('Display buy it now button', 'AUCTION_INFO_DISPLAY_BUY_NOW', '1', 'Display buy it now button for items that have not met their reserve', @t4, 4, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('Remove winning auction item from cart', 'AUCTION_INFO_DISPLAY_CART_REMOVE', '0', 'Allow customer to remove won aution item from shopping cart', @t4, 5, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('Display winning bidders name', 'AUCTION_INFO_DISPLAY_WIN_BID_NAME', '1', 'Display winning bidders name', @t4, 6, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('Display winning bidders bid', 'AUCTION_INFO_DISPLAY_WIN_BID_BID', '1', 'Display winning bidders bid', @t4, 7, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('Use CRON detection of auction close', 'AUCTION_CRON_ENABLE', '0', 'When Disabled (0=False), detecting closed auctions accrues during each page load. Enabling (1=True), will speed up your entire zen site BUT you must add a cron job or your auctions will never be detected as closed. Check with your host for instructions on the right way to set CRON jobs php -f /YOUR STORE PATH/cron.php >> /dev/null', @t4, 8, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('Display Pay Now button to winners', 'AUCTION_INFO_DISPLAY_PAY_NOW', '1', 'Display the Pay Now button or auto add to cart', @t4, 9, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'), ('Max bid for any product', 'MAX_AUCTION_BID_AMOUNT', '200', 'Enter the largest amount one can bid for a auction, whole numbers only (5000)?', @t4, 10, now(), now(), NULL, NULL), #added for auction sidebox ('Number of Products Auction SideBox', 'MAX_AUCTION_SIDEBOX_PRODUCTS', '2', 'Number of random Auction products to rotate in the sidebox Enter the number of products to display in this sidebox at one time. How many products do you want to display in this sidebox?', @t4, 11, now(), now(), NULL, NULL), ('Image - Auction SideBox Products Width', 'IMAGE_AUCTION_SIDEBOX_PRODUCTS_LISTING_WIDTH', '100', 'Default = 100', @t4, 12, now(), now(), NULL, NULL), ('Image - Auction SideBox Products Height', 'IMAGE_AUCTION_SIDEBOX_PRODUCTS_LISTING_HEIGHT', '80', 'Default = 80', @t4, 13, now(), now(), NULL, NULL), ('Display Auction SideBox Product Image', 'PRODUCT_AUCTION_SIDEBOX_LIST_IMAGE', '1', 'Do you want to display the Product Image? 0= off 1= on', @t4, 14, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')), '), ('Display Auction SideBox Product Name', 'PRODUCT_AUCTION_SIDEBOX_NAME', '1', 'Do you want to display the Product Name? 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'')), '), ('Display Auction SideBox Product Price', 'PRODUCT_AUCTION_SIDEBOX_PRICE', '1', 'Do you want to display the Product Price 0= off 1= on', @t4, 16, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')), '), ('Display Auction SideBox Product Time Left', 'PRODUCT_AUCTION_SIDEBOX_DATE_ADDED', '1', 'Do you want to display the Product Time left? 0= off 1= on', @t4, 17, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')), '), ('Display Auction SideBox Product Description', 'PRODUCT_AUCTION_SIDEBOX_DESCRIPTION', '150', 'How many characters do you want to display of the Product Description? 0= OFF 150= Suggested Length, or enter the maximum number of characters to display', @t4, 18, now(), now(), NULL, NULL), #added for the information sidebox ('Display Auction Information link in the Information sidebox', 'DEFINE_AUCTION_STATUS', '1', 'Display Auction Information link in the Information sidebox! 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'')), '), #added for the auction manager ('Number of Bids, Content Box', 'DISPLAY_AUCTION_BIDS', '2', 'How Many bids to display in the Auction Manager Content Box! Default is 2', @t4, 20, now(), now(), NULL, NULL); # ADD Auctions Manager menu items to admin menus INSERT INTO admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order) VALUES ('configAuctionManager','BOX_CONFIGURATION_AUCTION_MANAGER','FILENAME_CONFIGURATION', CONCAT('gID=',@t4),'configuration','Y',@t4), ('auctions','BOX_CATALOG_AUCTIONS_MANAGER','FILENAME_AUCTIONS_PRODUCTS','','catalog','Y','18'), ('convertType','BOX_TOOLS_CONVERT_TYPE','FILENAME_CONVERT_TYPE','','tools','Y','14');
25 Jul 2021, 08:53 PM
LilleyPadGifts

Re: Auction Product Type

Receiving the same error
25 Jul 2021, 08:57 PM
LilleyPadGifts

Re: Auction Product Type

It still gave me the same error.
I'm deleting and going to start with a fresh Zencart install.
This is just going to be an example store so I am going to use the basic templates that are already installed.
Will post update here when completed.

Apologize for duplicate post.... the previous one didn't show even when refreshing the page. It wasn't until I posted this that it could be seen.
25 Jul 2021, 10:36 PM
LilleyPadGifts

Re: Auction Product Type

Even after fresh install.... still same error.
Really need this thing to work asap. :-(
27 Jul 2021, 12:19 AM
LilleyPadGifts

Re: Auction Product Type

Here is the new log from today where I tried it again.

Code:

[26-Jul-2021 19:11:03 America/New_York] Request URI: /CarlsComics/MYADMINNAME/index.php?cmd=sqlpatch&action=execute, IP address: 66.27.190.49#1 trigger_error() called at [/home/my2xjapd1vrv/acomiccon.thedesertcactus.com/CarlsComics/includes/classes/db/mysql/query_factory.php:170] #2 queryFactory->show_error() called at [/home/my2xjapd1vrv/acomiccon.thedesertcactus.com/CarlsComics/includes/classes/db/mysql/query_factory.php:142] #3 queryFactory->set_error() called at [/home/my2xjapd1vrv/acomiccon.thedesertcactus.com/CarlsComics/includes/classes/db/mysql/query_factory.php:269] #4 queryFactory->Execute() called at [/home/my2xjapd1vrv/acomiccon.thedesertcactus.com/CarlsComics/MYADMINNAME/sqlpatch.php:291] #5 executeSql() called at [/home/my2xjapd1vrv/acomiccon.thedesertcactus.com/CarlsComics/MYADMINNAME/sqlpatch.php:736] #6 require(/home/my2xjapd1vrv/acomiccon.thedesertcactus.com/CarlsComics/MYADMINNAME/sqlpatch.php) called at [/home/my2xjapd1vrv/acomiccon.thedesertcactus.com/CarlsComics/MYADMINNAME/index.php:11] --> PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CREATE TABLE product_auction_extra ( products_id int(11) NOT NULL default '0'...' at line 1 :: DROP TABLE IF EXISTS product_auction_extra;CREATE TABLE product_auction_extra ( products_id int(11) NOT NULL default '0', auction_clock tinyint(1) NOT NULL default '0', bid_expire_date date NOT NULL default '0001-01-01', bid_expire_hour tinyint(2) NOT NULL default '0', bid_reserve_price decimal(10,2) NOT NULL default '0.00', bid_buynow_price decimal(10,4) NOT NULL default '0.0000', bid_start_price DECIMAL( 10, 2 ) NOT NULL, auction_closed VARCHAR( 1 ) DEFAULT 'N' NOT NULL, last_auction_winner_email_sent DATETIME NOT NULL, auction_closed_email_sent VARCHAR( 1 ) DEFAULT 'N' NOT NULL, bid_minimum_increase decimal(10,2) NOT NULL default '0.00', auction_start int(1) NOT NULL default '0', PRIMARY KEY (products_id) ) ENGINE=MyISAM; ==> (as called by) /home/my2xjapd1vrv/acomiccon.thedesertcactus.com/CarlsComics/MYADMINNAME/sqlpatch.php on line 291 <== in /home/my2xjapd1vrv/acomiccon.thedesertcactus.com/CarlsComics/includes/classes/db/mysql/query_factory.php on line 170.
27 Jul 2021, 02:48 PM
lat9

Re: Auction Product Type

I've run that updated set of installation code directly via my site's phpMyAdmin's SQL tab with no errors.
2 Aug 2021, 01:50 AM
LilleyPadGifts

Re: Auction Product Type

I really hate to give up on this plugin but it will not work on my site. I am trying to install it to a new basic site and it causes a 500 error.
Really needed this to work :-(
7 Aug 2021, 08:49 PM
LilleyPadGifts

Re: Auction Product Type

Can someone PLEASE make a version of this that works with the latest version of ZC? This is maddening!
30 Jun 2022, 08:47 PM
bestbetinc

Re: Auction Product Type

Will version V1.5.0 or is there a newer version I cant find of Auction Product type mod work with version V1.5.6c of Zencart? will I need to do a lot of file modifications? I'm not real good at adding these add-ons . I just muddle my way through it. Thanks for any help
2 Jul 2022, 04:11 AM
dbltoe

Re: Auction Product Type

see answer in other post.
18 May 2024, 04:02 PM
rukjix2

Re: Auction Product Type

Is there any way that someone could update this to work with the newest 2.0 zencart? I can't get it to work right on 1.5...I added it, but when you click sign in to bid, it just goes back and asks you to sign in again and again and you never get logged in. Thanks!

Show 100 post(s) from this thread on one page