<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">
Dear Loris DevTeam,
<div class=""><br class="">
</div>
<div class="">I am upgrading LORIS to the last version 23.0.0. While executing the SQL patch I got the following output with errors (see below). I have followed all the upgrading steps. Any ideas on what can be missing?</div>
<div class=""><br class="">
</div>
<div class="">Regards,</div>
<div class="">Alfredo.</div>
<div class=""><br class="">
</div>
<div class="">===</div>
<div class="">
<div class="">mysql> source /home/bic/moralf/22.0_To_23.0_upgrade.sql </div>
<div class="">+------------------------------------------------------------------------------------+</div>
<div class="">| Running: SQL/New_patches/2018-05-18-adding_physiological_all_sites_permissions.sql |</div>
<div class="">+------------------------------------------------------------------------------------+</div>
<div class="">| Running: SQL/New_patches/2018-05-18-adding_physiological_all_sites_permissions.sql |</div>
<div class="">+------------------------------------------------------------------------------------+</div>
<div class="">1 row in set (0.01 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.03 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class=""><font color="#ff0000" class="">ERROR 1048 (23000): Column 'userID' cannot be null</font></div>
<div class=""><font color="#ff0000" class="">ERROR 1048 (23000): Column 'userID' cannot be null</font></div>
<div class="">+---------------------------------------------------------------------+</div>
<div class="">| Running: SQL/New_patches/2018-07-23-battery_manager_permissions.sql |</div>
<div class="">+---------------------------------------------------------------------+</div>
<div class="">| Running: SQL/New_patches/2018-07-23-battery_manager_permissions.sql |</div>
<div class="">+---------------------------------------------------------------------+</div>
<div class="">1 row in set (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.01 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 0 rows affected (0.00 sec)</div>
<div class="">Records: 0 Duplicates: 0 Warnings: 0</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 0 rows affected (0.00 sec)</div>
<div class="">Records: 0 Duplicates: 0 Warnings: 0</div>
<div class=""><br class="">
</div>
<div class=""><font color="#ff0000" class="">ERROR 1146 (42S02): Table 'IPMSA_LORIS.modules' doesn't exist</font></div>
<div class="">+----------------------------------------------------------------+</div>
<div class="">| Running: SQL/New_patches/2019-02-08-multiple_mri_protocols.sql |</div>
<div class="">+----------------------------------------------------------------+</div>
<div class="">| Running: SQL/New_patches/2019-02-08-multiple_mri_protocols.sql |</div>
<div class="">+----------------------------------------------------------------+</div>
<div class="">1 row in set (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 0 rows affected (0.02 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 0 rows affected (0.02 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.01 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 0 rows affected (0.02 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 0 rows affected (0.03 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 0 rows affected (0.08 sec)</div>
<div class="">Records: 0 Duplicates: 0 Warnings: 0</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 9 rows affected (0.01 sec)</div>
<div class="">Rows matched: 9 Changed: 9 Warnings: 0</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 9 rows affected (0.09 sec)</div>
<div class="">Records: 9 Duplicates: 0 Warnings: 0</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 0 rows affected (0.05 sec)</div>
<div class="">Records: 0 Duplicates: 0 Warnings: 0</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 0 rows affected (0.00 sec)</div>
<div class="">Rows matched: 0 Changed: 0 Warnings: 0</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 0 rows affected (0.05 sec)</div>
<div class="">Records: 0 Duplicates: 0 Warnings: 0</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 0 rows affected (0.04 sec)</div>
<div class="">Records: 0 Duplicates: 0 Warnings: 0</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 0 rows affected (0.00 sec)</div>
<div class="">Rows matched: 0 Changed: 0 Warnings: 0</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 0 rows affected (0.07 sec)</div>
<div class="">Records: 0 Duplicates: 0 Warnings: 0</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 0 rows affected (0.06 sec)</div>
<div class="">Records: 0 Duplicates: 0 Warnings: 0</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 0 rows affected (0.00 sec)</div>
<div class="">Rows matched: 0 Changed: 0 Warnings: 0</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 0 rows affected (0.07 sec)</div>
<div class="">Records: 0 Duplicates: 0 Warnings: 0</div>
<div class=""><br class="">
</div>
<div class="">+------------------------------------------------------------------+</div>
<div class="">| Running: SQL/New_patches/2019-07-02-Add_Edit_DoB_Permissions.sql |</div>
<div class="">+------------------------------------------------------------------+</div>
<div class="">| Running: SQL/New_patches/2019-07-02-Add_Edit_DoB_Permissions.sql |</div>
<div class="">+------------------------------------------------------------------+</div>
<div class="">1 row in set (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.01 sec)</div>
<div class=""><br class="">
</div>
<div class="">+---------------------------------------------------------+</div>
<div class="">| Running: SQL/New_patches/2019-07-04-add_DoD_feature.sql |</div>
<div class="">+---------------------------------------------------------+</div>
<div class="">| Running: SQL/New_patches/2019-07-04-add_DoD_feature.sql |</div>
<div class="">+---------------------------------------------------------+</div>
<div class="">1 row in set (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 0 rows affected (0.77 sec)</div>
<div class="">Records: 0 Duplicates: 0 Warnings: 0</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.01 sec)</div>
<div class="">Records: 1 Duplicates: 0 Warnings: 0</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class="">Records: 1 Duplicates: 0 Warnings: 0</div>
<div class=""><br class="">
</div>
<div class="">+--------------------------------------------------------------+</div>
<div class="">| Running: SQL/New_patches/2019-07-05-Add_Language_feature.sql |</div>
<div class="">+--------------------------------------------------------------+</div>
<div class="">| Running: SQL/New_patches/2019-07-05-Add_Language_feature.sql |</div>
<div class="">+--------------------------------------------------------------+</div>
<div class="">1 row in set (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 126974 rows affected (4.18 sec)</div>
<div class="">Records: 126974 Duplicates: 0 Warnings: 0</div>
<div class=""><br class="">
</div>
<div class="">+--------------------------------------------------------------------------------+</div>
<div class="">| Running: SQL/New_patches/2019-08-06-Add_date_display_format_config_setting.sql |</div>
<div class="">+--------------------------------------------------------------------------------+</div>
<div class="">| Running: SQL/New_patches/2019-08-06-Add_date_display_format_config_setting.sql |</div>
<div class="">+--------------------------------------------------------------------------------+</div>
<div class="">1 row in set (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class="">Records: 1 Duplicates: 0 Warnings: 0</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.01 sec)</div>
<div class="">Records: 1 Duplicates: 0 Warnings: 0</div>
<div class=""><br class="">
</div>
<div class="">+-------------------------------------------------------------------------------------------+</div>
<div class="">| Running: SQL/New_patches/2019-10-09-move_MINCToolsPath_configuration_to_Config_tables.sql |</div>
<div class="">+-------------------------------------------------------------------------------------------+</div>
<div class="">| Running: SQL/New_patches/2019-10-09-move_MINCToolsPath_configuration_to_Config_tables.sql |</div>
<div class="">+-------------------------------------------------------------------------------------------+</div>
<div class="">1 row in set (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class="">Records: 1 Duplicates: 0 Warnings: 0</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class="">Records: 1 Duplicates: 0 Warnings: 0</div>
<div class=""><br class="">
</div>
<div class="">+-------------------------------------------------------------------------+</div>
<div class="">| Running: SQL/New_patches/2019-10-29-adding_issues_attachments_table.sql |</div>
<div class="">+-------------------------------------------------------------------------+</div>
<div class="">| Running: SQL/New_patches/2019-10-29-adding_issues_attachments_table.sql |</div>
<div class="">+-------------------------------------------------------------------------+</div>
<div class="">1 row in set (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 0 rows affected (0.03 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.01 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class="">Records: 1 Duplicates: 0 Warnings: 0</div>
<div class=""><br class="">
</div>
<div class="">+---------------------------------------------------------+</div>
<div class="">| Running: SQL/New_patches/2019-11-26-AddOtherSexEnum.sql |</div>
<div class="">+---------------------------------------------------------+</div>
<div class="">| Running: SQL/New_patches/2019-11-26-AddOtherSexEnum.sql |</div>
<div class="">+---------------------------------------------------------+</div>
<div class="">1 row in set (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 0 rows affected (0.00 sec)</div>
<div class="">Records: 0 Duplicates: 0 Warnings: 0</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 0 rows affected (0.01 sec)</div>
<div class="">Records: 0 Duplicates: 0 Warnings: 0</div>
<div class=""><br class="">
</div>
<div class="">+----------------------------------------------------------------------------+</div>
<div class="">| Running: SQL/New_patches/2019-11-29-Add_upload_directory_configuration.sql |</div>
<div class="">+----------------------------------------------------------------------------+</div>
<div class="">| Running: SQL/New_patches/2019-11-29-Add_upload_directory_configuration.sql |</div>
<div class="">+----------------------------------------------------------------------------+</div>
<div class="">1 row in set (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.01 sec)</div>
<div class="">Records: 1 Duplicates: 0 Warnings: 0</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class="">Records: 1 Duplicates: 0 Warnings: 0</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class="">Records: 1 Duplicates: 0 Warnings: 0</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.01 sec)</div>
<div class="">Records: 1 Duplicates: 0 Warnings: 0</div>
<div class=""><br class="">
</div>
<div class="">+--------------------------------------------------------+</div>
<div class="">| Running: SQL/New_patches/2019-12-05-AddModuleTable.sql |</div>
<div class="">+--------------------------------------------------------+</div>
<div class="">| Running: SQL/New_patches/2019-12-05-AddModuleTable.sql |</div>
<div class="">+--------------------------------------------------------+</div>
<div class="">1 row in set (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 0 rows affected (0.02 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.01 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.01 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.01 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.01 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.01 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.01 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.01 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.01 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.01 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">+-------------------------------------------------------+</div>
<div class="">| Running: SQL/New_patches/2020-01-16-ModuleManager.sql |</div>
<div class="">+-------------------------------------------------------+</div>
<div class="">| Running: SQL/New_patches/2020-01-16-ModuleManager.sql |</div>
<div class="">+-------------------------------------------------------+</div>
<div class="">1 row in set (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class=""><font color="#ff0000" class="">ERROR 1048 (23000): Column 'userID' cannot be null</font></div>
<div class=""><font color="#ff0000" class="">ERROR 1048 (23000): Column 'userID' cannot be null</font></div>
<div class="">+-------------------------------------------------------------------------------------------+</div>
<div class="">| Running: SQL/New_patches/2020-01-20-adding_electrophysiology_browser_to_modules_table.sql |</div>
<div class="">+-------------------------------------------------------------------------------------------+</div>
<div class="">| Running: SQL/New_patches/2020-01-20-adding_electrophysiology_browser_to_modules_table.sql |</div>
<div class="">+-------------------------------------------------------------------------------------------+</div>
<div class="">1 row in set (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">+------------------------------------------------------+</div>
<div class="">| Running: SQL/New_patches/2020-02-18-MyPrefModule.sql |</div>
<div class="">+------------------------------------------------------+</div>
<div class="">| Running: SQL/New_patches/2020-02-18-MyPrefModule.sql |</div>
<div class="">+------------------------------------------------------+</div>
<div class="">1 row in set (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">+----------------------------------------------------------------+</div>
<div class="">| Running: SQL/New_patches/2020-02-24-CandidateProfileModule.sql |</div>
<div class="">+----------------------------------------------------------------+</div>
<div class="">| Running: SQL/New_patches/2020-02-24-CandidateProfileModule.sql |</div>
<div class="">+----------------------------------------------------------------+</div>
<div class="">1 row in set (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">+----------------------------------------------------------------------+</div>
<div class="">| Running: SQL/New_patches/2020-04-20-Rename_highlander_permission.sql |</div>
<div class="">+----------------------------------------------------------------------+</div>
<div class="">| Running: SQL/New_patches/2020-04-20-Rename_highlander_permission.sql |</div>
<div class="">+----------------------------------------------------------------------+</div>
<div class="">1 row in set (0.01 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class="">Rows matched: 1 Changed: 1 Warnings: 0</div>
<div class=""><br class="">
</div>
<div class="">+---------------------------------------------------------------------------+</div>
<div class="">| Running: SQL/New_patches/2020-04-27-AddViolatedScansOwnSitePermission.sql |</div>
<div class="">+---------------------------------------------------------------------------+</div>
<div class="">| Running: SQL/New_patches/2020-04-27-AddViolatedScansOwnSitePermission.sql |</div>
<div class="">+---------------------------------------------------------------------------+</div>
<div class="">1 row in set (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 1 row affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">ERROR 1048 (23000): Column 'userID' cannot be null</div>
<div class="">+------------------------------------------------------------------------------+</div>
<div class="">| Running: SQL/New_patches/2020-05-08-ChangeDefaultMPCGForMriViolationsLog.sql |</div>
<div class="">+------------------------------------------------------------------------------+</div>
<div class="">| Running: SQL/New_patches/2020-05-08-ChangeDefaultMPCGForMriViolationsLog.sql |</div>
<div class="">+------------------------------------------------------------------------------+</div>
<div class="">1 row in set (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 0 rows affected (0.06 sec)</div>
<div class="">Records: 0 Duplicates: 0 Warnings: 0</div>
<div class=""><br class="">
</div>
<div class="">+---------------------------------------------------------------+</div>
<div class="">| Running: SQL/New_patches/2020-05-11-AddViolationsResolved.sql |</div>
<div class="">+---------------------------------------------------------------+</div>
<div class="">| Running: SQL/New_patches/2020-05-11-AddViolationsResolved.sql |</div>
<div class="">+---------------------------------------------------------------+</div>
<div class="">1 row in set (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 0 rows affected (0.00 sec)</div>
<div class="">Records: 0 Duplicates: 0 Warnings: 0</div>
<div class=""><br class="">
</div>
<div class="">+------------------------------------------------------------------------+</div>
<div class="">| Running: SQL/New_patches/2020-05-15-RemoveObsoleteMriViolationsLog.sql |</div>
<div class="">+------------------------------------------------------------------------+</div>
<div class="">| Running: SQL/New_patches/2020-05-15-RemoveObsoleteMriViolationsLog.sql |</div>
<div class="">+------------------------------------------------------------------------+</div>
<div class="">1 row in set (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 0 rows affected (0.00 sec)</div>
<div class=""><br class="">
</div>
<div class="">Query OK, 0 rows affected (2.04 sec)</div>
<div class="">Rows matched: 0 Changed: 0 Warnings: 0</div>
<div class=""><br class="">
</div>
<div class="">mysql> notee</div>
</div>
<div class=""><br class="">
</div>
<div 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>