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

Setting Draft to Submit for Grading: You have an error in your SQL syntax #74

Open
Richardvi opened this issue Dec 4, 2023 · 1 comment

Comments

@Richardvi
Copy link

Posted it at https://tracker.moodle.org/browse/MDL-80316 because I thought it was a Moodle bug. Turns out to be a MaharaWS bug.

Moodle 4.2, assignment set up as MaharaWS assignment as well as an upload file assignment. No Mahara portfolio is being turned in though. Following happens:

  1. Students have submitted an assignment as draft.
  2. In 'view all submissions'-screen, choose for 'edit -> submit for grading' behind a student's name.
  3. Following error occurs:

Error reading from database

More information about this error
Debug info: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM mdl_user WHERE id = '22671'' at line 1
SELECT FROM mdl_user WHERE id = ?
[array (
0 => '22671',
)]
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 1375 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->query_end()
line 1679 of /lib/dml/moodle_database.php: call to mysqli_native_moodle_database->get_records_sql()
line 1752 of /lib/dml/moodle_database.php: call to moodle_database->get_record_sql()
line 1733 of /lib/dml/moodle_database.php: call to moodle_database->get_field_sql()
line 1712 of /lib/dml/moodle_database.php: call to moodle_database->get_field_select()
line 595 of /mod/assign/submission/maharaws/locallib.php: call to moodle_database->get_field()
line 911 of /mod/assign/submission/maharaws/locallib.php: call to assign_submission_maharaws->submit_view()
line 6802 of /mod/assign/locallib.php: call to assign_submission_maharaws->submit_for_grading()
line 6850 of /mod/assign/locallib.php: call to assign->submit_for_grading()
line 561 of /mod/assign/locallib.php: call to assign->process_submit_other_for_grading()
line 55 of /mod/assign/view.php: call to assign->view()

@Richardvi
Copy link
Author

image

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