Hey Everyone,

I made some more configuration updates to improve database stability. If you notice any database errors, please post about them here.

Jake

When I'm logged into this site and visit my team page I get a database error that is not there if I'm logged out.



Also, I requested a change of foundership and after the 60 day grace period instead of being presented with the option to finalize the transfer, I could only choose to initiate the transfer again.
I'm not sure that the error is related to the change of foundership fail because I've had the fail occur on 3 or 4 other BOINC project sites that didn't display the error - but I'm sure I've seen that error before on other project's team pages.

---

I think there may be two seperate issues here.
I see the same database error when logged into the team page at Collatz but I was still able to finalize the founder transfer there.
I don't see the database error on the few BOINC projects that didn't show the option to finalize the transfer after the required wait period.

Hi Contact,

I found the query that is causing that database error. I am working on a fix for it now. It doesn't seem like an issue that would prevent team transfer though. We will see.

Jake

[Edit]
I fixed the issue with the database error. Changing founders does seem to work, I am not sure what method you were using though. Maybe you can give me a little more direction to where exactly you were seeing an issue.
[/Edit]

Thanks!
I no longer see the database error and I agree that the error did not cause the founder transfer fail because the database error was there for a least one other project (Collatz) where the transfer could be completed.

May I burden you further and ask if you can explain your fix simply enough for me to forward the info to other projects that may be experiencing the same database error?

Also, may I burden you even further to ask you to investigate why the founder transfer may have failed?

I can wait another 60 days to try if you need.

[Edit]Jake Weiss wrote:

I am not sure what method you were using though. Maybe you can give me a little more direction to where exactly you were seeing an issue.

When you are a member of a team you have an option on the projects team page to initiate a Team foundership change.
[/Edit]

Hi Contact,

There was a problem using a Group By statement in the database query for new users. As a quick fix, I just removed it. This means names can show up more than once as a new user, but I don't really think that's too big of a deal.


As for the founder issue, I actually tried it and simulated a 60 day wait time on our database. The functionality definitely works assuming the date is set correctly when a request is sent. I'll check on that today. Chances are, you will have to wait another 60 days once I get it working though. That seems to be the only fair way to make sure the system isn't getting cheated.

Jake

Thanks for your time and information Jake, and my apologies for hijacking this thread.
I agree that it's most fair and more interesting to wait again.

As a side note, I just had another founder transfer fail on another project and this time noticed this response after I re-initiated transfer:
SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/Troubleshooting
The current founder has been notified of your request by email and private message.

Likely not the problem on this site, and maybe just an insignificant mail send fail, but could something like that block some other call to the code and so not actually initiate founder transfer?