Hi i am installing version 1.2.12
onto my webserver (hosted on bluehost) on the initial checks it says my version of MySQL is fine its version 5.1.66
but when i try to setup the database i get an error saying MySQL 4.1.0 or later is required for installation.
I also get an error saying "POSSIBLE PROBLEM -Database user doesn't have access to the database ( )"
I have attached a screen below
problems with install
Moderators: Developer, Contributor
-
Lapinkiller
- Posts: 408
- Joined: 28 Jan 2011, 18:47
- Location: France
- Contact:
Re: problems with install
Hello
check you used the good login and password with good rights for database
check you used the good login and password with good rights for database
Lapinkiller,
French PHP developer
New look for your mantis : http://www.mantisbt.org/forums/viewtopi ... =4&t=20055
French PHP developer
New look for your mantis : http://www.mantisbt.org/forums/viewtopi ... =4&t=20055
-
Dandello
Re: problems with install
I'm having exactly the same problem with MantisBT-1.2.12
phpMyadmin indicates the user assigned to the bugtracker database has all the proper rights. The password is braindead simple as is the login. (Since it's on a standalone test server I can get away with three letter passwords.)
This is supposed to be simple.
phpMyadmin indicates the user assigned to the bugtracker database has all the proper rights. The password is braindead simple as is the login. (Since it's on a standalone test server I can get away with three letter passwords.)
This is supposed to be simple.
-
Dandello
Re: problems with install
Downloaded 1.2.11 and it went in just fine - with exacly the same credentials that failed on 1.2.12 
Re: problems with install
I had this problem with 1.2.11 on Debian Wheezy, this is a version included with the distro repository. I found this to be a typo in
/usr/share/mantis/www/admin/install.php.
I corrected this by changing the code below by just replacing the '<' to '>'. The function version_compare is applied incorrectly, it returns the error 'MySQL 4.1.0 or later is required for installation.' when the version IS bigger than 4.1.0. After this correction the installation went OK.
----------------------------------------------------------------------- code:
case 'mysql' :
case 'mysqli' :
// due to a bug in ADODB, this call prompts warnings, hence the @
// the check only works on mysql if the database is open
// using default mysql db to test the version
$default_mysql_database = "mysql" ;
@$g_db->Connect ( $f_hostname, $f_admin_username, $f_admin_password,$default_mysql_databas
$t_version_info = @$g_db->ServerInfo ();
if (version_compare ( $t_version_info ['version'], '4.1.0', '<' )) {
$t_error = 'MySQL 4.1.0 or later is required for installation. '.$error_go_back;
}else{
$t_result_validation = '<br /> Running ' . $f_db_type . ' version ' . $t_version_i
}
break;
case 'pgsql' :
case 'mssql' :
case 'db2' :
default :
$t_result_validation = '<br /> Running ' . $f_db_type ;
break;
/usr/share/mantis/www/admin/install.php.
I corrected this by changing the code below by just replacing the '<' to '>'. The function version_compare is applied incorrectly, it returns the error 'MySQL 4.1.0 or later is required for installation.' when the version IS bigger than 4.1.0. After this correction the installation went OK.
----------------------------------------------------------------------- code:
case 'mysql' :
case 'mysqli' :
// due to a bug in ADODB, this call prompts warnings, hence the @
// the check only works on mysql if the database is open
// using default mysql db to test the version
$default_mysql_database = "mysql" ;
@$g_db->Connect ( $f_hostname, $f_admin_username, $f_admin_password,$default_mysql_databas
$t_version_info = @$g_db->ServerInfo ();
if (version_compare ( $t_version_info ['version'], '4.1.0', '<' )) {
$t_error = 'MySQL 4.1.0 or later is required for installation. '.$error_go_back;
}else{
$t_result_validation = '<br /> Running ' . $f_db_type . ' version ' . $t_version_i
}
break;
case 'pgsql' :
case 'mssql' :
case 'db2' :
default :
$t_result_validation = '<br /> Running ' . $f_db_type ;
break;