MySQL 5.7

LATEST Official version.
Questions and discussions - NO ISSUES
FOR ISSUES => http://mantis.testlink.org

Moderators: Amaradana, TurboPT, TL Developers

MySQL 5.7

Postby stef-lhm » Tue May 09, 2017 10:14 am

We are usind TL 1.9.14 with MySQL 5.6.25.
Everything works fine.
Last week we updated MySQL to 5.7.17, but we had to do the rollback.
When writing new TC or new version of TC we get an DB access error.
The TC were written, but you cannot open it, cause of corrupt IDs.
In the tree structure the case is shown with Prefix, but NO ID.
You can delete these zombies by open the suite and using TC operations "delete".

So are the any experiences concerning MySQL 5.7 with TL 1.9.14 or higher?
In the requirements there is written MySQL 5.x ?! :mrgreen:
stef-lhm
Advanced user
 
Posts: 18
Joined: Thu Jan 31, 2013 7:43 pm

Re: MySQL 5.7

Postby stef-lhm » Thu May 11, 2017 9:46 am

We found a solution by changing the sql_mode parameter
stef-lhm
Advanced user
 
Posts: 18
Joined: Thu Jan 31, 2013 7:43 pm

Re: MySQL 5.7

Postby stef-lhm » Thu May 11, 2017 10:11 am

sql-mode = STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION,ONLY_FULL_GROUP_BY
stef-lhm
Advanced user
 
Posts: 18
Joined: Thu Jan 31, 2013 7:43 pm

Re: MySQL 5.7

Postby fman » Thu May 11, 2017 3:13 pm

thanks for your help

regards
fman
Member of TestLink Community
 
Posts: 2994
Joined: Tue Nov 15, 2005 7:19 am


Return to TestLink 1.9



Who is online

Users browsing this forum: No registered users and 1 guest