Open Forum
Maintained by
Open LMS Development
Open forum are designed to increase engagement and provide a responsive, modern alternative to standard Moodle forums.
Comments
Comments are no longer open for new posts. Existing comments remain available to read.
Debug info: Table 'lms.mdl_hsuforum_discussion' doesn't exist
SELECT count(1) FROM mdl_hsuforum_subscriptions_disc t1 LEFT JOIN mdl_hsuforum_discussion t2 ON t1.discussion = t2.id WHERE t1.discussion <> ? AND t2.id IS NULL
[array (
0 => '0',
)]
Error code: dmlreadexception
Stack trace:
line 423 of /lib/dml/moodle_database.php: dml_read_exception thrown
line 1005 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
line 1397 of /lib/dml/moodle_database.php: call to mysqli_native_moodle_database->get_records_sql()
line 1470 of /lib/dml/moodle_database.php: call to moodle_database->get_record_sql()
line 1641 of /lib/dml/moodle_database.php: call to moodle_database->get_field_sql()
line 105 of /admin/tool/xmldb/actions/check_foreign_keys/check_foreign_keys.class.php: call to moodle_database->count_records_sql()
line 159 of /admin/tool/xmldb/actions/XMLDBCheckAction.class.php: call to check_foreign_keys->check_table()
line 69 of /admin/tool/xmldb/index.php: call to XMLDBCheckAction->invoke()
We got this error in 2.3.8 and 2.5.1
Got it by checking for Foreign Key Violations in the XMLDB editor that comes with Moodle.
Go to Site Administrator > Development > XMLDB Editior and then click on the Check foreign keys option.
Was running the XMLDB editor in moodle to look for foreign key violations and I got the following error:
Debug info: Table 'lms.mdl_hsuforum_discussion' doesn't exist
SELECT count(1) FROM mdl_hsuforum_subscriptions_disc t1 LEFT JOIN mdl_hsuforum_discussion t2 ON t1.discussion = t2.id WHERE t1.discussion <> ? AND t2.id IS NULL
[array (
0 => '0',
)]
Error code: dmlreadexception
Any suggestions for a fix?
You may be happy to know that we are working with the Core developers to include that functionality in a later version. Further details will be provided when they are ready.
Would be a good idea to have different documentation for this lite version to save others looking for things that aren't there. I only realised after reading one of the comments above.
@Tony - the Moodle 2.3 version does not address the changes to support YUI 2in3 required for Moodle 2.4. It generally takes us a full release cycle (6 months) to update plugins to the latest version of Moodle, though we are trying to improve on that in the future.