|Anonymous | Login | Signup for a new account||2020-02-28 09:27 UTC|
|Main | My View | View Issues | Change Log | My Account|
|View Issue Details|
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0004112||TestLink||Reports||public||2010-12-20 14:08||2011-01-22 15:11|
|Platform||IIS7||OS||Windows||OS Version||2008 R2|
|Product Version||1.9 (Prague)|
|Fixed in Version||1.9.1 (bug fixing)|
|Summary||0004112: IIS/MSSQL: Report "Test Cases with Execution Details" fails with an "Internal server error"|
|Description||The report "Test Cases with Execution Details" fails every time with a "500 Internal server error". |
I enclose my php.ini because a problem with a warning caused by navbar.php (line 96) was fixed by changing some reporting settings in php.ini - and this could be related because the error reported by the IIS is the same.
|Steps To Reproduce||Go to reports -> Test Cases with Execution Details. After a short time the internal server error appears every time.|
|Additional Information||From the Windows event log:|
"Faulting application name: php-cgi.exe, version: 184.108.40.206, time stamp: 0x4c47484c
Faulting module name: ntdll.dll, version: 6.1.7600.16385, time stamp: 0x4a5bdb3b
Faulting application path: c:\php\php-cgi.exe
Faulting module path: C:\Windows\SysWOW64\ntdll.dll"
|Tags||No tags attached.|
|Database (MySQL,Postgres,etc)||MSSQL v10.50.1600 Enterprise|
|QA Team - Task Workflow Status|
|Attached Files||php.ini [^] (50,703 bytes) 2010-12-20 14:08|
I am also seeing this bug in my environment. My environment is
Win Server 2003
(Apache & PHP) XAMPP 1.7.3
For the tesplan with problems
In my case it doesnt seem to matter what size project it is.
In the current setup...
1. 6 projects (p1: 2 x tc, p2: 73 x tc, p3: 127 x tc, p4: 96 x tc, p5: 5 x tc, p6: 235 x tc)
2. 535(ish) test cases
3. 10 test plans
6. 7 builds
Test plan with problems (it happens for me in each project but here are details of smallest project)
1. 2 test cases
2. 1 build
3. 2 executions
To answer your question the size of the project has no influence on the error. It can be reproduced with just one project, one plan, execution of one test case with just one step. Or as one of my colleagues did it with a hundred or more test cases. Allow me to elaborate...
In my company we started using TestLink at v1.8.5 on Apache/Mysql but wanted to convert to IIS/MSSQL because of company policy and backup options. So we had v1.8.5 Apache, v1.9 Apache and V1.9 IIS installations running at the same time to test the new version and platform (compared to v1.8.5 on Apache in production).
Apache v1.9 runs perfectly but unfortunately the IIS/MSSQL setup has proven to be nothing but trouble due to the reported and other issues (including an issue that oileanach has reported elsewhere that wasn't reproducable outside an IIS/MSSQL environment). One of these issues (also IIS/MSSQL only) is that we saved a table pasted from MSWord (9.2k html data) into a test case summary, saved it but on retrieval only half was displayed and the rest was ignored. I checked in the database where I found the full text. This was also reproduced with plain text and I really should have checked if this was a known error and reported it if it wasn't. I'm sorry I didn't fill out a report.
In any case our conclusion has been to go back to the 'original' Apache/Mysql environment (upgrading to v1.9) as the code seems to function best in this environment. At least that is what my experience tells me no matter if IIS, MSSQL, PHP or the combination of all three is the root cause. If you have the time, I would suggest testing extensively using these three components.
Thanks for looking into this matter in any case,
Fan of TestLink and looking forward to the test case review feature :)
issue is created by use of reserved keyword EXEC as table alias in
if you change it to any other thing (example EXECU) all will work again (at least on my tests)
In addition please do following steps if no done yet
1. post your company on forum
2. go to sourceforge TL summary section and add a 'Thumb up'
3. go to jumpox site section user voice and vote for a jumpbox with TL
Please do not chanhe aim of issue -> this comment will have no effect at all:
>> looking forward to the test case review feature :)
if you would like to see this feature look for the right issue (if exists) or open a new one.
|2010-12-20 14:08||allanbj||New Issue|
|2010-12-20 14:08||allanbj||File Added: php.ini|
|2011-01-18 10:09||oileanach||Note Added: 0013311|
|2011-01-18 10:55||fman||Note Added: 0013312|
|2011-01-18 11:18||oileanach||Note Added: 0013314|
|2011-01-18 12:38||allanbj||Note Added: 0013315|
|2011-01-18 21:05||fman||Assigned To||=> fman|
|2011-01-18 21:05||fman||Status||new => assigned|
|2011-01-18 21:11||fman||Note Added: 0013319|
|2011-01-18 21:22||fman||Status||assigned => resolved|
|2011-01-18 21:22||fman||Fixed in Version||=> 1.9.1 (bug fixing)|
|2011-01-18 21:22||fman||Resolution||open => fixed|
|2011-01-22 15:11||fman||Note Added: 0013351|
|2011-01-22 15:11||fman||Status||resolved => closed|
|Copyright © 2000 - 2020 MantisBT Team|