Testlink update Notes / Description
I will write this in English because there are a lot of people that use Testlink – testcase management software and would like to know this. This fix is applicable for the last stable version 1.8.5 (current version is Beta 1.9.6 – Testlink betas do ONLY serve the purpose of evaluating the product features and should NOT be used in live systems.)
The problem : There is a small issue regarding the Notes / Description function from the execute mode. You can add a comment to a testcase and when you would like to add a second one, the first is deleted and so on. The idea is that every time you submit a new Note/Description the old one disappears. To fix this situation there were two possibilities, either insert in the data base each comment or make an update to the VALUE tag from the Notes / Description textarea. The first solution would increase the size of the data base so I implemented the second solution.
Solution : You need to find the file execSetResults.php (/lib/execute/execSetResults.php). Go to line 776 and you will find the following code :
$of=web_editor("notes[{$tcversion_id}]",$basehref,$editorCfg) ;
$of=null;
Change-it to:
$of=web_editor("notes[{$tcversion_id}]",$basehref,$editorCfg);
$build_id=$_GET['build_id'];
$id=$_GET['version_id'];
$result=mysql_query("SELECT notes FROM `executions` WHERE tcversion_id='".$id."' AND build_id='".$build_id."' ");
while($row=mysql_fetch_array($result)){
$value_com=$row['notes'];}
$of=$value_com; //null;
The solution if pretty rough, but light with the data base and very fast. Basicaly the default value of the Notes/Description textarea will always contain all older comments.
! Important Notice from the developers : Data migration from one beta to another beta or to a stable release is NOT possible. I will write another post on how can you transfer the database from one to another, because I just found out that is possible 
Things are only impossible until they’re not.
