Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error reading from database - Unknown column 'q.category' in 'on clause' #38

Open
jprovasnik opened this issue Nov 21, 2023 · 0 comments

Comments

@jprovasnik
Copy link

Hello, Using Moodle 4.1 on Workplace, the plugin works fine with the exception of adding a "question" to the Content Page activity -- as soon as the Add a question button is clicked, a Error reading from Database message appears. A was question was already created at the course-level question bank, but I could not access it:

URL: https://judemigration.unhosting.site/mod/icontent/addquestionpage.php?id=32137&pageid=2

Content Pages Sample: Add new question
Error reading from database
More information about this error

Debug info: Unknown column 'q.category' in 'on clause'
SELECT q.id, q.qtype, q.name, q.timecreated, q.timemodified, q.createdby, q.modifiedby, c.contextid
FROM mdl_question q
JOIN mdl_question_categories c
ON c.id = q.category
WHERE c.contextid = ?
AND q.qtype IN (?,?,?,?)
ORDER BY q.name ASC LIMIT 0, 20
[array (
0 => 134013,
1 => 'essay',
2 => 'match',
3 => 'multichoice',
4 => 'truefalse',
)]
Error code: dmlreadexception×Dismiss this notification
Stack trace:
line 494 of /lib/dml/moodle_database.php: dml_read_exception thrown
line 293 of /lib/dml/moodle_read_slave_trait.php: call to moodle_database->query_end()
line 1282 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->query_end()
line 546 of /mod/icontent/locallib.php: call to mysqli_native_moodle_database->get_records_sql()
line 85 of /mod/icontent/addquestionpage.php: call to icontent_get_questions_of_questionbank()

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant