Auction Product Type

I get the same error when i try to install the sql patch.
Does anybody have any idea what I have to do to get the patch installed?

That SQL works fine for me. However, your version appears unwilling to treat the empty string as a null value. First off try replacing the relevant line in the patch (line 21 about half way down) with> INSERT INTO product_types VALUES (NULL, 'Product - Auction', 'product_auction', '1', 'N', '', now(), now());If that doesn't work for you try> INSERT INTO product_types set type_name='Product - Auction', type_handler='product_auction', type_master_type='1', allow_add_to_cart='N', default_image='', date_added=now(), last_modified=now();

You will also need to check whether the statements after this executed successfully. If so your database will already have that data in and executing them again would cause duplicates. But my guess would be that they will have suffered from the same problem and need similar approaches to make them work.

i went one query at a time and it was working but on the last query
i got this error

Column 'configuration_group_id' cannot be null

here are the queries i was using

INSERT INTO configuration set configuration_title= 'Display previous bids to logged in users', configuration_key= 'AUCTION_INFO_DISPLAY_PREVIOUS_BIDS', configuration_value= '1', configuration_description='Allow logged in users see previous bids', configuration_group_id= @t4,sort_order= 1, last_modified=now(),date_added=now(),use_function= NULL, set_function='zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),';

INSERT INTO configuration VALUES (null, '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'')),');

any help would be appreciated

Are you also running the statements that immediately precede these where the sql variable @t4 is defined?

here is the error i get when i put the t@4 statements in

Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; SELECT (@t4:=configuration_group_id) as t4 FROM configuration_group WHERE ' at line 1

here is the query i just tried

SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'Auction Manager';

INSERT INTO configuration VALUES (null, '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'')),'),
(null, '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'')),'),
(null, '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'')),'),
(null, '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'')),'),
(null, 'Display winning bidders name', 'AUCTION_INFO_DISPLAY_WIN_BID_NAME', '1', 'Display winning bidders name', @t4, 5, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),'),
(null, 'Display winning bidders bid', 'AUCTION_INFO_DISPLAY_WIN_BID_BID', '1', 'Display winning bidders bid', @t4, 6, now(), now(), NULL, 'zen_cfg_select_drop_down(array(array(''id''=>''1'', ''text''=>''True''), array(''id''=>''0'', ''text''=>''False'')),');

im hosting my own site. why wouldn't any of my sql patches go in easily
is there something i need to install on my server?

It does sound as though there are problems with your SQL. Are you using MySQL? If so, what version?

im using mysql 5.0.2
and php 5.2.4

I found out where the problem was

it was in my mysql configuration. all i had to do was

go through the mysql server config wizard

and uncheck strict mode

then all the patches went in with no problem

That's helpful to know. Thanks for posting the solution.

I have the mod in and working now but sometimes i get a mail server error ?
And also is there a setting i am missing for the bid increments. i tried it out and can bid at what ever amount i want .05 etc.. be nice to set it at 5-10 bucks or something

bobh:

I have the mod in and working now but sometimes i get a mail server error ?
And also is there a setting i am missing for the bid increments. i tried it out and can bid at what ever amount i want .05 etc.. be nice to set it at 5-10 bucks or something
there seems to be some confusion on bid increments, starting at $.01, no bid is accepted until it reaches $1.25 ??
then when a bid is accepted I get this error
Email Error: Could not instantiate mail function.

Anybody know how to change the bid increments?
1st it seems to start at $1.00, nothing lower will start the bid, then after you can bid in penny increments
Please help :mellow:

bobh:

I have the mod in and working now but sometimes i get a mail server error ?
And also is there a setting i am missing for the bid increments. i tried it out and can bid at what ever amount i want .05 etc.. be nice to set it at 5-10 bucks or something

Should this add-on work with 1.3.8a? Are there any "instructions" on how this suppose to work?
Tx
Merry Christmas Everyone!

Veronika7747:

Should this add-on work with 1.3.8a? Are there any "instructions" on how this suppose to work?
Tx
Merry Christmas Everyone!
Never found any "real" instructions, was a learn as you go. besides I think this mod is all but dead.
I am having a new mod written at a cost as I really would like to see this feature :shocking:

AndyII:

Never found any "real" instructions, was a learn as you go. besides I think this mod is all but dead.
I am having a new mod written at a cost as I really would like to see this feature :shocking:

That's too bad if it is really dead. It looked like bobh and kuroi had it working...

Squeeze me?

http://www.raptorman.ca/shop/index.php?main_page=redirect&action=banner&goto=12

I have it looking like it's working....is it going to work?

I'd like to know before the auctions end.

my test auctions worked ok, even got email notices, the ones other say didnt work, so maybe is server related problems as well.
went to your site, looks like all is as it should be......only time will tell thou..... :mellow:

efman:

Squeeze me?

http://www.raptorman.ca/shop/index.php?main_page=redirect&action=banner&goto=12

I have it looking like it's working....is it going to work?

I'd like to know before the auctions end.

Looks good. What version of zencart and the mod did you use?

SiddG:

Has anyone tried the auction mod with 1.3.7?

I am going to try and integrate it for 1.3.7.

Anyone's experiences will help

Thanks Ya All
Sid
Installed in a clean new zencart version 1.37. Run sql in zencart; doesn't work in PHPMYadmin. Everything works fine except on every new item, when the first bid is made it produces a mail setup error. No matter what the mail setting is, still get an error. Goes away after the first bid. Makes it just about unusuable since it would scare the customer away when they get this error.