search

vanderbilt-redcap / email-alerts-module

Module to send customized emails alerts after a form/survey is completed to one or several recipients.
MIT License
2 stars 9 forks source link

Email Alert v2.3.5 crashes on RedCap 9.5.14 #24

Closed u0046038 closed 4 years ago

u0046038 commented 4 years ago

REDCap crashed due to an unexpected PHP fatal error!

Error message: Uncaught Exception: An error occurred while running an External Module query. Query execution failed (see the server error log for more details). in /www/virtualhosts/redcap.gbiomed.kuleuven.be/html/redcap_v9.5.14/ExternalModules/classes/ExternalModules.php:2156 Stack trace: #0 /www/virtualhosts/redcap.gbiomed.kuleuven.be/html/redcap_v9.5.14/ExternalModules/classes/AbstractExternalModule.php(846): ExternalModules\ExternalModules::query('SELECT DISTINCT...') #1 /www/virtualhosts/redcap.gbiomed.kuleuven.be/html/modules/email_alerts_v2.3.5/EmailTriggerExternalModule.php(1693): ExternalModules\AbstractExternalModule->query('SELECT DISTINCT...', Array) #2 /www/virtualhosts/redcap.gbiomed.kuleuven.be/html/modules/email_alerts_v2.3.5/configure.php(27): Vanderbilt\EmailTriggerExternalModule\EmailTriggerExternalModule->getAdditionalFieldChoices(Array, '430') #3 /www/virtualhosts/redcap.gbiomed.kuleuven.be/html/redcap_v9.5.14/ExternalModules/index.php(102): require_once('/www/virtualhos...') #4 {main} thrown File: /www/virtualhosts/redcap.gbiomed.kuleuven.be/html/redcap_v9.5.14/ExternalModules/classes/ExternalModules.php Line: 2156

Logs says :

[11-May-2020 17:32:58 Europe/Brussels] An error occurred while running an External Module query: { "Message": "Query execution failed", "SQL": "SELECT DISTINCT form_name\n\t\t\t\t\tFROM redcap_metadata\n\t\t\t\t\tWHERE project_id = ?\n\t\t\t\t\tORDER BY field_order", "DB Error": "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 '?\n\t\t\t\t\tORDER BY field_order' at line 3", "Code": 0, "File": "\/www\/virtualhosts\/redcap.gbiomed.kuleuven.be\/html\/redcap_v9.5.14\/ExternalModules\/classes\/ExternalModules.php", "Line": 2135, "Trace": [ { "file": "\/www\/virtualhosts\/redcap.gbiomed.kuleuven.be\/html\/redcap_v9.5.14\/ExternalModules\/classes\/AbstractExternalModule.php", "line": 846, "function": "query", "class": "ExternalModules\ExternalModules", "type": "::", "args": [ "SELECT DISTINCT form_name\n\t\t\t\t\tFROM redcap_metadata\n\t\t\t\t\tWHERE project_id = ?\n\t\t\t\t\tORDER BY field_order" ] }, ...

knil-maloon commented 4 years ago

Hi @u0046038

There was an issue where the redcap min version was incorrect in the last updates. I've removed those versions from the repo and updated the new one with the correct redcap min, version 9.7.8.

Also new Redcap LTS version will be released next month.

u0046038 commented 4 years ago

Hi Eva,

We are using your email alert module in some very important COVID-19 studies… Can we get this module working again asap in the LTS version we are working with ?

It’s so important to get this fixed…

Thank you for the fast response….

Kind Regards,

Gert Goos Head of IT Group Biomedical Sciences University KU Leuven Belgium

From: Eva Bascompte notifications@github.com Reply to: vanderbilt-redcap/email-alerts-module reply@reply.github.com Date: Tuesday, 12 May 2020 at 20:54 To: vanderbilt-redcap/email-alerts-module email-alerts-module@noreply.github.com Cc: Gert Goos gert.goos@kuleuven.be, Mention mention@noreply.github.com Subject: Re: [vanderbilt-redcap/email-alerts-module] Email Alert v2.3.5 crashes on RedCap 9.5.14 (#24)

Hi @u0046038https://github.com/u0046038

There was an issue where the redcap min version was incorrect in the last updates. I've removed those versions from the repo and updated the new one with the correct redcap min, version 9.7.8.

Also new Redcap LTS version will be released next month.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://github.com/vanderbilt-redcap/email-alerts-module/issues/24#issuecomment-627528356, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AH5PTFIPGTI6J7SJIBEFTDTRRGLNXANCNFSM4M6SU23Q. [ { "@context": "http://schema.org", "@type": "EmailMessage", "potentialAction": { "@type": "ViewAction", "target": "https://github.com/vanderbilt-redcap/email-alerts-module/issues/24#issuecomment-627528356", "url": "https://github.com/vanderbilt-redcap/email-alerts-module/issues/24#issuecomment-627528356", "name": "View Issue" }, "description": "View this Issue on GitHub", "publisher": { "@type": "Organization", "name": "GitHub", "url": "https://github.com" } } ]

knil-maloon commented 4 years ago

Hi @u0046038

You should be able to still use the module, it's just going to be an older version. We only changed some vulnerabilities and dependencies in the new ones but the functionality should be the same in older versions.

u0046038 commented 4 years ago

Hi Eva,

When we click on ‘Configue Email Alerts’ we are receiving this message :

REDCap crashed due to an unexpected PHP fatal error!

Error message: Uncaught Exception: An error occurred while running an External Module query. Query execution failed (see the server error log for more details). in /www/virtualhosts/redcap.gbiomed.kuleuven.be/html/redcap_v9.5.14/ExternalModules/classes/ExternalModules.php:2156 Stack trace: #0 /www/virtualhosts/redcap.gbiomed.kuleuven.be/html/redcap_v9.5.14/ExternalModules/classes/AbstractExternalModule.php(846): ExternalModules\ExternalModules::query('SELECT DISTINCT...') #1 /www/virtualhosts/redcap.gbiomed.kuleuven.be/html/modules/email_alerts_v2.3.5/EmailTriggerExternalModule.php(1693): ExternalModules\AbstractExternalModule->query('SELECT DISTINCT...', Array) #2 /www/virtualhosts/redcap.gbiomed.kuleuven.be/html/modules/email_alerts_v2.3.5/configure.php(27): Vanderbilt\EmailTriggerExternalModule\EmailTriggerExternalModule->getAdditionalFieldChoices(Array, '130') #3 /www/virtualhosts/redcap.gbiomed.kuleuven.be/html/redcap_v9.5.14/ExternalModules/index.php(102): require_once('/www/virtualhos...') #4 {main} thrown File:/www/virtualhosts/redcap.gbiomed.kuleuven.be/html/redcap_v9.5.14/ExternalModules/classes/ExternalModules.php Line: 2156

Kind Regards,

Gert Goos

From: Eva Bascompte notifications@github.com Reply to: vanderbilt-redcap/email-alerts-module reply@reply.github.com Date: Tuesday, 12 May 2020 at 21:47 To: vanderbilt-redcap/email-alerts-module email-alerts-module@noreply.github.com Cc: Gert Goos gert.goos@kuleuven.be, Mention mention@noreply.github.com Subject: Re: [vanderbilt-redcap/email-alerts-module] Email Alert v2.3.5 crashes on RedCap 9.5.14 (#24)

Hi @u0046038https://github.com/u0046038

You should be able to still use the module, it's just going to be an older version. We only changed some vulnerabilities and dependencies in the new ones but the functionality should be the same in older versions.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://github.com/vanderbilt-redcap/email-alerts-module/issues/24#issuecomment-627555099, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AH5PTFKTSGNEWCLA42UNW6TRRGRVLANCNFSM4M6SU23Q. [ { "@context": "http://schema.org", "@type": "EmailMessage", "potentialAction": { "@type": "ViewAction", "target": "https://github.com/vanderbilt-redcap/email-alerts-module/issues/24#issuecomment-627555099", "url": "https://github.com/vanderbilt-redcap/email-alerts-module/issues/24#issuecomment-627555099", "name": "View Issue" }, "description": "View this Issue on GitHub", "publisher": { "@type": "Organization", "name": "GitHub", "url": "https://github.com" } } ]

knil-maloon commented 4 years ago

Hi Gert,

You should first go in REDCap->Control Center->External Modules->Enable a Module + and search Email Alerts. You can change the version in there. I think version 2.3.2 or lower should be fine as that error seems still to be from the new version which is not compatible with your REDCap version.

Let me know how it goes.

Best, Eva.

u0046038 commented 4 years ago

Hi Eva,

So, many thanks !

It’s working again…

Didn’t know that i could lower the version of an module this way….

So many thanks !

Kind Regards,

Gert

From: Eva Bascompte notifications@github.com Reply to: vanderbilt-redcap/email-alerts-module reply@reply.github.com Date: Tuesday, 12 May 2020 at 22:02 To: vanderbilt-redcap/email-alerts-module email-alerts-module@noreply.github.com Cc: Gert Goos gert.goos@kuleuven.be, Mention mention@noreply.github.com Subject: Re: [vanderbilt-redcap/email-alerts-module] Email Alert v2.3.5 crashes on RedCap 9.5.14 (#24)

Hi Gert,

You should first go in REDCap->Control Center->External Modules->Enable a Module + and search Email Alerts. You can change the version in there. I think version 2.3.2 or lower should be fine as that error seems still to be from the new version which is not compatible with your REDCap version.

Let me know how it goes.

Best, Eva.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://github.com/vanderbilt-redcap/email-alerts-module/issues/24#issuecomment-627562464, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AH5PTFOVJLZPTLB7HD5ZJA3RRGTMJANCNFSM4M6SU23Q. [ { "@context": "http://schema.org", "@type": "EmailMessage", "potentialAction": { "@type": "ViewAction", "target": "https://github.com/vanderbilt-redcap/email-alerts-module/issues/24#issuecomment-627562464", "url": "https://github.com/vanderbilt-redcap/email-alerts-module/issues/24#issuecomment-627562464", "name": "View Issue" }, "description": "View this Issue on GitHub", "publisher": { "@type": "Organization", "name": "GitHub", "url": "https://github.com" } } ]

knil-maloon commented 4 years ago

Woohoo!

You can do that with any external module. Now you know how :) Glad I could help!