<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">
Hi Dave,
<div class=""><br class="">
</div>
<div class="">What is your suggestion to fix this?</div>
<div class=""><br class="">
</div>
<div class="">Best,</div>
<div class="">Alfredo.</div>
<div class="">
<div><br class="">
<blockquote type="cite" class="">
<div class="">On Feb 8, 2021, at 1:24 PM, Dave MacFarlane <<a href="mailto:dave.macfarlane@mcin.ca" class="">dave.macfarlane@mcin.ca</a>> wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<p style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class="">
<span style="padding: 3px 10px; border-top-left-radius: 5px; border-top-right-radius: 5px; border-bottom-right-radius: 5px; border-bottom-left-radius: 5px; color: rgb(255, 255, 255); font-weight: bold; display: inline-block; background-color: rgb(255, 0, 0);" class=""> External
Email - Use Caution </span></p>
<div style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class="">
<br class="webkit-block-placeholder">
</div>
<div dir="ltr" style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class="">
<div class="">I don't think the Real_name field should be null. It's used for the name to display in the menu at the top of LORIS.</div>
<div class=""><br class="">
</div>
<div class="">(In my local database the column is non-nullable, but it seems that the default schema allows null.. I think the fact that it allowed you to insert a null value is a minor bug.)<br class="">
</div>
<div class=""><br class="">
</div>
<div class="">- Dave<br class="">
</div>
<br class="">
</div>
<br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class="">
<div class="gmail_quote" style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;">
<div dir="ltr" class="gmail_attr">On Mon, Feb 8, 2021 at 1:07 PM Morales Pinzon, Alfredo <<a href="mailto:AMORALESPINZON@bwh.harvard.edu" class="">AMORALESPINZON@bwh.harvard.edu</a>> wrote:<br class="">
</div>
<blockquote class="gmail_quote" style="margin: 0px 0px 0px 0.8ex; border-left-width: 1px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding-left: 1ex;">
<div style="overflow-wrap: break-word;" class="">Dear LorisDev,
<div class=""><br class="">
</div>
<div class="">I am getting a 500 error after login into LORIS. This is what I can see in the logs:</div>
<div class=""><br class="">
</div>
<div class="">===</div>
<div class="">
<div style="margin: 0px; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo;" class="">
<span style="font-variant-ligatures: no-common-ligatures;" class="">[Mon Feb 08 12:57:54.559522 2021] [php7:error] [pid 8074] [client<span class="Apple-converted-space"> </span><a href="http://secure-web.cisco.com/1yyORuoeO9JxDA-IdiJYnWoKpPeOCoB_GC-bwmu-kKM0hweK4CWSEriGGX17eQ8Qq5nz4PPRg7R3MYEuJEIQ1HN01bBB6ZtcT0PcZpjpgMCm4yw-keQSOTQm7UYnGOOiDWbOzKlVrF4X1CyvYs3dwvgl8ZTqBBqwom6DVPTxrFrCBiDQPFG2wVI5CQ6-FmFg4RgFYYtKQ6MJC-ebrPkpxHNlL2iNIIYgeMOgR7dg_StpUuwxXqWRY8EKN93dnaKG3gFAwBzlBJ9eeQX2RGLbHUA/http%3A%2F%2F216.15.126.108%3A61071" target="_blank" class="">216.15.126.108:61071</a>]
PHP Fatal error: Uncaught TypeError: Return value of User::getFullname() must be of the type string, null returned in /var/www/loris/php/libraries/User.class.inc:236\nStack trace:\n#0 /var/www/loris/modules/dashboard/php/module.class.inc(118): User->getFullname()\n#1
/var/www/loris/modules/dashboard/php/module.class.inc(57): LORIS\\dashboard\\Module->_getWelcomeWidget(Object(Database), Object(NDB_Config), Object(User))\n#2 /var/www/loris/modules/dashboard/php/dashboard.class.inc(75): LORIS\\dashboard\\Module->getWidgets('dashboard',
Object(User), Array)\n#3 /var/www/loris/php/libraries/Module.class.inc(275): LORIS\\dashboard\\Dashboard->__construct(Object(LORIS\\dashboard\\Module), 'dashboard', '', '', 'dashboard')\n#4 /var/www/loris/php/libraries/Module.class.inc(342): Module->loadPage('dashboard')\n#5
/var/www/loris/src/Middleware/ResponseGenerator.php(50): Module->handle(Object(Laminas\\Diactoros\\ServerRequest))\n#6 /var/www/loris/src/Middleware/AuthMiddleware.php(63): LORIS\\Middleware\\ResponseGenerator->process(Object(Laminas\\Diactoros\\Se in /var/www/loris/php/libraries/User.class.inc
on line 236</span></div>
</div>
<div class="">===</div>
<div class=""><br class="">
</div>
<div class="">Perhaps it is an issue with the name of the user? I created hundreds of users for batch insertion of candidates and visits for previous versions of LORIS that required insertion of Candidates and Visits by users belonging to a given center. </div>
<div class=""><br class="">
</div>
<div class="">This is an entry in the users table without the hashed password:</div>
<div class=""><br class="">
</div>
<div class="">===</div>
<div class="">
<div style="margin: 0px; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo;" class="">
<span style="font-variant-ligatures: no-common-ligatures;" class="">*************************** 850. row ***************************</span></div>
<div style="margin: 0px; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo;" class="">
<span style="font-variant-ligatures: no-common-ligatures;" class=""> ID: 850</span></div>
<div style="margin: 0px; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo;" class="">
<span style="font-variant-ligatures: no-common-ligatures;" class=""> UserID: 723-DKC-1_dataman</span></div>
<div style="margin: 0px; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo;" class="">
<span style="font-variant-ligatures: no-common-ligatures;" class=""> Password: NULL</span></div>
<div style="margin: 0px; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo;" class="">
<span style="font-variant-ligatures: no-common-ligatures;" class=""> Real_name: NULL</span></div>
<div style="margin: 0px; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo;" class="">
<span style="font-variant-ligatures: no-common-ligatures;" class=""> First_name: NULL</span></div>
<div style="margin: 0px; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo;" class="">
<span style="font-variant-ligatures: no-common-ligatures;" class=""> Last_name: NULL</span></div>
<div style="margin: 0px; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo;" class="">
<span style="font-variant-ligatures: no-common-ligatures;" class=""> Degree: NULL</span></div>
<div style="margin: 0px; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo;" class="">
<span style="font-variant-ligatures: no-common-ligatures;" class=""> Position_title: NULL</span></div>
<div style="margin: 0px; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo;" class="">
<span style="font-variant-ligatures: no-common-ligatures;" class=""> Institution: NULL</span></div>
<div style="margin: 0px; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo;" class="">
<span style="font-variant-ligatures: no-common-ligatures;" class=""> Department: NULL</span></div>
<div style="margin: 0px; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo;" class="">
<span style="font-variant-ligatures: no-common-ligatures;" class=""> Address: NULL</span></div>
<div style="margin: 0px; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo;" class="">
<span style="font-variant-ligatures: no-common-ligatures;" class=""> City: NULL</span></div>
<div style="margin: 0px; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo;" class="">
<span style="font-variant-ligatures: no-common-ligatures;" class=""> State: NULL</span></div>
<div style="margin: 0px; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo;" class="">
<span style="font-variant-ligatures: no-common-ligatures;" class=""> Zip_code: NULL</span></div>
<div style="margin: 0px; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo;" class="">
<span style="font-variant-ligatures: no-common-ligatures;" class=""> Country: NULL</span></div>
<div style="margin: 0px; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo;" class="">
<span style="font-variant-ligatures: no-common-ligatures;" class=""> Phone: NULL</span></div>
<div style="margin: 0px; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo;" class="">
<span style="font-variant-ligatures: no-common-ligatures;" class=""> Fax: NULL</span></div>
<div style="margin: 0px; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo;" class="">
<span style="font-variant-ligatures: no-common-ligatures;" class=""> <span class="Apple-converted-space"> </span><a href="mailto:723-DKC-1_dataman@ipmsa.com" target="_blank" class="">Email: 723-DKC-1_dataman@ipmsa.com</a></span></div>
<div style="margin: 0px; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo;" class="">
<span style="font-variant-ligatures: no-common-ligatures;" class=""> Privilege: 0</span></div>
<div style="margin: 0px; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo;" class="">
<span style="font-variant-ligatures: no-common-ligatures;" class=""> PSCPI: N</span></div>
<div style="margin: 0px; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo;" class="">
<span style="font-variant-ligatures: no-common-ligatures;" class=""> DBAccess: </span></div>
<div style="margin: 0px; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo;" class="">
<span style="font-variant-ligatures: no-common-ligatures;" class=""> Active: Y</span></div>
<div style="margin: 0px; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo;" class="">
<span style="font-variant-ligatures: no-common-ligatures;" class=""> Password_hash: /REMOVED/</span></div>
<div style="margin: 0px; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo;" class="">
<span style="font-variant-ligatures: no-common-ligatures;" class=""> Password_expiry: 2035-01-01</span></div>
<div style="margin: 0px; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo;" class="">
<span style="font-variant-ligatures: no-common-ligatures;" class=""> Pending_approval: N</span></div>
<div style="margin: 0px; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo;" class="">
<span style="font-variant-ligatures: no-common-ligatures;" class="">Doc_Repo_Notifications: N</span></div>
<div style="margin: 0px; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo;" class="">
<span style="font-variant-ligatures: no-common-ligatures;" class=""> language_preference: NULL</span></div>
<div style="margin: 0px; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo;" class="">
<span style="font-variant-ligatures: no-common-ligatures;" class=""> active_from: NULL</span></div>
<div style="margin: 0px; font-stretch: normal; font-size: 11px; line-height: normal; font-family: Menlo;" class="">
<span style="font-variant-ligatures: no-common-ligatures;" class=""> active_to: NULL</span></div>
</div>
<div class="">===</div>
<div class=""><br class="">
</div>
<div class="">Best,</div>
<div class="">Alfredo.</div>
<div class="">The information in this e-mail is intended only for the person to whom it is addressed. If you believe this e-mail was sent to you in error and the e-mail contains patient information, please contact the Mass General Brigham Compliance HelpLine
at<span class="Apple-converted-space"> </span><a href="http://secure-web.cisco.com/1mpsSvwo8y-cQVgPzryfWrMGrwgyJRuBZ21l3OpfPidIIOGkJJP5M-dA79KxrAs8inL2wDNKKwu_7FhZUrX1B9jZN_ESfEAND5f7ouFz36SxeVJtmLYqIy1_s5VhkkRuoHuptM3Uh1sF78u_V56JHmBd_-oG0pUY46rhlI4D5gs24UyDJj-bZy2iQgX7qpfPI2maK5TTtXgqHCQvlSfhPSJVo58wWwaeXZEJ7P8BJ4biZGLOYTiIwB5eSN4T8a77Dg2hjPsDH4rvouJJAf5F3Jg/http%3A%2F%2Fwww.massgeneralbrigham.org%2Fcomplianceline" target="_blank" class="">http://www.massgeneralbrigham.org/complianceline</a><span class="Apple-converted-space"> </span>.
If the e-mail was sent to you in error but does not contain patient information, please contact the sender and properly dispose of the e-mail.</div>
</div>
_______________________________________________<br class="">
Loris-dev mailing list<br class="">
<a href="mailto:Loris-dev@bic.mni.mcgill.ca" target="_blank" class="">Loris-dev@bic.mni.mcgill.ca</a><br class="">
<a href="https://secure-web.cisco.com/1YVFggw7EgDexlyx8pzmXliYExDI_SUGOOLhxJeHrfWOj50RAafEI5uGOBNyI4CRn6B4sl6vqQyDz_mgNWYCDYnu7_rYAr4EnOj5g3g6Mf5KG8H4DWL7T9BvF-_0IGFgWZzXI3mjSKHk4ri4vhgIO19lTq1AABOiJMRT7HnHR33sn1YMzq9tVjrXyWr6Vw50EHfrHJr8TIMegfBktpLydEls9DCJ25ZiMU7sZJSnI0U-l7LBWJh2cKMHDKIfcbAg32FpB12zUC9HPZ1jO0GtneA/https%3A%2F%2Fmailman.bic.mni.mcgill.ca%2Fmailman%2Flistinfo%2Floris-dev" rel="noreferrer" target="_blank" class="">https://mailman.bic.mni.mcgill.ca/mailman/listinfo/loris-dev</a></blockquote>
</div>
</div>
</blockquote>
</div>
<br class="">
</div>
<div>The information in this e-mail is intended only for the person to whom it is addressed. If you believe this e-mail was sent to you in error and the e-mail contains patient information, please contact the Mass General Brigham Compliance HelpLine at http://www.massgeneralbrigham.org/complianceline . If the e-mail was sent to you in error but does not contain patient information, please contact the sender and properly dispose of the e-mail.</div></body>
</html>