SQL Message after placing backup

[Violanzzj]

Dear all,

just placed a SQL backup of our original DB. While doing this I've received no error message, and also while checking the tables I can see data! So all of this seems to very good signs.

Though when I go to the webpage I receive a big error message see below. It seems customfields are causing some issues.

What can I do to do fix this?

best regards,
Rolf




Argument 1 passed to columns_remove_invalid() must be of the type array, null given, called in C:\inetpub\wwwroot\Mantis\core\custom_function_api.php on line 315 C:\inetpub\wwwroot\Mantis\core\custom_function_api.php: 315: - - - - columns_remove_invalid( NULL, { [0] => 'id', [1] => 'project_id', [2] => 'reporter_id', [3] => 'handler_id', [4] => 'priority', [5] => 'severity', [6] => 'reproducibility', [7] => 'status', [8] => 'resolution', [9] => 'category_id', [10] => 'date_submitted', [11] => 'last_updated', [12] => 'os', [13] => 'os_build', [14] => 'platform', [15] => 'version', [16] => 'fixed_in_version', [17] => 'target_version', [18] => 'view_state', [19] => 'summary', [20] => 'due_date', [21] => 'description', [22] => 'steps_to_reproduce', [23] => 'additional_information', [24] => 'attachment_count', [25] => 'bugnotes_count', [26] => 'selection', [27] => 'edit', [28] => 'notes', [29] => 'tags', [30] => 'overdue', [31] => 'custom_0- WA available', [32] => 'custom_00- Issue impact on', [33] => 'custom_01 - MVII Internal ServiceNow ID', [34] => 'custom_1- TestLink/case ID', [35] => 'custom_2- Supplier', [36] => 'custom_3- Software version detected', [37] => 'custom_4- Defect ID supplier', [38] => 'custom_5- Planned version resolved', [39] => 'custom_6- Version resolved', [40] => 'custom_8 Effect', [41] => 'custom_A- Issue Meeting Action Holder', [42] => 'custom_B- Issue Meeting Status', [43] => 'custom_C- Issue Meeting Due Date', [44] => 'custom_Due date monitoring', [45] => 'custom_M- Triage date', [46] => 'custom_N1- Argo status', [47] => 'custom_N2- Argo status description', [48] => 'custom_Triage issue', [49] => 'custom_Vesselname' } ) C:\inetpub\wwwroot\Mantis\core\helper_api.php: 471: - - - - custom_function_default_get_columns_to_view( 1, NULL ) C:\inetpub\wwwroot\Mantis\core\helper_api.php: 506: - - - - helper_call_custom_function( 'get_columns_to_view', { [0] => 1, [1] => NULL } ) C:\inetpub\wwwroot\Mantis\core\filter_api.php: 2299: - - - - helper_get_columns_to_view( 1 ) C:\inetpub\wwwroot\Mantis\core\classes\BugFilterQuery.class.php: 1699: - - - - filter_get_visible_sort_properties_array( { ['_version'] => 'v9', ['_view_type'] => 'simple', ['category_id'] => { [0] => '0' }, ['severity'] => { [0] => 0 }, ['status'] => { [0] => 0 }, ['highlight_changed'] => 6, ['reporter_id'] => { [0] => 0 }, ['handler_id'] => { [0] => 0 }, ['project_id'] => { [0] => -3 }, ['resolution'] => { [0] => 0 }, ['build'] => { [0] => '0' }, ['version'] => { [0] => '0' }, ['hide_status'] => { [0] => 90 }, ['monitor_user_id'] => { [0] => 0 }, ['sort'] => 'last_updated', ['dir'] => 'DESC', ['per_page'] => 50, ['match_type'] => 0, ['platform'] => { [0] => '0' }, ['os'] => { [0] => '0' }, ['os_build'] => { [0] => '0' }, ['fixed_in_version'] => { [0] => '0' }, ['target_version'] => { [0] => '0' }, ['profile_id'] => { [0] => 0 }, ['priority'] => { [0] => 0 }, ['note_user_id'] => { [0] => 0 }, ['sticky'] => true, ['filter_by_date'] => false, ['start_month'] => '11', ['end_month'] => '11', ['start_day'] => 1, ['end_day'] => '10', ['start_year'] => '2020', ['end_year'] => '2020', ['filter_by_last_updated_date'] => false, ['last_updated_start_month'] => '11', ['last_updated_end_month'] => '11', ['last_updated_start_day'] => 1, ['last_updated_end_day'] => '10', ['last_updated_start_year'] => '2020', ['last_updated_end_year'] => '2020', ['search'] => '', ['view_state'] => 0, ['tag_string'] => '', ['tag_select'] => 0, ['relationship_type'] => -1, ['relationship_bug'] => 0, ['custom_fields'] => { [1] => { [0] => '0' }, [2] => { [0] => '0' }, [3] => { [0] => '0' }, [5] => { [0] => '0' }, [7] => { [0] => '0' }, [8] => { [0] => '0' }, [9] => { [0] => '0' }, [10] => { [0] => '0' }, [11] => { [0] => '0' }, [12] => { [0] => '0' }, [13] => { [0] => '0' }, [14] => { [0] => '0' }, [15] => { [0] => '0' }, [16] => { [0] => '0' }, [17] => { [0] => '0' }, [20] => { [0] => '0' }, [18] => { [0] => '0' }, [19] => { [0] => '0' }, [21] => { [0] => '0' }, [22] => { [0] => '0' }, [23] => { [0] => '0' }, [24] => { [0] => '0' }, [25] => { [0] => '0' }, [26] => { [0] => '0' }, [27] => { [0] => '0' }, [28] => { [0] => '0' }, [29] => { [0] => '0' }, [30] => { [0] => '0' }, [31] => { [0] => '0' }, [32] => { [0] => '0' }, [33] => { [0] => '0' }, [34] => { [0] => '0' }, [36] => { [0] => '0' }, [37] => { [0] => '0' }, [38] => { [0] => '0' }, [39] => { [0] => '0' } } } ) C:\inetpub\wwwroot\Mantis\core\classes\BugFilterQuery.class.php: 355: BugFilterQuery - -> - build_order_by() C:\inetpub\wwwroot\Mantis\core\classes\BugFilterQuery.class.php: 227: BugFilterQuery - -> - string_query_list() C:\inetpub\wwwroot\Mantis\core\classes\BugFilterQuery.class.php: 206: BugFilterQuery - -> - build_query() C:\inetpub\wwwroot\Mantis\core\classes\BugFilterQuery.class.php: 191: BugFilterQuery - -> - set_query_type( 0 ) C:\inetpub\wwwroot\Mantis\core\filter_api.php: 1120: BugFilterQuery - -> - __construct( { ['_version'] => 'v9', ['_view_type'] => 'simple', ['category_id'] => { [0] => '0' }, ['severity'] => { [0] => 0 }, ['status'] => { [0] => 0 }, ['highlight_changed'] => 6, ['reporter_id'] => { [0] => 0 }, ['handler_id'] => { [0] => 0 }, ['project_id'] => { [0] => -3 }, ['resolution'] => { [0] => 0 }, ['build'] => { [0] => '0' }, ['version'] => { [0] => '0' }, ['hide_status'] => { [0] => 90 }, ['monitor_user_id'] => { [0] => 0 }, ['sort'] => 'last_updated', ['dir'] => 'DESC', ['per_page'] => 50, ['match_type'] => 0, ['platform'] => { [0] => '0' }, ['os'] => { [0] => '0' }, ['os_build'] => { [0] => '0' }, ['fixed_in_version'] => { [0] => '0' }, ['target_version'] => { [0] => '0' }, ['profile_id'] => { [0] => 0 }, ['priority'] => { [0] => 0 }, ['note_user_id'] => { [0] => 0 }, ['sticky'] => true, ['filter_by_date'] => false, ['start_month'] => '11', ['end_month'] => '11', ['start_day'] => 1, ['end_day'] => '10', ['start_year'] => '2020', ['end_year'] => '2020', ['filter_by_last_updated_date'] => false, ['last_updated_start_month'] => '11', ['last_updated_end_month'] => '11', ['last_updated_start_day'] => 1, ['last_updated_end_day'] => '10', ['last_updated_start_year'] => '2020', ['last_updated_end_year'] => '2020', ['search'] => '', ['view_state'] => 0, ['tag_string'] => '', ['tag_select'] => 0, ['relationship_type'] => -1, ['relationship_bug'] => 0, ['custom_fields'] => { [1] => { [0] => '0' }, [2] => { [0] => '0' }, [3] => { [0] => '0' }, [5] => { [0] => '0' }, [7] => { [0] => '0' }, [8] => { [0] => '0' }, [9] => { [0] => '0' }, [10] => { [0] => '0' }, [11] => { [0] => '0' }, [12] => { [0] => '0' }, [13] => { [0] => '0' }, [14] => { [0] => '0' }, [15] => { [0] => '0' }, [16] => { [0] => '0' }, [17] => { [0] => '0' }, [20] => { [0] => '0' }, [18] => { [0] => '0' }, [19] => { [0] => '0' }, [21] => { [0] => '0' }, [22] => { [0] => '0' }, [23] => { [0] => '0' }, [24] => { [0] => '0' }, [25] => { [0] => '0' }, [26] => { [0] => '0' }, [27] => { [0] => '0' }, [28] => { [0] => '0' }, [29] => { [0] => '0' }, [30] => { [0] => '0' }, [31] => { [0] => '0' }, [32] => { [0] => '0' }, [33] => { [0] => '0' }, [34] => { [0] => '0' }, [36] => { [0] => '0' }, [37] => { [0] => '0' }, [38] => { [0] => '0' }, [39] => { [0] => '0' } } }, { ['query_type'] => 0, ['project_id'] => NULL, ['user_id'] => NULL, ['use_sticky'] => true } ) C:\inetpub\wwwroot\Mantis\view_all_bug_page.php: 71: - - - - filter_get_bug_rows( 1, NULL, NULL, NULL, NULL, NULL, NULL, true )

[cas]

So what happened, why did you restored a DB?
How old was the backup, from the same mantis version?
Any change in PHP or mysql?

[Violanzzj]

Hi Cas,

we were running an old version 1.2.10 on a Linux server. Unfortunately we have to decomission this server for security reasons. So we've created an SQL backup of that old DB. From the old to the new SQL we stayed on a MySQL instance!

Then we've created a new Mantis Server (Microsoft) with the latest version 2.24.3. After some installation struggle I've got it all to work. I was able to logon and create new cases.

So from what I've read it is possible to import an old Mantis DB into the newest version, so that is basically what I tried.
the import was just done a normal command prompt and didn't gave any errors. Like said I can also see all tables seems to filled with info.

is this the information you are looking for?

regards,
Rolf

[Violanzzj]

I think it is solved!! Had to go to the install.php page again. Then Mantis updated the database where needed!

Okay not all variables are correct but we have a 99% correct fully restored backup, so that should do the trick for now!

can someone please close this topic where i can't..

[cas]

No need to close, it remains as info for others.
Please do read the administration manual around updating your Mantis installation, it would have gome smoother.
Nevertheless good to hear you got it fixed.