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

The long code, everything after "Database Error" is because I enabled recently debugging output while working on something else.
I now disabled it.
But the database error, and subsequent "Warning: count()" error, is still present. (TODO)

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

I did not know about it.

I disabled the new member listing on team page due to the "database" errors.