<div dir="ltr">Hi Rida.<div><br><div>For some reason the user_psc_rel table wasn't what I wanted it to be.</div><div>All is well now. Thank you for pointing me to this fix so quickly!</div><div><br></div><div>Best wishes,</div><div>Ioannis</div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Feb 6, 2020 at 5:11 PM Rida Abou-Haidar <<a href="mailto:rida.abou-haidar@mcin.ca">rida.abou-haidar@mcin.ca</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Check your users table.<div><br></div><div>It looks like only user with Id 2 is associated with a site. is that the user you are logging in from ?</div><div><br clear="all"><div><div dir="ltr"><div dir="ltr"><div><div dir="ltr">Rida Abou-Haidar<br>Software Developer<br>Montreal Neurological Institute<br>McGill University<br><div><a href="mailto:rida.abou-haidar@mcin.ca" target="_blank">rida.abou-haidar@mcin.ca</a></div></div></div></div></div></div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Feb 6, 2020 at 8:08 PM Ioannis Pappas <<a href="mailto:ioannis@berkeley.edu" target="_blank">ioannis@berkeley.edu</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Hi Ling and Rida.<div>Apologies for the late reply.</div><div><br></div><div>[ioannis@loris ~]$ rpm -q httpd<br>httpd-2.4.6-90.el7.centos.x86_64<br></div><div><br></div><div>Also </div><div><br></div><div>[ioannis@loris ~]$ mysql -V<br>mysql Ver 15.1 Distrib 10.3.20-MariaDB, for Linux (x86_64) using readline 5.1<br></div><div><br></div><div>I think I have loris version 21. What's the best way for me to look at the version? </div><div>These are my two tables:</div><div><br></div><div>MariaDB [loris_database]> SELECT * FROM psc;<br>+----------+----------+---------+---------+------+---------+------+--------+--------+----------+----------+-------+-----------+---------+------------+<br>| CenterID | Name | PSCArea | Address | City | StateID | ZIP | Phone1 | Phone2 | Contact1 | Contact2 | Alias | MRI_alias | Account | Study_site |<br>+----------+----------+---------+---------+------+---------+------+--------+--------+----------+----------+-------+-----------+---------+------------+<br>| 1 | MT | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | MT | MT | NULL | Y |<br>| 2 | BC | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | BR | BR | NULL | Y |<br>+----------+----------+---------+---------+------+---------+------+--------+--------+----------+----------+-------+-----------+---------+------------+<br>2 rows in set (0.028 sec)<br><br>MariaDB [loris_database]> SELECT * FROM user_psc_rel;<br>+--------+----------+<br>| UserID | CenterID |<br>+--------+----------+<br>| 2 | 1 |<br>+--------+----------+<br>1 row in set (0.000 sec)<br></div><div><br></div><div>I might have done something wrong here. The user is not associated with the center id?</div><div>Best wishes,</div><div>Ioannis</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Feb 6, 2020 at 4:49 PM Ling Ma <<a href="mailto:lingyun.ma@mcin.ca" target="_blank">lingyun.ma@mcin.ca</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Hi Ioannis,<div><br></div><div>I just guess that you are using version 21. also guess that the reason could be that you have no psc associated with the user, you need to check tables<b> psc, user_psc_rel</b> to see if the user has a psc record. </div><div><br></div><div>Best regards,</div><div>Ling Ma<br></div><div>Consultant</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Feb 6, 2020 at 7:26 PM Rida Abou-Haidar <<a href="mailto:rida.abou-haidar@mcin.ca" target="_blank">rida.abou-haidar@mcin.ca</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Hi Ioannis,<div><br></div><div>Could you tell us which version of LORIS you are currently using and your PHP and MySQL versions as well please?</div><div><br></div><div>Did you recently upgrade any of those? what might have caused a difference from last month to this month ?</div><div><br></div><div>Best,<br clear="all"><div><div dir="ltr"><div dir="ltr"><div><div dir="ltr">Rida Abou-Haidar<br>Software Developer<br>Montreal Neurological Institute<br>McGill University<br><div><a href="mailto:rida.abou-haidar@mcin.ca" target="_blank">rida.abou-haidar@mcin.ca</a></div></div></div></div></div></div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Feb 6, 2020 at 7:08 PM Ioannis Pappas <<a href="mailto:ioannis@berkeley.edu" target="_blank">ioannis@berkeley.edu</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Hi loris support.<div><br></div><div>I hope you are well. I would like to report a problem with respect to signing in to the loris front-end. Despite signing in normally a month ago, we are now getting a "blank" white page after logging in.</div><div><br>Below are the logs from /var/log/httpd/loris-error.log:<br><br>[Thu Feb 06 14:36:20.838065 2020] [php7:notice] [pid 7015] [client <a href="http://10.0.2.4:55302/" rel="noreferrer" target="_blank">10.0.2.4:55302</a>] PHP Notice: Undefined variable: isStudySite in /srv/www/loris/src/Middleware/UserPageDecorationMiddleware.php on line 130, referer: <a href="http://loris/" rel="noreferrer" target="_blank">http://loris/</a><br>[Thu Feb 06 14:36:20.838108 2020] [php7:warn] [pid 7015] [client <a href="http://10.0.2.4:55302/" rel="noreferrer" target="_blank">10.0.2.4:55302</a>] PHP Warning: in_array() expects parameter 2 to be array, null given in /srv/www/loris/src/Middleware/UserPageDecorationMiddleware.php on line 130, referer: <a href="http://loris/" rel="noreferrer" target="_blank">http://loris/</a><br>[Thu Feb 06 14:36:20.838469 2020] [php7:error] [pid 7015] [client <a href="http://10.0.2.4:55302/" rel="noreferrer" target="_blank">10.0.2.4:55302</a>] PHP Fatal error: Uncaught TypeError: explode() expects parameter 2 to be string, null given in /srv/www/loris/php/libraries/User.class.inc:272\nStack trace:\n#0 /srv/www/loris/php/libraries/User.class.inc(272): explode(';', NULL)\n#1 /srv/www/loris/modules/dashboard/php/dashboard.class.inc(40): User->getSiteNames()\n#2 /srv/www/loris/php/libraries/NDB_Form.class.inc(188): LORIS\\dashboard\\Dashboard->setup()\n#3 /srv/www/loris/src/Middleware/UserPageDecorationMiddleware.php(171): NDB_Form->handle(Object(Zend\\Diactoros\\ServerRequest))\n#4 /srv/www/loris/src/Middleware/PageDecorationMiddleware.php(49): LORIS\\Middleware\\UserPageDecorationMiddleware->process(Object(Zend\\Diactoros\\ServerRequest), Object(LORIS\\dashboard\\Dashboard))\n#5 /srv/www/loris/php/libraries/NDB_Page.class.inc(659): LORIS\\Middleware\\PageDecorationMiddleware->process(Object(Zend\\Diactoros\\ServerRequest), Object(LORIS\\dashboard\\Dashboard))\n#6 /srv/www/loris/php/libraries/Module.class.inc(341): NDB_Page->process(Object(Zend\\Diactoros\\ServerRequest), Object(LORIS\\dashboar in /srv/www/loris/php/libraries/User.class.inc on line 272, referer: <a href="http://loris/" rel="noreferrer" target="_blank">http://loris/</a><br></div><div><br></div><div>We would appreciate any help with this.</div><div><br></div><div>Best wishes,</div><div>Ioannis</div></div>
_______________________________________________<br>
Loris-dev mailing list<br>
<a href="mailto:Loris-dev@bic.mni.mcgill.ca" target="_blank">Loris-dev@bic.mni.mcgill.ca</a><br>
<a href="https://mailman.bic.mni.mcgill.ca/mailman/listinfo/loris-dev" rel="noreferrer" target="_blank">https://mailman.bic.mni.mcgill.ca/mailman/listinfo/loris-dev</a><br>
</blockquote></div>
_______________________________________________<br>
Loris-dev mailing list<br>
<a href="mailto:Loris-dev@bic.mni.mcgill.ca" target="_blank">Loris-dev@bic.mni.mcgill.ca</a><br>
<a href="https://mailman.bic.mni.mcgill.ca/mailman/listinfo/loris-dev" rel="noreferrer" target="_blank">https://mailman.bic.mni.mcgill.ca/mailman/listinfo/loris-dev</a><br>
</blockquote></div>
</blockquote></div>
</blockquote></div>
</blockquote></div>