2.4 (7/6/05 2:12 PM Build) bid history not working(FIXED)

[snoopy5]

Hi

2.4 (7/6/05 2:12 PM Build) bid history not working properly.

If I click on it as a bidder, it only shows me my last bid-message ("Your bid is too low. You must bid at least $150.00.").

I can not see the list of bids and the bid steps and time stamps like at ebay.

Any way to correct this easily?

Thanks in advance

[Chuck S]

Please register a name here and place a bid

http://www.reeftalk.com/classifieds/

I can see the bid history as an admin and a test user that placed a bid so lets see if I can see your bid as well

Thanks

[snoopy5]

Hi Omegatron,

I just registered with 2 accounts on your board and tested it there. on your board, i can see the bid history.

I have now classified 2.41, but the bid history problem is still the same as described above.

Do you have a different file for that functionality on your board then in the classified download file as of 30.07.2005?

[Chuck S]

No my site is running 2.41 same as you

make sure you have indeed uploaded all the new files and ran any applicable upgrades.

Thats the first place I would suggest you go as your thread here says 2.4 not 2.41

[snoopy5]

mmmhhh,

this was a fresh install. File was downloaded last WE.

Could you upload the file in this thread that is dealing with this, so I can overwrite it on my server?

[Chuck S]

I am using the default showproduct.php that is in the 2.41 download

$hbuserlink = "<a href=\"{$Globals['maindir']}/member.php?uid=$highbidder\">$hbuser</a>$hbicon";
$hbnumbids = "$numbids ";
$hbnumbids .= ($numbids > 1 ? $Globals['pp_lang']['bids'] : $Globals['pp_lang']['bid'] ) . " &middot; <a href=\"{$Globals['maindir']}/bids.php?action=history&amp;product=$product\">{$Globals['pp_lang']['bidhistory']}</a>";

So for that product you think should have a bid run this query and see what it outputs as $numbids is what your looking for

SELECT id,user,userid,cat,date,title,price,description,keywords,bigimage,bigimage2,bigimage3,views,approved,rating,extra1,extra2,extra3,extra4,extra5,extra6,disporder,status,isauction,highbidder,maxbid,numbids,enddate,zipcode FROM pp_products WHERE id=PRODUCTNUMBERHERE

[snoopy5]

Originally Posted by omegatron

I am using the default showproduct.php that is in the 2.41 download

$hbuserlink = "<a href=\"{$Globals['maindir']}/member.php?uid=$highbidder\">$hbuser</a>$hbicon";
$hbnumbids = "$numbids ";
$hbnumbids .= ($numbids > 1 ? $Globals['pp_lang']['bids'] : $Globals['pp_lang']['bid'] ) . " &middot; <a href=\"{$Globals['maindir']}/bids.php?action=history&amp;product=$product\">{$Globals['pp_lang']['bidhistory']}</a>";

So for that product you think should have a bid run this query and see what it outputs as $numbids is what your looking for

SELECT id,user,userid,cat,date,title,price,description,keywords,bigimage,bigimage2,bigimage3,views,approved,rating,extra1,extra2,extra3,extra4,extra5,extra6,disporder,status,isauction,highbidder,maxbid,numbids,enddate,zipcode FROM pp_products WHERE id=PRODUCTNUMBERHERE

äääähhhhhmmm

I guess you mean with "run a query" to do this in phpmyadmin? How do I do this exactly?

I checked the showproduct.php file and the 3 lines you posted here are the same in my file...

[tcroft2683]

Hello .. (same here..)
I have the exact same problem. Running php2bb forums on PhotoPost Classifieds 2.41 (latest release) in addition the high bid does not refresh on the showproduct.php?product={number}

http://www.jersey-auctions.com/aucti...tory&product=9
I always get Your bid is too low. You must bid at least $XX.XX.

When I run that command above i get valid data:
"9";"qatest";"3";"14";"1123386231";"Misc test item";"34.00";"test item";;"Bathroomjunk.jpg";;;"24";"1";"Fair";;;;;;;"99999";"0";"1";"5";"60.00";"3";"1124682246";"10030"


my url is http://www.jersey-auctions.com/auction

Feel free to register and test for me.

SQL-query: SELECT * FROM `pp_bids` WHERE ad_id=9 LIMIT 0, 30;
Rows: 3
id ad_id user_id username bid maxbid bid_date bid_ip
7 9 4 qatest1 23.23 33.00 1123387116 67.85.199.000
8 9 4 qatest1 26.00 33.00 1123389548
9 9 5 tcroft 34.00 60.00 1123389665 67.85.199.000

I have made minimum code changes. Please advise if you get a fix.

Thanks All.
Tom

[Fatsie]

Same problem here, when I run the query for a testproduct I get a valid return with numbids of 4

[Chuck S]

If I go here there is a highest bidder link and bid history so I see nothing wrong just like on my site

http://www.jersey-auctions.com/aucti....php?product=4

seffern yes I mean phpmyadmin and give me a direct link to your site

[jet26man]

Sorry.. but I see you did make a bid and somehow the auction closed for product 9. I'm using PHPBB2 for the registration process and your membership did not get transfered to the classified database..
http://www.jersey-auctions.com/auction/showmembers.php
thats another converstation.. I'll worry about this later..

First item.. the problem is the last user that bids on an item is not being shown and corrisponding "highest bidder" field.

The second item is when you click on the bid history any users will see:

Your bid is too low. You must bid at least $XX.XX.

Should I re-install the product photo-classifieds product again? Would changing the global naviagation files effect these items?

Thanks again.

[Fatsie]

Any news on this, still isn't working for me....

[Chuck S]

Try changing in bids.php add in bold

typecast($_REQUEST, array('action' => STRING, 'product' => INT));

[Fatsie]

That did the trick, thanks yet again

[jet26man]

Thanks for this BTW. It works now.

[snoopy5]

Hi,

I just had time now to review all thraeds...

I changed also the bids.php file, and in fact, Im can see now a bid history.

BUT it does not show correctly.

It shows only one bidder, always the one with the highst bid. It does not show the bidders that tried it inbetween, with smaller mounts.

So bid history looks:

user1
user1
user1
user1

and it should look (like at ebay):

user1
user2
user1
user2
user1

The way it looks currently is not a bid history, it is only showing the username of the highest bidder.

How to fix this?

(sorry that I compare it always with ebay, but this is the benchmark)

Thanks in advance

[Chuck S]

Hello

I do not know what to say here as it works fine that I can see

http://www.reeftalk.com/classifieds/...ory&product=58

You can login with testing and testing

[snoopy5]

Hi Omegatron, I will send you a link to my test install. It was a fresh 2.41 install 2-3 weeks ago...

[Chuck S]

Only thing I can suggest is that your ftp program is not allowing certain files to be updated. Delete all templates and main php files except your two config files and upload the new files

I would then suggest if this was an upgrade you rerun the upgrade script to make sure your not missing anything.

Next thing to do is look under your bidding table and see what that query I posted pulls as it should pull the same as our script is pulling

This query is pretty absolute as far as history goes as you can agree

$query = "SELECT id,user_id,username,bid,maxbid,bid_date FROM {$Globals['pp_db_prefix']}bids WHERE ad_id=$product ORDER BY bid DESC";
$rows = ppmysql_query($query,$link);

[snoopy5]

Originally Posted by omegatron

Next thing to do is look under your bidding table and see what that query I posted pulls as it should pull the same as our script is pulling

This query is pretty absolute as far as history goes as you can agree

$query = "SELECT id,user_id,username,bid,maxbid,bid_date FROM {$Globals['pp_db_prefix']}bids WHERE ad_id=$product ORDER BY bid DESC";
$rows = ppmysql_query($query,$link);

Just to e suer to do the right thing:

I go into phpmyadmin, select the database for my installtion, then select the table "bidding" and then click on "SQL" and insert in the upper big text field the mentioned code?