3.3.1 Install hangs

Ask your questions regarding TimeTrex installation here.
ironmonger
Posts: 15
Joined: Sun Feb 28, 2010 3:59 pm

3.3.1 Install hangs

Post by ironmonger »

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.
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: 3.3.1 Install hangs

Post by shaunw »

What version did you try to upgrade from?
ironmonger
Posts: 15
Joined: Sun Feb 28, 2010 3:59 pm

Re: 3.3.1 Install hangs

Post by ironmonger »

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.
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: 3.3.1 Install hangs

Post by shaunw »

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.
ironmonger
Posts: 15
Joined: Sun Feb 28, 2010 3:59 pm

Re: 3.3.1 Install hangs

Post by ironmonger »

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?
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: 3.3.1 Install hangs

Post by shaunw »

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:

Code: Select all

$pclf->getByCompanyId( $c_obj->getId() );
Change the entire line to:

Code: Select all

$pclf->getByCompanyId( $c_obj->getId(), NULL, NULL, NULL, array( 'name' => 'asc' ) ); 
Once the change is done, save the file and continue with the installation in the web browser.
ironmonger
Posts: 15
Joined: Sun Feb 28, 2010 3:59 pm

Re: 3.3.1 Install hangs

Post by ironmonger »

I followed your instructions but am still getting the same result as I did originally, it is stalling at 55%.
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: 3.3.1 Install hangs

Post by shaunw »

Its possible something else is happening. Can you check your error logs to see if any helpful information is being written to them?
ironmonger
Posts: 15
Joined: Sun Feb 28, 2010 3:59 pm

Re: 3.3.1 Install hangs

Post by ironmonger »

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
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: 3.3.1 Install hangs

Post by shaunw »

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.
ironmonger
Posts: 15
Joined: Sun Feb 28, 2010 3:59 pm

Re: 3.3.1 Install hangs

Post by ironmonger »

That's the error I get every time I try to complete the set up process. What should I do now?
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: 3.3.1 Install hangs

Post by shaunw »

I would recommend trying to restore from your most recent backup and waiting for v3.3.2 to be released before upgrading.
noamparn
Posts: 115
Joined: Thu Aug 27, 2009 9:17 am

Re: 3.3.1 Install hangs

Post by noamparn »

shaunw wrote:I would recommend trying to restore from your most recent backup and waiting for v3.3.2 to be released before upgrading.
Shaun -
Any update on when we can expect 3.3.2?
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: 3.3.1 Install hangs

Post by shaunw »

Yup, its being mirrored onto the servers today.
noamparn
Posts: 115
Joined: Thu Aug 27, 2009 9:17 am

Re: 3.3.1 Install hangs

Post by noamparn »

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.
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: 3.3.1 Install hangs

Post by shaunw »

Excellent, thanks for the update.
ironmonger
Posts: 15
Joined: Sun Feb 28, 2010 3:59 pm

Re: 3.3.1 Install hangs

Post by ironmonger »

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.
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: 3.3.1 Install hangs

Post by shaunw »

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.
ironmonger
Posts: 15
Joined: Sun Feb 28, 2010 3:59 pm

Re: 3.3.1 Install hangs

Post by ironmonger »

(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
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: 3.3.1 Install hangs

Post by shaunw »

There should be much more debug text then that, usually around 5-20 pages worth.
ironmonger
Posts: 15
Joined: Sun Feb 28, 2010 3:59 pm

Re: 3.3.1 Install hangs

Post by ironmonger »

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
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: 3.3.1 Install hangs

Post by shaunw »

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.
ironmonger
Posts: 15
Joined: Sun Feb 28, 2010 3:59 pm

Re: 3.3.1 Install hangs

Post by ironmonger »

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
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: 3.3.1 Install hangs

Post by shaunw »

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.
ironmonger
Posts: 15
Joined: Sun Feb 28, 2010 3:59 pm

Re: 3.3.1 Install hangs

Post by ironmonger »

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.
Locked