Auction Product Type

[BUTTSTTUB]

here is the error i get when i put the t AT 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'')),');

[BUTTSTTUB]

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?

[kuroi]

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

[BUTTSTTUB]

im using mysql 5.0.2
and php 5.2.4

[BUTTSTTUB]

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

[kuroi]

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

[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