<script src="https://www.mysite.com/include/xoops.js" type="text/javascript">script> <link rel="stylesheet" href="https://www.mysite.com/language/french/style.css" type="text/css" />
public static function getUsersFromGroup($groupId)
{
/** @var XoopsMemberHandler $memberHandler */
$memberHandler = xoops_getHandler('member');
file_put_contents(OLEDRION_GATEWAY_LOG_PATH, "memberHandler: " . print_r($memberHandler,true) . "n", FILE_APPEND | LOCK_EX);
$users = $memberHandler->getUsersByGroup($groupId, true);
file_put_contents(OLEDRION_GATEWAY_LOG_PATH, "users: " . print_r($users,true) . "n", FILE_APPEND | LOCK_EX);
return $users;
}
/**
* Retourne la liste des emails des utilisateurs membres d'un groupe
*
* @param $groupId
* @return array Emails list
* @internal param int $group_id Group's number
*/
public static function getEmailsFromGroup($groupId)
{
$ret = [];
file_put_contents(OLEDRION_GATEWAY_LOG_PATH, "groupId: " . print_r($groupId) . "n", FILE_APPEND | LOCK_EX);
$member_handler = xoops_getHandler('member');
$user_ids = static::getUsersFromGroup($groupId);
file_put_contents(OLEDRION_GATEWAY_LOG_PATH, "users_ids: " . print_r($user_ids,true) . "n", FILE_APPEND | LOCK_EX);
foreach ($user_ids as $user_id) {
//$user = $member_handler->getUser($user_id);
$user = $member_handler->getUsers(null, true);
$ret[] = $user->getVar('email');
}
file_put_contents(OLEDRION_GATEWAY_LOG_PATH, "ret: " . print_r($ret,true) . "n", FILE_APPEND | LOCK_EX);
return $ret;
}
$member_handler = xoops_getHandler('member');
file_put_contents(OLEDRION_GATEWAY_LOG_PATH, "users_ids: " . print_r($user_ids,true) . "n", FILE_APPEND | LOCK_EX);
memberHandler: XoopsMemberHandler Object
(
[groupHandler:protected] => XoopsGroupHandler Object
(
[table] => xoops_groups
[db] => XoopsMySQLDatabaseProxy Object
(
[conn] => mysqli Object
(
[affected_rows] => -1
[client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
[client_version] => 50011
[connect_errno] => 0
[connect_error] =>
[errno] => 2006
[error] => MySQL server has gone away
[error_list] => Array
(
[0] => Array
(
[errno] => 2006
[sqlstate] => HY000
[error] => MySQL server has gone away
)
[1] => Array
(
[errno] => 2006
[sqlstate] => HY000
[error] => MySQL server has gone away
)
)
[field_count] => 0
[host_info] => Localhost via UNIX socket
[info] => Rows matched: 1 Changed: 1 Warnings: 0
[insert_id] => 0
[server_info] => 5.5.60-log
[server_version] => 50560
[stat] =>
[sqlstate] => HY000
[protocol_version] => 10
[thread_id] => 2346
[warning_count] => 0
)
[prefix] => xoops
[logger] => XoopsLogger Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SET SQL_BIG_SELECTS = 1
[error] =>
[errno] =>
[query_time] => 0.00029397010803223
)
[1] => Array
(
[sql] => SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
[error] =>
[errno] =>
[query_time] => 0.0035851001739502
)
[2] => Array
(
[sql] => SELECT sess_data, sess_ip FROM xoops_session WHERE sess_id = '3l1hmfs01p6f82lu11uk0tmgk1'
[error] =>
[errno] =>
[query_time] => 0.00056004524230957
)
)
[blocks] => Array
(
)
[extra] => Array
(
)
[logstart] => Array
(
[XOOPS] => 1576070405.709
[XOOPS Boot] => 1576070405.709
)
[logend] => Array
(
[query_time] => 1576070405.7597
)
[errors] => Array
(
)
[deprecated] => Array
(
)
[usePopup] =>
[activated] =>
[renderingEnabled] => 1
)
[allowWebChanges] => 1
)
)
[userHandler:protected] => XoopsUserHandler Object
(
[handler] =>
[handlers] => Array
(
[read] =>
[stats] =>
[joint] =>
[write] =>
[sync] =>
)
[table] => xoops_users
[keyName] => uid
[className] => XoopsUser
[identifierName] => uname
[field_link] =>
[field_object] =>
[db] => XoopsMySQLDatabaseProxy Object
(
[conn] => mysqli Object
(
[affected_rows] => -1
[client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
[client_version] => 50011
[connect_errno] => 0
[connect_error] =>
[errno] => 2006
[error] => MySQL server has gone away
[error_list] => Array
(
[0] => Array
(
[errno] => 2006
[sqlstate] => HY000
[error] => MySQL server has gone away
)
[1] => Array
(
[errno] => 2006
[sqlstate] => HY000
[error] => MySQL server has gone away
)
[2] => Array
(
[errno] => 2006
[sqlstate] => HY000
[error] => MySQL server has gone away
)
)
[field_count] => 0
[host_info] => Localhost via UNIX socket
[info] => Rows matched: 1 Changed: 1 Warnings: 0
[insert_id] => 0
[server_info] => 5.5.60-log
[server_version] => 50560
[stat] =>
[sqlstate] => HY000
[protocol_version] => 10
[thread_id] => 2346
[warning_count] => 0
)
[prefix] => xoops
[logger] => XoopsLogger Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SET SQL_BIG_SELECTS = 1
[error] =>
[errno] =>
[query_time] => 0.00029397010803223
)
[1] => Array
(
[sql] => SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
[error] =>
[errno] =>
[query_time] => 0.0035851001739502
)
[2] => Array
(
[sql] => SELECT sess_data, sess_ip FROM xoops_session WHERE sess_id = '3l1hmfs01p6f82lu11uk0tmgk1'
[error] =>
[errno] =>
[query_time] => 0.00056004524230957
)
)
[blocks] => Array
(
)
[extra] => Array
(
)
[logstart] => Array
(
[XOOPS] => 1576070405.709
[XOOPS Boot] => 1576070405.709
)
[logend] => Array
(
[query_time] => 1576070405.7597
)
[errors] => Array
(
)
[deprecated] => Array
(
)
[usePopup] =>
[activated] =>
[renderingEnabled] => 1
)
[allowWebChanges] => 1
)
)
[membershipHandler:protected] => XoopsMembershipHandler Object
(
[table] => xoops_groups_users_link
[db] => XoopsMySQLDatabaseProxy Object
(
[conn] => mysqli Object
(
[affected_rows] => -1
[client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
[client_version] => 50011
[connect_errno] => 0
[connect_error] =>
[errno] => 2006
[error] => MySQL server has gone away
[error_list] => Array
(
[0] => Array
(
[errno] => 2006
[sqlstate] => HY000
[error] => MySQL server has gone away
)
[1] => Array
(
[errno] => 2006
[sqlstate] => HY000
[error] => MySQL server has gone away
)
[2] => Array
(
[errno] => 2006
[sqlstate] => HY000
[error] => MySQL server has gone away
)
[3] => Array
(
[errno] => 2006
[sqlstate] => HY000
[error] => MySQL server has gone away
)
)
[field_count] => 0
[host_info] => Localhost via UNIX socket
[info] => Rows matched: 1 Changed: 1 Warnings: 0
[insert_id] => 0
[server_info] => 5.5.60-log
[server_version] => 50560
[stat] =>
[sqlstate] => HY000
[protocol_version] => 10
[thread_id] => 2346
[warning_count] => 0
)
[prefix] => xoops
[logger] => XoopsLogger Object
(
[queries] => Array
(
[0] => Array
(
[sql] => SET SQL_BIG_SELECTS = 1
[error] =>
[errno] =>
[query_time] => 0.00029397010803223
)
[1] => Array
(
[sql] => SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
[error] =>
[errno] =>
[query_time] => 0.0035851001739502
)
[2] => Array
(
[sql] => SELECT sess_data, sess_ip FROM xoops_session WHERE sess_id = '3l1hmfs01p6f82lu11uk0tmgk1'
[error] =>
[errno] =>
[query_time] => 0.00056004524230957
)
)
[blocks] => Array
(
)
[extra] => Array
(
)
[logstart] => Array
(
[XOOPS] => 1576070405.709
[XOOPS Boot] => 1576070405.709
)
[logend] => Array
(
[query_time] => 1576070405.7597
)
[errors] => Array
(
)
[deprecated] => Array
(
)
[usePopup] =>
[activated] =>
[renderingEnabled] => 1
)
[allowWebChanges] => 1
)
)
[membersWorkingList:protected] => Array
(
)
)
Dhurgan wrote:
...
Checking the error.log it shows the message...
Upgrade required on users table!, referer:
So apparently some step in the upgrade has required a db schema change.
...