Further info:
Appears to be sql errors; despite the fact that queries execute OK from command line.
Previously (code above), ALL sql queries returned no results and, did not appear in transaction log.
And, yes, phpmyadmin reports db as "clean"
Really simple testcase (dump the class):
I researched this and error is commonly caused by:
sql: max_allowed_packet (I use 16M, nowhere near hitting this limit)
sql: wait_timeout, interactive_timeout (I use 28800, nowhere near hitting this limit)
running outa memory:
free -h
total used free shared buffers cached
Mem: 1.9G 1.8G 140M 60K 45M 495M
-/+ buffers/cache: 1.3G 681M
Swap: 3.9G 115M 3.8G
$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
(
)
)
What I don't get is why simply instantiating $member_handler = xoops_getHandler('member'); results in errors.
I also have issues with new members being unable to register - keeps returning to basic registration page.
I have spent way too much time on this and am considering giving up on oledrion and finding a non-xoops e-commerce solution.
Anyone care to assist debugging? May involve sshing in.
Regards;
Bill
