Hi i'm downloded the Auction Product Type
but i have problem in Admin Area. I can not sii de Auction Manager box
When i owerwrite the application_top.php become the meseage "Illegal Acces"
I have Zen Cart v1.3.0.1
Thanks
gusuval
Printable View
Hi i'm downloded the Auction Product Type
but i have problem in Admin Area. I can not sii de Auction Manager box
When i owerwrite the application_top.php become the meseage "Illegal Acces"
I have Zen Cart v1.3.0.1
Thanks
gusuval
the auction has many problems and bugs, still need lot of work.
search the forum for a list of errors...
Can somebody send me a 1.3.0 Auction module? I am not able to download it form the manage.it.nl site...
If some one could send me the new version of this auction mod...I would really appreciate it. roseblossom222 AT hotmail DOT com
Thank you.
Here is the authors site offering the auction download...
http://managing-it.nl/zencart-auctio...ng-p-2467.html
I tried to download butI get stuck at step 3 :(
I think I have a copy somewhere will try to find it for you...
Thank you Johnny43 for your quick reply. I went to that site and tried to signup but the download link is not there...or I can't read the foreign language well enough to find the link...but if you could find yours and send to me...I would be soooo grateful.
Thank you again for your help.
I found a copy "Zen-Auctions094_zencart130.zip" which I would have probably downloaded from the above site Aug-02-2006, I will mail you a copy...
Reply to this thead if it works OK to help others...
It should be possible again to download it from our website
www.managing-it.nl
There was a zen-cart bug causing issues downloading the software, but this is solved.
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
Would anybody be willing to setup a bounty for a good stable auction type plugin..? I'd pitch in 50$.
I currently have it set up at my website and have it testing at the moment. When and if I ever get it to a fairly stable level I will let you know. In the categories list- the auctions are at the bottom, currently testing.
http://stampcommune.com/store/
GJW
Looked on your site stampsville but couldnt see the auction mod, maybe it didnt work and u removed it,
Is there a latest release for Zen Cart.
Thanks
Mick
So far as I know, this hasn't been touched for some time.
Ok thanks for reply, Will wait and hope
Mobilemick,
I do have it installed and working, but unfortunately still having email problems and way to many mods installed to seperate anything out. I don't want to release it due to it's instability.
Stampsville
Just tried to install it m8,
and now cant access admin page.
Or index pageQuote:
Warning: main(includes/application_top.php) [function.main]: failed to open stream: No such file or directory in /home/kccae/public_html/global/admin/index.php on line 23
Warning: main(includes/application_top.php) [function.main]: failed to open stream: No such file or directory in /home/kccae/public_html/global/admin/index.php on line 23
Warning: main(includes/application_top.php) [function.main]: failed to open stream: No such file or directory in /home/kccae/public_html/global/admin/index.php on line 23
Fatal error: main() [function.require]: Failed opening required 'includes/application_top.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/kccae/public_html/global/admin/index.php on line 23
Any help would be appreciated :)Quote:
1146 Table 'kccae_zc1.zen_product_auction_extra' doesn't exist
in:
[SELECT * FROM zen_product_auction_extra WHERE auction_closed = 'N' AND CURDATE() > bid_expire_date or (bid_expire_hour < 16 and bid_expire_date = CURDATE() and auction_closed = 'N')]
Thanks
Mick
Any luck Sid?
Hi Mick,
> 1146 Table 'kccae_zc1.zen_product_auction_extra' doesn't exist
>in: [SELECT * FROM zen_product_auction_extra WHERE auction
One of 'kccae_zc1.zen_product_auction_extra' or 'zen_product_auction_extra' is wrong - They should both be the same (depending whether you use rable prefixes or not).
Sorry, I can't be of more help with this module (I just stumbled across your msg), but I've just been working on a similar problem with another module.
Cheers
Rod
THe problem is that the code in the mod can't find the table zen_product_auction_extra (the kccae_zc1 is simply the full path to the expected table including the database name).
The two likely reasons are EITHER the SQL that creates the table wasn't executed probably during installation, so it genuinely doesn't exist OR the SQL assumed a database prefix of zen_ but you are not using a prefix, or are using a different one and so the table has been misnamed.
I recommend taking a look at your table names in phpMyAdmin, to establish which. Once you know that the solution (or at least the next step) should be straightforward.
Hi Folks,
[FONT=Arial][/FONT][FONT=Arial][/FONT]
[FONT=Arial][FONT=Arial]I compared at all the files that are used in this auction mod:-[/FONT][/FONT]
[FONT=Arial][/FONT]
[FONT=Arial][FONT=Arial]auctions.zip [/FONT][/FONT]
[FONT=Arial][/FONT]
[FONT=Arial][FONT=Arial]http://www.zen-cart.com/archived_contributions/other/auctions.zip[/FONT][/FONT]
[FONT=Arial][/FONT]
[FONT=Arial][FONT=Arial]I am getting this error now and can’t find any pointers on the forum.[/FONT][/FONT]
[FONT=Arial][/FONT]
[FONT=Arial][FONT=Arial]When I run the sql I got this error:-[/FONT][/FONT]
[FONT=Arial][/FONT]
[FONT=Times New Roman]Error[/FONT]
[FONT=Times New Roman]SQL query:[/FONT]
[FONT=Times New Roman]INSERT[/FONT]INTOproduct_types
VALUES (
[FONT=Times New Roman]''[/FONT], 'Product - Auction', 'product_auction', '1', 'N', '', now( ) , now( )
[FONT=Times New Roman])[/FONT];
[FONT=Times New Roman]MySQL said: [/FONT][FONT=Courier New]#1264 - Out of range value adjusted for column 'type_id' at row 1 [/FONT]
[FONT=Arial][/FONT]
[FONT=Arial][/FONT]
[FONT=Arial][FONT=Arial]any ideas ?[/FONT][/FONT]
[FONT=Arial][/FONT]
[FONT=Arial][FONT=Arial]kind regards[/FONT][/FONT]
[FONT=Arial][/FONT]
[FONT=Arial][FONT=Arial]Jamie [/FONT][/FONT]
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) withIf that doesn't work for you tryQuote:
INSERT INTO product_types VALUES (NULL, 'Product - Auction', 'product_auction', '1', 'N', '', now(), 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.Quote:
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();
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 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'')),');
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
there seems to be some confusion on bid increments, starting at $.01, no bid is accepted until it reaches $1.25 ??Quote:
Originally Posted by bobh
then when a bid is accepted I get this error
Quote:
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:
Quote:
Originally Posted by bobh
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.Quote:
Originally Posted by Veronika7747
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...Quote:
Originally Posted by AndyII
Squeeze me?
http://www.raptorman.ca/shop/index.p...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:
Looks good. What version of zencart and the mod did you use?Quote:
Originally Posted by efman
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.Quote:
Originally Posted by SiddG
I got the mail error to stop by using sendmail.
It also retains the old info on last bid if you redo the auction with new date, new price.
Has to be a dollar bid, no matter what its started at, so much for penny auctions :(
have to agree that it not useful at this point :no:
O.K. I could not get it working on 1.3.8a, so I am tying 1.3.7.1, but obviousky I missed a file, which I cannot see now. I get the following when displaying the auction item:
TEXT_DATE_AVAILABLE4 days 5 hours 30 minutes - 0 AUCTION_BIDS
AUCTION_RESERVE_NOT_MET
TEXT_PRODUCT_MODELAcrylic on board 14" x 36"
1TEXT_PRODUCT_QUANTITY
Would anyone know of hand what file I am missing???
Thanks a lot!
You are definitely missing a file or two, My 1st thought is language, but I would also compare thu ftp the distro to whats on site.
Quote:
Originally Posted by Veronika7747
I have it installed. Works and does not work :no:
1) I have Zen cart version 1.3.8 and seems to work fine.
2) UNTIL auction ends and was not sold or sold
As stated before what If you re-launch a same auction will keep old date
3) If you want to copy an auction will give you an error message and the copied one (clone) will open with NO info at all all fields and pictures blank.
4) Many errors to install specially on the SQL part
recommend NOT to install!
At this moment I am removing it
Marcelo
www.ysandals.com
Will leave a couple of days so you can take a look
those bids were test by me 2 weeks ago from today
WARNING THIS IS A LIVE SITE!
http://www.ysandals.com/index.php?ma...roducts_id=466
aUCTION WILL END SUNDAY JANUARY 3TH 2008
Meant old data = previous bids from old listing.Quote:
Originally Posted by marcelo63
Also I did not mention that you CAN NOT handle customer or bids at old. So the back administration is non existent
Did anyone here tried this product??
http://www.quidascript.com/index.php...roducts_id=113
If yes, does it work??
Not tried it, but a cursery glance shows that it's a standalone script (not a Zen Cart mod), it's copyright is 2004 and says that it's best viewed in Internet Explorer 5+ (so getting a bit long in the tooth) and is an old-fashioned table layout with a heap of validation errors (though by the standards of its day, it's actually not too bad).Quote:
Originally Posted by Veronika7747
I haven't given it a function test (although there is a demo on the site to which you linked), but it looked reasonably competent. The downsides are that if there problems or it doesn't do all you want, then you would have nowhere to turn for support or help, and that it is necessarily based on technologies, PHP4 and MySQL 4 at best, which are in the process of being withdrawn and disappearing from hosting arrangements.
Thank you Kuroi, I guess I have to keep looking...Quote:
Originally Posted by kuroi
Has anyone got this for completely working for 1.3.7?
It seems to be working for but but i see an option for buy it now if no reserve has been met and it isnt showing the buy it now button.
Thanks,
Tony
I couldnt get the "buy it now" button to work either (I have 1.37)
But the auction part is working. I'd like the Buy it Now however.
I have just installed it on 1.3.8a and still no buy it now button, I guess i will look further at the code to see what is happening and why it isnt doing it. Just wish i knew more about php.Quote:
Originally Posted by efman
I must report that I finished my auction and it worked well.
A couple of notes for whoever is tackling this:
1) There is no way to view bids in the Admin panel
2) Should have a setting to display first name and initial for each bid. Peoples full names dont really go over well.
3) Please fix the "buy it now" problem.
It seems a shame that this great mod works well for the harder elements of the script, but the smaller less significant parts are unsolved. Kudos to Ian C Wilson for developing it this far. Can someone finish it?
You will have more issues coming up. I do have it installed running on Zen 1.38aQuote:
Originally Posted by efman
Many of administration options are "lacking" in other word you can not control mostly anything
AND ... if there are bids and item is NOT sold, forget it to relist it, keep old bid information upon "relist (changing dates). better delete that auction/porduct rather than "relisting"
I think this must be re-written from scratch
Marcelo
Does anyone know of any workable alternatives to this mod? Since eBay has started to run people off with their changes and the number of people have left eBay I can see where something like this would come into more of a demand. I know their is a lot of sellers out there that are going other places now. Personally I'd like to see a version of ZC written and optimized to become an auction site. I know that would be a more than major undertaking though and really beyond the primary purpose of ZC so instead I'll settle for a mod to have auctions on my ZC.
I downloaded and installed the 0.95 version on Zen Cart 1.3.8a It took me a little while to get it up and running, but it seemed interesting.
There were some small items that I thought should be changed, so I made the changes...
I added a Minimum Bid Increase (so you cant just raise by 1 penny).
I inhibited the ability for someone to bid against themself.
I will be taking a look at the Bid Now missing button. I agree that full names listed in the bid history isnt a great idea... Maybe just the customer ID number?
Relisting an item is a problem, but cloning the item would solve the history problem. I would have to give that some thought. I wasnt really focused on the admin side (other than the minimum bid increase problem) this time around.
I have to diff the source tree that I have running in my sandbox with the 1.3.8a base release to figure out all the changes I made, but it shouldnt be too bad. I have tools for that.
I would like to package it up and send the changes back to the author, but I cannot seem to figure out who that is...
Is there some CVS tree that has this code?
Anyone know??
Arnold
I believe that the original author may have been Ian Wilson who is one of the Zen Cart developers (forum ID: Wilt), and that it was written long ago for a now defunct version of Zen Cart, so some updating is helpful.Quote:
Originally Posted by bramnick
Ok, here i go :) Craftzombie installed the auction mod for me back when I had 1.3.7. and it worked great (even though the email issues were still an issue) When I upgraded, it appeared to all still be in working condition. However, i found an issue. You can bid, etc but when the auction is over, the winning bidder is supposed to be able to click the pay button......and the amount always comes up $0.00 no matter what the winning bid was.
we never did figure out the email issues, but like many here, with ebay sellers flocking away from ebay in droves...it would be nice to get an updated workable version.
any suggestions on the $0.00 issue or where a new and functional mod can be found?
thanks!!
The version I have doesnt seem to experience your problem. I am in the process of cleaning up my mods and doing a test install to make sure they work. I will package it all up and post it when it is done.
There are some changes I want to make (like hiding the bidder's name) and I want to check out the buy now button problem others have reported, but I have not had a chance. I decided that cleaning up my source tree was more important at the moment.
OK I broke out the code mods into a separate source tree and successfully installed in on top of a clean 1.3.8a system. It works.
I uploaded it to the contribution area as a new version for the auction product type.
It is being reviewed and should be published shortly.
Cheers!
awesome!!! will i be able to just install it over the old mod? cause lord knows I dont know how to uninstall old mod.....LOL
Please let me know when it goes public :))
thanks!
It is available for download now... Upgrading from previous is an interesting conversation. I didnt really consider that since the previous one didnt work on 1.3.8a...
I know that it installs on top of 1.3.8a. So if you are presently running 1.3.8a you SHOULD be fine. The install.txt file lists the 2 modules that are changed from the base 1.3.8a. If you didnt install any custom code, or any other downloads that replace those 2 modules, this should drop on top just fine (backup backup backup). You should DIFF the code just to be comfortable that there are no other difference afoot.
As far as the DB is concerned, I added 1 new field to 1 table.
To change the DB from the 1.3.7 version (0.95) to the one I packaged in 0.96
You need to do this sql AFTER YOU BACKUP..... TRY THIS ON A TEST DATABASE FIRST!!!!!
ALTER TABLE `product_auction_extra` ADD `bid_minimum_increase` DECIMAL( 10, 2 ) NOT NULL DEFAULT '0';
Cheers!
I downloaded the new mod and installed in into my wholesale site which is not active yet. Everything appears to be ok cept the email. I kept it on the default PHP selection (configuration/email options) but I get this message:
ERROR: Failed sending email to: " " <> with subject: "Your Auction Bid - Mooncave Crystals" Could not instantiate mail function. Please check Admin->Configuration->Email Options->Email Transport.
I tried changing it to the "sendmail" option and did not get the error message, but also did not receive an email :) Any suggestions?
thanks! this mod is looking great!! (it would help if I actually knew what I was doing....LOL)
:clap:
I'm gonna have to get this latest, and see.
I also changed to sendmail to solve that error then only got an "end of auction winning bid notice"
guess cloning the action is one way of re doing it and will work for now, other problem I had was I wanted to be able to start at a lower amount than $1.00, like a penny auction
Bramnick
what is it set at for increments?
Quote:
I added a Minimum Bid Increase (so you cant just raise by 1 penny).
I inhibited the ability for someone to bid against themself.
yeah, my only question would be: If I change the email option to "sendmail" will that affect the other emails like the welcome letter, order confirmations, etc?
well on the test site, welcome letters worked, as fas as confirmations, I didnt test it as its not setup as a production site where I can buy something.
I would assume ( yea I know, never assume) that they would also work :mellow:
I did a clean install of zencart for my wholesale site and a clean install of the auction mod. Everything appears to be functioning wonderfully.
On my retail site, i had the old auction mod installed with a few code adjustments due to the email not working, etc. I installed the new auction mod over the old (since i had no ideas what files to remove without screwing things up). It all appears to work EXCEPT for the email, even though I changed the email option over to sendmail as well.
I have no idea where to look to find out why this is happening. Any suggestions?
Thanks!
I didnt try a start price lower than $1. I didnt (knowingly) touch that code. It would have thought that $0.01 would work....Quote:
Originally Posted by AndyII
I can take a peek...
Will get back to the forum if I find something
AHB
Very interesting. I setup the email as usual in the ADMIN panel. I didnt play with the emails. I will need to retest it, but I recall getting emails.Quote:
Originally Posted by AndyII
the only thing I know of is that unless someone LOOKS at an item after the auction closes, there is no email sent. The system needs a cron job that locates closed auctions and notifies the winners... I have thought about it, but done nothing more than that.
AHB
Exactly which emails are NOT going out?Quote:
Originally Posted by mooncavecrystals
AHB
did a test auction today and got this email seems a couple house past after end of auction before I got the email, I am using 'sendmail' but the SMPT should work as well
bramnick
The bidding has to be a $1.00 and then any increment , Exp. $1.01 to take the bid
(not on your rework, this is before you did any mods), but I want to be able to start the bidding at $.10 as most of these items may only sell for $2.00-$3.00
so small increments are ok with me for now
Quote:
Dear user
You recently bid on our auction product - New Auction. The auction for that product is now closed, and you were the highest bidder. You should login to the store to complete the purchase of this product
For help with any of our online services, please email the store-owner:
I am looking at the email code... I dont think I am getting ANY emails regarding auction items, but I havent really played with it yet.
I will look at the $1 minimum. I am not sure where the code for that is, but your observation that it was the minimum before I started playing will help me track it down (thanks!).
I am not sure when I will get a chance to look at this, but I will try.
(I also noticed that the expire HOUR is stored in a different DB field than the time (which seems a little odd) so I want to poke around with that too. )
AHB
After receiving the winning bid email, I went and "paid" for the auction, I then received the order confirmation, so I would say that the emails seem to work, Yes the time difference (2 hours) from when the action ended and when I received the notice is strange
bramnick, kind Sir;
a question, will your mod work with zen 1.3.7?
Im looking now at the code trying to see where the control is for the minimum starting bid.
I did another test auction, put '0' as the starting price, but its still looking for that minimum of $1.00 plus to be able to bid, even tried $1.00 and said "Bid Too Low" but as was with the other tests $1.01 was accepted.
Sir, if you can figure this out, I would be indebted to you :clap:
I dont have 1.3.7 (and dont really want to dig it up) so I dont really have any way to determine if it will work.
I did find the $1 minimum problem. I am working on some other stuff so I am not ready to publish a new package, but the code fix is easy if you want to just edit the file....
BACKUP BACKUP!!!!
../includes/modules/pages/product_auction_info/header_php.php
Replace this line (line #30)
$auction_current_bid = ($auction_current_bid >= 1) ? $auction_current_bid : 1;
with this:
$auction_current_bid = ($auction_current_bid >= 0) ? $auction_current_bid : 0.01;
notice the "0" and the penny - The logic says "IF the current auction bid is greater than or equal to 0 (which is actually silly, but anyway), then return the current bid. Otherwise, return a penny. This sets the minimum price of any bid (including a raise) to 1 cent. you can change it to ten cents if you want (replace 0.01 with 0.10).
That will fix the $1 problem.
The emails do indeed seem to work on my machine. I do get outbid notices. I think that the YOU WIN notice will only appear if someone views the auction page after the closing time. (hence the cron job comment earlier).
I think that an initial bid email is never sent out. I will look into that (only winners, losers and outbids). I am also working on logging the emails which isnt happening even though there is a DB table for it.
Anyway... as time allows.....
Cheers!
AHB
Upon further reflection (like 10 seconds worth) since there are only 2 files in the auction ZIP file that collide with the shipped ZEN versions, if you compare those 2 files line by line (or better - use a tool like WINDIFF to spot the changes), if the changes are ALL related to the auction code (which is in a block) then the auction code should drop on top OK. If not, you need to move the 1.3.8a auction related code into the same spot in the 1.3.7 code.
That is the best I can do to help... sorry...
AHB
I installed this mod on a test site I'm working on, it installed fine and seems to be working well thought I haven't placed bids or the like.
How to actually make it work after that I have no idea so seen as it has been made for a diff use I'd love to extarct what I need out of it but I don't know which bits I'll need.
I would assume that it would be easy enough for the maker of the mod to do a simple mod to add an expiry date to products and have the product disable once it expires.
Thank you.
Set up a category for Auctions. When you go to add a new product, make sure you have selected "product auction" from the drop down menu. Once you click on New product there is a place to set a start date and an ending date and even a ending time. Once the ending date is done, the product is no longer available.
It's there, you just have to get in there and futz with it :)
Have fun! Its a great mod :)
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.
Hey B, the $0.01 thing was actually for Andy. I am the one that was having trouble getting the email to work when installing the new auction mod over the old one. Still having that issue but have no idea how to fix it. Any suggestions?
I deleted all the files related to this mod and restored the original files which were changed. I also deleted the db tables associated with this mod.
However, the 2 products which I had set as an auction product can't be viewd in the catalog and can't be deleted even though they exist in the admin.
How do I get rid of them and the admin>configuration>auction manager form my admin?
Thank you.
Sorry MCC - I clearly was confused... I cant think of why the mods would break the 1.3.7 mail. I didnt do anything to that package that touched the email. My test system DOES generate emails for OUTBID at the time of the OUTBID. It generates a WIN and LOSE message when someone looks at the page after the expiration time (which is annoying). Mine does NOT generate email when you place an initial BID (which is also annoying).
If I come across something, I will be sure to post it to you... I assume that a migration to the current code base isnt an easy option for you.
AHB
Interesting... sounds like a DB data problem.Quote:
Originally Posted by vivaraquel
The auction product does create a couple of new tables, but it also adds stuff to existing tables. I think there is where the problem is.
The way I would do it is by carefully removing the products from the "products" table. If you are NOT comfortable diddling directly with the DB (or finding someone who is) you will need to uninstall the product and DB and reinstall the base ZC then install the mod ontop.
Since this is a test system I am sure ;-) the easiest thing to do is uninstall the whole thing and start again. I do that on a fairly regular basis these days.
AHB
I would tend to agree with that...
I have found on several mods that the installation was dependent on the table prefix standard of zen_ , and during installation of the cart a different prefix was chosen, so I then found the files that were making calls to the DB looking for zen_ and changed them to the one that was being used.
Mostly it will throw a sql error and it makes it very easy to locate and fix the problem.
ok, what i did was to use all of bramnick files, except that I used the original
./includes/application_top.php
./includes/classes/shopping_cart.php
from the 0.95 release for zen v 1.3.7, all seems to work fine, so far, so my question is this, can the "Buy It Now" feature be removed once a bid is made?
Andy
Hey Bramnick, no apologies necessary! :) you are much in demand here so easy to get confused.
The clean install on my zen worked well (wholesale site) its the install over the old install (retail site) that I am having issue with. Maybe I will have to break out winmerge and compare to see if some code on my old one was changed? I would think the new one would over write, but I am not good at this stuff. Scares me to death...ROFL
Thanks again though......i love the way you updated the mod. Good job!!
I MUST agree with mooncavecrystals,
you have done great things here and you are very much appreciated, so
Thank you Bramnick :clap:
ok, this is out of my comfort zone, but........
how exactly does one uninstall something? Am thinking I would want to uninstall the old auction stuff and keep the new stuff? or uninstall the old auction stuff and reinstall the new?
This is way over my head.......LOL :blink:
Quote:
Originally Posted by AndyII
Andy,
I dont think that would be too hard, but is that really what everyone would want?? It might make sense to hide the Buy it Now button once the bid price reaches the Buy it Now price since that button would be a problem (we wouldnt want someone Buying it Now for $10 if the current bid is now $11!).
I will have to think about this one...
Good idea
AHB
Which version to you have installed? If it is 0.95, then you need a small change to the DB to upgrade you to 0.97. I posted a the SQL earlier in this forum.Quote:
Originally Posted by mooncavecrystals
Other than that, the 0.97 should drop right on top of the 0.95 version
I will warn you that the 0.95 package had a lot of extra stuff in it. I removed what I didnt need which made it much smaller. Leaving the extra files around wont hurt anything, but trash is trash, so I understand why you want to remove it.
So... In summary
to get from 0.95 to 0.97 is a small DB change (see earlier posting) AND then drop the existing 0.97 files on top of 0.95 files. (After you backup everything including the DB and try this out on a test system of course) :blush:
AHB
yea, that would work just great! :yes:
hide the Buy it Now button once the bid price reaches the Buy it Now price.
wait till everyone finds out about the update, might get real busy here in this thread.
I started looking at this in October 2007, and almost gave up on it, so glad you decided to do this.....
Quote:
Originally Posted by bramnick
So here is the good news... The system does this already... when the current bid price exceeds the buy it now price, the option to buy it now goes away.
I should have looked before i posted... oh well
AHB
was going to go test that theory before I saw your post, but cant less I sign up as a customer lol, forgot you took away the ability to bid against your self (which is good)
now see if you can help with this, auction set for a starting bid of $.25 with .10 increments, now when I bid and take it, the Current high bid doesn't reflect the high bidders bid...?
it says this
-------------------------------------------------------------------------------------
Auction ends in 0 days 0 hours 47 minutes - 1 Bids Current Highest Bid: $0.25 You are the current high bidder!
-------------------------------------------------------------------------------------
The minimum bid increase is $0.10 Buy Now Price $4.95 Action 20 Previous Bids $0.35 - Bidder ID: 1
----------------------------------------------------------------------------------------
Quote:
Originally Posted by bramnick
So I was wrong... application_top.php has 2 cute lines at the end that check for expired auctions. The original programmer was clever. So long as anyone loads any page on the site, the auction DB is scanned for closed auctions. If it finds any it processes them.Quote:
Originally Posted by AndyII
Now onto your problem:
You CAN log on as 2 people at the same time if you use 2 browsers. So use IE to logon to 1 user and Firefox to logon to the other. That is how I test, I bid one against the other.
I will need to reproduce your issue, but I need to know what you set the auction items to...
Is there a Buy it now price?
Is there a reserve?
Send me all the settings so I can see what you did and then i can play
Cheers!
AHB :frusty:
OK i see it... I will need to look at it..
I also want to change the status of a closed auction item so that it doesnt appear in the catalog anymore (prevents closed auctions from filling up the screen).
How long after the auction close should I wait before i mark the status as unavailable do you think? Remember, once i change the status no one but the admin will be able to see it....
Maybe I should change the status after it is paid for???
Thoughts?
AHB
a certain amount of closed auctions are good. this gives others a chance to see what they missed :laugh:
status , good question, although admin can disable that status anyway, so not sure, I''l most likely keep them visible for a while then either disable the status or delete them...
Correct, I made an auction, made a bid, didn't return to the site until after auction end, just went to the index page and immediately received the email notice , so, in a perfect world, or at least if the site has any viewers, then it will process the closed auctions.Quote:
The original programmer was clever. So long as anyone loads any page on the site, the auction DB is scanned for closed auctions. If it finds any it processes them.
might be ok as is without a cron, most of the time....lol
bramnick, when you come back on, I see in the info after auction end the persons name...did I get something wrong?
also as you can see, the real winning bid was $0.35
with bidder ID: 1 and my name, hmmm :dontgetit
Quote:
Bidding Over Auction Winner: Andy Andy Winning Bid: $0.25 Congratulations, you are the winning bidder!
Action 20 Previous Bids $0.35 - Bidder ID: 1
Very coolQuote:
Originally Posted by AndyII
No, you didnt do anything wrong. There is clearly another module that needs to be changed to not print the name. I will need to track that down (along with the price thing). Both of which are probably small changes...
And here I thought I got this working :(
Cheers!
AHB
On the contrary, you have given NEW life to this mod, and revived hopes again. :clap:
so much more is working and this is all good :cool:
Quote:
Originally Posted by bramnick
OK I am making progress..Quote:
Originally Posted by AndyII
I changed the code so that the current price shown in the summaries is the current high bid... I did this by updating the "starting price" each time the bid is raised. It made sense to me anyway. There is an odd side effect that I am tracking down, but I think we will be ok
I am looking at the pricing problem (0.35 vs 0.25) that you found. The funny thing is that if the bid reaches $1 all is well. I will figure it out sooner or later.
I am also working on a cron job. I really dont like the fact that EVERY page view of the store seaches for expired auctions. It isnt an efficient design, especially as that table starts to get large. I dont have that working yet. I know how to do with with a HUGE hack. I am trying to stay away from that.
stay tuned
A