Delicious      Technorati      Blinklist      Furl      Reddit

TimeTrex Time and Attendance

TimeTrex Time and Attendance


* FAQ    * Search
* Login   * Register

All times are UTC - 8 hours [ DST ]




Post new topic Reply to topic  [ 6 posts ] 
Author Message
PostPosted: Wed Nov 30, 2016 3:32 am 
Offline

Joined: Wed Nov 30, 2016 2:23 am
Posts: 3
im trying to install the latest version of TimeTrex 9.1.3 on my local windows PC using WAMP

The problem is during the database configuration, when creating the database tables i get the below error

Quote:
The network connection was lost. Please check your network connection then try again.                     ADOConnection._Execute(ALTER TABLE punch ADD COLUMN position_accuracy integer, false) % line 1116, file: adodb.inc.php
                  ADOConnection.Execute(ALTER TABLE punch ADD COLUMN position_accuracy integer) % line 192, file: InstallSchema_Base.class.php
                InstallSchema_Base._InstallSchema() % line 248, file: InstallSchema_Base.class.php
              InstallSchema_Base.InstallSchema() % line 0, file:
            call_user_func_array(Array[2], Array[0]) % line 107, file: InstallSchema.class.php
          InstallSchema.__call(InstallSchema, Array[0]) % line 659, file: Install.class.php
        InstallSchema.InstallSchema() % line 659, file: Install.class.php
      Install.createSchema(1061A) % line 570, file: Install.class.php
    Install.createSchemaRange(null, null) % line 478, file: APIInstall.class.php
  APIInstall.setDatabaseSchema(0) % line 0, file:
call_user_func_array(Array[2], Array[1]) % line 88, file: api.php
unauthenticatedInvokeService(APIInstall, setDatabaseSchema, Array[1], bcd7e221-5905-fbc3-9043-3cc3b33ff608, Object:APIAuthentication) % line 287, file: api.php


{"api_retval":false,"api_details":{"code":"EXCEPTION","description":"TimeTrex is unable to connect to its database, please make sure that the database service on your own local TimeTrex server has been started and is running. If you are unsure, try rebooting your server.","record_details":{"total":0,"valid":0,"invalid":0},"user_generic_status_batch_id":false,"request":false,"pager":false,"details":false}}



My network works fine but every time i try to install i get the above error...

Any help on how it can be fixed?

Thanks


Top
 Profile  
 
PostPosted: Wed Nov 30, 2016 9:52 am 
Offline

Joined: Tue Sep 19, 2006 2:22 pm
Posts: 7224
TimeTrex appears to be losing the connection to your database server. Is your database crashing perhaps? May want to check your database event logs for more information.


Top
 Profile  
 
PostPosted: Wed Nov 30, 2016 12:35 pm 
Offline

Joined: Wed Nov 30, 2016 2:23 am
Posts: 3
Hi

Thanks for the reply

In my log i have the below
Quote:
2016-11-30T19:31:18.351782Z 119 [ERROR] InnoDB: Table `mysql`.`innodb_table_stats` not found.
2016-11-30T19:31:18.353782Z 119 [ERROR] InnoDB: Fetch of persistent statistics requested for table `payroll`.`accrual_balance` but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2016-11-30T19:31:18.545793Z 119 [ERROR] InnoDB: Table `mysql`.`innodb_table_stats` not found.
2016-11-30T19:31:18.551794Z 119 [ERROR] InnoDB: Table `mysql`.`innodb_table_stats` not found.
2016-11-30T19:31:18.553794Z 119 [ERROR] InnoDB: Fetch of persistent statistics requested for table `payroll`.`permission_user` but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2016-11-30T19:31:18.889813Z 119 [ERROR] InnoDB: Table `mysql`.`innodb_table_stats` not found.
2016-11-30T19:31:18.895813Z 119 [ERROR] InnoDB: Table `mysql`.`innodb_table_stats` not found.
2016-11-30T19:31:18.896814Z 119 [ERROR] InnoDB: Fetch of persistent statistics requested for table `payroll`.`permission_user` but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.


Top
 Profile  
 
PostPosted: Wed Nov 30, 2016 1:15 pm 
Offline

Joined: Tue Sep 19, 2006 2:22 pm
Posts: 7224
Yup, your MySQL database is not functioning properly, you will need to figure out how to fix those errors and get it working properly before it will allow TimeTrex to be installed.

Keep in mind MySQL database is not recommended for TimeTrex, errors such as these are just one of many reasons.


Top
 Profile  
 
PostPosted: Fri Dec 02, 2016 2:40 am 
Offline

Joined: Wed Nov 30, 2016 2:23 am
Posts: 3
Thanks for the quick reply...

I managed to fix those errors with a fresh WAMP installation. But now half way during the installation when the database is being setuped. I get the below error


Quote:
TimeTrex is unable to connect to its database, please make sure that the database service on your own local TimeTrex server has been started and is running. If you are unsure, try rebooting your server.


I restarted WAMP but still the same


Top
 Profile  
 
PostPosted: Fri Dec 02, 2016 10:29 am 
Offline

Joined: Tue Sep 19, 2006 2:22 pm
Posts: 7224
Likely still getting database errors, we would need to see either the database error log or the TimeTrex error log to move forward though.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ] 

All times are UTC - 8 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  


Time and Attendance




Powered by phpBB® Forum Software © phpBB Group