3.3.1 Install hangs
-
- Posts: 15
- Joined: Sun Feb 28, 2010 3:59 pm
3.3.1 Install hangs
I just upgraded from an earlier version on Windows 7. When installing, at "3. Database Configuration," it hangs at 55% of Upgrading Database. I can't access TimeTrex. Please help.
Re: 3.3.1 Install hangs
What version did you try to upgrade from?
-
- Posts: 15
- Joined: Sun Feb 28, 2010 3:59 pm
Re: 3.3.1 Install hangs
I'm not sure of the version number, I believe I downloaded it in January of 2010. If you have to know the version number. I can try to restore my computer to an earlier restore point.
Re: 3.3.1 Install hangs
If its around one year old, the issue is likely caused by a bug in v3.3.1 that only occurs when upgrading from a much older version of TimeTrex.
This will be fixed in v3.3.2, but in the mean time you can download v3.2.X, upgrade to that, then upgrade to v3.3.1. Normally this isn't necessary of course, but in this case it is.
This will be fixed in v3.3.2, but in the mean time you can download v3.2.X, upgrade to that, then upgrade to v3.3.1. Normally this isn't necessary of course, but in this case it is.
-
- Posts: 15
- Joined: Sun Feb 28, 2010 3:59 pm
Re: 3.3.1 Install hangs
Restoring Windows to an earlier restore point didn't roll back TimeTrex to the old version I had previously, so I tried installing 3.2.1 over 3.3.1, but I'm encountering a similar problem. It is hanging at 97% when Upgrading Database. Now what do I do?
Re: 3.3.1 Install hangs
It might be best to try and fix the issue with v3.3.1 and finish the installation with it now.
If you install v3.3.1 over top of your existing installation again, then before the installer asks you to launch the web browser to complete the installation, you will need to edit: classes/modules/install/InstallSchema_1037A.class.php
Around line 152 you will see:
Change the entire line to:
Once the change is done, save the file and continue with the installation in the web browser.
If you install v3.3.1 over top of your existing installation again, then before the installer asks you to launch the web browser to complete the installation, you will need to edit: classes/modules/install/InstallSchema_1037A.class.php
Around line 152 you will see:
Code: Select all
$pclf->getByCompanyId( $c_obj->getId() );
Code: Select all
$pclf->getByCompanyId( $c_obj->getId(), NULL, NULL, NULL, array( 'name' => 'asc' ) );
-
- Posts: 15
- Joined: Sun Feb 28, 2010 3:59 pm
Re: 3.3.1 Install hangs
I followed your instructions but am still getting the same result as I did originally, it is stalling at 55%.
Re: 3.3.1 Install hangs
Its possible something else is happening. Can you check your error logs to see if any helpful information is being written to them?
-
- Posts: 15
- Joined: Sun Feb 28, 2010 3:59 pm
Re: 3.3.1 Install hangs
This is what I am getting:
[Tue Jan 11 18:01:02 2011] [error] [client 127.0.0.1] PHP Fatal error: Uncaught exception 'ADODB_Exception' with message 'postgres7 error: [-18: ERROR: relation "system_log_detail" does not exist] in adodb_throw(INSERT INTO system_log_detail(SYSTEM_LOG_ID,FIELD,NEW_VALUE,OLD_VALUE) VALUES(?,?,?,?), Array)\n' in C:\\Program Files\\TimeTrex\\timetrex\\classes\\adodb\\adodb-exceptions.inc.php:78\nStack trace:\n#0 C:\\Program Files\\TimeTrex\\timetrex\\classes\\adodb\\adodb.inc.php(227): adodb_throw('postgres7', 'adodb_throw', -18, 'ERROR: relatio...', 'INSERT INTO sys...', Array, Object(ADODB_postgres7))\n#1 C:\\Program Files\\TimeTrex\\timetrex\\classes\\adodb\\adodb.inc.php(1037): ADODB_TransMonitor('postgres7', 'EXECUTE', -18, 'ERROR: relatio...', 'INSERT INTO sys...', Array, Object(ADODB_postgres7))\n#2 C:\\Program Files\\TimeTrex\\timetrex\\classes\\adodb\\adodb.inc.php(1008): ADOConnection->_Execute('INSERT INTO sys...', Array)\n#3 C:\\Program Files\\TimeTrex\\timetrex\\classes\\modules\\core\\LogDetailFactory.class.php(1482): ADOConnection->Execute('INSERT INTO sys...', Array)\n#4 C:\\Program Files\\TimeTrex\\ti in C:\\Program Files\\TimeTrex\\timetrex\\classes\\adodb\\adodb-exceptions.inc.php on line 78, referer: http://localhost:8085/interface/install ... nstaller=1
[Tue Jan 11 18:01:02 2011] [error] [client 127.0.0.1] PHP Fatal error: Uncaught exception 'ADODB_Exception' with message 'postgres7 error: [-18: ERROR: relation "system_log_detail" does not exist] in adodb_throw(INSERT INTO system_log_detail(SYSTEM_LOG_ID,FIELD,NEW_VALUE,OLD_VALUE) VALUES(?,?,?,?), Array)\n' in C:\\Program Files\\TimeTrex\\timetrex\\classes\\adodb\\adodb-exceptions.inc.php:78\nStack trace:\n#0 C:\\Program Files\\TimeTrex\\timetrex\\classes\\adodb\\adodb.inc.php(227): adodb_throw('postgres7', 'adodb_throw', -18, 'ERROR: relatio...', 'INSERT INTO sys...', Array, Object(ADODB_postgres7))\n#1 C:\\Program Files\\TimeTrex\\timetrex\\classes\\adodb\\adodb.inc.php(1037): ADODB_TransMonitor('postgres7', 'EXECUTE', -18, 'ERROR: relatio...', 'INSERT INTO sys...', Array, Object(ADODB_postgres7))\n#2 C:\\Program Files\\TimeTrex\\timetrex\\classes\\adodb\\adodb.inc.php(1008): ADOConnection->_Execute('INSERT INTO sys...', Array)\n#3 C:\\Program Files\\TimeTrex\\timetrex\\classes\\modules\\core\\LogDetailFactory.class.php(1482): ADOConnection->Execute('INSERT INTO sys...', Array)\n#4 C:\\Program Files\\TimeTrex\\ti in C:\\Program Files\\TimeTrex\\timetrex\\classes\\adodb\\adodb-exceptions.inc.php on line 78, referer: http://localhost:8085/interface/install ... nstaller=1
Re: 3.3.1 Install hangs
That looks like an error you might get trying to login to TimeTrex before the database has been upgraded to the latest version, but not an error you would get during the upgrade process itself.
-
- Posts: 15
- Joined: Sun Feb 28, 2010 3:59 pm
Re: 3.3.1 Install hangs
That's the error I get every time I try to complete the set up process. What should I do now?
Re: 3.3.1 Install hangs
I would recommend trying to restore from your most recent backup and waiting for v3.3.2 to be released before upgrading.
Re: 3.3.1 Install hangs
Shaun -shaunw wrote:I would recommend trying to restore from your most recent backup and waiting for v3.3.2 to be released before upgrading.
Any update on when we can expect 3.3.2?
Re: 3.3.1 Install hangs
Yup, its being mirrored onto the servers today.
Re: 3.3.1 Install hangs
Wow! Had I know that all it took as to ask, I would have asked earlier in the week
I just installed it, and checked that the Maryland tax rate appears to be calculating correctly.
I just entered the county percentage in the box (3.2), and the pay stub looks correct.
Thanks.
I just installed it, and checked that the Maryland tax rate appears to be calculating correctly.
I just entered the county percentage in the box (3.2), and the pay stub looks correct.
Thanks.
Re: 3.3.1 Install hangs
Excellent, thanks for the update.
-
- Posts: 15
- Joined: Sun Feb 28, 2010 3:59 pm
Re: 3.3.1 Install hangs
I tried installing 3.3.2 this evening (after successfully restoring my old version), and I got the same problem, upgrading database stalled at 54%. So I completely uninstalled everything and did a clean install of 3.3.2, then restore my database using the instruction at http://www.timetrex.com/wiki/index.php/ ... _Questions under "How do I migrate TimeTrex On-Site from one computer to another?" and the same thing happens. I guess I have no choice but to do another clean install and manually replace all my configuration and start all over again (fortunately there is only one employee. Unless you have another suggestion.
Re: 3.3.1 Install hangs
Thats strange, it sounds like there is something odd with your database to begin with.
To figure out exactly whats going on, try following the instructions here:
http://forums.timetrex.com/viewtopic.php?p=8170#p8170
That should output the debug log to the progress bar frame when it hangs at 54%. Once we have that information we can hopefully move forward on finding you a solution.
To figure out exactly whats going on, try following the instructions here:
http://forums.timetrex.com/viewtopic.php?p=8170#p8170
That should output the debug log to the progress bar frame when it hangs at 54%. Once we have that information we can hopefully move forward on finding you a solution.
-
- Posts: 15
- Joined: Sun Feb 28, 2010 3:59 pm
Re: 3.3.1 Install hangs
(postgres7): select datname from pg_database where datname not in ('template0','template1') order by 1
(postgres7): select tablename,'T' from pg_tables where tablename not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') union select viewname,'V' from pg_views where viewname not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema')
C:\Program Files\TimeTrex\cache\/9b/adodb_9bfe6a1c139c82942026e34ad0c3c70c.cache cache failure: C:\Program Files\TimeTrex\cache\/9b/adodb_9bfe6a1c139c82942026e34ad0c3c70c.cache file/URL not found (see sql below)
(postgres7): select * from company where id = -1
(postgres7): select * from company WHERE deleted = 0 order by status_id asc,name asc
-Paul
(postgres7): select tablename,'T' from pg_tables where tablename not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema') union select viewname,'V' from pg_views where viewname not like 'pg\_%' and schemaname not in ( 'pg_catalog','information_schema')
C:\Program Files\TimeTrex\cache\/9b/adodb_9bfe6a1c139c82942026e34ad0c3c70c.cache cache failure: C:\Program Files\TimeTrex\cache\/9b/adodb_9bfe6a1c139c82942026e34ad0c3c70c.cache file/URL not found (see sql below)
(postgres7): select * from company where id = -1
(postgres7): select * from company WHERE deleted = 0 order by status_id asc,name asc
-Paul
Re: 3.3.1 Install hangs
There should be much more debug text then that, usually around 5-20 pages worth.
-
- Posts: 15
- Joined: Sun Feb 28, 2010 3:59 pm
Re: 3.3.1 Install hangs
That's all the code I see, and it's at the top of the page, not in the progress bar frame. In fact all I see in the progress bar frame are the words "Upgrading database, please wait... " I don't even see the progress bar itself any longer.
Paul
Paul
Re: 3.3.1 Install hangs
You may have turned the debug verbosity in your timetrex.ini.php to 11, which it should only be 10. The database schema debug verbosity should be 11 though.
If you right click on the area where the progress bar used to be, its a iframe, so you can view the source of the just the iframe and that might show you more information.
If you right click on the area where the progress bar used to be, its a iframe, so you can view the source of the just the iframe and that might show you more information.
-
- Posts: 15
- Joined: Sun Feb 28, 2010 3:59 pm
Re: 3.3.1 Install hangs
After setting everything under Debug to True, in addition to the code I mentioned previously, I now see below the status bar:
Debug Buffer
============================================================================
Memory Usage: 6469992 Buffer Size: 18
----------------------------------------------------------------------------
DEBUG [161]: TTDate::setTimeZone(): Setting TimeZone: America/New_York
DEBUG [80]: [Function](): Bypassing Authentication
DEBUG [419]: TTi18n::chooseBestLocale(): Choosing Best Locale...
DEBUG [427]: TTi18n::chooseBestLocale(): Using Language from cookie: en_US
DEBUG [334]: TTi18n::setLocale(): Generated/Passed In Locale: en_US
DEBUG [270]: TTi18n::generateLocale(): Array of Locales to try in order for "en_US": en_US,en
DEBUG [220]: TTi18n::tryLocale(): Found valid windows locale: English_United States.1252 Linux locale: en_US
DEBUG [228]: TTi18n::tryLocale(): Found valid locale: en_US
DEBUG [340]: TTi18n::setLocale(): Attempting to set Locale(s) to: en_US Category: 0 Current Locale:
DEBUG [343]: TTi18n::setLocale(): Setting currency/numeric Locale to: en_US
DEBUG [356]: TTi18n::setLocale(): Setting translator to normalized locale: en_US
DEBUG [376]: TTi18n::setLocale(): Set Master Locale To: en_US
DEBUG [492]: TTi18n::chooseBestLocale(): Using Locale: en_US
DEBUG [107]: Install::isInstallMode(): Install Mode is ON
DEBUG [293]: Install::checkDatabaseExists(): Database Name: timetrex
DEBUG [303]: Install::checkDatabaseExists(): Exists - Database Name: timetrex
DEBUG [335]: Install::checkTableExists(): Table Name: company
DEBUG [345]: Install::checkTableExists(): Exists - Table Name: company
============================================================================
============================================================================
PROFILER OUTPUT
============================================================================
Calls Time Routine
-----------------------------------------------------------------------------
1 469.4681 ms (73.60 %) Main
13 10.4136 ms (1.63 %) __autoload
1 10.1869 ms (1.60 %) getEmptyRecordSet()
1 146.8849 ms (23.03 %) unprofiled
0.8914 ms (0.14 %) Missed
============================================================================
637.8450 ms (100.00 %) OVERALL TIME
Debug Buffer
============================================================================
Memory Usage: 6469992 Buffer Size: 18
----------------------------------------------------------------------------
DEBUG [161]: TTDate::setTimeZone(): Setting TimeZone: America/New_York
DEBUG [80]: [Function](): Bypassing Authentication
DEBUG [419]: TTi18n::chooseBestLocale(): Choosing Best Locale...
DEBUG [427]: TTi18n::chooseBestLocale(): Using Language from cookie: en_US
DEBUG [334]: TTi18n::setLocale(): Generated/Passed In Locale: en_US
DEBUG [270]: TTi18n::generateLocale(): Array of Locales to try in order for "en_US": en_US,en
DEBUG [220]: TTi18n::tryLocale(): Found valid windows locale: English_United States.1252 Linux locale: en_US
DEBUG [228]: TTi18n::tryLocale(): Found valid locale: en_US
DEBUG [340]: TTi18n::setLocale(): Attempting to set Locale(s) to: en_US Category: 0 Current Locale:
DEBUG [343]: TTi18n::setLocale(): Setting currency/numeric Locale to: en_US
DEBUG [356]: TTi18n::setLocale(): Setting translator to normalized locale: en_US
DEBUG [376]: TTi18n::setLocale(): Set Master Locale To: en_US
DEBUG [492]: TTi18n::chooseBestLocale(): Using Locale: en_US
DEBUG [107]: Install::isInstallMode(): Install Mode is ON
DEBUG [293]: Install::checkDatabaseExists(): Database Name: timetrex
DEBUG [303]: Install::checkDatabaseExists(): Exists - Database Name: timetrex
DEBUG [335]: Install::checkTableExists(): Table Name: company
DEBUG [345]: Install::checkTableExists(): Exists - Table Name: company
============================================================================
============================================================================
PROFILER OUTPUT
============================================================================
Calls Time Routine
-----------------------------------------------------------------------------
1 469.4681 ms (73.60 %) Main
13 10.4136 ms (1.63 %) __autoload
1 10.1869 ms (1.60 %) getEmptyRecordSet()
1 146.8849 ms (23.03 %) unprofiled
0.8914 ms (0.14 %) Missed
============================================================================
637.8450 ms (100.00 %) OVERALL TIME
Re: 3.3.1 Install hangs
Unfortunately you're not providing us with the proper debug information. I would recommend purchasing a support package so one of our support representatives and login to your computer and correct the issue for you.
-
- Posts: 15
- Joined: Sun Feb 28, 2010 3:59 pm
Re: 3.3.1 Install hangs
I've done everything exactly as you said. Could you please inform me how I can derive additional debug information? All I'm trying to do is upgrade the software so I can get the new tables for 2011. It shouldn't be this difficult.