DML Exception error with postgreSQL when trying to open pdf file using version 1.5.3 (2022120500.)

[HarryBleckert]

A DML Exception error is shown when trying to open the pdf file initially. It won't open and won't show.

We are using DB Server postgreSQL 15 and Moodle 3.11.11+ with latest pdf annotator plugin version 1.5.3 (2022120500.)

PDF Annotator v1.4 release 11 is running without any known issues.
We downgraded.

Error log:
2022-12-15 07:53:50: (mod_fastcgi.c.450) FastCGI-stderr:PHP message: Default exception handler: Fehler beim Lesen der Datenbank Debug: FEHLER: ung\xc3\xbcltige Eingabesyntax f\xc3\xbcr Typ
bigint: \xc2\xbbEvaluationen -Dokumentation.pdf\xc2\xab
2022-12-15 07:53:50: (mod_fastcgi.c.450) FastCGI-stderr:CONTEXT: unbenanntes Portal Parameter $1 = '...'
2022-12-15 07:53:50: (mod_fastcgi.c.450) FastCGI-stderr:SELECT 'x' FROM mdl_pdfannotator_comments WHERE id = $1 LIMIT 1
2022-12-15 07:53:50: (mod_fastcgi.c.450) FastCGI-stderr:[array (
2022-12-15 07:53:50: (mod_fastcgi.c.450) FastCGI-stderr: 0 => 'Evaluationen -Dokumentation.pdf',
2022-12-15 07:53:50: (mod_fastcgi.c.450) FastCGI-stderr:)]
2022-12-15 07:53:50: (mod_fastcgi.c.450) FastCGI-stderr:Error code: dmlreadexception
2022-12-15 07:53:50: (mod_fastcgi.c.450) FastCGI-stderr:* line 486 of /lib/dml/moodle_database.php: dml_read_exception thrown
2022-12-15 07:53:50: (mod_fastcgi.c.450) FastCGI-stderr:* line 293 of /lib/dml/moodle_read_slave_trait.php: call to moodle_database->query_end()
2022-12-15 07:53:50: (mod_fastcgi.c.450) FastCGI-stderr:* line 338 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->read_slave_query_end()
2022-12-15 07:53:50: (mod_fastcgi.c.450) FastCGI-stderr:* line 892 of /lib/dml/pgsql_native_moodle_database.php: call to pgsql_native_moodle_database->query_end()
2022-12-15 07:53:50: (mod_fastcgi.c.450) FastCGI-stderr:* line 2002 of /lib/dml/moodle_database.php: call to pgsql_native_moodle_database->get_recordset_sql()
2022-12-15 07:53:50: (mod_fastcgi.c.450) FastCGI-stderr:* line 1987 of /lib/dml/moodle_database.php: call to moodle_database->record_exists_sql()
2022-12-15 07:53:50: (mod_fastcgi.c.450) FastCGI-stderr:* line 1971 of /lib/dml/moodle_database.php: call ...

---

[nisaDoc]

Hello,
thank you for using our plugin and for reporting this issue. We will check this problem.

[leblzhaw]

Hello,
we have the same error in our system (moodle 4.0.6) with the latest version of the plugin (v.1.5.3).
With version 1.4.x we had no problems yet.

Best regards

[ghost]

We have Moodle 4.1.1 running on MS SQL 2019 and have a similar issue with v1.5 r3:

Message: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Error converting data type nvarchar to bigint.

SELECT 'x' FROM mdl_pdfannotator_comments WHERE id = N'sample.pdf' ORDER BY 1 OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY
[array (
0 => 'sample.pdf',
)]

Error code: dmlreadexception
Stack trace:
line 494 of \lib\dml\moodle_database.php: dml_read_exception thrown
line 324 of \lib\dml\sqlsrv_native_moodle_database.php: call to moodle_database->query_end()
line 431 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->query_end()
line 900 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->do_query()
line 2010 of \lib\dml\moodle_database.php: call to sqlsrv_native_moodle_database->get_recordset_sql()
line 1995 of \lib\dml\moodle_database.php: call to moodle_database->record_exists_sql()
line 1979 of \lib\dml\moodle_database.php: call to moodle_database->record_exists_select()
line 381 of \mod\pdfannotator\lib.php: call to moodle_database->record_exists()
line 5205 of \lib\filelib.php: call to pdfannotator_pluginfile()
line 46 of \pluginfile.php: call to file_pluginfile()

[mrkskwsnck]

Same error for me for Moodle v3.11.13 with Microsoft SQL Server. Downgrade to tag v1.4.11.2_Moodle3.10 went fine +1

[ghost]

The code in my PR is in use on our system.

[nisaDoc]

Hello @mikehenry1979-bah,
thx for the PR. We will check it.

[nisaDoc]

Hello,
new release is there with fix for this problem.

cheers
Nisa