I've recently set up my first Moodle installation, hosted on an InMotion server. I'm using Configurable Reports, but otherwise, everything is standard out-of-the-box Moodle. A few days ago, I gave several new users 'Manager' permissions and they have been adding users and creating configurable reports.
Now, I'm getting database errors when I try to access the site. Based on what I've read here, it could be a hosting issue, but I want to make sure that it isn't something that we broke on our end.
If anyone from the community can help me interpret this stack trace, I will be extremely grateful.
Error reading from database
Debug info: MySQL server has gone away
SELECT * FROM mdl_portfolio_instance ORDER BY name
[array (
)]
Error code: dmlreadexception
SELECT * FROM mdl_portfolio_instance ORDER BY name
[array (
)]
Error code: dmlreadexception
Stack trace:
- line 441 of /lib/dml/moodle_database.php: dml_read_exception thrown
- line 996 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
- line 530 of /lib/portfoliolib.php: call to mysqli_native_moodle_database->get_records_sql()
- line 232 of /admin/settings/plugins.php: call to portfolio_instances()
- line 6389 of /lib/adminlib.php: call to require()
- line 19 of /admin/settings.php: call to admin_get_root()
and this one:
Error reading from database
Debug info: MySQL server has gone away
SELECT
bi.id,
bp.id AS blockpositionid,
bi.blockname,
bi.parentcontextid,
bi.showinsubcontexts,
bi.pagetypepattern,
bi.subpagepattern,
bi.defaultregion,
bi.defaultweight,
COALESCE(bp.visible, 1) AS visible,
COALESCE(bp.region, bi.defaultregion) AS region,
COALESCE(bp.weight, bi.defaultweight) AS weight,
bi.configdata
, ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, ctx.instanceid AS ctxinstance
FROM mdl_block_instances bi
JOIN mdl_block b ON bi.blockname = b.name
LEFT JOIN mdl_block_positions bp ON bp.blockinstanceid = bi.id
AND bp.contextid = ?
AND bp.pagetype = ?
AND bp.subpage = ?
LEFT JOIN mdl_context ctx ON (ctx.instanceid = bi.id AND ctx.contextlevel = ?)
WHERE
bi.parentcontextid = ?
AND bi.pagetypepattern IN (?,?,?,?,?)
AND (bi.subpagepattern IS NULL OR bi.subpagepattern = ?)
AND (bp.visible = 1 OR bp.visible IS NULL)
AND b.visible = 1
ORDER BY
COALESCE(bp.region, bi.defaultregion),
COALESCE(bp.weight, bi.defaultweight),
bi.id
[array (
0 => '1',
1 => 'admin-setting-debugging',
2 => '',
3 => 80,
4 => '1',
5 => 'admin-setting-debugging',
6 => 'admin-setting-debugging-*',
7 => 'admin-setting-*',
8 => 'admin-*',
9 => '*',
10 => '',
)]
Error code: dmlreadexception
SELECT
bi.id,
bp.id AS blockpositionid,
bi.blockname,
bi.parentcontextid,
bi.showinsubcontexts,
bi.pagetypepattern,
bi.subpagepattern,
bi.defaultregion,
bi.defaultweight,
COALESCE(bp.visible, 1) AS visible,
COALESCE(bp.region, bi.defaultregion) AS region,
COALESCE(bp.weight, bi.defaultweight) AS weight,
bi.configdata
, ctx.id AS ctxid, ctx.path AS ctxpath, ctx.depth AS ctxdepth, ctx.contextlevel AS ctxlevel, ctx.instanceid AS ctxinstance
FROM mdl_block_instances bi
JOIN mdl_block b ON bi.blockname = b.name
LEFT JOIN mdl_block_positions bp ON bp.blockinstanceid = bi.id
AND bp.contextid = ?
AND bp.pagetype = ?
AND bp.subpage = ?
LEFT JOIN mdl_context ctx ON (ctx.instanceid = bi.id AND ctx.contextlevel = ?)
WHERE
bi.parentcontextid = ?
AND bi.pagetypepattern IN (?,?,?,?,?)
AND (bi.subpagepattern IS NULL OR bi.subpagepattern = ?)
AND (bp.visible = 1 OR bp.visible IS NULL)
AND b.visible = 1
ORDER BY
COALESCE(bp.region, bi.defaultregion),
COALESCE(bp.weight, bi.defaultweight),
bi.id
[array (
0 => '1',
1 => 'admin-setting-debugging',
2 => '',
3 => 80,
4 => '1',
5 => 'admin-setting-debugging',
6 => 'admin-setting-debugging-*',
7 => 'admin-setting-*',
8 => 'admin-*',
9 => '*',
10 => '',
)]
Error code: dmlreadexception
Stack trace:
- line 441 of /lib/dml/moodle_database.php: dml_read_exception thrown
- line 933 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
- line 633 of /lib/blocklib.php: call to mysqli_native_moodle_database->get_recordset_sql()
- line 1417 of /lib/pagelib.php: call to block_manager->load_blocks()
- line 855 of /lib/pagelib.php: call to moodle_page->starting_output()
- line 791 of /lib/outputrenderers.php: call to moodle_page->set_state()
- line 2559 of /lib/outputrenderers.php: call to core_renderer->header()
- line 362 of /lib/setuplib.php: call to core_renderer->fatal_error()
- line ? of unknownfile: call to default_exception_handler()
Thanks! -Joel