i can not create testcases ! ISS 7.0 , PHP 5.2.17. MSSQL

[KianSS]

i can not create testcases !

hope you can help me .


i installed IIS 7 , FastCGI with PHP Version 5.2.17 , MS SQL 2008

i can create Users, can see the complete GUI "pictures, CSS files" which means for me , that i have the correct folder permissions.


i created a Database named testlink and run the following scripts:

1) testlink-1.9.3installsqlmssqltestlink_create_tables.sql
2) testlink-1.9.3installsqlmssqltestlink_create_default_data.sql



My problem:

i can create a Project , a Plan, creat new user, give them roles ! i can creat a Testsuite.


BUT when i want to create a testcase for the testsuite i will get a timout !

HTTP Error 500.0 - Internal Server Error

C:phpphp-cgi.exe - The FastCGI process exited unexpectedly




Module

FastCgiModule



Notification

ExecuteRequestHandler



Handler

php-5.2.17



Error Code

0xc0000005





Requested URL

http://localhost:80/lib/testcases/tcEdi ... tainerID=3



Physical Path

C:inetpubwwwrootlibtestcasestcEdit.php



Logon Method

Anonymous



Logon User

Anonymous



Failed Request Tracing Log Directory

C:inetpublogsFailedReqLogFiles



my phpinfo is showing mssql with alle the correct Configs:


[MSSQL]

mssql.allow_persistent = On
mssql.max_persistent = -1
mssql.max_links = -1
mssql.min_error_severity = 10
mssql.min_message_severity = 10
mssql.compatability_mode = Off
mssql.secure_connection = Off
mssql.connect_timeout = 5
mssql.timeout = 60
mssql.batchsize = 0
mssql.datetimeconvert = On

extension=php_mssql.dll


extension_dir = "C:phpext"
upload_tmp_dir = "C:inetpubwwwroottemp"
open_basedir = "C:inetpubwwwroot"
error_log = "C:WindowsTempphp-5.2.17_errors.log"
cgi.force_redirect = 0
cgi.fix_pathinfo = 1
fastcgi.impersonate = 1
html_errors = Off
fastcgi.logging =

[fman]

Please if you post on forum, then do not open issue on mantis at SAME TIME.

[KianSS]

Sorry but i am really annoyed about the problem and cant fix it by my own

[KianSS]

i installed Testlink over the normal Install Process ( localhost/install )

on IIS 7.5, MS SQL 2008 Express RC2 , PHP 5.2.17 with PEAR. i can login, logout, create a testplan, work with the userroles. "didnt made any changes in the Config File" , I can see all Gifs,Jpegs, all CSS files will loaded correctly , which means for me that the Folder Permission is working fine.

Installation works after i created a empty Database "called testlink" via SQL Management Studio.

all tables and inserts worked fine , after that.



my problem is still the same : i can create Testsuites but no testcases ( runnning to a timeout and takes more than 3 minutes )

after refreshing the Webserver, i can the the testcase in the tree, but the creating is stucking
i had a look to the events : there are no problems there.

[KianSS]

Test Project 'MAMIS' - Test Plan 'MAMIS Testplan' was created
19/05/2012 13:07:22
admin
Test Project 'MAMIS' was created
19/05/2012 13:07:03
admin
Login for 'admin' from '::1' succeeded
Log level: WARNING (5 Items)
19/05/2012 13:10:19
admin
E_NOTICE Undefined index: type - in C:\inetpub\wwwroot\lib\functions\exttable.class.php - Line 244
19/05/2012 13:10:19
admin
E_NOTICE Undefined index: type - in C:\inetpub\wwwroot\lib\functions\exttable.class.php - Line 244
19/05/2012 13:10:19
admin
E_NOTICE Undefined index: type - in C:\inetpub\wwwroot\lib\functions\exttable.class.php - Line 244
19/05/2012 13:10:19
admin
E_NOTICE Undefined index: type - in C:\inetpub\wwwroot\lib\functions\exttable.class.php - Line 244
19/05/2012 13:07:04
admin
No project found: Assume a new installation and redirect to create it

[fman]

IMHO, beign annoyed is not a good reason to generate noise.
From it release date on 07/2011 we have had several issues on TL with MSSQL.
Some of these are related to missing columns on tables
Yesterday an user has giving you this hint through mantis,
then
1. so search on mantis to look for similar issues
2. compare MySQL create table script with MSSQL, in order to find other missing columns, before posting

>> Installation works after i created a empty Database "called testlink" via SQL Management Studio.
this is sign of problems, because installer is responsible of creating DB (when a user with right grants is provided)

[KianSS]

i added the following coloumn in my database : ALTER TABLE dbo.tcversions ADD status smallint NOT NULL CONSTRAINT DF_tcversions_status DEFAULT ((1))

than i push the create button for creating a testcase in a testsuite and it takes 2 minutes "to reach a timeout".

getting a HTTP Error 500.0 - Internal Server Error
FastCgiHandler
ExecuteRequestHandler
Requested URL :http://localhost:80/lib/testcases/tcEdi ... tainerID=9 [^]
Physical Path :C:\inetpub\wwwroot\lib\testcases\tcEdit.php


really strange behavior , because everything else like roles, testplan, project etc. is working pretty fine


Same Problem happens if I want to create

1. a Build under Test Execution.
2. Create ReQ
3. Click to Test Report


things which are working :

creating a Project
creating a testplan

Going to Events
Going to User Management and define userroles and order people to the roles.
Genrate Test Specs Documents

[Billhelmke]

Has anyone gotten testlink working with IIS7.5 MSSQL 2008 and PHP 5.3? If so can you please provide details, I feel like I take one step forward and two steps back.

[fman]

Hi, again with the risk to seems not polite:

unfortunatelly this a common pattern on forums: people start asking desperately for help, and when they got the answer ..., no time to share with others.

Please give a look to : http://mantis.testlink.org/view.php?id=5025#c16760 .
If issue persists, please create issue on mantis