Probelm with Installing source on WAMP Server in localhost

Ask your questions regarding TimeTrex installation here.
Locked
ramuvk
Posts: 12
Joined: Wed Sep 14, 2011 4:50 am

Probelm with Installing source on WAMP Server in localhost

Post by ramuvk »

(mysqli): SET SESSION sql_mode='ansi' (mysqli): SET TRANSACTION ISOLATION LEVEL READ COMMITTED (mysqli): SET SESSION time_zone='UTC' (mysqli): select session_id,user_id,ip_address,created_date,updated_date from authentication WHERE session_id = NULL AND ip_address = '127.0.0.1' AND updated_date >= 1315973697 Query: select session_id,user_id,ip_address,created_date,updated_date from authentication WHERE session_id = NULL AND ip_address = '127.0.0.1' AND updated_date >= 1315973697 failed. Table 'timetrex.authentication' doesn't exist
1146: Table 'timetrex.authentication' doesn't exist

ADOConnection._Execute(select session_id,user_id,ip_address,created_date,updated_date from authentication WHERE session_id = NULL AND ip_add...) % line 993, file: adodb.inc.php
ADOConnection.Execute(select session_id,user_id,ip_address,created_date,updated_date from authentication WHERE session_id = ? AND ip_addres..., Array[3]) % line 1605, file: adodb.inc.php
ADOConnection.GetRow(select session_id,user_id,ip_address,created_date,updated_date from authentication WHERE session_id = ? AND ip_addres..., Array[3]) % line 482, file: Authentication.class.php
Authentication.Read() % line 629, file: Authentication.class.php
Authentication.Check() % line 90, file: Interface.inc.php


( ! ) Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysqli error: [1146: Table 'timetrex.authentication' doesn' in C:\wamp\www\timetrex\classes\adodb\adodb-exceptions.inc.php on line 78
( ! ) ADODB_Exception: mysqli error: [1146: Table 'timetrex.authentication' doesn't exist] in EXECUTE("select session_id,user_id,ip_address,created_date,updated_date from authentication WHERE session_id = NULL AND ip_address = '127.0.0.1' AND updated_date >= 1315973697 ") in C:\wamp\www\timetrex\classes\adodb\adodb-exceptions.inc.php on line 78
Call Stack
# Time Memory Function Location
1 0.0030 387968 {main}( ) ..\index.php:0
2 0.0817 4767736 require_once( 'C:\wamp\www\timetrex\includes\Interface.inc.php' ) ..\index.php:42
3 0.1166 7174072 Authentication->Check( ) ..\Interface.inc.php:90
4 0.1168 7175024 Authentication->Read( ) ..\Authentication.class.php:629
5 0.1168 7175560 ADOConnection->GetRow( ) ..\Authentication.class.php:482
6 0.1169 7175592 ADOConnection->Execute( ) ..\adodb.inc.php:1605
7 0.1170 7177368 ADOConnection->_Execute( ) ..\adodb.inc.php:993
8 0.1191 7178872 adodb_throw( )

anybody have a clear idea regarding this issue.

Thanks in Advance

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

Re: Probelm with Installing source on WAMP Server in localhost

Post by shaunw »

It would appear that you haven't gone through the complete installation process as described in the readme.txt as the TimeTrex tables haven't been created yet.
ramuvk
Posts: 12
Joined: Wed Sep 14, 2011 4:50 am

Re: Probelm with Installing source on WAMP Server in localhost

Post by ramuvk »

i had changes timetrex.ini.php file.

; Database connection settings. These can be set from the installer.
;
[database]
;type = mysqlt
type = mysqli
;type = postgres8

host = localhost
database_name = timetrex
user = root
;password = ENTER_PASSWORD_HERE
password =

[debug]
;Set to false if you're debugging
production = TRUE

enable = TRUE
enable_display = TRUE
buffer_output = TRUE
enable_log = TRUE
verbosity = 11



[other]
; Force all clients to use SSL.
force_ssl = FALSE
installer_enabled = TRUE
primary_company_id = 0
hostname = localhost

like as above i had changed database settings.

let me know some instructions if any need

Thanks in Advance

Ramu Vallabhaneni















;<?php if (; //Cause parse error to hide from prying eyes, just in case. DO NOT REMOVE?>
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Probelm with Installing source on WAMP Server in localhost

Post by shaunw »

What about step 6 and 7 in the readme?
ramuvk
Posts: 12
Joined: Wed Sep 14, 2011 4:50 am

Re: Probelm with Installing source on WAMP Server in localhost

Post by ramuvk »

i have below content as step 6 and 7 in readme file

6. Point your web browser to:
http://<web server address>/<timetrex directory>/interface/install/install.php
ie: http://localhost/timetrex/interface/install/install.php

7. Follow instructions


as u said i kept the timetrex folder in c:\wamp\www\

when i tried to install it from wamp server through the said link it shows the error related to data base.

also i tried like before installing i created a daabase with the name of timetrex and given all priviliges

Thanks in Advance

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

Re: Probelm with Installing source on WAMP Server in localhost

Post by shaunw »

If your timetrex.ini.php contains the data you showed here, the debug verbosity is set to 11 which is strictly for debugging purposes only and tells TimeTrex to do one single operation and immediately stop. It can not be used for normal purposes with that set to 11.
ramuvk
Posts: 12
Joined: Wed Sep 14, 2011 4:50 am

Re: Probelm with Installing source on WAMP Server in localhost

Post by ramuvk »

i had changed that after looking some where in posts. is it wrong.. wht value i need to keep in verbosity


Thanks In Advance

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

Re: Probelm with Installing source on WAMP Server in localhost

Post by shaunw »

Anything less than 11 is fine.
ramuvk
Posts: 12
Joined: Wed Sep 14, 2011 4:50 am

Re: Probelm with Installing source on WAMP Server in localhost

Post by ramuvk »

i had changed the verbosity to 10. now when i try to install it shows error like below

Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysqli error: [1146: Table 'timetrex.authentication' doesn' in C:\wamp\www\timetrex\classes\adodb\adodb-exceptions.inc.php on line 78
( ! ) ADODB_Exception: mysqli error: [1146: Table 'timetrex.authentication' doesn't exist] in EXECUTE("select session_id,user_id,ip_address,created_date,updated_date from authentication WHERE session_id = NULL AND ip_address = '127.0.0.1' AND updated_date >= 1316008492 ") in C:\wamp\www\timetrex\classes\adodb\adodb-exceptions.inc.php on line 78
Call Stack
# Time Memory Function Location
1 0.0191 387968 {main}( ) ..\index.php:0
2 0.7192 4413072 require_once( 'C:\wamp\www\timetrex\includes\Interface.inc.php' ) ..\index.php:42
3 1.0508 6819432 Authentication->Check( ) ..\Interface.inc.php:90
4 1.0512 6820384 Authentication->Read( ) ..\Authentication.class.php:629
5 1.0513 6820920 ADOConnection->GetRow( ) ..\Authentication.class.php:482
6 1.0513 6820952 ADOConnection->Execute( ) ..\adodb.inc.php:1605
7 1.0515 6822728 ADOConnection->_Execute( ) ..\adodb.inc.php:993
8 1.0679 6822928 adodb_throw( )


Thanks in Advance

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

Re: Probelm with Installing source on WAMP Server in localhost

Post by shaunw »

What is the full and exact URL that you are going to in your web browser when you see that?
ramuvk
Posts: 12
Joined: Wed Sep 14, 2011 4:50 am

Re: Probelm with Installing source on WAMP Server in localhost

Post by ramuvk »

This is the url when i click from wamp server

http://localhost/timetrex/

when the error cames it shows the url as

http://localhost/timetrex/interface/

and error shows as i posted

if i try to put url as

http://localhost/timetrex/interface/install/install.php

then it shows error as below

PHP GetText extension is not installed, TimeTrex requires GetText to be installed.


( ! ) Warning: include(PEAR.php) [function.include]: failed to open stream: No such file or directory in C:\wamp\www\timetrex\interface\install\install.php on line 87
Call Stack
# Time Memory Function Location
1 0.0013 344528 {main}( ) ..\install.php:0

( ! ) Warning: include() [function.include]: Failed opening 'PEAR.php' for inclusion (include_path='.;C:\php\pear') in C:\wamp\www\timetrex\interface\install\install.php on line 87
Call Stack
# Time Memory Function Location
1 0.0013 344528 {main}( ) ..\install.php:0
PHP's PEAR package is not installed. TimeTrex requires PEAR to be installed.
On Windows PHP includes a file called go-pear.bat that you can use to install PEAR.

For installation support, please join our community forums or contact a TimeTrex support expert for Implementation Support Services.


Thanks in Advance

Ramu Vallabhaneni
ramuvk
Posts: 12
Joined: Wed Sep 14, 2011 4:50 am

Re: Probelm with Installing source on WAMP Server in localhost

Post by ramuvk »

i had enabled the php extension. so the error

PHP GetText extension is not installed, TimeTrex requires GetText to be installed.

is not showing now. but the remaining error related to peer is still showing.

i tried to install go-peer.bat in php directry.
but still the error is showing..

plz guide me by step wise once

Thanks in Advance

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

Re: Probelm with Installing source on WAMP Server in localhost

Post by shaunw »

Warning: include() [function.include]: Failed opening 'PEAR.php' for inclusion (include_path='.;C:\php\pear') in C:\wamp\www\timetrex\interface\install\install.php on line 87
Call Stack
Does this file exist on your system?

C:\php\pear\PEAR.php

If not, you need to install PEAR properly so PHP can find it.
ramuvk
Posts: 12
Joined: Wed Sep 14, 2011 4:50 am

Re: Probelm with Installing source on WAMP Server in localhost

Post by ramuvk »

iam using wamp server. so my php is located at

C:\wamp\bin\php\php5.3.5\PEAR

when i go to this folder it has only one file with the name of "go-pear.phar"

Thanks in Advance

Ramu Vallabhaneni
ramuvk
Posts: 12
Joined: Wed Sep 14, 2011 4:50 am

Re: Probelm with Installing source on WAMP Server in localhost

Post by ramuvk »

now i unstalled Peer.

now peer.php is located in C:\wamp\bin\php\php5.3.5\PEAR

what i need to do now... after this step also it showing same error

Thanks in Advance

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

Re: Probelm with Installing source on WAMP Server in localhost

Post by shaunw »

I would recommend asking in the WAMP forums as the issue pertains to WAMP, PHP and PEAR itself, not TimeTrex, therefore they should be better equipped to help you out.

Keep in mind you can always use the automated TimeTrex installers to have all of this done for you.
Locked