I'm trying to upgrade an existing 1.1.8 installation of MantisBT to 1.2.0.
I did the following steps:
1. Copying config_inc.php, custom_strings.inc.php and custom_constants_inc.php from the old to the new installation. I do not use custom functions, so I do not have a custom_functions_inc.php.
2. Performing a diff of [...]\lang\strings_german.txt, because I did some changes on this file. I noticed a few things, please see below.
3. Running http://mywebserver/mantis-1.2.0/admin/install.php. An upgrade was detected and done successfully.
4. Running http://mywebserver/mantis-1.2.0/admin/check.php. Here I see a lot of errors and/or problems. Please see attachment.
Here are the issues I encountered:
In step 2: The translations for the following strings are missing in strings_german.txt of the new installation. Is this okay, because they are not used anymore or are the gone lost?
In step 4: In the attachment, I see a lot of errors.
1. The issue with validate_email is clear for me, I need PHP 5.3 or later to use it, but my installed PHP version is 5.2.11. I would like to still use this PHP version, because if I use PHP5.3, I run into a lot of problems with another tool (TestLink). Can I disable the validate_email feature in config_inc.php? What will be the disadvantages?
2. What's the problem with that swedish language file? Can I ignore that? No one here will ever use the swedish translation of Mantis.
3. What's the issue with that upload setting?
4. What's the problem with my adodb version? Isn't that part of Mantis?
Thank you very much for your answers!
Best regards
Karl
Sorry, I cannot upload any file here, so I will post the output of check.php. Here we go:
Checking your installation
Checking adodb version...
5.1 WARN
Database Type (adodb) mysql
Database Provider (adodb) mysql
Database Server Description (adodb) 5.1.32-community-log
Database Server Description (version) 5.1.32
validate_email (if ON) requires php 5.3 on windows... BAD
magic_quotes_gpc
include_path D:\Server\installiert\wamp\www\mantisbt-1.2.0\core\;D:\Server\installiert\wamp\www\mantisbt-1.2.0\library;.;D:\Server\installiert\wamp\bin\php\php5.2.9-1\pear
Checking Table Collation is utf8 for mantis_bug_file_table....
latin1_swedish_ci BAD
Checking Table Collation is utf8 for mantis_bug_history_table....
latin1_swedish_ci BAD
Checking Table Collation is utf8 for mantis_bug_monitor_table....
latin1_swedish_ci BAD
Checking Table Collation is utf8 for mantis_bug_relationship_table....
latin1_swedish_ci BAD
Checking Table Collation is utf8 for mantis_bug_table....
latin1_swedish_ci BAD
Checking Table Collation is utf8 for mantis_bug_tag_table....
latin1_swedish_ci BAD
Checking Table Collation is utf8 for mantis_bug_text_table....
latin1_swedish_ci BAD
Checking Table Collation is utf8 for mantis_bugnote_table....
latin1_swedish_ci BAD
Checking Table Collation is utf8 for mantis_bugnote_text_table....
latin1_swedish_ci BAD
Checking Table Collation is utf8 for mantis_config_table....
latin1_swedish_ci BAD
Checking Table Collation is utf8 for mantis_custom_field_project_table....
latin1_swedish_ci BAD
Checking Table Collation is utf8 for mantis_custom_field_string_table....
latin1_swedish_ci BAD
Checking Table Collation is utf8 for mantis_custom_field_table....
latin1_swedish_ci BAD
Checking Table Collation is utf8 for mantis_email_table....
latin1_swedish_ci BAD
Checking Table Collation is utf8 for mantis_filters_table....
latin1_swedish_ci BAD
Checking Table Collation is utf8 for mantis_news_table....
latin1_swedish_ci BAD
Checking Table Collation is utf8 for mantis_project_file_table....
latin1_swedish_ci BAD
Checking Table Collation is utf8 for mantis_project_hierarchy_table....
latin1_swedish_ci BAD
Checking Table Collation is utf8 for mantis_project_table....
latin1_swedish_ci BAD
Checking Table Collation is utf8 for mantis_project_user_list_table....
latin1_swedish_ci BAD
Checking Table Collation is utf8 for mantis_project_version_table....
latin1_swedish_ci BAD
Checking Table Collation is utf8 for mantis_sponsorship_table....
latin1_swedish_ci BAD
Checking Table Collation is utf8 for mantis_tag_table....
latin1_swedish_ci BAD
Checking Table Collation is utf8 for mantis_tokens_table....
latin1_swedish_ci BAD
Checking Table Collation is utf8 for mantis_user_pref_table....
latin1_swedish_ci BAD
Checking Table Collation is utf8 for mantis_user_print_pref_table....
latin1_swedish_ci BAD
Checking Table Collation is utf8 for mantis_user_profile_table....
latin1_swedish_ci BAD
Checking Table Collation is utf8 for mantis_user_table....
latin1_swedish_ci BAD
Checking Non-null Column Collation in mantis_bug_file_table is utf8 for title....
latin1_swedish_ci ( varchar(250)) BAD
Checking Non-null Column Collation in mantis_bug_file_table is utf8 for description....
latin1_swedish_ci ( varchar(250)) BAD
Checking Non-null Column Collation in mantis_bug_file_table is utf8 for diskfile....
latin1_swedish_ci ( varchar(250)) BAD
Checking Non-null Column Collation in mantis_bug_file_table is utf8 for filename....
latin1_swedish_ci ( varchar(250)) BAD
Checking Non-null Column Collation in mantis_bug_file_table is utf8 for folder....
latin1_swedish_ci ( varchar(250)) BAD
Checking Non-null Column Collation in mantis_bug_file_table is utf8 for file_type....
latin1_swedish_ci ( varchar(250)) BAD
Checking Non-null Column Collation in mantis_bug_history_table is utf8 for field_name....
latin1_swedish_ci ( varchar(64)) BAD
Checking Non-null Column Collation in mantis_bug_history_table is utf8 for old_value....
latin1_swedish_ci ( varchar(255)) BAD
Checking Non-null Column Collation in mantis_bug_history_table is utf8 for new_value....
latin1_swedish_ci ( varchar(255)) BAD
Checking Non-null Column Collation in mantis_bug_table is utf8 for os....
latin1_swedish_ci ( varchar(32)) BAD
Checking Non-null Column Collation in mantis_bug_table is utf8 for os_build....
latin1_swedish_ci ( varchar(32)) BAD
Checking Non-null Column Collation in mantis_bug_table is utf8 for platform....
latin1_swedish_ci ( varchar(32)) BAD
Checking Non-null Column Collation in mantis_bug_table is utf8 for version....
latin1_swedish_ci ( varchar(64)) BAD
Checking Non-null Column Collation in mantis_bug_table is utf8 for fixed_in_version....
latin1_swedish_ci ( varchar(64)) BAD
Checking Non-null Column Collation in mantis_bug_table is utf8 for build....
latin1_swedish_ci ( varchar(32)) BAD
Checking Non-null Column Collation in mantis_bug_table is utf8 for summary....
latin1_swedish_ci ( varchar(128)) BAD
Checking Non-null Column Collation in mantis_bug_table is utf8 for target_version....
latin1_swedish_ci ( varchar(64)) BAD
Checking Non-null Column Collation in mantis_bug_text_table is utf8 for description....
latin1_swedish_ci ( longtext) BAD
Checking Non-null Column Collation in mantis_bug_text_table is utf8 for steps_to_reproduce....
latin1_swedish_ci ( longtext) BAD
Checking Non-null Column Collation in mantis_bug_text_table is utf8 for additional_information....
latin1_swedish_ci ( longtext) BAD
Checking Non-null Column Collation in mantis_bugnote_table is utf8 for note_attr....
latin1_swedish_ci ( varchar(250)) BAD
Checking Non-null Column Collation in mantis_bugnote_text_table is utf8 for note....
latin1_swedish_ci ( longtext) BAD
Checking Non-null Column Collation in mantis_news_table is utf8 for headline....
latin1_swedish_ci ( varchar(64)) BAD
Checking Non-null Column Collation in mantis_news_table is utf8 for body....
latin1_swedish_ci ( longtext) BAD
Checking Non-null Column Collation in mantis_project_file_table is utf8 for title....
latin1_swedish_ci ( varchar(250)) BAD
Checking Non-null Column Collation in mantis_project_file_table is utf8 for description....
latin1_swedish_ci ( varchar(250)) BAD
Checking Non-null Column Collation in mantis_project_file_table is utf8 for diskfile....
latin1_swedish_ci ( varchar(250)) BAD
Checking Non-null Column Collation in mantis_project_file_table is utf8 for filename....
latin1_swedish_ci ( varchar(250)) BAD
Checking Non-null Column Collation in mantis_project_file_table is utf8 for folder....
latin1_swedish_ci ( varchar(250)) BAD
Checking Non-null Column Collation in mantis_project_file_table is utf8 for file_type....
latin1_swedish_ci ( varchar(250)) BAD
Checking Non-null Column Collation in mantis_project_table is utf8 for name....
latin1_swedish_ci ( varchar(128)) BAD
Checking Non-null Column Collation in mantis_project_table is utf8 for file_path....
latin1_swedish_ci ( varchar(250)) BAD
Checking Non-null Column Collation in mantis_project_table is utf8 for description....
latin1_swedish_ci ( longtext) BAD
Checking Non-null Column Collation in mantis_project_version_table is utf8 for version....
latin1_swedish_ci ( varchar(64)) BAD
Checking Non-null Column Collation in mantis_project_version_table is utf8 for description....
latin1_swedish_ci ( longtext) BAD
Checking Non-null Column Collation in mantis_tag_table is utf8 for name....
latin1_swedish_ci ( varchar(100)) BAD
Checking Non-null Column Collation in mantis_tag_table is utf8 for description....
latin1_swedish_ci ( longtext) BAD
Checking Non-null Column Collation in mantis_user_table is utf8 for username....
latin1_swedish_ci ( varchar(32)) BAD
Checking Non-null Column Collation in mantis_user_table is utf8 for realname....
latin1_swedish_ci ( varchar(64)) BAD
Checking Non-null Column Collation in mantis_user_table is utf8 for email....
latin1_swedish_ci ( varchar(64)) BAD
Checking Non-null Column Collation in mantis_user_table is utf8 for password....
latin1_swedish_ci ( varchar(32)) BAD
Checking Non-null Column Collation in mantis_user_table is utf8 for cookie_string....
latin1_swedish_ci ( varchar(64)) BAD
Checking Non-null Column Collation in mantis_user_profile_table is utf8 for platform....
latin1_swedish_ci ( varchar(32)) BAD
Checking Non-null Column Collation in mantis_user_profile_table is utf8 for os....
latin1_swedish_ci ( varchar(32)) BAD
Checking Non-null Column Collation in mantis_user_profile_table is utf8 for os_build....
latin1_swedish_ci ( varchar(32)) BAD
Checking Non-null Column Collation in mantis_user_profile_table is utf8 for description....
latin1_swedish_ci ( longtext) BAD
Checking Non-null Column Collation in mantis_user_pref_table is utf8 for bugnote_order....
latin1_swedish_ci ( varchar(4)) BAD
Checking Non-null Column Collation in mantis_user_pref_table is utf8 for language....
latin1_swedish_ci ( varchar(32)) BAD
Checking Non-null Column Collation in mantis_user_pref_table is utf8 for timezone....
latin1_swedish_ci ( varchar(32)) BAD
Checking Non-null Column Collation in mantis_user_print_pref_table is utf8 for print_pref....
latin1_swedish_ci ( varchar(64)) BAD
Checking Non-null Column Collation in mantis_custom_field_table is utf8 for name....
latin1_swedish_ci ( varchar(64)) BAD
Checking Non-null Column Collation in mantis_custom_field_table is utf8 for possible_values....
latin1_swedish_ci ( text) BAD
Checking Non-null Column Collation in mantis_custom_field_table is utf8 for default_value....
latin1_swedish_ci ( varchar(255)) BAD
Checking Non-null Column Collation in mantis_custom_field_table is utf8 for valid_regexp....
latin1_swedish_ci ( varchar(255)) BAD
Checking Non-null Column Collation in mantis_custom_field_string_table is utf8 for value....
latin1_swedish_ci ( varchar(255)) BAD
Checking Non-null Column Collation in mantis_filters_table is utf8 for name....
latin1_swedish_ci ( varchar(64)) BAD
Checking Non-null Column Collation in mantis_filters_table is utf8 for filter_string....
latin1_swedish_ci ( longtext) BAD
Checking Non-null Column Collation in mantis_sponsorship_table is utf8 for logo....
latin1_swedish_ci ( varchar(128)) BAD
Checking Non-null Column Collation in mantis_sponsorship_table is utf8 for url....
latin1_swedish_ci ( varchar(128)) BAD
Checking Non-null Column Collation in mantis_tokens_table is utf8 for value....
latin1_swedish_ci ( longtext) BAD
Checking Non-null Column Collation in mantis_config_table is utf8 for config_id....
latin1_swedish_ci ( varchar(64)) BAD
Checking Non-null Column Collation in mantis_config_table is utf8 for value....
latin1_swedish_ci ( longtext) BAD
Checking Non-null Column Collation in mantis_email_table is utf8 for email....
latin1_swedish_ci ( varchar(64)) BAD
Checking Non-null Column Collation in mantis_email_table is utf8 for subject....
latin1_swedish_ci ( varchar(250)) BAD
Checking Non-null Column Collation in mantis_email_table is utf8 for metadata....
latin1_swedish_ci ( longtext) BAD
Checking Non-null Column Collation in mantis_email_table is utf8 for body....
latin1_swedish_ci ( longtext) BAD
PHP variable "upload_max_filesize" 2000000
PHP variable "post_max_size" 8000000
MantisBT variable "max_file_size" 5000000
Checking MantisBT upload file size is less than php BAD
There may also be settings in your web server and database that prevent you from uploading files or limit the maximum file size. See the documentation for those packages if you need more information.
Your current settings will most likely need adjustments to the PHP max_execution_time or memory_limit settings, the MySQL max_allowed_packet setting, or equivalent.
There may also be settings in your web server that prevent you from uploading files or limit the maximum file size. See the documentation for those packages if you need more information.
Thanks for your help! After changing the collation to utf8 (as described in the other thread), all errors concerning latin1_swedish_ci are gone!
However, I still get the warning about the adodb version (I'm using 5.1). Can I ignore that?
And I still get the error with validate_email, as I'm not using PHP5.3. Can I also ignore that and/or turn off this feature in config.inc.php, or will I face any issues then?
I'm ignoring the warnings/error for the moment and everything seems to be okay, anyway. But maybe someone can still clearify this issue ...
By the way, don't delete the admin-folder before logging in into your new Mantis installation the first time. If you delete it, you will not see any potential warning concerning an outdated database structure. If so you will get a lot of errors later, when using Mantis. Therefore keep the admin folder, go to the Mantis login page and check if there is this warning. If this is the case, follow the steps to update the database structure and delete the admin folder after doing that. If no warning is printed, you can delete the admin folder, too.
karl.reichert wrote:
In step 2: The translations for the following strings are missing in strings_german.txt of the new installation. Is this okay, because they are not used anymore or are the gone lost?
