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 (LINE 1: ...notatorid AND c.isquestion = $2 AND c.isdeleted = $3GROUP BY...) #109

Open
caiadogithub opened this issue Jul 28, 2024 · 0 comments

Comments

@caiadogithub
Copy link

Hi,

First install and I got this error message:

"Error reading from database

Debug info: ERRO: elemento incorreto após parâmetro em ou próximo a "$3G"
LINE 1: ...notatorid AND c.isquestion = $2 AND c.isdeleted = $3GROUP BY...
^
SELECT AVG(count) AS average FROM (SELECT COUNT(*) AS count FROM mdl_pdfannotator_comments c, mdl_pdfannotator a WHERE a.course = $1 AND a.id = c.pdfannotatorid AND c.isquestion = $2 AND c.isdeleted = $3GROUP BY c.userid ) AS counts
[array (
0 => '2951',
1 => '1',
2 => '0',
)]
Error code: dmlreadexception
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 341 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->read_slave_query_end()
line 1027 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
line 105 of /mod/pdfannotator/model/statistics.class.php: call to pgsql_native_moodle_database->get_records_sql()
line 143 of /mod/pdfannotator/model/statistics.class.php: call to pdfannotator_statistics->get_comments_average_course()
line 57 of /mod/pdfannotator/classes/output/statistics.php: call to pdfannotator_statistics->get_tabledata()
line 478 of /mod/pdfannotator/controller.php: call to mod_pdfannotator\output\statistics->__construct()
line 89 of /mod/pdfannotator/view.php: call to require_once()"

PDF Annotator v1.5 release 5 (2023112900)
Moodle 4.1.11+ (Build: 20240712)
PostgreSQL 16
PHP 7.4

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