Search function has been acting up recently, I had numerous blank outputs upon search requests. If you encounter the same problem just put the desired profile name after:
Code:
https://bpip.org/profile.aspx?p=
and you will be fine.
Topic: Announcing BPIP - The Bitcointalk Public Information Project! - page 11. (Read 33817 times)
https://bpip.org/profile.aspx?p=Don%20Pedro%20Dinero
Search function has been acting up recently, I had numerous blank outputs upon search requests. If you encounter the same problem just put the desired profile name after:
and you will be fine.
Search function has been acting up recently, I had numerous blank outputs upon search requests. If you encounter the same problem just put the desired profile name after:
and you will be fine.
Interesting > this profile is missing from the database.
I tried searching by name, ID.. nothing.. >
https://bitcointalksearch.org/user/don-pedro-dinero-1107222
Don Pedro Dinero
I tried searching by name, ID.. nothing.. >
https://bitcointalksearch.org/user/don-pedro-dinero-1107222
Don Pedro Dinero
Duplicate entry bug?
However, seclog shows only one entry:
I have seen information about your password change from BPIP.
I think BPIP is incorrect:Quote
4/9/2019 5:51:54 AM password changed
4/10/2019 5:51:54 AM password changed
Note how the time is exactly the same, but a day later.4/10/2019 5:51:54 AM password changed
However, seclog shows only one entry:
Quote
Today at 07:51:54 AM - Shafiqul Islam - password changed
(archived)
(archived)
It's the same error I get on lyka account.
Yeah, I looked at that, can't seem to find the reason.... :/
legendary
Activity: 1919
Merit: 1230
AKA Ms-overzealous-condecsending-explitive-account
Small bug:
Only happens on Banned users:
https://bpip.org/search.aspx?q=nuno12345 doesn't work <-----------
https://bpip.org/profile.aspx?p=nuno12345 works
All Other non-banned users:
https://bpip.org/search.aspx?q=LoyceV works
https://bpip.org/profile.aspx?p=LoyceV works
Thanks to LoyceV for helping me narrow it down.
Only happens on Banned users:
https://bpip.org/search.aspx?q=nuno12345 doesn't work <-----------
https://bpip.org/profile.aspx?p=nuno12345 works
All Other non-banned users:
https://bpip.org/search.aspx?q=LoyceV works
https://bpip.org/profile.aspx?p=LoyceV works
Thanks to LoyceV for helping me narrow it down.
Upon visiting the thread of Few Trusted Escrow Provider and I checked the profile there one by one, and I noticed that this user TwinWinNerD only has the error of with their bpip page. Or only just me? 
Code:
Server Error in '/' Application.
Arithmetic overflow error converting numeric to data type numeric.
Arithmetic overflow error converting numeric to data type numeric.
It's the same error I get on lyka account.
Got a Database error trying to open this account :
lyka
https://bpip.org/profile.aspx?p=lyka
~snip code~
lyka
https://bpip.org/profile.aspx?p=lyka
Quote
Arithmetic overflow error converting numeric to data type numeric.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Arithmetic overflow error converting numeric to data type numeric.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Arithmetic overflow error converting numeric to data type numeric.
~snip code~
Upon visiting the thread of Few Trusted Escrow Provider and I checked the profile there one by one, and I noticed that this user TwinWinNerD only has the error of with their bpip page. Or only just me?
Code:
Server Error in '/' Application.
Arithmetic overflow error converting numeric to data type numeric.
Arithmetic overflow error converting numeric to data type numeric.
so I guess there are maybe other users whom got wrong figures (delayed updated) on BPIP site.
I doubt it, unless other people had merit refunded as well. :/
I'll have to delete all the merit awarded on that thread...
I misposted the one in my topic (wrong board), so I quoted it here for you, Vod.
Today, I saw a bug (maybe bug) in BPIP site with the case of Xal0lex (staff), who created a topic for bitcointalk souvenirs on April 1st.
theymos stated the KYC now required is April Fool there:
All funds (sMerits) in the topic, Souvenirs from the Bitcointalk.org were refunded days ago.
However, the figures of Xal0lex on BPIP site are wrong, so I guess there are maybe other users whom got wrong figures (delayed updated) on BPIP site.
The BPIP site built by Vod.
Please check it and fix such a delayed updating bug (if it is) when you have time to do it.
Thank you.
Proof of potential bugs on Xal0lex
1> The Souvenirs topic after all sMerits refunded to senders:
2> Xal0lex's profile page on bitcointalk:
3> Profile page on BPIP site:
4> Most merited profiles Rank System:
https://bpip.org/report.aspx?r=mostmerited
theymos stated the KYC now required is April Fool there:
April fools!
2541 people submitted the KYC form, but the actual data entered into the form was never even sent to bitcointalk.org, much less collected. So if you actually entered any sensitive info there, you should feel a bit silly, but don't worry about it. (Probably some people left funny comments, but regrettably these were not collected.)
The verification flairs were random.
Thanks to Mr. Big, hilariousandco, malevolent, Halab, Mitchell, and Xal0lex for contributing ideas related to this, and to everyone else for having fun with it!
2541 people submitted the KYC form, but the actual data entered into the form was never even sent to bitcointalk.org, much less collected. So if you actually entered any sensitive info there, you should feel a bit silly, but don't worry about it. (Probably some people left funny comments, but regrettably these were not collected.)
The verification flairs were random.
Thanks to Mr. Big, hilariousandco, malevolent, Halab, Mitchell, and Xal0lex for contributing ideas related to this, and to everyone else for having fun with it!
All funds (sMerits) in the topic, Souvenirs from the Bitcointalk.org were refunded days ago.
Sadly, we ran out of our stock of zero items. So everyone gets a full refund:
However, the figures of Xal0lex on BPIP site are wrong, so I guess there are maybe other users whom got wrong figures (delayed updated) on BPIP site.
The BPIP site built by Vod.
Please check it and fix such a delayed updating bug (if it is) when you have time to do it.
Thank you.
Proof of potential bugs on Xal0lex
1> The Souvenirs topic after all sMerits refunded to senders:
2> Xal0lex's profile page on bitcointalk:
3> Profile page on BPIP site:
4> Most merited profiles Rank System:
https://bpip.org/report.aspx?r=mostmerited
I'm glad I was able to help with the design.
Ok, I'm curious.. what help did you offer?
Thanks, for all of your work with BPIP that is sharing you with us, and I'm glad I was able to help with the design - hopefully it will work thanks for sharing again.
Hello Vod,
Looks like there are some strange things happening again:
Don't know if you are currently working on it or if this is a new issue
Looks like there are some strange things happening again:
Code:
Current Merit 500
Merit Rank >1000
Merit Received 176.00
Merit Rank >1000
Merit Received 176.00
Don't know if you are currently working on it or if this is a new issue
I'm doing a lot of changes right now.
While I do work on test code, it uses the live database. Sometimes I make a change to that and if affects the non test code. 
Hello Vod,
Looks like there are some strange things happening again:
Don't know if you are currently working on it or if this is a new issue
Looks like there are some strange things happening again:
Code:
Current Merit 500
Merit Rank >1000
Merit Received 176.00
Merit Rank >1000
Merit Received 176.00
Don't know if you are currently working on it or if this is a new issue
Will you like to share the access to your database of bpip in the way similar to the Piggy Sql Tool?
I just like to query it.
I just like to query it.
Got a Database error trying to open this account :
lyka
https://bpip.org/profile.aspx?p=lyka
Code of the error :
lyka
https://bpip.org/profile.aspx?p=lyka
Quote
Arithmetic overflow error converting numeric to data type numeric.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Arithmetic overflow error converting numeric to data type numeric.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Arithmetic overflow error converting numeric to data type numeric.
Code of the error :
Code:
Source Error:
Line 50: cmd.CommandType = CommandType.StoredProcedure;
Line 51: cmd.Parameters.AddWithValue("@name", ProfileName);
Line 52: sdr = cmd.ExecuteReader();
Line 53: if (!sdr.HasRows)
Line 54: {
Source File: C:\inetpub\bpip\profile.aspx.cs Line: 52
Stack Trace:
[SqlException (0x80131904): Arithmetic overflow error converting numeric to data type numeric.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +3306108
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +736
System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4061
System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +90
System.Data.SqlClient.SqlDataReader.get_MetaData() +99
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) +604
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) +3303
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) +667
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +83
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +301
System.Data.SqlClient.SqlCommand.ExecuteReader() +137
bpip_profile.Page_Load(Object sender, EventArgs e) in C:\inetpub\bpip\profile.aspx.cs:52
System.Web.UI.Control.OnLoad(EventArgs e) +106
System.Web.UI.Control.LoadRecursive() +68
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3785
Line 50: cmd.CommandType = CommandType.StoredProcedure;
Line 51: cmd.Parameters.AddWithValue("@name", ProfileName);
Line 52: sdr = cmd.ExecuteReader();
Line 53: if (!sdr.HasRows)
Line 54: {
Source File: C:\inetpub\bpip\profile.aspx.cs Line: 52
Stack Trace:
[SqlException (0x80131904): Arithmetic overflow error converting numeric to data type numeric.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +3306108
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +736
System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4061
System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +90
System.Data.SqlClient.SqlDataReader.get_MetaData() +99
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) +604
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) +3303
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) +667
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +83
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +301
System.Data.SqlClient.SqlCommand.ExecuteReader() +137
bpip_profile.Page_Load(Object sender, EventArgs e) in C:\inetpub\bpip\profile.aspx.cs:52
System.Web.UI.Control.OnLoad(EventArgs e) +106
System.Web.UI.Control.LoadRecursive() +68
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3785
I was just going through my BPIP "merit sent," and I noticed that I could only go back 6 months.
It shows exactly 1000 entries, just like the Most Activity pages are limited to 1000. Probably to prevent server load once tens of thousands of Merit has been sent/received. I agree though, a complete list is better.Fixed.
You can also set dates as well. yyyy/mm/dd
https://bpip.org/smerit.aspx?to=&from=&start=&end=&min=&max=
Whoaza!!!!!!! Check out the friendly (or NOT) competition that is taking place, right before our very eyes!!!!
Thanks to both of you for your rivalry that benefits the remainder of us mere mortals (this is an opportunity for me to subtly assert that I am not a bot, as some others have accused me)...
I was just going through my BPIP "merit sent," and I noticed that I could only go back 6 months.
It shows exactly 1000 entries, just like the Most Activity pages are limited to 1000. Probably to prevent server load once tens of thousands of Merit has been sent/received. I agree though, a complete list is better.Fixed.
You can also set dates as well. yyyy/mm/dd
https://bpip.org/smerit.aspx?to=&from=&start=&end=&min=&max=
I was just going through my BPIP "merit sent," and I noticed that I could only go back 6 months.
It shows exactly 1000 entries, just like the Most Activity pages are limited to 1000. Probably to prevent server load once tens of thousands of Merit has been sent/received. I agree though, a complete list is better.Quote
I was not able to check (at least I had not figured out a way to look back further).
I have detailed files (I love quoting the Terminator): http://loyce.club/Merit/history/252510.html (note the BBCode link).
Hey Vod.
I was just going through my BPIP "merit sent," and I noticed that I could only go back 6 months. I was wondering about such design decision. Is the further back data, there? or was there a reason that you wanted to limit based on concerns of abuse of the information?
My personal reason today, was that sometimes, I merit posts that I want to remember (or create a short cut) and most of the time, the post will be in recent weeks, but this time, I was pretty sure that the merited post would have been back further than 6 months, and I was not able to check (at least I had not figured out a way to look back further).
Also, I was wondering if there could be a way to allow the merit fans and favorite to send sections could be expanded out with like a (see more) that might open another page or tab to expand beyond 10 for each of those?
Thanks for your ongoing maintenance of this site.. its very helpful.
I was just going through my BPIP "merit sent," and I noticed that I could only go back 6 months. I was wondering about such design decision. Is the further back data, there? or was there a reason that you wanted to limit based on concerns of abuse of the information?
My personal reason today, was that sometimes, I merit posts that I want to remember (or create a short cut) and most of the time, the post will be in recent weeks, but this time, I was pretty sure that the merited post would have been back further than 6 months, and I was not able to check (at least I had not figured out a way to look back further).
Also, I was wondering if there could be a way to allow the merit fans and favorite to send sections could be expanded out with like a (see more) that might open another page or tab to expand beyond 10 for each of those?
Thanks for your ongoing maintenance of this site.. its very helpful.
Possible, but I don't want to start parsing every post yet. Once these lists formed, they would change slowly, if at all. Not a preferred use of a real time system.
Better left to the statistical geniuses like LoyceV. I have other plans...
Noted!Better left to the statistical geniuses like LoyceV. I have other plans...
By post or by views, there's already one here in the forum, why do we need it in BPIP?
To get there:
Go to the Homepage by clicking "Home", scroll down to the bottom of the page, then click "[More Stats]".
Or just click that link above. ↗
I know this, but I was talking about the top 10 favorite boards of an individual member not GLOBAL. To get there:
Go to the Homepage by clicking "Home", scroll down to the bottom of the page, then click "[More Stats]".
Or just click that link above. ↗
Jump to: