[dashboard] 500 error coming from mri_violations widget #8697
Description
Describe the bug
Got this bug after running make testdata and checking that all instances of PhaseEncodingDirection in https://github.com/aces/Loris/blob/25.0-release/SQL/0000-00-00-schema.sql are in my DB
[Thu May 11 10:26:08.587630 2023] [php:notice] [pid 1399] [client 192.168.122.1:33918] [ERROR] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'PhaseEncodingDirection' in 'field list'#0 /var/www/loris/src/Data/Provisioners/DBRowProvisioner.php(87): PDOStatement->execute()\n#1 /var/www/loris/src/Data/ProvisionerInstance.php(115): LORIS\\Data\\Provisioners\\DBRowProvisioner->getAllInstances()\n#2 /var/www/loris/src/Data/Table.php(67): LORIS\\Data\\ProvisionerInstance->execute()\n#3 /var/www/loris/src/Data/Table.php(80): LORIS\\Data\\Table->getRows()\n#4 /var/www/loris/modules/mri_violations/php/module.class.inc(98): LORIS\\Data\\Table->toArray()\n#5 /var/www/loris/modules/dashboard/php/module.class.inc(147): LORIS\\mri_violations\\Module->getWidgets()\n#6 /var/www/loris/modules/dashboard/php/module.class.inc(58): LORIS\\dashboard\\Module->_getTasksWidget()\n#7 /var/www/loris/modules/dashboard/php/dashboard.class.inc(88): LORIS\\dashboard\\Module->getWidgets()\n#8 /var/www/loris/php/libraries/Module.class.inc(222): LORIS\\dashboard\\Dashboard->__construct()\n#9 /var/www/loris/php/libraries/Module.class.inc(300): Module->loadPage()\n#10 /var/www/loris/src/Middleware/ResponseGenerator.php(50): Module->handle()\n#11 /var/www/loris/src/Middleware/AuthMiddleware.php(63): LORIS\\Middleware\\ResponseGenerator->process()\n#12 /var/www/loris/src/Router/ModuleRouter.php(74): LORIS\\Middleware\\AuthMiddleware->process()\n#13 /var/www/loris/src/Middleware/ExceptionHandlingMiddleware.php(54): LORIS\\Router\\ModuleRouter->handle()\n#14 /var/www/loris/src/Router/BaseRouter.php(132): LORIS\\Middleware\\ExceptionHandlingMiddleware->process()\n#15 /var/www/loris/src/Middleware/ResponseGenerator.php(50): LORIS\\Router\\BaseRouter->handle()\n#16 /var/www/loris/src/Middleware/ContentLength.php(52): LORIS\\Middleware\\ResponseGenerator->process()\n#17 /var/www/loris/htdocs/index.php(55): LORIS\\Middleware\\ContentLength->process()\n#18 {main}, referer: https://zrosli-test-25.loris.ca/
To Reproduce
Steps to reproduce the behavior (attach screenshots if applicable):
- Go to '...'
- Click on '....'
- Scroll down to '....'
- See error
What did you expect to happen?
A clear and concise description of what you expected to happen.
Browser Environment (please complete the following information):
- OS: [e.g. Plan9, HURD, Oberon, etc]
- Browser [e.g. chrome, firefox] (note that only these two browsers are supported)
- Version [e.g. 22]
Server Environment (if known):
Note: We only support the most recent release of LORIS.
- LORIS Version: [e.g. 22.0.0]
- Linux distribution and Version: [e.g. Ubuntu 16.04, CentOS 7]
- MySQL/MariaDB Version: [e.g. MySQL 5.7, MariaDB 10.3]
Additional context
Add any other context about the problem here.