Upgrade from v5.3.3 to v7.3.5 fails

Ask your questions regarding TimeTrex installation here.
Locked
sgrzy01
Posts: 2
Joined: Wed Apr 30, 2014 1:45 pm

Upgrade from v5.3.3 to v7.3.5 fails

Post by sgrzy01 »

Did an upgrade of community and all appeared to go well.

But when you login as admin it goes from Processing->Downloading->Network Timeout and and SQL error is registered on the console (from where i started TT) and in the log...

Can't proceed....

Any help would be appreciated...

Attached are the v5.3.3 timetrex.ini.php and log from v7.3.5 when error happens:

Code: Select all

From v5.3.3-20130328.2 to v7.3.5-20130328.2

Error once upgrade is complete
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Appears when loggining into the GUI

TimeTrex@li287-83:~$ ./TimeTrex/stop
Syntax OK
/home/TimeTrex/TimeTrex/apache2/scripts/ctl.sh : httpd stopped
/home/TimeTrex/TimeTrex/postgresql/scripts/ctl.sh : postgresql stopped
TimeTrex@li287-83:~$ ./TimeTrex/start
LOG:  database system was shut down at 2014-04-25 08:04:21 EDT
LOG:  autovacuum launcher started
LOG:  database system is ready to accept connections
/home/TimeTrex/TimeTrex/postgresql/scripts/ctl.sh : postgresql  started at port 5433
Syntax OK
/home/TimeTrex/TimeTrex/apache2/scripts/ctl.sh : httpd started at port 8085
TimeTrex@li287-83:~$ ERROR:  relation "user_setting" does not exist
STATEMENT:  select	*
							from	user_setting
							where	user_id =  $1
								AND	name =  $2
								AND deleted = 0
From v5.3.3 before upgrade
~~~~~~~~~~~~~~~~~~~~~~~~~~

TimeTrex@li287-83:~/TimeTrex/timetrex$ cat timetrex.ini.php
; 
; 
; TimeTrex Configuration File
; *Linux* Example
; 
; 
; 
; System paths. NO TRAILING SLASHES!
; 

[path]
; URL to TimeTrex web root directory. ie: http://your.domain.com/<*BASE_URL*>
; DO NOT INCLUDE http://your.domain.com, just the directory AFTER your domain
base_url=/interface
; 
; log directory
; 
; Linux
log=/home/TimeTrex/TimeTrex/log
; 
; Full path and name to the PHP CLI Binary
; 
; Linux
php_cli=/home/TimeTrex/TimeTrex/php/bin/php
; 
; Misc storage, for attachments/images
; 
; Linux
storage=/home/TimeTrex/TimeTrex/storage

; 
; Database connection settings. These can be set from the installer.
; 

[database]
database_name=timetrex
; type = postgres8
host=localhost:5433
password=e7290506b
type=postgres8
user=timetrex

; 
; Email delivery settings.
; 

[mail]
; Least setup, deliver email through TimeTrex's email relay via SOAP (HTTP port 80)
delivery_method=soap

; Deliver email through local sendmail command specified in php.ini
; delivery_method = mail
; Deliver email through remote SMTP server with the following settings.
; delivery_method = smtp
; smtp_host=smtp.gmail.com
; smtp_port=587
; smtp_username=timetrex@gmail.com
; smtp_password=testpass123
; 
; Cache settings
; 

[cache]
; Linux
dir=/home/TimeTrex/TimeTrex/cache
enable=TRUE

[debug]
buffer_output=TRUE
enable=TRUE
enable_display=TRUE
enable_log=TRUE
; Set to false if you're debugging
production=TRUE
verbosity=10

[other]
; Force all clients to use SSL.
force_ssl=FALSE
hostname=localhost
installer_enabled=TRUE
primary_company_id=1
; WARNING: DO NOT CHANGE THIS AFTER YOU HAVE INSTALLED TIMETREX.
; If you do it will cause all your passwords to become invalid,
; and you may lose access to some encrypted data.
salt=8dc737a83d72f7113bbc585553f7d756
7_3_5_log.tar.gz
Log after upgrade when error happens
(13.42 KiB) Downloaded 361 times
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Upgrade from v5.3.3 to v7.3.5 fails

Post by shaunw »

Please make sure you completed both stages of the install/upgrade process. The first stage just copies the files and directs you to open your web browser to complete the 2nd stage which upgrades your database. Both must be completed otherwise you see errors like you are seeing.
sgrzy01
Posts: 2
Joined: Wed Apr 30, 2014 1:45 pm

Re: Upgrade from v5.3.3 to v7.3.5 fails

Post by sgrzy01 »

Yup... 100% my fault...

Perhaps you can have the installer end by printing out that setup info from the readme for people who are being careless like myslef..

ie:

Code: Select all

.
.
.
Installation Done....
Before you can use the TimeTrex, regardless if this is a new install or an upgrade, you MUST:

Edit timetrex.ini.php in your new or existing TimeTrex directory and set/confirm:
	installer_enabled = TRUE
Point your web browser to:
	http://<web server address>/<timetrex directory>/interface/install/install.php
	ie: http://localhost/timetrex/interface/install/install.php

to complete the setup of a new or upgraded installation.
just my 2c

Thanx for the help
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Upgrade from v5.3.3 to v7.3.5 fails

Post by shaunw »

The automated installer does display a message at the end, as well it automatically opens the web browser for you and takes you to the place you need to be as long as you don't explicitly tell it not too.
Locked