Hi everyone,
I am experiencing a severe issue with Scriptcase where I cannot open any project connected to a Microsoft SQL Server database.
Environment:
- Scriptcase Version: 9.9.014
- Edition: Enterprise Gold
- PHP Version: PHP 8.1 (default for SC 9.9)
Issue Details:
- The Primary Issue: Whenever I attempt to open any project that uses a Microsoft SQL Server database, Scriptcase immediately crashes or drops the session, redirecting me straight back to the Scriptcase login screen.
- The Secondary Issue (License Connection Limit): Due to these repeated silent crashes/redirects, PHP sessions are left unclosed. Shortly after, I get locked out with the error:
“You have reached your license connections limit, please choose which session you want to disconnect to log in.”
What I Have Verified / Tested:
- Database Connection: Testing the SQL Server connection directly inside Scriptcase returns OK.
- Database Health: The target SQL Server database is running fine.
-
Internal Database: The internal SQLite database (
nm_scriptcase.db) is intact. - Other Databases: Projects using MySQL / non-MSSQL databases open and work completely fine without any issues.
It seems like opening an MSSQL project causes a silent fatal error or memory crash in the background (possibly related to pdo_sqlsrv or memory limits), which instantly destroys the PHP session and forces a logout.
Has anyone encountered this issue on version 9.9.014 or know how to resolve it? Any advice on PHP configuration tweaks or driver fixes would be greatly appreciated.
Thank you!