Network connection lost during installation

Ask your questions regarding TimeTrex installation here.
Post Reply
livewirerules
Posts: 3
Joined: Wed Nov 30, 2016 2:23 am

Network connection lost during installation

Post by livewirerules » Wed Nov 30, 2016 3:32 am

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
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

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

Re: Network connection lost during installation

Post by shaunw » Wed Nov 30, 2016 9:52 am

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.

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

Re: Network connection lost during installation

Post by livewirerules » Wed Nov 30, 2016 12:35 pm

Hi

Thanks for the reply

In my log i have the below
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.

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

Re: Network connection lost during installation

Post by shaunw » Wed Nov 30, 2016 1:15 pm

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.

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

Re: Network connection lost during installation

Post by livewirerules » Fri Dec 02, 2016 2:40 am

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

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

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

Re: Network connection lost during installation

Post by shaunw » Fri Dec 02, 2016 10:29 am

Likely still getting database errors, we would need to see either the database error log or the TimeTrex error log to move forward though.

Post Reply