REDCap External Module Hook Exception - repeat_survey_link (error message)

tertek / redcap-repeat-survey-link

Access to the next instance of a repeating instrument's survey from any other instrument/form/survey.

MIT License

1 stars 1 forks source link

REDCap External Module Hook Exception - repeat_survey_link (error message) #4

Open koskea1 opened 3 years ago

koskea1 commented 3 years ago

Hello,

Thank you so much for helping me troubleshoot. I've attached a word document that contains the error message, along with the other information you requested and screenshots. I believe I set everything up correctly, but please let me know if I missed or misinterpreted anything. I also want to confirm the functionality of this external module. When I am able to get it working correctly, I should be able to provide users with a repeating survey link that will allow users to complete a public survey multiple times, generating a new instance for that record, correct?

Thank you again for your assistance and please let me know if you need anything else from me to help troubleshoot. Also let me know if there is something that my local IT needs to do from their end to get this external module to work correctly.

Thank you, Amber

repeat survey error message.docx

tertek commented 3 years ago

Hi, Can you please also share a Screenshot of:

Project Setup View
Modify Repeatable Instruments Dialog
(if "Use longitudinal data collection with defined events" is Enabled) Define Events and Designate Instruments for My Events Dialogs

Thank you

koskea1 commented 3 years ago

Hello,

Thank you for your prompt response. Attached are two screenshots - the project setup view and modify repeatable instruments dialog. This project does not use longitudinal data collection.

Thank you again, Amber

project setup view.docx

tertek commented 3 years ago

I have tested the module on REDCap 11.1.3 and it is working as expected. Can you please also provide server error log with details?

koskea1 commented 3 years ago

Good morning and thank you for the follow-up. I appreciate you testing the module out and verifying that it is working correctly. I'm connecting with my local IT to see if I can get the server error log, but it is taking a bit of time. I'm hoping that they can either provide me with it to share with you or might be able to help figure out why it doesn't seem to be working at our institution. As far as you could tell from the configuration settings that I sent you, did I set up the external module correctly? I am pretty sure I did, but always nice to know that I didn't do something wrong on my end.

tertek commented 3 years ago

As far as you could tell from the configuration settings that I sent you, did I set up the external module correctly? Your configuration looks valid.

Regarding the database error there seems to be a problem while preparing the query before actual execution. This could be a problem with your MYSQL version or MYSQL configuration. Please ensure that DB Placeholder limit is at least 65000. Default is 65,536.