Page 1 of 1

Timetrex Debug is unable to connect to its database

Posted: Wed Mar 08, 2017 11:44 am
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.

Re: Timetrex Debug is unable to connect to its database

Posted: Wed Mar 08, 2017 3:08 pm
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

Re: Timetrex Debug is unable to connect to its database

Posted: Wed Mar 08, 2017 3:40 pm
by brad
I am using MySQL version '5.7.9-log'

Re: Timetrex Debug is unable to connect to its database

Posted: Wed Mar 08, 2017 4:02 pm
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.

Re: Timetrex Debug is unable to connect to its database

Posted: Wed Mar 08, 2017 9:46 pm
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!