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