Yet another frozen install problem

Ask your questions regarding TimeTrex installation here.
Locked
dgilkey
Posts: 4
Joined: Wed Apr 21, 2010 12:08 pm

Yet another frozen install problem

Post by dgilkey »

Ok doing the expert install and the installation freezes at 1% I have tried using MYSQL, Postgres, and both the latest stable and development releases of timetrex.

My server stats:
Cent Os 5.4
PHP 5.1.6
Postgres 8.4
MySQL 5.1
Apache 2.2

3. Database Configuration




Initializing database, please wait...




Server response time: 0.420 seconds.
Copyright © 2010 TimeTrex-Debug. The Program is provided AS IS, without warranty. Licensed under AGPLv3.
This program is free software; you can redistribute it and/or modify it under the terms of the
GNU Affero General Public License version 3 as published by the Free Software Foundation including the additional permission set forth in the source code header.



Debug Buffer
============================================================================
Memory Usage: 5003704 Buffer Size: 18
----------------------------------------------------------------------------
DEBUG [130]: TTDate::setTimeZone(): Setting TimeZone: America/Los_Angeles
DEBUG [80]: [Function](): Bypassing Authentication
DEBUG [419]: TTi18n::chooseBestLocale(): Choosing Best Locale...
DEBUG [390]: TTi18n::getBrowserLanguage(): HTTP_ACCEPT_LANGUAGE: en-us
DEBUG [473]: TTi18n::chooseBestLocale(): cSetting Locale: 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_US.UTF-8,en,en.UTF-8
DEBUG [228]: TTi18n::tryLocale(): Found valid locale: en_US
DEBUG [340]: TTi18n::setLocale(): Attempting to set Locale(s) to: en_US Category: 6 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 [349]: Install::checkTableExists(): Does not Exist - Table Name: company
============================================================================

============================================================================
PROFILER OUTPUT
============================================================================
Calls Time Routine
-----------------------------------------------------------------------------
1 292.1617 ms (70.24 %) Main
12 41.8611 ms (10.06 %) __autoload
1 81.2416 ms (19.53 %) unprofiled

0.6876 ms (0.17 %) Missed
============================================================================
415.9520 ms (100.00 %) OVERALL TIME
============================================================================


PHP Version: OK (v5.1.6)
PHP Requirements
Database Engine: OK
BCMATH Enabled: OK
GETTEXT Enabled: OK
CALENDAR Enabled: OK
SOAP Enabled: OK
GD Enabled: OK
SimpleXML Enabled: OK
MAIL Enabled: OK
PEAR Enabled: OK
Safe Mode Turned Off: OK
Magic Quotes GPC Turned Off: OK
Memory Limit: OK(128M)
Other Requirements
Writable TimeTrex-Debug Configuration File (timetrex.ini.php): OK
Writable Cache Directory: OK
Writable Storage Directory: OK
Writable Log Directory: OK
Empty Cache Directory: OK

Your TimeTrex-Debug configuration file (timetrex.ini.php) is located at:
/var/www/html/timetrex/includes/../timetrex.ini.php

Your PHP configuration file (php.ini) is located at:
/etc/php.ini, the include path is: ""

Detailed PHP Information


PHP Version 5.1.6

System Linux localhost.localdomain 2.6.18-164.el5xen #1 SMP Thu Sep 3 04:47:32 EDT 2009 i686
Build Date Jan 13 2010 17:14:42
Configure Command './configure' '--build=i686-redhat-linux-gnu' '--host=i686-redhat-linux-gnu' '--target=i386-redhat-linux-gnu' '--program-prefix=' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/usr/com' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--cache-file=../config.cache' '--with-libdir=lib' '--with-config-file-path=/etc' '--with-config-file-scan-dir=/etc/php.d' '--disable-debug' '--with-pic' '--disable-rpath' '--without-pear' '--with-bz2' '--with-curl' '--with-exec-dir=/usr/bin' '--with-freetype-dir=/usr' '--with-png-dir=/usr' '--enable-gd-native-ttf' '--without-gdbm' '--with-gettext' '--with-gmp' '--with-iconv' '--with-jpeg-dir=/usr' '--with-openssl' '--with-png' '--with-pspell' '--with-expat-dir=/usr' '--with-pcre-regex=/usr' '--with-zlib' '--with-layout=GNU' '--enable-exif' '--enable-ftp' '--enable-magic-quotes' '--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-sysvmsg' '--enable-track-vars' '--enable-trans-sid' '--enable-yp' '--enable-wddx' '--with-kerberos' '--enable-ucd-snmp-hack' '--with-unixODBC=shared,/usr' '--enable-memory-limit' '--enable-shmop' '--enable-calendar' '--enable-dbx' '--enable-dio' '--with-mime-magic=/usr/share/file/magic.mime' '--without-sqlite' '--with-libxml-dir=/usr' '--with-xml' '--with-system-tzdata' '--with-apxs2=/usr/sbin/apxs' '--without-mysql' '--without-gd' '--without-odbc' '--disable-dom' '--disable-dba' '--without-unixODBC' '--disable-pdo' '--disable-xmlreader' '--disable-xmlwriter'
Server API Apache 2.0 Handler
Virtual Directory Support disabled
Configuration File (php.ini) Path /etc/php.ini
Scan this dir for additional .ini files /etc/php.d
additional .ini files parsed /etc/php.d/bcmath.ini, /etc/php.d/dbase.ini, /etc/php.d/gd.ini, /etc/php.d/mysql.ini, /etc/php.d/mysqli.ini, /etc/php.d/pdo.ini, /etc/php.d/pdo_mysql.ini, /etc/php.d/pdo_sqlite.ini, /etc/php.d/soap.ini
PHP API 20041225
PHP Extension 20050922
Zend Extension 220051025
Debug Build no
Thread Safety disabled
Zend Memory Manager enabled
IPv6 Support enabled
Registered PHP Streams php, file, http, ftp, compress.bzip2, compress.zlib, https, ftps
Registered Stream Socket Transports tcp, udp, unix, udg, ssl, sslv3, sslv2, tls
Registered Stream Filters string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed, convert.iconv.*, bzip2.*, zlib.*

This program makes use of the Zend Scripting Language Engine:
Zend Engine v2.1.0, Copyright (c) 1998-2006 Zend Technologies



--------------------------------------------------------------------------------

PHP Credits

--------------------------------------------------------------------------------

Configuration
PHP Core
Directive Local Value Master Value
allow_call_time_pass_reference Off Off
allow_url_fopen On On
always_populate_raw_post_data Off Off
arg_separator.input & &
arg_separator.output & &
asp_tags Off Off
auto_append_file no value no value
auto_globals_jit On On
auto_prepend_file no value no value
browscap no value no value
default_charset no value no value
default_mimetype text/html text/html
define_syslog_variables Off Off
disable_classes no value no value
disable_functions no value no value
display_errors On Off
display_startup_errors Off Off
doc_root no value no value
docref_ext no value no value
docref_root no value no value
enable_dl On On
error_append_string no value no value
error_log no value no value
error_prepend_string no value no value
error_reporting 2047 2047
expose_php On On
extension_dir /usr/lib/php/modules /usr/lib/php/modules
file_uploads On On
highlight.bg #FFFFFF #FFFFFF
highlight.comment #FF8000 #FF8000
highlight.default #0000BB #0000BB
highlight.html #000000 #000000
highlight.keyword #007700 #007700
highlight.string #DD0000 #DD0000
html_errors On On
ignore_repeated_errors Off Off
ignore_repeated_source Off Off
ignore_user_abort Off Off
implicit_flush Off Off
include_path /var/www/html/timetrex/classes/modules/core/../../../classes/modules/core:/var/www/html/timetrex/classes/modules/core/../../../classes:.:/usr/share/pear:/usr/share/php:/var/www/html/timetrex/classes/modules/core/../../../classes/pear .:/usr/share/pear:/usr/share/php
log_errors On On
log_errors_max_len 1024 1024
magic_quotes_gpc Off Off
magic_quotes_runtime Off Off
magic_quotes_sybase Off Off
mail.force_extra_parameters no value no value
max_execution_time 1800 30
max_file_uploads 20 20
max_input_nesting_level 64 64
max_input_time 60 60
memory_limit 128M 128M
open_basedir no value no value
output_buffering 4096 4096
output_handler no value no value
post_max_size 8M 8M
precision 14 14
realpath_cache_size 16K 16K
realpath_cache_ttl 120 120
register_argc_argv Off Off
register_globals Off Off
register_long_arrays Off Off
report_memleaks On On
report_zend_debug On On
safe_mode Off Off
safe_mode_exec_dir no value no value
safe_mode_gid Off Off
safe_mode_include_dir no value no value
sendmail_from no value no value
sendmail_path /usr/sbin/sendmail -t -i /usr/sbin/sendmail -t -i
serialize_precision 100 100
short_open_tag On On
SMTP localhost localhost
smtp_port 25 25
sql.safe_mode Off Off
track_errors On Off
unserialize_callback_func no value no value
upload_max_filesize 2M 2M
upload_tmp_dir no value no value
user_dir no value no value
variables_order EGPCS EGPCS
xmlrpc_error_number 0 0
xmlrpc_errors Off Off
y2k_compliance On On
zend.ze1_compatibility_mode Off Off


apache2handler
Apache Version Apache/2.2.3 (CentOS)
Apache API Version 20051115
Server Administrator root@localhost
Hostname:Port localhost.localdomain:0
User/Group apache(48)/48
Max Requests Per Child: 4000 - Keep Alive: off - Max Per Connection: 100
Timeouts Connection: 120 - Keep-Alive: 15
Virtual Server No
Server Root /etc/httpd
Loaded Modules core prefork http_core mod_so mod_auth_basic mod_auth_digest mod_authn_file mod_authn_alias mod_authn_anon mod_authn_dbm mod_authn_default mod_authz_host mod_authz_user mod_authz_owner mod_authz_groupfile mod_authz_dbm mod_authz_default util_ldap mod_authnz_ldap mod_include mod_log_config mod_logio mod_env mod_ext_filter mod_mime_magic mod_expires mod_deflate mod_headers mod_usertrack mod_setenvif mod_mime mod_dav mod_status mod_autoindex mod_info mod_dav_fs mod_vhost_alias mod_negotiation mod_dir mod_actions mod_speling mod_userdir mod_alias mod_rewrite mod_proxy mod_proxy_balancer mod_proxy_ftp mod_proxy_http mod_proxy_connect mod_cache mod_suexec mod_disk_cache mod_file_cache mod_mem_cache mod_cgi mod_version mod_php5 mod_proxy_ajp

Directive Local Value Master Value
engine 1 1
last_modified 0 0
xbithack 0 0


Apache Environment
Variable Value
HTTP_ACCEPT image/gif, image/jpeg, image/pjpeg, image/pjpeg, application/x-shockwave-flash, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, application/x-ms-application, application/x-ms-xbap, application/vnd.ms-xpsdocument, application/xaml+xml, */*
HTTP_REFERER http://192.168.1.32/timetrex/interface/ ... nstaller=0
HTTP_ACCEPT_LANGUAGE en-us
HTTP_USER_AGENT Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; InfoPath.2; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)
HTTP_ACCEPT_ENCODING gzip, deflate
HTTP_IF_MODIFIED_SINCE Tue, 20 Apr 2010 18:37:05 GMT
HTTP_HOST 192.168.1.32
HTTP_CONNECTION Keep-Alive
HTTP_COOKIE __utmc=257821131; __utmv=257821131.Version%3A%203.1.0-rc1; __utma=257821131.1436587714.1271482797.1271794944.1271878077.6; __utmz=257821131.1271482797.1.1.utmccn=(direct)|utmcsr=(direct)|utmcmd=(none); __utmb=257821131
PATH /sbin:/usr/sbin:/bin:/usr/bin
SERVER_SIGNATURE <address>Apache/2.2.3 (CentOS) Server at 192.168.1.32 Port 80</address>
SERVER_SOFTWARE Apache/2.2.3 (CentOS)
SERVER_NAME 192.168.1.32
SERVER_ADDR 192.168.1.32
SERVER_PORT 80
REMOTE_ADDR 192.168.1.144
DOCUMENT_ROOT /var/www/html
SERVER_ADMIN root@localhost
SCRIPT_FILENAME /var/www/html/timetrex/interface/install/Requirements.php
REMOTE_PORT 1760
GATEWAY_INTERFACE CGI/1.1
SERVER_PROTOCOL HTTP/1.1
REQUEST_METHOD GET
QUERY_STRING action:phpinfo=phpinfo
REQUEST_URI /timetrex/interface/install/Requirements.php?action:phpinfo=phpinfo
SCRIPT_NAME /timetrex/interface/install/Requirements.php


HTTP Headers Information
HTTP Request Headers
HTTP Request GET /timetrex/interface/install/Requirements.php?action:phpinfo=phpinfo HTTP/1.1
Accept image/gif, image/jpeg, image/pjpeg, image/pjpeg, application/x-shockwave-flash, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, application/x-ms-application, application/x-ms-xbap, application/vnd.ms-xpsdocument, application/xaml+xml, */*
Referer http://192.168.1.32/timetrex/interface/ ... nstaller=0
Accept-Language en-us
User-Agent Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; InfoPath.2; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)
Accept-Encoding gzip, deflate
If-Modified-Since Tue, 20 Apr 2010 18:37:05 GMT
Host 192.168.1.32
Connection Keep-Alive
Cookie __utmc=257821131; __utmv=257821131.Version%3A%203.1.0-rc1; __utma=257821131.1436587714.1271482797.1271794944.1271878077.6; __utmz=257821131.1271482797.1.1.utmccn=(direct)|utmcsr=(direct)|utmcmd=(none); __utmb=257821131
HTTP Response Headers
X-Powered-By PHP/5.1.6
Expires Mon, 26 Jul 1997 05:00:00 GMT
Last-Modified Wed, 21 Apr 2010 19:48:21 GMT
Cache-Control max-age=0
Pragma public


bcmath
BCMath support enabled


bz2
BZip2 Support Enabled
Stream Wrapper support compress.bz2://
Stream Filter support bzip2.decompress, bzip2.compress
BZip2 Version 1.0.3, 15-Feb-2005


calendar
Calendar support enabled


ctype
ctype functions enabled


curl
CURL support enabled
CURL Information libcurl/7.15.5 OpenSSL/0.9.8b zlib/1.2.3 libidn/0.6.5


date
date/time support enabled
Timezone Database Version 0.system
Timezone Database internal
Default timezone America/Los_Angeles

Directive Local Value Master Value
date.default_latitude 31.7667 31.7667
date.default_longitude 35.2333 35.2333
date.sunrise_zenith 90.583333 90.583333
date.sunset_zenith 90.583333 90.583333
date.timezone no value no value


exif
EXIF Support enabled
EXIF Version 1.4 $Id: exif.c,v 1.173.2.5 2006/04/10 18:23:24 helly Exp $
Supported EXIF Version 0220
Supported filetypes JPEG,TIFF


ftp
FTP support enabled


gd
GD Support enabled
GD Version bundled (2.0.28 compatible)
FreeType Support enabled
FreeType Linkage with freetype
FreeType Version 2.2.1
GIF Read Support enabled
GIF Create Support enabled
JPG Support enabled
PNG Support enabled
WBMP Support enabled
XBM Support enabled


gettext
GetText Support enabled


gmp
gmp support enabled


hash
hash support enabled
Hashing Engines md4 md5 sha1 sha256 sha384 sha512 ripemd128 ripemd160 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru gost adler32 crc32 crc32b haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5


iconv
iconv support enabled
iconv implementation glibc
iconv library version 2.5

Directive Local Value Master Value
iconv.input_encoding ISO-8859-1 ISO-8859-1
iconv.internal_encoding ISO-8859-1 ISO-8859-1
iconv.output_encoding ISO-8859-1 ISO-8859-1


libxml
libXML support active
libXML Version 2.6.26
libXML streams enabled


mime_magic
mime_magic support invalid magic file, disabled

Directive Local Value Master Value
mime_magic.debug Off Off
mime_magic.magicfile /usr/share/file/magic.mime /usr/share/file/magic.mime


mysql
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 5.0.77
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient

Directive Local Value Master Value
mysql.allow_persistent On On
mysql.connect_timeout 60 60
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off


mysqli
MysqlI Support enabled
Client API library version 5.0.77
Client API header version 5.0.77
MYSQLI_SOCKET /var/lib/mysql/mysql.sock

Directive Local Value Master Value
mysqli.default_host no value no value
mysqli.default_port 3306 3306
mysqli.default_pw no value no value
mysqli.default_socket no value no value
mysqli.default_user no value no value
mysqli.max_links Unlimited Unlimited
mysqli.reconnect Off Off


openssl
OpenSSL support enabled
OpenSSL Version OpenSSL 0.9.8e-fips-rhel5 01 Jul 2008


pcre
PCRE (Perl Compatible Regular Expressions) Support enabled
PCRE Library Version 6.6 06-Feb-2006


PDO
PDO support enabled
PDO drivers mysql, sqlite


pdo_mysql
PDO Driver for MySQL, client library version 5.0.77


pdo_sqlite
PDO Driver for SQLite 3.x enabled
PECL Module version 1.0.1 $Id: pdo_sqlite.c,v 1.10.2.6 2006/01/01 12:50:12 sniper Exp $
SQLite Library 3.3.6


pgsql
PostgreSQL Support enabled
PostgreSQL(libpq) Version 8.1.18
Multibyte character support enabled
SSL support enabled
Active Persistent Links 0
Active Links 0

Directive Local Value Master Value
pgsql.allow_persistent On On
pgsql.auto_reset_persistent Off Off
pgsql.ignore_notice Off Off
pgsql.log_notice Off Off
pgsql.max_links Unlimited Unlimited
pgsql.max_persistent Unlimited Unlimited


posix
Revision $Revision: 1.70.2.3 $


pspell
PSpell Support enabled


Reflection
Reflection enabled
Version $Id: php_reflection.c,v 1.164.2.33 2006/03/29 14:28:42 tony2001 Exp $


session
Session Support enabled
Registered save handlers files user
Registered serializer handlers php php_binary wddx

Directive Local Value Master Value
session.auto_start Off Off
session.bug_compat_42 Off Off
session.bug_compat_warn On On
session.cache_expire 180 180
session.cache_limiter nocache nocache
session.cookie_domain no value no value
session.cookie_lifetime 0 0
session.cookie_path / /
session.cookie_secure Off Off
session.entropy_file no value no value
session.entropy_length 0 0
session.gc_divisor 1000 1000
session.gc_maxlifetime 1440 1440
session.gc_probability 1 1
session.hash_bits_per_character 5 5
session.hash_function 0 0
session.name PHPSESSID PHPSESSID
session.referer_check no value no value
session.save_handler files files
session.save_path /var/lib/php/session /var/lib/php/session
session.serialize_handler php php
session.use_cookies On On
session.use_only_cookies Off Off
session.use_trans_sid 0 0


shmop
shmop support enabled


SimpleXML
Simplexml support enabled
Revision $Revision: 1.151.2.22 $
Schema support enabled


soap
Soap Client enabled
Soap Server enabled

Directive Local Value Master Value
soap.wsdl_cache 1 1
soap.wsdl_cache_dir /tmp /tmp
soap.wsdl_cache_enabled 1 1
soap.wsdl_cache_limit 5 5
soap.wsdl_cache_ttl 86400 86400


sockets
Sockets Support enabled


SPL
SPL support enabled
Interfaces Countable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject
Classes AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, DirectoryIterator, DomainException, EmptyIterator, FilterIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RuntimeException, SimpleXMLIterator, SplFileInfo, SplFileObject, SplObjectStorage, SplTempFileObject, UnderflowException, UnexpectedValueException


standard
Regex Library Bundled library enabled
Dynamic Library Support enabled
Path to sendmail /usr/sbin/sendmail -t -i

Directive Local Value Master Value
assert.active 1 1
assert.bail 0 0
assert.callback no value no value
assert.quiet_eval 0 0
assert.warning 1 1
auto_detect_line_endings 0 0
default_socket_timeout 5 60
safe_mode_allowed_env_vars PHP_ PHP_
safe_mode_protected_env_vars LD_LIBRARY_PATH LD_LIBRARY_PATH
url_rewriter.tags a=href,area=href,frame=src,input=src,form=fakeentry a=href,area=href,frame=src,input=src,form=fakeentry
user_agent no value no value


sysvmsg
sysvmsg support enabled
Revision $Revision: 1.20.2.3 $


tokenizer
Tokenizer Support enabled


wddx
WDDX Support enabled
WDDX Session Serializer enabled


xml
XML Support active
XML Namespace Support active
libxml2 Version 2.6.26


zlib
ZLib Support enabled
Stream Wrapper support compress.zlib://
Stream Filter support zlib.inflate, zlib.deflate
Compiled Version 1.2.3
Linked Version 1.2.3

Directive Local Value Master Value
zlib.output_compression Off Off
zlib.output_compression_level -1 -1
zlib.output_handler no value no value


Additional Modules
Module Name
dbase
sysvsem
sysvshm


Environment
Variable Value
TERM xterm
PATH /sbin:/usr/sbin:/bin:/usr/bin
PWD /
LANG en_US
SHLVL 2
_ /usr/sbin/httpd
TZ America/Los_Angeles
LANGUAGE en_US


PHP Variables
Variable Value
_REQUEST["action:phpinfo"] phpinfo
_REQUEST["__utmc"] 257821131
_REQUEST["__utmv"] 257821131.Version: 3.1.0-rc1
_REQUEST["__utma"] 257821131.1436587714.1271482797.1271794944.1271878077.6
_REQUEST["__utmz"] 257821131.1271482797.1.1.utmccn=(direct)|utmcsr=(direct)|utmcmd=(none)
_REQUEST["__utmb"] 257821131
_GET["action:phpinfo"] phpinfo
_COOKIE["__utmc"] 257821131
_COOKIE["__utmv"] 257821131.Version: 3.1.0-rc1
_COOKIE["__utma"] 257821131.1436587714.1271482797.1271794944.1271878077.6
_COOKIE["__utmz"] 257821131.1271482797.1.1.utmccn=(direct)|utmcsr=(direct)|utmcmd=(none)
_COOKIE["__utmb"] 257821131
_SERVER["HTTP_ACCEPT"] image/gif, image/jpeg, image/pjpeg, image/pjpeg, application/x-shockwave-flash, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, application/x-ms-application, application/x-ms-xbap, application/vnd.ms-xpsdocument, application/xaml+xml, */*
_SERVER["HTTP_REFERER"] http://192.168.1.32/timetrex/interface/ ... nstaller=0
_SERVER["HTTP_ACCEPT_LANGUAGE"] en-us
_SERVER["HTTP_USER_AGENT"] Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; InfoPath.2; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)
_SERVER["HTTP_ACCEPT_ENCODING"] gzip, deflate
_SERVER["HTTP_IF_MODIFIED_SINCE"] Tue, 20 Apr 2010 18:37:05 GMT
_SERVER["HTTP_HOST"] 192.168.1.32
_SERVER["HTTP_CONNECTION"] Keep-Alive
_SERVER["HTTP_COOKIE"] __utmc=257821131; __utmv=257821131.Version%3A%203.1.0-rc1; __utma=257821131.1436587714.1271482797.1271794944.1271878077.6; __utmz=257821131.1271482797.1.1.utmccn=(direct)|utmcsr=(direct)|utmcmd=(none); __utmb=257821131
_SERVER["PATH"] /sbin:/usr/sbin:/bin:/usr/bin
_SERVER["SERVER_SIGNATURE"] <address>Apache/2.2.3 (CentOS) Server at 192.168.1.32 Port 80</address>
_SERVER["SERVER_SOFTWARE"] Apache/2.2.3 (CentOS)
_SERVER["SERVER_NAME"] 192.168.1.32
_SERVER["SERVER_ADDR"] 192.168.1.32
_SERVER["SERVER_PORT"] 80
_SERVER["REMOTE_ADDR"] 192.168.1.144
_SERVER["DOCUMENT_ROOT"] /var/www/html
_SERVER["SERVER_ADMIN"] root@localhost
_SERVER["SCRIPT_FILENAME"] /var/www/html/timetrex/interface/install/Requirements.php
_SERVER["REMOTE_PORT"] 1760
_SERVER["GATEWAY_INTERFACE"] CGI/1.1
_SERVER["SERVER_PROTOCOL"] HTTP/1.1
_SERVER["REQUEST_METHOD"] GET
_SERVER["QUERY_STRING"] action:phpinfo=phpinfo
_SERVER["REQUEST_URI"] /timetrex/interface/install/Requirements.php?action:phpinfo=phpinfo
_SERVER["SCRIPT_NAME"] /timetrex/interface/install/Requirements.php
_SERVER["PHP_SELF"] /timetrex/interface/install/Requirements.php
_SERVER["REQUEST_TIME"] 1271879300
_ENV["TERM"] xterm
_ENV["PATH"] /sbin:/usr/sbin:/bin:/usr/bin
_ENV["PWD"] /
_ENV["LANG"] en_US
_ENV["SHLVL"] 2
_ENV["_"] /usr/sbin/httpd
_ENV["TZ"] America/Los_Angeles
_ENV["LANGUAGE"] en_US
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Yet another frozen install problem

Post by shaunw »

Can you edit interface/install/DatabaseSchema.php and around line 150 you will see:

Code: Select all

                //Need to create the tables after the database
                //exists and Database.inc.php has made a connection.
                //Otherwise we can't use objects yet.
                //Debug::setVerbosity(11);
                Debug::Text('Install Schema', __FILE__, __LINE__, __METHOD__,10);
Remove // from the line with:

Code: Select all

//Debug::setVerbosity(11);
Then re-run the installer. This should print all the debug information in a tiny little frame around the progress bar. You won't be able to see it all, but you can copy and paste it here, there should be several pages worth at least.
dgilkey
Posts: 4
Joined: Wed Apr 21, 2010 12:08 pm

Re: Yet another frozen install problem

Post by dgilkey »

No problem here you go:

(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')
--------------------------------------------------------------------------------

3. Database Configuration




Initializing database, please wait...




Server response time: 0.429 seconds.
Copyright © 2010 TimeTrex-Debug. The Program is provided AS IS, without warranty. Licensed under AGPLv3.
This program is free software; you can redistribute it and/or modify it under the terms of the
GNU Affero General Public License version 3 as published by the Free Software Foundation including the additional permission set forth in the source code header.



Debug Buffer
============================================================================
Memory Usage: 5222632 Buffer Size: 18
----------------------------------------------------------------------------
DEBUG [130]: TTDate::setTimeZone(): Setting TimeZone: America/Los_Angeles
DEBUG [80]: [Function](): Bypassing Authentication
DEBUG [419]: TTi18n::chooseBestLocale(): Choosing Best Locale...
DEBUG [390]: TTi18n::getBrowserLanguage(): HTTP_ACCEPT_LANGUAGE: en-us
DEBUG [473]: TTi18n::chooseBestLocale(): cSetting Locale: 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_US.UTF-8,en,en.UTF-8
DEBUG [228]: TTi18n::tryLocale(): Found valid locale: en_US
DEBUG [340]: TTi18n::setLocale(): Attempting to set Locale(s) to: en_US Category: 6 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 [349]: Install::checkTableExists(): Does not Exist - Table Name: company
============================================================================

============================================================================
PROFILER OUTPUT
============================================================================
Calls Time Routine
-----------------------------------------------------------------------------
1 302.1834 ms (71.02 %) Main
12 42.0902 ms (9.89 %) __autoload
1 80.5471 ms (18.93 %) unprofiled

0.6943 ms (0.16 %) Missed
============================================================================
425.5149 ms (100.00 %) OVERALL TIME
============================================================================
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Yet another frozen install problem

Post by shaunw »

Unfortunately thats not the correct debug information. If you have the debug verbosity set to 11 in your timetrex.ini.php file, you will need to change it to 10.

The debug output that we need will appear in the tiny little frame around the progress bar, and you will not be able to see it all. The only way to see it is to copy and paste it into a text editor, or right click on the progress bar and view source. (we would prefer the non-source version, but either way it will help)

This is separate from the debug information that is clearly visible at very the bottom of each page during the installation procedure.

Another possibility if you use FireFox web browser is to right click on the progress bar and open the frame in a new window/tab, then the debug text will be completely visible.
dgilkey
Posts: 4
Joined: Wed Apr 21, 2010 12:08 pm

Re: Yet another frozen install problem

Post by dgilkey »

Ok I attached the file because it was too big to post. See file attachment.
Attachments
debuglog.txt
(158.89 KiB) Downloaded 9630 times
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Yet another frozen install problem

Post by shaunw »

The issue appears to be a permission problem with your TimeTrex cache directory.
#1 DBError->__construct(ADODB_Exception Object ([dbms] => postgres7,[fn] => adodb_throw,[sql] => ,[params] => ,[host] => localhost,[database] => timetrex,[] => postgres7 error: [-32000: Cache write error] in adodb_throw(/tmp/timetrex//af/adodb_afe5452eb5f22400302e3b71dbb3629c.cache, select name,minute,hour,day_of_month,month,day_of_week,command,status_id,created_date,updated_date,id from cron where id = -1)
Though is somewhat odd as the Requirements page of the installer will warn you if the is a problem with your cache directory, you didn't happen to bypass this by chance did you?

Anyways, I recommend deleting all the files and directories from /tmp/timetrex/ and making sure that the user your web server runs as has full read/write permissions to this directory, as well that no other user creates files here, specifically if the TimeTrex maintenance jobs are being run from cron as a user other than your web server user.
dhananjay
Posts: 47
Joined: Thu Jan 20, 2011 2:28 pm

Re: Yet another frozen install problem

Post by dhananjay »

Running TimeTrex on a MS Windows SBS 2003. Upgraded from 3.0.8 to 3.3.1 when the upgrading database status bar stalled at 55%.

Then Installed 3.3.2 over the existing installation, which is now stalled at 54%.

I've posted the debug information below. Let me know is there's a preferred manner in which to post the debug information. I just enclosed it inside the code tags. Thanks!

Code: Select all

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
	54 %
(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')   (postgres7): select * from system_setting where name = ?   [ (name=>'schema_version_group_A') ] (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')   (postgres7): select * from system_setting where name = ?   [ (name=>'schema_version_group_T') ] (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')   (postgres7): select * from system_setting where name = ?   [ (name=>'schema_version_group_A') ] (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')   (postgres7): select * from system_setting where name = ?   [ (name=>'schema_version_group_T') ] (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')   (postgres7): select * from system_setting where name = ?   [ (name=>'schema_version_group_A') ] (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')   (postgres7): select * from system_setting where name = ?   [ (name=>'schema_version_group_T') ] (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')   (postgres7): select * from system_setting where name = ?   [ (name=>'schema_version_group_A') ] (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')   (postgres7): select * from system_setting where name = ?   [ (name=>'schema_version_group_T') ] (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')   (postgres7): select * from system_setting where name = ?   [ (name=>'schema_version_group_A') ] (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')   (postgres7): select * from system_setting where name = ?   [ (name=>'schema_version_group_T') ] (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')   (postgres7): select * from system_setting where name = ?   [ (name=>'schema_version_group_A') ] (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')   (postgres7): select * from system_setting where name = ?   [ (name=>'schema_version_group_T') ] (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')   (postgres7): select * from system_setting where name = ?   [ (name=>'schema_version_group_A') ] (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')   (postgres7): select * from system_setting where name = ?   [ (name=>'schema_version_group_T') ] (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')   (postgres7): select * from system_setting where name = ?   [ (name=>'schema_version_group_A') ] (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')   (postgres7): select * from system_setting where name = ?   [ (name=>'schema_version_group_T') ] (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')   (postgres7): select * from system_setting where name = ?   [ (name=>'schema_version_group_A') ] (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')   (postgres7): select * from system_setting where name = ?   [ (name=>'schema_version_group_T') ] (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')   (postgres7): select * from system_setting where name = ?   [ (name=>'schema_version_group_A') ] (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')   (postgres7): select * from system_setting where name = ?   [ (name=>'schema_version_group_T') ] (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')   (postgres7): select * from system_setting where name = ?   [ (name=>'schema_version_group_A') ] (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')   (postgres7): select * from system_setting where name = ?   [ (name=>'schema_version_group_T') ] (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')   (postgres7): select * from system_setting where name = ?   [ (name=>'schema_version_group_A') ] (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')   (postgres7): select * from system_setting where name = ?   [ (name=>'schema_version_group_T') ] (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')   (postgres7): select * from system_setting where name = ?   [ (name=>'schema_version_group_A') ] (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')   (postgres7): select * from system_setting where name = ?   [ (name=>'schema_version_group_T') ] (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')   (postgres7): select * from system_setting where name = ?   [ (name=>'schema_version_group_A') ] (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')   (postgres7): select * from system_setting where name = ?   [ (name=>'schema_version_group_T') ] (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')   (postgres7): select * from system_setting where name = ?   [ (name=>'schema_version_group_A') ] (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')   (postgres7): select * from system_setting where name = ?   [ (name=>'schema_version_group_T') ] (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')   (postgres7): select * from system_setting where name = ?   [ (name=>'schema_version_group_A') ] (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')   (postgres7): select * from system_setting where name = ?   [ (name=>'schema_version_group_T') ] (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'NL', 1277967600, 31278, 7.7, 0)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'NL', 1277967600, 62556, 12.5, 1501)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'NL', 1277967600, 62556, 13.3, 2002)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'NS', 1277967600, 29590, 8.79, 0)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'NS', 1277967600, 59180, 14.95, 1823)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'NS', 1277967600, 93000, 16.67, 2841)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'NS', 1277967600, 150000, 17.5, 3613)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'NS', 1277967600, 150000, 24.5, 14113)   (postgres7): select * from system_setting where name = ?   [ (name=>'tax_data_version') ] (postgres7): select id from system_setting where name = ?   [ (name=>'tax_data_version') ] (postgres7): select id,name,value from system_setting where id = 2   (postgres7): UPDATE system_setting SET VALUE='20100701' WHERE id = 2   (postgres7): SELECT NEXTVAL('system_log_id_seq')  

                                    ADOConnection.CacheExecute(86400, select object_id,action_id,table_name,user_id,description,date,id from system_log where id = -1) % line  968, file: Factory.class.php
                                 Factory.getEmptyRecordSet() % line 1059, file: Factory.class.php
                              Factory.getInsertQuery() % line 1152, file: Factory.class.php
                           Factory.Save() % line   84, file: TTLog.class.php
                        TTLog.addEntry(2, 20, System Setting - Name: tax_data_version Value: 20100701, null, system_setting) % line  178, file: SystemSettingFactory.class.php
                     SystemSettingFactory.addLog(20) % line 1192, file: Factory.class.php
                  Factory.Save() % line   76, file: InstallSchema_1015T.class.php
               InstallSchema_1015T.postInstall() % line  170, file: InstallSchema_Base.class.php
            InstallSchema_Base.InstallSchema() % line    0, file: 
         call_user_func_array(Array[2], Array[0]) % line  111, file: InstallSchema.class.php
      InstallSchema.__call(InstallSchema, Array[0]) % line    0, file: 
   InstallSchema.InstallSchema() % line  468, file: Install.class.php
Install.createSchema(1015T) % line  404, file: Install.class.php
Install.createSchemaRange(null, null) % line  168, file: DatabaseSchema.php

E:\Program Files\TimeTrex\cache\/01/adodb_01966084020d17b28ed5020acf2dc239.cache reloaded, ttl=82160 [ select object_id,action_id,table_name,user_id,description,date,id from system_log where id = -1 ]
(postgres7): SELECT a.attname,t.typname,a.attlen,a.atttypmod,a.attnotnull,a.atthasdef,a.attnum FROM pg_class c, pg_attribute a,pg_type t WHERE relkind in ('r','v') AND (c.relname='system_log' or c.relname = lower('system_log')) and a.attname not like '....%' AND a.attnum > 0 AND a.atttypid = t.oid AND a.attrelid = c.oid ORDER BY a.attnum   (postgres7): SELECT ic.relname AS index_name, a.attname AS column_name,i.indisunique AS unique_key, i.indisprimary AS primary_key FROM pg_class bc, pg_class ic, pg_index i, pg_attribute a WHERE bc.oid = i.indrelid AND ic.oid = i.indexrelid AND (i.indkey[0] = a.attnum OR i.indkey[1] = a.attnum OR i.indkey[2] = a.attnum OR i.indkey[3] = a.attnum OR i.indkey[4] = a.attnum OR i.indkey[5] = a.attnum OR i.indkey[6] = a.attnum OR i.indkey[7] = a.attnum) AND a.attrelid = bc.oid AND bc.relname = 'system_log'   (postgres7): SELECT d.adnum as num, d.adsrc as def from pg_attrdef d, pg_class c where d.adrelid=c.oid and c.relname='system_log' order by d.adnum   (postgres7): INSERT INTO system_log ( ID, USER_ID, OBJECT_ID, TABLE_NAME, ACTION_ID, DESCRIPTION, DATE ) VALUES ( 19033, 0, 2, 'system_setting', 20, 'System Setting - Name: tax_data_version Value: 20100701', 1295558533 )   (postgres7): select * from system_setting where name = ?   [ (name=>'tax_engine_version') ] (postgres7): select id from system_setting where name = ?   [ (name=>'tax_engine_version') ] (postgres7): select id,name,value from system_setting where id = 3   (postgres7): UPDATE system_setting SET VALUE='1.0.15' WHERE id = 3   (postgres7): SELECT NEXTVAL('system_log_id_seq')  

                                    ADOConnection.CacheExecute(86400, select object_id,action_id,table_name,user_id,description,date,id from system_log where id = -1) % line  968, file: Factory.class.php
                                 Factory.getEmptyRecordSet() % line 1059, file: Factory.class.php
                              Factory.getInsertQuery() % line 1152, file: Factory.class.php
                           Factory.Save() % line   84, file: TTLog.class.php
                        TTLog.addEntry(3, 20, System Setting - Name: tax_engine_version Value: 1.0.15, null, system_setting) % line  178, file: SystemSettingFactory.class.php
                     SystemSettingFactory.addLog(20) % line 1192, file: Factory.class.php
                  Factory.Save() % line   94, file: InstallSchema_1015T.class.php
               InstallSchema_1015T.postInstall() % line  170, file: InstallSchema_Base.class.php
            InstallSchema_Base.InstallSchema() % line    0, file: 
         call_user_func_array(Array[2], Array[0]) % line  111, file: InstallSchema.class.php
      InstallSchema.__call(InstallSchema, Array[0]) % line    0, file: 
   InstallSchema.InstallSchema() % line  468, file: Install.class.php
Install.createSchema(1015T) % line  404, file: Install.class.php
Install.createSchemaRange(null, null) % line  168, file: DatabaseSchema.php

E:\Program Files\TimeTrex\cache\/01/adodb_01966084020d17b28ed5020acf2dc239.cache reloaded, ttl=82160 [ select object_id,action_id,table_name,user_id,description,date,id from system_log where id = -1 ]
(postgres7): INSERT INTO system_log ( ID, USER_ID, OBJECT_ID, TABLE_NAME, ACTION_ID, DESCRIPTION, DATE ) VALUES ( 19034, 0, 3, 'system_setting', 20, 'System Setting - Name: tax_engine_version Value: 1.0.15', 1295558533 )   (postgres7): select * from system_setting where name = ?   [ (name=>'schema_version_group_T') ] (postgres7): select id from system_setting where name = ?   [ (name=>'schema_version_group_T') ] (postgres7): select id,name,value from system_setting where id = 4   (postgres7): UPDATE system_setting SET VALUE='1015T' WHERE id = 4   (postgres7): SELECT NEXTVAL('system_log_id_seq')  

                                    ADOConnection.CacheExecute(86400, select object_id,action_id,table_name,user_id,description,date,id from system_log where id = -1) % line  968, file: Factory.class.php
                                 Factory.getEmptyRecordSet() % line 1059, file: Factory.class.php
                              Factory.getInsertQuery() % line 1152, file: Factory.class.php
                           Factory.Save() % line   84, file: TTLog.class.php
                        TTLog.addEntry(4, 20, System Setting - Name: schema_version_group_T Value: 1015T, null, system_setting) % line  178, file: SystemSettingFactory.class.php
                     SystemSettingFactory.addLog(20) % line 1192, file: Factory.class.php
                  Factory.Save() % line  155, file: InstallSchema_Base.class.php
               InstallSchema_Base._postPostInstall() % line  171, file: InstallSchema_Base.class.php
            InstallSchema_Base.InstallSchema() % line    0, file: 
         call_user_func_array(Array[2], Array[0]) % line  111, file: InstallSchema.class.php
      InstallSchema.__call(InstallSchema, Array[0]) % line    0, file: 
   InstallSchema.InstallSchema() % line  468, file: Install.class.php
Install.createSchema(1015T) % line  404, file: Install.class.php
Install.createSchemaRange(null, null) % line  168, file: DatabaseSchema.php

E:\Program Files\TimeTrex\cache\/01/adodb_01966084020d17b28ed5020acf2dc239.cache reloaded, ttl=82160 [ select object_id,action_id,table_name,user_id,description,date,id from system_log where id = -1 ]
(postgres7): INSERT INTO system_log ( ID, USER_ID, OBJECT_ID, TABLE_NAME, ACTION_ID, DESCRIPTION, DATE ) VALUES ( 19035, 0, 4, 'system_setting', 20, 'System Setting - Name: schema_version_group_T Value: 1015T', 1295558533 )   (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')   (postgres7): select * from system_setting where name = ?   [ (name=>'schema_version_group_A') ] (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')   (postgres7): select * from system_setting where name = ?   [ (name=>'schema_version_group_T') ] (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', NULL, 1293868800, 41544, 15, 0)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', NULL, 1293868800, 83088, 22, 2908)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', NULL, 1293868800, 128800, 26, 6232)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', NULL, 1293868800, 128800, 29, 10096)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'BC', 1293868800, 36146, 5.06, 0)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'BC', 1293868800, 72293, 7.7, 954)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'BC', 1293868800, 83001, 10.5, 2978)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'BC', 1293868800, 100787, 12.29, 4464)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'BC', 1293868800, 100787, 14.7, 6893)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'NB', 1293868800, 37150, 9.1, 0)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'NB', 1293868800, 74300, 12.10, 1115)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'NB', 1293868800, 120796, 12.40, 1337)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'NB', 1293868800, 120796, 12.70, 1700)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'NL', 1293868800, 31904, 7.7, 0)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'NL', 1293868800, 63807, 12.5, 1531)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'NL', 1293868800, 63807, 13.3, 2042)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'NT', 1293868800, 37626, 5.9, 0)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'NT', 1293868800, 75253, 8.6, 1016)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'NT', 1293868800, 122345, 12.2, 3725)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'NT', 1293868800, 122345, 14.05, 5988)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'NS', 1293868800, 29590, 8.79, 0)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'NS', 1293868800, 59180, 14.95, 1823)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'NS', 1293868800, 93000, 16.67, 2841)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'NS', 1293868800, 150000, 17.5, 3613)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'NS', 1293868800, 150000, 21.0, 8863)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'NU', 1293868800, 39612, 4.0, 0)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'NU', 1293868800, 79224, 7.0, 1188)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'NU', 1293868800, 128800, 9.0, 2773)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'NU', 1293868800, 128800, 11.5, 5993)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'ON', 1293868800, 37774, 5.05, 0)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'ON', 1293868800, 75550, 9.15, 1549)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'ON', 1293868800, 75550, 11.16, 3067)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'SK', 1293868800, 40919, 11, 0)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'SK', 1293868800, 116911, 13, 818)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'SK', 1293868800, 116911, 15, 3157)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'YT', 1293868800, 41544, 7.04, 0)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'YT', 1293868800, 83088, 9.68, 1097)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'YT', 1293868800, 128800, 11.44, 2559)   (postgres7): INSERT INTO income_tax_rate VALUES (DEFAULT, 'CA', 'YT', 1293868800, 128800, 12.76, 4259)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'NE', NULL, 1262332800, 10, 2400, 2.56, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'NE', NULL, 1262332800, 10, 17500, 3.57, 61.44)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'NE', NULL, 1262332800, 10, 27000, 5.12, 600.51)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'NE', NULL, 1262332800, 10, 27000, 6.84, 1086.91)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'NE', NULL, 1262332800, 20, 4800, 2.56, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'NE', NULL, 1262332800, 20, 35000, 3.57, 122.88)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'NE', NULL, 1262332800, 20, 54000, 5.12, 1201.02)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'NE', NULL, 1262332800, 20, 54000, 6.84, 2173.82)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'NE', NULL, 1262332800, 30, 2400, 2.56, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'NE', NULL, 1262332800, 30, 17500, 3.57, 61.44)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'NE', NULL, 1262332800, 30, 27000, 5.12, 600.51)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'NE', NULL, 1262332800, 30, 27000, 6.84, 1086.91)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'NE', NULL, 1262332800, 40, 4500, 2.56, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'NE', NULL, 1262332800, 40, 28000, 3.57, 115.20)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'NE', NULL, 1262332800, 40, 40000, 5.12, 954.15)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'NE', NULL, 1262332800, 40, 40000, 6.84, 1568.55)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'MD', NULL, 1262332800, 10, 150000, 6.00, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'MD', NULL, 1262332800, 10, 300000, 6.25, 9000)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'MD', NULL, 1262332800, 10, 500000, 6.50, 18375)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'MD', NULL, 1262332800, 10, 500000, 6.75, 31375)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'MD', NULL, 1262332800, 20, 200000, 6.00, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'MD', NULL, 1262332800, 20, 350000, 6.25, 12000)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'MD', NULL, 1262332800, 20, 500000, 6.50, 21375)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'MD', NULL, 1262332800, 20, 500000, 6.75, 31125)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'MD', NULL, 1262332800, 30, 150000, 6.00, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'MD', NULL, 1262332800, 30, 300000, 6.25, 9000)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'MD', NULL, 1262332800, 30, 500000, 6.50, 18375)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'MD', NULL, 1262332800, 30, 500000, 6.75, 31375)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'MD', NULL, 1262332800, 40, 200000, 6.00, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'MD', NULL, 1262332800, 40, 350000, 6.25, 12000)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'MD', NULL, 1262332800, 40, 500000, 6.50, 21375)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'MD', NULL, 1262332800, 40, 500000, 6.75, 31125)   (postgres7): delete from income_tax_rate_us where state = 'AL'   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'AL', NULL, 1136102400, 10, 500, 2, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'AL', NULL, 1136102400, 10, 3000, 4, 10)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'AL', NULL, 1136102400, 10, 3000, 5, 110)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'AL', NULL, 1136102400, 20, 1000, 2, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'AL', NULL, 1136102400, 20, 6000, 4, 20)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'AL', NULL, 1136102400, 20, 6000, 5, 220)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'AL', NULL, 1136102400, 30, 500, 2, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'AL', NULL, 1136102400, 30, 3000, 4, 10)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'AL', NULL, 1136102400, 30, 3000, 5, 110)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'AL', NULL, 1136102400, 40, 500, 2, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'AL', NULL, 1136102400, 40, 3000, 4, 10)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'AL', NULL, 1136102400, 40, 3000, 5, 110)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'AL', NULL, 1136102400, 50, 500, 2, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'AL', NULL, 1136102400, 50, 3000, 4, 10)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'AL', NULL, 1136102400, 50, 3000, 5, 110)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', NULL, NULL, 1293868800, 10, 2100, 0, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', NULL, NULL, 1293868800, 10, 10600, 10, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', NULL, NULL, 1293868800, 10, 36600, 15, 850.00)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', NULL, NULL, 1293868800, 10, 85700, 25, 4750.00)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', NULL, NULL, 1293868800, 10, 176500, 28, 17025.00)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', NULL, NULL, 1293868800, 10, 381250, 33, 42449.00)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', NULL, NULL, 1293868800, 10, 381250, 35, 110016.50)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', NULL, NULL, 1293868800, 20, 7900, 0, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', NULL, NULL, 1293868800, 20, 24900, 10, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', NULL, NULL, 1293868800, 20, 76900, 15, 1700.00)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', NULL, NULL, 1293868800, 20, 147250, 25, 9500.00)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', NULL, NULL, 1293868800, 20, 220200, 28, 27087.50)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', NULL, NULL, 1293868800, 20, 387050, 33, 47513.50)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', NULL, NULL, 1293868800, 20, 387050, 35, 102574.00)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'CA', NULL, 1293868800, 10, 7124, 1.1, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'CA', NULL, 1293868800, 10, 16890, 2.2, 78.36)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'CA', NULL, 1293868800, 10, 26657, 4.4, 293.21)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'CA', NULL, 1293868800, 10, 37005, 6.6, 722.96)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'CA', NULL, 1293868800, 10, 46766, 8.8, 1405.93)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'CA', NULL, 1293868800, 10, 1000000, 10.23, 2264.90)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'CA', NULL, 1293868800, 10, 1000000, 11.33, 99780.74)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'CA', NULL, 1293868800, 20, 7124, 1.1, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'CA', NULL, 1293868800, 20, 16890, 2.2, 78.36)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'CA', NULL, 1293868800, 20, 26657, 4.4, 293.21)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'CA', NULL, 1293868800, 20, 37005, 6.6, 722.96)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'CA', NULL, 1293868800, 20, 46766, 8.8, 1405.93)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'CA', NULL, 1293868800, 20, 1000000, 10.23, 2264.90)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'CA', NULL, 1293868800, 20, 1000000, 11.33, 99780.74)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'CA', NULL, 1293868800, 30, 14248, 1.1, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'CA', NULL, 1293868800, 30, 33780, 2.2, 156.73)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'CA', NULL, 1293868800, 30, 53314, 4.4, 586.43)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'CA', NULL, 1293868800, 30, 74010, 6.6, 1445.93)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'CA', NULL, 1293868800, 30, 93532, 8.8, 2811.87)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'CA', NULL, 1293868800, 30, 1000000, 10.23, 4529.81)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'CA', NULL, 1293868800, 30, 1000000, 11.33, 97261.49)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'CA', NULL, 1293868800, 40, 14257, 1.1, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'CA', NULL, 1293868800, 40, 33780, 2.2, 156.83)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'CA', NULL, 1293868800, 40, 43545, 4.4, 586.34)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'CA', NULL, 1293868800, 40, 53893, 6.6, 1016.00)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'CA', NULL, 1293868800, 40, 63657, 8.8, 1698.97)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'CA', NULL, 1293868800, 40, 1000000, 10.23, 2558.20)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'CA', NULL, 1293868800, 40, 1000000, 11.33, 98346.09)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'CO', NULL, 1293868800, 10, 2100, 0, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'CO', NULL, 1293868800, 10, 2100, 4.63, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'CO', NULL, 1293868800, 20, 7900, 0, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'CO', NULL, 1293868800, 20, 7900, 4.63, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'ME', NULL, 1293868800, 10, 2950, 0, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'ME', NULL, 1293868800, 10, 7950, 2.0, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'ME', NULL, 1293868800, 10, 12900, 4.5, 100)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'ME', NULL, 1293868800, 10, 22900, 7.0, 323)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'ME', NULL, 1293868800, 10, 22900, 8.5, 1023)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'ME', NULL, 1293868800, 20, 6800, 0, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'ME', NULL, 1293868800, 20, 16800, 2.0, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'ME', NULL, 1293868800, 20, 26750, 4.5, 200)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'ME', NULL, 1293868800, 20, 46700, 7.0, 648)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'ME', NULL, 1293868800, 20, 46700, 8.5, 2045)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'MN', NULL, 1293868800, 10, 2100, 0, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'MN', NULL, 1293868800, 10, 25200, 5.35, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'MN', NULL, 1293868800, 10, 77990, 7.05, 1235.85)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'MN', NULL, 1293868800, 10, 77990, 7.85, 4957.55)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'MN', NULL, 1293868800, 20, 5950, 0, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'MN', NULL, 1293868800, 20, 39720, 5.35, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'MN', NULL, 1293868800, 20, 140120, 7.05, 1806.70)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'MN', NULL, 1293868800, 20, 140120, 7.85, 8884.90)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'NY', 'NYC', 1293868800, 10, 8000, 1.9, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'NY', 'NYC', 1293868800, 10, 8700, 2.65, 152)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'NY', 'NYC', 1293868800, 10, 15000, 3.1, 171)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'NY', 'NYC', 1293868800, 10, 25000, 3.7, 366)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'NY', 'NYC', 1293868800, 10, 60000, 3.9, 736)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'NY', 'NYC', 1293868800, 10, 500000, 4.0, 2101)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'NY', 'NYC', 1293868800, 10, 500000, 4.25, 19701)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'NY', 'NYC', 1293868800, 20, 8000, 1.9, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'NY', 'NYC', 1293868800, 20, 8700, 2.65, 152)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'NY', 'NYC', 1293868800, 20, 15000, 3.1, 171)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'NY', 'NYC', 1293868800, 20, 25000, 3.7, 366)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'NY', 'NYC', 1293868800, 20, 60000, 3.9, 736)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'NY', 'NYC', 1293868800, 20, 500000, 4.0, 2101)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'NY', 'NYC', 1293868800, 20, 500000, 4.25, 19701)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'ND', NULL, 1293868800, 10, 3900, 0, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'ND', NULL, 1293868800, 10, 37000, 1.84, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'ND', NULL, 1293868800, 10, 77000, 3.44, 609.04)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'ND', NULL, 1293868800, 10, 176000, 3.81, 1985.04)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'ND', NULL, 1293868800, 10, 380000, 4.42, 5756.94)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'ND', NULL, 1293868800, 10, 380000, 4.86, 14773.74)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'ND', NULL, 1293868800, 20, 9400, 0, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'ND', NULL, 1293868800, 20, 65000, 1.84, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'ND', NULL, 1293868800, 20, 124000, 3.44, 1023.04)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'ND', NULL, 1293868800, 20, 220000, 3.81, 3052.64)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'ND', NULL, 1293868800, 20, 386000, 4.42, 6710.24)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'ND', NULL, 1293868800, 20, 386000, 4.86, 14047.44)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'OK', NULL, 1293868800, 10, 5800, 0, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'OK', NULL, 1293868800, 10, 6800, 0.5, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'OK', NULL, 1293868800, 10, 8300, 1.0, 5)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'OK', NULL, 1293868800, 10, 9550, 2.0, 20)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'OK', NULL, 1293868800, 10, 10700, 3.0, 45)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'OK', NULL, 1293868800, 10, 13000, 4.0, 79.50)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'OK', NULL, 1293868800, 10, 14500, 5.0, 171.50)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'OK', NULL, 1293868800, 10, 14500, 5.5, 246.50)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'OK', NULL, 1293868800, 20, 11600, 0, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'OK', NULL, 1293868800, 20, 13600, 0.5, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'OK', NULL, 1293868800, 20, 16600, 1.0, 10)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'OK', NULL, 1293868800, 20, 19100, 2.0, 40)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'OK', NULL, 1293868800, 20, 21400, 3.0, 90)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'OK', NULL, 1293868800, 20, 23800, 4.0, 159)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'OK', NULL, 1293868800, 20, 26600, 5.0, 255)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'OK', NULL, 1293868800, 20, 26600, 5.5, 395)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'RI', NULL, 1293868800, 10, 55000, 3.75, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'RI', NULL, 1293868800, 10, 125000, 4.75, 2063)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'RI', NULL, 1293868800, 10, 125000, 5.99, 5388)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'RI', NULL, 1293868800, 20, 55000, 3.75, 0)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'RI', NULL, 1293868800, 20, 125000, 4.75, 2063)   (postgres7): INSERT INTO income_tax_rate_us VALUES (DEFAULT, 'US', 'RI', NULL, 1293868800, 20, 125000, 5.99, 5388)  

                           ADOConnection.CacheExecute(86400, select * from company where id = -1) % line  968, file: Factory.class.php
                        Factory.getEmptyRecordSet() % line  871, file: Factory.class.php
                     Factory.getSortSQL(Array[2]) % line   60, file: CompanyListFactory.class.php
                  CompanyListFactory.getAll() % line   61, file: InstallSchema_1016T.class.php
               InstallSchema_1016T.postInstall() % line  170, file: InstallSchema_Base.class.php
            InstallSchema_Base.InstallSchema() % line    0, file: 
         call_user_func_array(Array[2], Array[0]) % line  111, file: InstallSchema.class.php
      InstallSchema.__call(InstallSchema, Array[0]) % line    0, file: 
   InstallSchema.InstallSchema() % line  468, file: Install.class.php
Install.createSchema(1016T) % line  404, file: Install.class.php
Install.createSchemaRange(null, null) % line  168, file: DatabaseSchema.php

E:\Program Files\TimeTrex\cache\/9b/adodb_9bfe6a1c139c82942026e34ad0c3c70c.cache reloaded, ttl=82155 [ select * from company where id = -1 ]
(postgres7): select * from company WHERE deleted = 0 order by status_id asc,name asc   (postgres7): select * from pay_stub_entry_account_link where company_id = ? AND deleted = 0   [ (id=>'1') ] (postgres7): select * from company_deduction where company_id = ? AND lower(name) LIKE lower(?) AND deleted = 0 ORDER BY calculation_order ASC   [ (company_id=>'1') (name=>'Social Security - Employee') ] (postgres7): select a.* from company_deduction_pay_stub_entry_account as a where a.company_deduction_id = ? AND a.type_id = ?   [ (id=>'4') (type_id=>'10') ] (postgres7): select a.* from company_deduction_pay_stub_entry_account as a where a.company_deduction_id = ? AND a.type_id = ?   [ (id=>'4') (type_id=>'20') ] (postgres7): select id,company_id,status_id,type_id,name,calculation_id,calculation_order,country,province,district,company_value1,company_value2,user_value1,user_value2,user_value3,user_value4,user_value5,user_value6,user_value7,user_value8,user_value9,user_value10,lock_user_value1,lock_user_value2,lock_user_value3,lock_user_value4,lock_user_value5,lock_user_value6,lock_user_value7,lock_user_value8,lock_user_value9,lock_user_value10,pay_stub_entry_account_id,created_date,created_by,updated_date,updated_by,deleted_date,deleted_by,deleted,start_date,end_date,minimum_length_of_service,minimum_length_of_service_unit_id,minimum_length_of_service_days,maximum_length_of_service,maximum_length_of_service_unit_id,maximum_length_of_service_days,include_account_amount_type_id,exclude_account_amount_type_id from company_deduction where id = 4   (postgres7): UPDATE company_deduction SET USER_VALUE1='4.2', UPDATED_DATE=1295558534, MINIMUM_LENGTH_OF_SERVICE_DAYS=0, MAXIMUM_LENGTH_OF_SERVICE_DAYS=0 WHERE id = 4   (postgres7): SELECT NEXTVAL('system_log_id_seq')  

                                    ADOConnection.CacheExecute(86400, select object_id,action_id,table_name,user_id,description,date,id from system_log where id = -1) % line  968, file: Factory.class.php
                                 Factory.getEmptyRecordSet() % line 1059, file: Factory.class.php
                              Factory.getInsertQuery() % line 1152, file: Factory.class.php
                           Factory.Save() % line   84, file: TTLog.class.php
                        TTLog.addEntry(4, 20, Tax / Deduction, null, company_deduction, Object:CompanyDeductionListFactory) % line 4147, file: CompanyDeductionFactory.class.php
                     CompanyDeductionFactory.addLog(20) % line 1192, file: Factory.class.php
                  Factory.Save() % line   91, file: InstallSchema_1016T.class.php
               InstallSchema_1016T.postInstall() % line  170, file: InstallSchema_Base.class.php
            InstallSchema_Base.InstallSchema() % line    0, file: 
         call_user_func_array(Array[2], Array[0]) % line  111, file: InstallSchema.class.php
      InstallSchema.__call(InstallSchema, Array[0]) % line    0, file: 
   InstallSchema.InstallSchema() % line  468, file: Install.class.php
Install.createSchema(1016T) % line  404, file: Install.class.php
Install.createSchemaRange(null, null) % line  168, file: DatabaseSchema.php

E:\Program Files\TimeTrex\cache\/01/adodb_01966084020d17b28ed5020acf2dc239.cache reloaded, ttl=82159 [ select object_id,action_id,table_name,user_id,description,date,id from system_log where id = -1 ]
(postgres7): INSERT INTO system_log ( ID, USER_ID, OBJECT_ID, TABLE_NAME, ACTION_ID, DESCRIPTION, DATE ) VALUES ( 19036, 0, 4, 'company_deduction', 20, 'Tax / Deduction', 1295558534 )   (postgres7): select * from company where id = ? AND deleted = 0   [ (id=>'1') ] (postgres7): select id from company_deduction where company_id = ? AND name = ? AND deleted=0   [ (company_id=>'1') (name=>'Social Security - Employee') ] (postgres7): select * from pay_stub_entry_account where id in (?) AND deleted = 0   [ (0=>'7') ] (postgres7): INSERT INTO system_log_detail(SYSTEM_LOG_ID,FIELD,NEW_VALUE,OLD_VALUE) VALUES(?,?,?,?)   [ (0=>'19036') (1=>'user_value1') (2=>'4.2') (3=>'6.2') ] -18: ERROR: relation "system_log_detail" does not exist

                                 ADOConnection._Execute(INSERT INTO system_log_detail(SYSTEM_LOG_ID,FIELD,NEW_VALUE,OLD_VALUE) VALUES(?,?,?,?), Array[4]) % line 1008, file: adodb.inc.php
                              ADOConnection.Execute(INSERT INTO system_log_detail(SYSTEM_LOG_ID,FIELD,NEW_VALUE,OLD_VALUE) VALUES(?,?,?,?), Array[4]) % line 1482, file: LogDetailFactory.class.php
                           LogDetailFactory.addLogDetail(20, 19036, Object:CompanyDeductionListFactory) % line   93, file: TTLog.class.php
                        TTLog.addEntry(4, 20, Tax / Deduction, null, company_deduction, Object:CompanyDeductionListFactory) % line 4147, file: CompanyDeductionFactory.class.php
                     CompanyDeductionFactory.addLog(20) % line 1192, file: Factory.class.php

shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Yet another frozen install problem

Post by shaunw »

I would recommend restoring from your latest backup prior to upgrading to v3.3.1 of TimeTrex. Once that is done, make sure everything continues to work, then upgrade directly to v3.3.2 of TimeTrex.
dhananjay
Posts: 47
Joined: Thu Jan 20, 2011 2:28 pm

Re: Yet another frozen install problem

Post by dhananjay »

I've already attempted the install and it is stalling both for installing 3.3.1 and for 3.3.2

So I don't understand your response. Also, can you point me to instructions on backup and restoration?
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Yet another frozen install problem

Post by shaunw »

You did create a full backup of your TimeTrex installation prior to upgrading, as directed by the installer correct?
dhananjay
Posts: 47
Joined: Thu Jan 20, 2011 2:28 pm

Re: Yet another frozen install problem

Post by dhananjay »

I have the following subdirectories:
rollbackBackupDirectory, rollbackBackupDirectory1, & rollbackBackupDirectory2
inside my TimeTrex installation directory.
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Yet another frozen install problem

Post by shaunw »

hose aren't backups, they are just rollback save points for non-data files.

I gather that you didn't create a backup that you can restore too. As long as you haven't tampered with things too much, the data is likely still all there, just not accessible for whatever reason. I'm going to recommend that you purchase a support package from us so one of our support representatives can troubleshoot your installation and get you back up and running. I doubt it would take more then an hour to complete.
dhananjay
Posts: 47
Joined: Thu Jan 20, 2011 2:28 pm

Re: Yet another frozen install problem

Post by dhananjay »

I found my backup timetrex_database_date.sql and the timetrex.ini.php files.

What should we try next? Tried following the restoration procedures in moving TimeTrex installations from one machine to another, but that still didn't help.
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Yet another frozen install problem

Post by shaunw »

It was just brought to my attention that our developers may have discovered the cause for this, they are testing as solution for it now. I will keep you updated.
dhananjay
Posts: 47
Joined: Thu Jan 20, 2011 2:28 pm

Re: Yet another frozen install problem

Post by dhananjay »

I've got 3.0.8 reinstalled and working with original data and everything it seems. Is there a way to update the tax tables / calculations in the mean time to keep our payroll going and to avoid disgruntling the employees?
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Yet another frozen install problem

Post by shaunw »

Locked