I am trying to upgrade mantis 1.0.6 to 1.1.0 from one machine to another. Machine1 which has 1.0.6 has Fedora core 4, PHP5, MySQL 4.1.20-1.FC4.1 and Machine2 where I am trying to install 1.1.0 has Fedora core 4, PHP 5 and MySQL 5.0.4-10.5.
Here is the procedure that I followed:
1. Took mySQL dump from Machine1 to Machine2.
2. Imported the dump into the MySQL database on Machine2.
3. Installed mantis 1.1.0 on Machine2
4. Ran admin/install.php
Here is the output of install.php
Setting Database Hostname GOOD
Setting Database Type GOOD
Checking PHP support for database type GOOD
Setting Database Username GOOD
Setting Database Password GOOD
Setting Database Name GOOD
Setting Admin Username GOOD
Setting Admin Password GOOD
Attempting to connect to database as admin GOOD
Checking Database Server Version
Running mysql version 5.0.37 POSSIBLE PROBLEM
Please ensure that your installation supports the new password scheme used in MySQL 4.1.0 and later. See http://dev.mysql.com/doc/mysql/en/password-hashing.html.
Attempting to connect to database as user GOOD
Installing Database
Create database if it does not exist GOOD
Attempting to connect to database as user GOOD
And following is the output of check.php
Checking your installation
Opening connection to database [celtrack] on host [localhost] with username [root] GOOD
Database Type (adodb) mysql
Database Provider (adodb) mysql
Database Server Description (adodb) 5.0.37
Database Server Description (version) 5.0.37
Checking to see if your absolute_path config option has a trailing slash: "/var/www/mantis/" GOOD
magic_quotes_gpc
gpc_order
variables_order EGPCS
include_path .:/usr/share/pear
short_open_tag 1
mssql.textsize
mssql.textlimit
Bug attachments download thresholds (view_attachments_threshold, download_attachments_threshold, delete_attachments_threshold) GOOD
Bug attachments allow own flags (allow_view_own_attachments, allow_download_own_attachments, allow_delete_own_attachments) GOOD
check mail configuration: send_reset_password = ON requires allow_blank_email = OFF GOOD
check mail configuration: send_reset_password = ON requires enable_email_notification = ON GOOD
check mail configuration: allow_signup = ON requires enable_email_notification = ON GOOD
check mail configuration: allow_signup = ON requires send_reset_password = ON GOOD
check language configuration: fallback_language is not 'auto' GOOD
check configuration: allow_anonymous_login = ON requires anonymous_account to be set GOOD
check configuration: anonymous_account is a valid username if set GOOD
check configuration: anonymous_account should not be an administrator GOOD
$g_bug_link_tag is not empty ("#") GOOD
$g_bugnote_link_tag is not empty ("~") GOOD
filters: dhtml_filters = ON requires use_javascript = ON GOOD
I don't get any errors but when I log into Mantis, I don't see all the bugs in various projects. I suppose the upgrade database process should create tag tables but when I look at the table list in the database, I don't see any tag tables. There are no new tables created.
I was wondering if there is any incompatibility between database version. I even tried 'mysqlcheck --check-upgrade --all-databases --auto-repair' to upgrade the database but there is no change in the result.
Upgrade from 1.0.6 to 1.1.0
Moderators: Developer, Contributor
Re: Upgrade from 1.0.6 to 1.1.0
I figured out the problem after looking at the apache error log with the following entry.
PHP Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 11 bytes) in /var/www/mantis/admin/schema.php on line 250, referer: http://10.0.1.170/mantis/admin/install.php
Apparently, install.php is demanding more than 8M allotted memory to it in php.ini. I changed the value to 12M and the install.php ran smoothly.
PHP Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 11 bytes) in /var/www/mantis/admin/schema.php on line 250, referer: http://10.0.1.170/mantis/admin/install.php
Apparently, install.php is demanding more than 8M allotted memory to it in php.ini. I changed the value to 12M and the install.php ran smoothly.