Posts by UBT - Timbo
|
1)
Message boards :
Cafe :
Formula BOINC 2024 Deprecated: Creation of dynamic property BoincUser::$prefs is deprecated in /var/boincadm/prj/html/inc/forum_db.inc on line 164 (Message 4799) Posted 16 Feb 2024 by UBT - Timbo Post: Formula BOINC 2024 re-launch I am acting as admin for the above group and I wanted to let you know that the Formula BOINC website has been updated for the 2024 Season. And that the Sprint Season will start on 29th February - just about 2 weeks time - so please help publicise Formula BOINC to your team members so that they can take part. For Teams: Teams previously registered to take part in these regular BOINC Challenges in previous years have been included for this season and Teams have now been allocated to one of 3 Leagues, depending on their performance in 2023. If your team is NOT registered already, please ask your team founder to register (via the FB website) Registered Teams are listed here: https://formula-boinc.org/teams.py?race=0&division=1&standing=team And it would be really good if your team members can take part and support the various BOINC projects throughout the forthcoming year. As many teams are already registered, members do not have to do anything EXCEPT to make a note of the date and time when the Sprints will be taking place and to ensure that they are crunching tasks from the chosen project. This information will be displayed on our website here: https://formula-boinc.org/sprints.py?race=0&division=1&standing=team For members: We also have a Members League so that individuals can compete against one another - this is entirely voluntary but it can be rewarding to know how well you are doing when compared to other FB members - even those in the same team. If any team members have not already registered, then there is a webpage that you can visit and register, which is here: https://formula-boinc.org/howtoregister.py And finally for all the latest news about Formula BOINC, we would ask members to visit our forum: https://formula-boinc.org/forum/index.php I do hope teams and members will support the Challenges and by doing so, this will help the many BOINC projects who need the support of volunteers in order to continue their research. best regards UBT - Timbo Admin for Formula BOINC |
|
2)
Message boards :
News :
Database Crash and Recovery
(Message 4026)
Posted 3 Mar 2020 by UBT - Timbo Post: Glad to see the project website back up and running. Well done to Tomas for all his efforts. Hopefully a new backup policy can be implemented so that *IF* a future failure occurs then less data will be lost. But computers are funny beasts and can fail at the worst times...but in the end it is the data that is most important rather than a few lost credits (which I understand does suck, but no point crying over spilt milk...just crunch a few more tasks and you'll make up the loss soon enough ;-) ).. |
|
3)
Message boards :
Closed Issues :
Website error when viewing teams
(Message 3942)
Posted 24 Jan 2020 by UBT - Timbo Post: Hi Tomáš Thanx for your prompt reply... OK, so it's a "work in progress" - at least you are aware of it (which I didn't know and why I reported it). regards Tim |
|
4)
Message boards :
Closed Issues :
Website error when viewing teams
(Message 3934)
Posted 22 Jan 2020 by UBT - Timbo Post: Hi Recently (over the last day or so) whenever I've wanted to see the team data for "UK BOINC Team" on this website, I get many lines of code, and the information is then displayed underneath, just like a normal page would do. But there are many lines of code displayed, and maybe are a sign of something failing? regards Tim Founder, UK BOINC Team This is an example, for BOINC@Australia - but it also happens with other teams too, though it does seem to vary as sometimes it will load the page correctly...maybe it's an issue with server load ?. Database Error
: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'boinc.team_delta.timestamp' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
array(6) {
[0]=>
array(7) {
["file"]=>
string(49) "/mnt/data/other/boincadm/prj/html/inc/db_conn.inc"
["line"]=>
int(140)
["function"]=>
string(8) "do_query"
["class"]=>
string(6) "DbConn"
["object"]=>
object(DbConn)#1 (3) {
["db_conn"]=>
object(mysqli)#2 (19) {
["affected_rows"]=>
int(-1)
["client_info"]=>
string(79) "mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $"
["client_version"]=>
int(50012)
["connect_errno"]=>
int(0)
["connect_error"]=>
NULL
["errno"]=>
int(1055)
["error"]=>
string(238) "Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'boinc.team_delta.timestamp' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by"
["error_list"]=>
array(1) {
[0]=>
array(3) {
["errno"]=>
int(1055)
["sqlstate"]=>
string(5) "42000"
["error"]=>
string(238) "Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'boinc.team_delta.timestamp' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by"
}
}
["field_count"]=>
int(15)
["host_info"]=>
string(25) "Localhost via UNIX socket"
["info"]=>
NULL
["insert_id"]=>
int(0)
["server_info"]=>
string(6) "8.0.17"
["server_version"]=>
int(80017)
["stat"]=>
string(146) "Uptime: 1407360 Threads: 4 Questions: 11480901 Slow queries: 0 Opens: 3854833 Flush tables: 3 Open tables: 64 Queries per second avg: 8.157"
["sqlstate"]=>
string(5) "00000"
["protocol_version"]=>
int(10)
["thread_id"]=>
int(379334)
["warning_count"]=>
int(0)
}
["db_name"]=>
string(5) "boinc"
["readonly"]=>
bool(false)
}
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
string(104) "select * from boinc.team_delta where teamid=3028 and timestamp>1579650666 and joining=1 group by userid "
}
}
[1]=>
array(7) {
["file"]=>
string(49) "/mnt/data/other/boincadm/prj/html/inc/db_conn.inc"
["line"]=>
int(165)
["function"]=>
string(12) "enum_general"
["class"]=>
string(6) "DbConn"
["object"]=>
object(DbConn)#1 (3) {
["db_conn"]=>
object(mysqli)#2 (19) {
["affected_rows"]=>
int(-1)
["client_info"]=>
string(79) "mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $"
["client_version"]=>
int(50012)
["connect_errno"]=>
int(0)
["connect_error"]=>
NULL
["errno"]=>
int(0)
["error"]=>
string(0) ""
["error_list"]=>
array(0) {
}
["field_count"]=>
int(15)
["host_info"]=>
string(25) "Localhost via UNIX socket"
["info"]=>
NULL
["insert_id"]=>
int(0)
["server_info"]=>
string(6) "8.0.17"
["server_version"]=>
int(80017)
["stat"]=>
string(146) "Uptime: 1407360 Threads: 4 Questions: 11480902 Slow queries: 0 Opens: 3854833 Flush tables: 3 Open tables: 64 Queries per second avg: 8.157"
["sqlstate"]=>
string(5) "00000"
["protocol_version"]=>
int(10)
["thread_id"]=>
int(379334)
["warning_count"]=>
int(0)
}
["db_name"]=>
string(5) "boinc"
["readonly"]=>
bool(false)
}
["type"]=>
string(2) "->"
["args"]=>
array(2) {
[0]=>
string(14) "BoincTeamDelta"
[1]=>
string(105) "select * from boinc.team_delta where teamid=3028 and timestamp>1579650666 and joining=1 group by userid "
}
}
[2]=>
array(7) {
["file"]=>
string(49) "/mnt/data/other/boincadm/prj/html/inc/db_conn.inc"
["line"]=>
int(170)
["function"]=>
string(11) "enum_fields"
["class"]=>
string(6) "DbConn"
["object"]=>
object(DbConn)#1 (3) {
["db_conn"]=>
object(mysqli)#2 (19) {
["affected_rows"]=>
int(-1)
["client_info"]=>
string(79) "mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $"
["client_version"]=>
int(50012)
["connect_errno"]=>
int(0)
["connect_error"]=>
NULL
["errno"]=>
int(0)
["error"]=>
string(0) ""
["error_list"]=>
array(0) {
}
["field_count"]=>
int(15)
["host_info"]=>
string(25) "Localhost via UNIX socket"
["info"]=>
NULL
["insert_id"]=>
int(0)
["server_info"]=>
string(6) "8.0.17"
["server_version"]=>
int(80017)
["stat"]=>
string(146) "Uptime: 1407361 Threads: 4 Questions: 11480903 Slow queries: 0 Opens: 3854833 Flush tables: 3 Open tables: 64 Queries per second avg: 8.157"
["sqlstate"]=>
string(5) "00000"
["protocol_version"]=>
int(10)
["thread_id"]=>
int(379334)
["warning_count"]=>
int(0)
}
["db_name"]=>
string(5) "boinc"
["readonly"]=>
bool(false)
}
["type"]=>
string(2) "->"
["args"]=>
array(5) {
[0]=>
string(10) "team_delta"
[1]=>
string(14) "BoincTeamDelta"
[2]=>
string(1) "*"
[3]=>
string(72) "where teamid=3028 and timestamp>1579650666 and joining=1 group by userid"
[4]=>
NULL
}
}
[3]=>
array(7) {
["file"]=>
string(50) "/mnt/data/other/boincadm/prj/html/inc/boinc_db.inc"
["line"]=>
int(304)
["function"]=>
string(4) "enum"
["class"]=>
string(6) "DbConn"
["object"]=>
object(DbConn)#1 (3) {
["db_conn"]=>
object(mysqli)#2 (19) {
["affected_rows"]=>
int(-1)
["client_info"]=>
string(79) "mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $"
["client_version"]=>
int(50012)
["connect_errno"]=>
int(0)
["connect_error"]=>
NULL
["errno"]=>
int(0)
["error"]=>
string(0) ""
["error_list"]=>
array(0) {
}
["field_count"]=>
int(15)
["host_info"]=>
string(25) "Localhost via UNIX socket"
["info"]=>
NULL
["insert_id"]=>
int(0)
["server_info"]=>
string(6) "8.0.17"
["server_version"]=>
int(80017)
["stat"]=>
string(146) "Uptime: 1407361 Threads: 4 Questions: 11480904 Slow queries: 0 Opens: 3854833 Flush tables: 3 Open tables: 64 Queries per second avg: 8.157"
["sqlstate"]=>
string(5) "00000"
["protocol_version"]=>
int(10)
["thread_id"]=>
int(379334)
["warning_count"]=>
int(0)
}
["db_name"]=>
string(5) "boinc"
["readonly"]=>
bool(false)
}
["type"]=>
string(2) "->"
["args"]=>
array(3) {
[0]=>
string(10) "team_delta"
[1]=>
string(14) "BoincTeamDelta"
[2]=>
string(66) "teamid=3028 and timestamp>1579650666 and joining=1 group by userid"
}
}
[4]=>
array(6) {
["file"]=>
string(46) "/mnt/data/other/boincadm/prj/html/inc/team.inc"
["line"]=>
int(351)
["function"]=>
string(4) "enum"
["class"]=>
string(14) "BoincTeamDelta"
["type"]=>
string(2) "::"
["args"]=>
array(1) {
[0]=>
string(66) "teamid=3028 and timestamp>1579650666 and joining=1 group by userid"
}
}
[5]=>
array(4) {
["file"]=>
string(55) "/mnt/data/other/boincadm/prj/html/user/team_display.php"
["line"]=>
int(65)
["function"]=>
string(15) "new_member_list"
["args"]=>
array(1) {
[0]=>
int(3028)
}
}
}
query: select * from boinc.team_delta where teamid=3028 and timestamp>1579650666 and joining=1 group by userid
Warning: count(): Parameter must be an array or an object that implements Countable in /mnt/data/other/boincadm/prj/html/inc/team.inc on line 352
Warning: Cannot modify header information - headers already sent by (output started at /mnt/data/other/boincadm/prj/html/inc/db_conn.inc:78) in /mnt/data/other/boincadm/prj/html/inc/util.inc on line 257
Warning: Cannot modify header information - headers already sent by (output started at /mnt/data/other/boincadm/prj/html/inc/db_conn.inc:78) in /mnt/data/other/boincadm/prj/html/inc/util.inc on line 258
Warning: Cannot modify header information - headers already sent by (output started at /mnt/data/other/boincadm/prj/html/inc/db_conn.inc:78) in /mnt/data/other/boincadm/prj/html/inc/util.inc on line 260
Warning: Cannot modify header information - headers already sent by (output started at /mnt/data/other/boincadm/prj/html/inc/db_conn.inc:78) in /mnt/data/other/boincadm/prj/html/inc/util.inc on line 262
Warning: Cannot modify header information - headers already sent by (output started at /mnt/data/other/boincadm/prj/html/inc/db_conn.inc:78) in /mnt/data/other/boincadm/prj/html/inc/util.inc on line 264
|
©2024 Tomáš Brada