MySQL 5.7

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

Moderators: Amaradana, TurboPT, TL Developers

Post Reply
stef-lhm
Advanced user
Posts: 27
Joined: Thu Jan 31, 2013 7:43 pm

MySQL 5.7

Post by stef-lhm »

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: 27
Joined: Thu Jan 31, 2013 7:43 pm

Re: MySQL 5.7

Post by stef-lhm »

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

Re: MySQL 5.7

Post by stef-lhm »

sql-mode = STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION,ONLY_FULL_GROUP_BY
fman
Member of TestLink Community
Posts: 3123
Joined: Tue Nov 15, 2005 7:19 am

Re: MySQL 5.7

Post by fman »

thanks for your help

regards
Post Reply