Error upgrading to 7.2 from 7.1.3

Ask your questions regarding TimeTrex installation here.
Locked
dialacci
Posts: 48
Joined: Thu Apr 28, 2011 7:17 am

Error upgrading to 7.2 from 7.1.3

Post by dialacci »

hello, I am trying to upgrade to the latest 7.2 release of Timetrex Community edition. Everything goes fine until it attempts the database upgrade, wich freezes at 98%.

I turned on debug mode, nothing special revealed:

Code: Select all

Debug Buffer
============================================================================
Memory Usage: 13591016 Buffer Size: 12
----------------------------------------------------------------------------
DEBUG [L0408] [5ms]: [Function](): URI: /interface/install/DatabaseSchema.php?external_installer= IP Address: 10.0.0.142
DEBUG [L0410] [5ms]: [Function](): Version: 7.2.0 Edition: 10 Production: 0 Demo Mode: 0
DEBUG [L0167] [32ms]: TTDate::setTimeZone(): Setting TimeZone: America/New_York
DEBUG [L0085] [60ms]: [Function](): Bypassing Authentication
DEBUG [L0399] [65ms]: TTi18n::setLocale(): Set Master Locale To: en_US.UTF-8
DEBUG [L0517] [65ms]: TTi18n::chooseBestLocale(): Using Locale: en_US.UTF-8
DEBUG [L1863] [68ms]: Misc::detectMobileBrowser(): User Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:25.0) Gecko/20100101 Firefox/25.0 Retval:
DEBUG [L0110] [72ms]: Install::isInstallMode(): Install Mode is ON
DEBUG [L0381] [72ms]: Install::checkDatabaseExists(): Database Name: timetrex
DEBUG [L0391] [73ms]: Install::checkDatabaseExists(): Exists - Database Name: timetrex
DEBUG [L0423] [73ms]: Install::checkTableExists(): Table Name: company
DEBUG [L0433] [77ms]: Install::checkTableExists(): Exists - Table Name: company
============================================================================

============================================================================
                              PROFILER OUTPUT
============================================================================
Calls                    Time  Routine
-----------------------------------------------------------------------------
  1    192.6739 ms (70.98 %)  Main
 16    48.3053 ms (17.80 %)  __autoload
  1    1.8680 ms (0.69 %)  getEmptyRecordSet()
  1    28.1551 ms (10.37 %)  unprofiled

       0.4416 ms (0.16 %)  Missed
============================================================================
       271.4438 ms (100.00 %)  OVERALL TIME
============================================================================
The Timetrex.log file shows:

Code: Select all

DEBUG [L0133] [463ms]:  <b>InstallSchema_Base::_InstallSchema()</b>: Schema SQL has data, executing commands!<br>
DEBUG [L0078] [507ms]:  <b>Debug::Shutdown()</b>: PHP ERROR - FATAL(1): Uncaught exception 'ADODB_Exception' with message 'mysqli error: [1060: Duplicate column name 'position_accuracy'] in adodb_$
DEBUG [L0078] [507ms]:  <b>Debug::Shutdown()</b>: nteger, )<br>
DEBUG [L0078] [507ms]:  <b>Debug::Shutdown()</b>: ' in /var/timetrex/classes/adodb/adodb-exceptions.inc.php:78<br>
DEBUG [L0078] [507ms]:  <b>Debug::Shutdown()</b>: Stack trace:<br>
DEBUG [L0078] [507ms]:  <b>Debug::Shutdown()</b>: #0 /var/timetrex/classes/adodb/adodb.inc.php(227): adodb_throw('mysqli', 'adodb_throw', 1060, 'Duplicate colum...', 'ALTER TABLE pun...', false, O$
$, false, Object(ADODB_mysqli))<br>
DEBUG [L0078] [507ms]:  <b>Debug::Shutdown()</b>: #2 /var/timetrex/classes/adodb/adodb.inc.php(1017): ADOConnection->_Execute('ALTER TABLE pun...', false)<br>
DEBUG [L0078] [507ms]:  <b>Debug::Shutdown()</b>: #3 /var/timetrex/classes/modules/install/InstallSchema_Base.class.php(144): ADOConnection->Execute('ALTER TABLE pun...')<br>
DEBUG [L0078] [507ms]:  <b>Debug::Shutdown()</b>: #4 /var/timetrex/classes/modules/install/InstallSchema_Base.class.php(188): InstallSchema_Base->_InstallSchema()<br>
DEBUG [L0078] [507ms]:  <b>Debug::Shutdown()</b>: #5 [internal function]: InstallSchema_Base->InstallSchema()<br>
DEBUG [L0078] [507ms]:  <b>Debug::Shutdown()</b>: #6 /var/timetrex/classes/ File: /var/timetrex/classes/adodb/adodb-exceptions.inc.php Line: 78<br>
DEBUG [L0184] [507ms]:  <b>Debug::Text()</b>: Detected PHP errors (1), emailing log...<br>
DEBUG [L0184] [507ms]:  <b>Debug::Text()</b>: ---------------[ 17-Dec-2013 10:44:43 -0500 (PID: 21893) ]---------------<br>
---------------[ 17-Dec-2013 10:44:43 -0500 (PID: 21893) ]---------------
There is indeed a field position_accuracy, it does not have any values. I tried renaming it to position_accuracy_bad and re-running the installer - no change.

Any ideas? let me know if there is anything else I can provide.
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Error upgrading to 7.2 from 7.1.3

Post by shaunw »

It appears that you maybe tried to the run the upgrade twice perhaps? Or it failed the first time and you tried it a second time, but the error messages the 2nd time would all be completely different and not the "real" errors.

If thats the case, unfortunately due to shortcomings in MySQL (and one the main reasons we don't recommend using it) you would need to restore the entire database from a backup and try the upgrade again, as your database is now essentially corrupted. Before you try the upgrade again you may want to download the TimeTrex .ZIP file once more just to make sure you have a good copy.
dialacci
Posts: 48
Joined: Thu Apr 28, 2011 7:17 am

Re: Error upgrading to 7.2 from 7.1.3

Post by dialacci »

We were at 7.0.0, the upgrade to 7.1 -> 7.1.2 ->7.1.3 worked fine, it hangs up every time we attempt to go to 7.2.0.

I restored back to 7.1.3 (we do nightly DB backups) and its working fine now... odd that it only throws the error going to 7.2.

we downloaded a fresh 7.2.0 ZIP from Sourceforge and tried again, same thing :(
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Error upgrading to 7.2 from 7.1.3

Post by shaunw »

Can you clear your TimeTrex logs then run the upgrade (from a freshly restored database) again, then send us a copy of the log?

The error you posted above is definitely not the original error, so we need to find out what the original error was...
Locked