Application Form
Maintained by
Fumikazu Iseki
This module is for submission of the application form.
Comments
Comments are no longer open for new posts. Existing comments remain available to read.
Error reading from database
More information about this error
Debug info: Table 'doh_db.mdl_apply_submit' doesn't exist
SELECT * FROM mdl_apply_submit WHERE version>0 AND class!=0 AND apply_id=? AND user_id=?
[array (
0 => '94',
1 => '416',
)]
Error code: dmlreadexceptionDismiss 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 1398 of /lib/dml/mysqli_native_moodle_database.php: call to mysqli_native_moodle_database->query_end()
line 1513 of /lib/dml/moodle_database.php: call to mysqli_native_moodle_database->get_records_sql()
line 181 of /mod/apply/locallib.php: call to moodle_database->get_records_select()
line 189 of /mod/apply/locallib.php: call to apply_get_valid_submits()
line 152 of /mod/apply/view.php: call to apply_get_valid_submits_count()
using 4.3
I try merge Andrew's code.
Thank you for your information and thank you Andrew Hancox
Could you add to your plugin "Field FILE" that allow to upload files?
Andrew Hancox already work in FILE UPLOAD (https://github.com/andrewhancox/moodle-mod_apply) but, maybe is not oficial release.
Thanks a lot...
Therefore I checked the repository published by Iseki-sensei and found the 2022/07/06 version.
Source control URL (http://www.nsl.tuis.ac.jp/svn/php/mod_apply/trunk/)
Concerned about other similar problems, I replaced all the files in the repository with the files under /mod/apply/ in the server.
As a result, it works fine! Thank you for your continued support.
Fatal error: Array and string offset access syntax with curly braces is no longer supported in /usr/local/www/apache24/data/moodle/mod/apply/jbxl/jbxl_tools.php on line 164
Could this be the key to the solution?
Thank you very much.
The error occurred when I clicked on the Application Form icon, resulting in a transition to a blank screen.
Since it is a pure white screen, there is no error message. Also, such an error does not occur in other Moodle pages or modules.
My environment here is as follows.
OS: FreeBSD 13.1-RELEASE-p1 GENERIC
PHP 8.0.20
apache24-2.4.54
mysql80-server-8.0.29
Moodle 3.11.9
Currently, PHP is back to php74-7.4.30, and there is no problem. It seems that there is no problem in the resemble environment of Rocky Linux 8, so it may be a FreeBSD problem.
If you can come up with something like a hint of a solution, it would be helpful if you could tell me.
Thank you.
Where does the error occur?
Is it when you click on the Application Form icon?
Do you get any messages when you put Moodle into debug mode?
The error does not occur in my environment.
Thanks.
my environment.
OS : Rocky Linux 8
PHP 8.0.13
httpd-2.4.37-47 (Apache)
mariadb-10.3.32
Moodle-4.0.1
Now, I have updated Moodle version from 3.11.5 to 3.11.8 and PHP version from 7.4 to 8.0. And when I started the Application Form, "HTTP ERROR 500" was displayed and I could not access it.
Perhaps PHP 7.4 will end support in November, so I updated to 8.0, but I suspect that this is the cause.
I am sorry to bother you while you are busy, but could you tell me if there is a solution?
Please feel free to use it.
I personally am not happy with the sorting feature, but I am currently working on another project (Moodle+JupyterHub) and don't have time to fix it.
https://gitlab.nsl.tuis.ac.jp/explore
Thanks.
https://github.com/andrewhancox/moodle-mod_apply