Timetrex Debug is unable to connect to its database

Ask your questions regarding TimeTrex installation here.
Post Reply
brad
Posts: 3
Joined: Wed Mar 08, 2017 9:58 am

Timetrex Debug is unable to connect to its database

Post by brad »

I have been to install severaltimes the software and solved some errors on my configuration file(timetrex.ini.php). I have finally managed to start the installation, and its broke it when the process "Initializing database" has 85% whit the next error message:

Timetrex Debug is unable to connect to its database, please make sure that the database service on your own local timetrex-Debug server has been started and is running if you are unsure, try rebooting your server.

I was using next configuration:
OS: Windows 10
Timetrex: Community_Edition_v10.1.2 (Manual Installation)
Php: 5.6
Database: Mysql 5.7
Web Server: IIS
Browser: Google Chrome Version 56.0.2924.87

In the php log errors file there are not errors.

i attach a file with more information.

Thanks a lot.
Attachments
install_Log.docx
Images, timetrex.ini.php and timetrex.log
(836.77 KiB) Downloaded 326 times
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Timetrex Debug is unable to connect to its database

Post by shaunw »

MySQL is giving you this error:
mysqli error: [1093: You can't specify target table 'user_preference' for update in FROM clause
When trying to run this query:

Code: Select all

delete from user_preference where id in ( select * from ( select a.id from ( select user_id from user_preference group by user_id having count(*) > 1 ) as tmp, user_preference as a WHERE a.user_id = tmp.user_id ) as tmp );
Something is strange though, since we use MySQL on our test system and here and it works just fine:

Code: Select all

mysql> select version();
+-------------------------+
| version()               |
+-------------------------+
| 5.7.17                   |
+-------------------------+
1 row in set (0.02 sec)

mysql> delete from user_preference where id in ( select * from ( select a.id from ( select user_id from user_preference group by user_id having count(*) > 1 ) as tmp, user_preference as a WHERE a.user_id = tmp.user_id ) as tmp );
Query OK, 0 rows affected (0.01 sec)
What is the full and exact version of MySQL that you are using?



*NOTE: This URL may provide more information for developers: http://stackoverflow.com/questions/4549 ... rom-clause
brad
Posts: 3
Joined: Wed Mar 08, 2017 9:58 am

Re: Timetrex Debug is unable to connect to its database

Post by brad »

I am using MySQL version '5.7.9-log'
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Timetrex Debug is unable to connect to its database

Post by shaunw »

I would recommend upgrading to the latest version to see if that makes any difference.

Unfortunately we run into this quite often with MySQL some versions work, some don't, and its just one of the many reasons why we don't recommend using MySQL.
brad
Posts: 3
Joined: Wed Mar 08, 2017 9:58 am

Re: Timetrex Debug is unable to connect to its database

Post by brad »

I was upgrade MySQL to version 5.7.17 try a new install but this broken again. then run the query in MySQl and show error code 1175. Searh on google and found this article.

http://stackoverflow.com/questions/1144 ... -workbench

following steps : On MysqlWorkbench

Go to Edit --> Preferences
Click to uncheck "SQL Editor" tab and uncheck "Safe Updates" check box
Query --> Reconnect to Server // logout and then login

Now execute newly the install process and this run without problem.

Thanks a lot!
Post Reply