installation fails at 71%

markdavidshaw · Post by **markdavidshaw** » Mon Nov 12, 2007 4:20 am

Hi,

The installation fails at 71% with message on screen "Initializing database, please wait..."

I am using a debian box with all pre-requisites met and showing OK, also the mysql database is version:
mysql --version
mysql Ver 14.12 Distrib 5.0.45, for pc-linux-gnu (i486) using readline 5.2

phpmyadmin shows that the timetrex database has been populated with 91 tables and yet the installer will not pass to the next screen

BELOW IS CONTENT OF timetrex.log which maybe of use intracing the problem:

///////////////////////////////////////////////////////////////////

---------------[ Mon, 12 Nov 2007 10:50:55 +0000 (PID: 6366) ]---------------
DEBUG [249]: [Function](): URI: /timetrex/interface/install/License.php?external_installer=0 
DEBUG [251]: [Function](): Production: 1 
DEBUG [100]: TTDate::setTimeZone(): Setting TimeZone: GMT 
DEBUG [53]: [Function](): Bypassing Authentication 
DEBUG [400]: TTi18n::chooseBestLocale(): Choosing Best Locale... 
DEBUG [371]: TTi18n::getBrowserLanguage(): HTTP_ACCEPT_LANGUAGE: en 
DEBUG [454]: TTi18n::chooseBestLocale(): cSetting Locale: en 
DEBUG [318]: TTi18n::setLocale(): Generated/Passed In Locale: en 
DEBUG [252]: TTi18n::generateLocale(): Array of Locales to try in order: en,en.UTF-8,en_US,en_US.UTF-8 
DEBUG [211]: TTi18n::tryLocale(): Found valid locale: en_US 
DEBUG [324]: TTi18n::setLocale(): Attempting to set Locale(s) to: en_US Category: 6 Current Locale: 
DEBUG [327]: TTi18n::setLocale(): Setting currency/numeric Locale to: en_US 
DEBUG [340]: TTi18n::setLocale(): Setting translator locale to: en_US 
DEBUG [357]: TTi18n::setLocale(): Set Master Locale To: en_US 
DEBUG [463]: TTi18n::chooseBestLocale(): Using Locale: en_US 
DEBUG [90]: Install::isInstallMode(): Install Mode is ON 
---------------[ Mon, 12 Nov 2007 10:50:55 +0000 (PID: 6366) ]---------------
---------------[ Mon, 12 Nov 2007 10:51:04 +0000 (PID: 6365) ]---------------
DEBUG [249]: [Function](): URI: /timetrex/interface/install/Requirements.php?external_installer=0 
DEBUG [251]: [Function](): Production: 1 
DEBUG [100]: TTDate::setTimeZone(): Setting TimeZone: GMT 
DEBUG [53]: [Function](): Bypassing Authentication 
DEBUG [400]: TTi18n::chooseBestLocale(): Choosing Best Locale... 
DEBUG [371]: TTi18n::getBrowserLanguage(): HTTP_ACCEPT_LANGUAGE: en 
DEBUG [454]: TTi18n::chooseBestLocale(): cSetting Locale: en 
DEBUG [318]: TTi18n::setLocale(): Generated/Passed In Locale: en 
DEBUG [252]: TTi18n::generateLocale(): Array of Locales to try in order: en,en.UTF-8,en_US,en_US.UTF-8 
DEBUG [211]: TTi18n::tryLocale(): Found valid locale: en_US 
DEBUG [324]: TTi18n::setLocale(): Attempting to set Locale(s) to: en_US Category: 6 Current Locale: 
DEBUG [327]: TTi18n::setLocale(): Setting currency/numeric Locale to: en_US 
DEBUG [340]: TTi18n::setLocale(): Setting translator locale to: en_US 
DEBUG [357]: TTi18n::setLocale(): Set Master Locale To: en_US 
DEBUG [463]: TTi18n::chooseBestLocale(): Using Locale: en_US 
DEBUG [90]: Install::isInstallMode(): Install Mode is ON 
DEBUG [476]: Install::checkPHPVersion(): Comparing with Version: 5.2.4-2 
DEBUG [476]: Install::checkPHPVersion(): Comparing with Version: 5.2.4-2 
DEBUG [476]: Install::checkPHPVersion(): Comparing with Version: 5.2.4-2 
DEBUG [476]: Install::checkPHPVersion(): Comparing with Version: 5.2.4-2 
DEBUG [476]: Install::checkPHPVersion(): Comparing with Version: 5.2.4-2 
---------------[ Mon, 12 Nov 2007 10:51:04 +0000 (PID: 6365) ]---------------
---------------[ Mon, 12 Nov 2007 10:51:24 +0000 (PID: 6508) ]---------------
DEBUG [249]: [Function](): URI: /timetrex/interface/install/DatabaseConfig.php 
DEBUG [251]: [Function](): Production: 1 
DEBUG [100]: TTDate::setTimeZone(): Setting TimeZone: GMT 
DEBUG [53]: [Function](): Bypassing Authentication 
DEBUG [400]: TTi18n::chooseBestLocale(): Choosing Best Locale... 
DEBUG [371]: TTi18n::getBrowserLanguage(): HTTP_ACCEPT_LANGUAGE: en 
DEBUG [454]: TTi18n::chooseBestLocale(): cSetting Locale: en 
DEBUG [318]: TTi18n::setLocale(): Generated/Passed In Locale: en 
DEBUG [252]: TTi18n::generateLocale(): Array of Locales to try in order: en,en.UTF-8,en_US,en_US.UTF-8 
DEBUG [211]: TTi18n::tryLocale(): Found valid locale: en_US 
DEBUG [324]: TTi18n::setLocale(): Attempting to set Locale(s) to: en_US Category: 6 Current Locale: 
DEBUG [327]: TTi18n::setLocale(): Setting currency/numeric Locale to: en_US 
DEBUG [340]: TTi18n::setLocale(): Setting translator locale to: en_US 
DEBUG [357]: TTi18n::setLocale(): Set Master Locale To: en_US 
DEBUG [463]: TTi18n::chooseBestLocale(): Using Locale: en_US 
DEBUG [90]: Install::isInstallMode(): Install Mode is ON 
---------------[ Mon, 12 Nov 2007 10:51:24 +0000 (PID: 6508) ]---------------
---------------[ Mon, 12 Nov 2007 10:51:35 +0000 (PID: 6784) ]---------------
DEBUG [249]: [Function](): URI: /timetrex/interface/install/DatabaseConfig.php?data%5Btype%5D=mysqlt&data%5Bhost%5D=localhost&data%5Bdatabase_name%5D=timetrex&data%5Buser%5D=root&data%5Bpassword%5D=admin&data%5Bpriv_user%5D=&data%5Bpriv_password%5D=&action%3Atest_connection=Test+Connection&external_installer= 
DEBUG [251]: [Function](): Production: 1 
DEBUG [100]: TTDate::setTimeZone(): Setting TimeZone: GMT 
DEBUG [53]: [Function](): Bypassing Authentication 
DEBUG [400]: TTi18n::chooseBestLocale(): Choosing Best Locale... 
DEBUG [371]: TTi18n::getBrowserLanguage(): HTTP_ACCEPT_LANGUAGE: en 
DEBUG [454]: TTi18n::chooseBestLocale(): cSetting Locale: en 
DEBUG [318]: TTi18n::setLocale(): Generated/Passed In Locale: en 
DEBUG [252]: TTi18n::generateLocale(): Array of Locales to try in order: en,en.UTF-8,en_US,en_US.UTF-8 
DEBUG [211]: TTi18n::tryLocale(): Found valid locale: en_US 
DEBUG [324]: TTi18n::setLocale(): Attempting to set Locale(s) to: en_US Category: 6 Current Locale: 
DEBUG [327]: TTi18n::setLocale(): Setting currency/numeric Locale to: en_US 
DEBUG [340]: TTi18n::setLocale(): Setting translator locale to: en_US 
DEBUG [357]: TTi18n::setLocale(): Set Master Locale To: en_US 
DEBUG [463]: TTi18n::chooseBestLocale(): Using Locale: en_US 
DEBUG [90]: Install::isInstallMode(): Install Mode is ON 
DEBUG [275]: Install::checkDatabaseExists(): Database Name: timetrex 
DEBUG [285]: Install::checkDatabaseExists(): Exists - Database Name: timetrex 
---------------[ Mon, 12 Nov 2007 10:51:35 +0000 (PID: 6784) ]---------------
---------------[ Mon, 12 Nov 2007 10:51:50 +0000 (PID: 6366) ]---------------
DEBUG [249]: [Function](): URI: /timetrex/interface/install/DatabaseConfig.php?data%5Btype%5D=mysqlt&data%5Bhost%5D=localhost&data%5Bdatabase_name%5D=timetrex&data%5Buser%5D=root&data%5Bpassword%5D=admin&data%5Bpriv_user%5D=&data%5Bpriv_password%5D=&action%3Atest_connection=Test+Connection&external_installer= 
DEBUG [251]: [Function](): Production: 1 
DEBUG [100]: TTDate::setTimeZone(): Setting TimeZone: GMT 
DEBUG [53]: [Function](): Bypassing Authentication 
DEBUG [400]: TTi18n::chooseBestLocale(): Choosing Best Locale... 
DEBUG [371]: TTi18n::getBrowserLanguage(): HTTP_ACCEPT_LANGUAGE: en 
DEBUG [454]: TTi18n::chooseBestLocale(): cSetting Locale: en 
DEBUG [318]: TTi18n::setLocale(): Generated/Passed In Locale: en 
DEBUG [252]: TTi18n::generateLocale(): Array of Locales to try in order: en,en.UTF-8,en_US,en_US.UTF-8 
DEBUG [211]: TTi18n::tryLocale(): Found valid locale: en_US 
DEBUG [324]: TTi18n::setLocale(): Attempting to set Locale(s) to: en_US Category: 6 Current Locale: 
DEBUG [327]: TTi18n::setLocale(): Setting currency/numeric Locale to: en_US 
DEBUG [340]: TTi18n::setLocale(): Setting translator locale to: en_US 
DEBUG [357]: TTi18n::setLocale(): Set Master Locale To: en_US 
DEBUG [463]: TTi18n::chooseBestLocale(): Using Locale: en_US 
DEBUG [90]: Install::isInstallMode(): Install Mode is ON 
DEBUG [275]: Install::checkDatabaseExists(): Database Name: timetrex 
DEBUG [285]: Install::checkDatabaseExists(): Exists - Database Name: timetrex 
---------------[ Mon, 12 Nov 2007 10:51:50 +0000 (PID: 6366) ]---------------
---------------[ Mon, 12 Nov 2007 10:51:59 +0000 (PID: 6365) ]---------------
DEBUG [249]: [Function](): URI: /timetrex/interface/install/DatabaseSchema.php?external_installer= 
DEBUG [251]: [Function](): Production: 1 
DEBUG [100]: TTDate::setTimeZone(): Setting TimeZone: GMT 
DEBUG [53]: [Function](): Bypassing Authentication 
DEBUG [400]: TTi18n::chooseBestLocale(): Choosing Best Locale... 
DEBUG [371]: TTi18n::getBrowserLanguage(): HTTP_ACCEPT_LANGUAGE: en 
DEBUG [454]: TTi18n::chooseBestLocale(): cSetting Locale: en 
DEBUG [318]: TTi18n::setLocale(): Generated/Passed In Locale: en 
DEBUG [252]: TTi18n::generateLocale(): Array of Locales to try in order: en,en.UTF-8,en_US,en_US.UTF-8 
DEBUG [211]: TTi18n::tryLocale(): Found valid locale: en_US 
DEBUG [324]: TTi18n::setLocale(): Attempting to set Locale(s) to: en_US Category: 6 Current Locale: 
DEBUG [327]: TTi18n::setLocale(): Setting currency/numeric Locale to: en_US 
DEBUG [340]: TTi18n::setLocale(): Setting translator locale to: en_US 
DEBUG [357]: TTi18n::setLocale(): Set Master Locale To: en_US 
DEBUG [463]: TTi18n::chooseBestLocale(): Using Locale: en_US 
DEBUG [90]: Install::isInstallMode(): Install Mode is ON 
DEBUG [275]: Install::checkDatabaseExists(): Database Name: timetrex 
DEBUG [285]: Install::checkDatabaseExists(): Exists - Database Name: timetrex 
DEBUG [317]: Install::checkTableExists(): Table Name: system_setting 
DEBUG [331]: Install::checkTableExists(): Does not Exist - Table Name: system_setting 
---------------[ Mon, 12 Nov 2007 10:51:59 +0000 (PID: 6365) ]---------------

///////////////////////////////////////////////////////////

Thanks in advance

markdavidshaw · Post by **markdavidshaw** » Mon Nov 12, 2007 4:24 am

According to the below forum the mysql should be OK, or is this forum wrong?

http://forums.timetrex.com/viewtopic.php?t=298

indicates that the version of mysql 5.0.45 should be OK

Post by **shaunw** » Mon Nov 12, 2007 9:33 am

Did you follow the instruction here:

http://forums.timetrex.com/viewtopic.php?t=65

When you created the database/user?

TimeTrex Time and Attendance

installation fails at 71%

installation fails at 71%

mysql version is OK?

Time and Attendance