View Issue Details

IDProjectCategoryView StatusLast Update
0000058Timekoin ServerGeneral Issuepublic2021-08-13 16:32
Reporterdangermouse Assigned ToKnightMB  
PrioritynormalSeverityminorReproducibilityalways
Status resolvedResolutionfixed 
Product Version2.34 
Target Version2.41Fixed in Version2.35 
Summary0000058: History Sent From does not list properly
DescriptionWhen History is selected. The History for the Sent From server component are not displayed properly according to the number selected. The default is to display the last 5 transactions sent from the server, however, if the transaction from the server actually occurred 6 server transactions back it will cease to display.
Steps To ReproduceClick History Tab and have a Sent From transaction more than 5 transactions back
Additional InformationSQL statement can be adjusted to make it work properly:

change statement from:

$sql = "SELECT timestamp, public_key_from, public_key_to, crypt_data3 FROM `transaction_history` WHERE `public_key_from` = '$my_public_key' ORDER BY `transaction_history`.`timestamp` DESC LIMIT $show_last";

to

$sql = "SELECT timestamp, public_key_from, public_key_to, crypt_data3 FROM `transaction_history` WHERE `public_key_to` != '$my_public_key' AND `public_key_from` = '$my_public_key' ORDER BY `transaction_history`.`timestamp`
DESC LIMIT $show_last";
TagsNo tags attached.

Activities

KnightMB

2013-04-03 23:49

administrator   ~0000048

I'll look into this, I don't know how I missed this bug report. I usually get an e-mail about them otherwise I would have responded sooner. :)

KnightMB

2013-04-04 00:12

administrator   ~0000050

Last edited: 2013-04-04 00:13

I attached a screen-shot of the test I did with v2.34, I had it show the last 7 transactions sent from the test machine. When you try something similar, basically it comes up blank?

KnightMB

2013-04-04 01:08

administrator   ~0000055

Ok, I see it now. If you have less than 5 sent transactions, you have to show 6 or more to get the past transactions to show. If you set 5, it only showed 1 in my test, when I really had 2 that should have showed up.

KnightMB

2013-04-04 02:20

administrator   ~0000056

Originally, the script would filter out the keys for the list to help speed things up, but that was probably before the indexes were introduced. So it has probably been broken for a while, but should be fixed now with the changes you recommended.

KnightMB

2021-08-13 16:32

administrator   ~0000070

This was the original screen-shot, restore from an earlier version.
screenshot_1.png (80,633 bytes)   
screenshot_1.png (80,633 bytes)   

Issue History

Date Modified Username Field Change
2013-03-25 21:11 dangermouse New Issue
2013-04-03 23:49 KnightMB Note Added: 0000048
2013-04-03 23:49 KnightMB Assigned To => KnightMB
2013-04-03 23:49 KnightMB Status new => acknowledged
2013-04-04 00:11 KnightMB File Added: bug_report_01.png
2013-04-04 00:12 KnightMB Note Added: 0000050
2013-04-04 00:13 KnightMB Note Edited: 0000050
2013-04-04 00:37 KnightMB Status acknowledged => assigned
2013-04-04 01:08 KnightMB Note Added: 0000055
2013-04-04 01:08 KnightMB Status assigned => confirmed
2013-04-04 02:20 KnightMB Note Added: 0000056
2013-04-04 02:20 KnightMB Status confirmed => resolved
2013-04-04 02:20 KnightMB Fixed in Version 2.41 => 2.35
2013-04-04 02:20 KnightMB Resolution open => fixed
2021-08-13 16:25 KnightMB File Deleted: bug_report_01.png
2021-08-13 16:32 KnightMB Note Added: 0000070
2021-08-13 16:32 KnightMB File Added: screenshot_1.png