Foreign key refers to a non-existent annotations table.

[gigadep]

Moodle Version in use
Moodle 4.5.1

** Plugin Version **
PDF Annotator v1.5 release 7 (2024121200) (and older)

Describe the bug
When we check the foreign keys in Site Administration > Development > XMLDB Editor, we obtain the following messages:

• The foreign key annotationid on the pdfannotator_comments table refers to a non-existent annotations table.
• The foreign key annotationid on the pdfannotator_subscriptions table refers to a non-existent annotationsneu table.

To Reproduce
Steps to reproduce the behavior:

1. Go to 'Administration > Development > XMLDB Editor'
2. Click on 'check the foreign keys'
3. See error in 'Search results'

Expected behavior
No message.

Problem
The problem is due to two errors in the pdfannotator/db/install.xml file (thanks to Christian BOCQUET who found the source of the problem on the French forum)

Solution :

• Edit the pdfannotator/db/install.xml file like this:
• replace on line 55, REFTABLE="annotations" with REFTABLE="pdfannotator_annotations"
• replace on line 128, REFTABLE="annotationsneu" with REFTABLE="pdfannotator_annotations"