Sorry for the length. This is the same text I sent in an email to support@scriptcase.net, but I fear it might take days if they even reply at all!
Regarding issue no. (0), I’ve been waiting for a response for 18 days now…
I’m asking here to see if anyone else has encountered this problem or if anyone knows how I might resolve it.
Thanks in advance.
(0) Warning: Undefined variable $decimal_db in C:\disco_P\scriptcase_913\wwwroot\scriptcase\prod\lib\php\nm_ini_perfil.php on line 2063
- riga 1638 : $decimal_db = “”; // added by me 30/10/2026
I have Scriptcase 9.13.021(2) for PHP 8.2, running on Windows 11. You sent me the link via email; I didn’t download it from the download section of your website because I couldn’t find it there—the site only offers version 9.13.020 for download!
I imported the entire backup from version 9.5.003, performed all necessary checks, and updated the instructions for the PHP version transition (from 7.4 to 8.2). I’ve verified everything, and for the time being—in my local environment—there are no obvious errors.
However, I am encountering the following error locally (though it is not a blocking issue):
Fatal error: Uncaught TypeError: mysqli_close(): Argument #1 ($mysql) must be of type mysqli, bool given in C:\disco_P\scriptcase_913\wwwroot\scriptcase\prod\third\adodb\drivers\adodb-mysqli.inc.php:805 Stack trace: #0 C:\disco_P\scriptcase_913\wwwroot\scriptcase\prod\third\adodb\drivers\adodb-mysqli.inc.php(805): mysqli_close() #1 C:\disco_P\scriptcase_913\wwwroot\scriptcase\prod\third\adodb\adodb.inc.php(2360): ADODB_mysqli->_close() #2 C:\disco_P\scriptcase_913\wwwroot\scriptcase\app\eurostore\root_control_login\root_control_login_apl.php(2016): ADOConnection->Close() #3 C:\disco_P\scriptcase_913\wwwroot\scriptcase\app\eurostore\root_control_login\root_control_login_apl.php(1798): root_control_login_apl->NM_close_db() #4 C:\disco_P\scriptcase_913\wwwroot\scriptcase\app\eurostore\root_control_login\index.php(3222): root_control_login_apl->controle() #5 {main} thrown in C:\disco_P\scriptcase_913\wwwroot\scriptcase\prod\third\adodb\drivers\adodb-mysqli.inc.php on line 805
Line 805 is this: @mysqli_close($this->_connectionID); // original statement
I modified the “_close()” function like this; the error no longer appears, and it seems to be working well!
// returns true or false
function _close()
{
// @mysqli_close($this->_connectionID); // original statement
// add from enrico 01 nov 2026
if ($this->_connectionID instanceof mysqli) {
@mysqli_close($this->_connectionID);
}
// --- end enrico
$this->_connectionID = false;
}
Remote environment: Debian 13, MariaDB 11, PHP 8.2
I successfully enter the login form (control), but upon attempting to log in, I receive an “Internal Server Error 500.”
In the log, I find:
[Tue Nov 17 14:39:22.793744 2026] [proxy_fcgi:error] [pid 253613:tid 253619] [client 188.27.140.66:0] AH01071: Got error ‘PHP message: PHP Fatal error: Uncaught mysqli_sql_exception: Access denied for user ‘euros_’@‘localhost’ (using password: YES) in /home/euros/web/test.eurostore.cloud/public_html/_lib/prod/third/adodb/drivers/adodb-mysqli.inc.php:107\nStack trace:\n#0 /home/euros/web/test.eurostore.cloud/public_html/_lib/prod/third/adodb/drivers/adodb-mysqli.inc.php(107): mysqli_real_connect()\n#1 /home/euros/web/test.eurostore.cloud/public_html/_lib/prod/third/adodb/adodb.inc.php(614): ADODB_mysqli->_connect()\n#2 /home/euros/web/test.eurostore.cloud/public_html/_lib/prod/lib/php/nm_ini_perfil.php(1344): ADOConnection->Connect()\n#3 /home/euros/web/test.eurostore.cloud/public_html/root_menuapp_t1/index.php(1573): db_conect()\n#4 /home/euros/web/test.eurostore.cloud/public_html/root_menuapp_t1/index.php(6437): root_menuapp_t1_class->root_menuapp_t1_menu()\n#5 /home/euros/web/test.eurostore.cloud/public_html/root_menuapp_t1/root_menuapp_t1.php(2): include_once(’…’)\n#6 {main}\n thrown in /home/euros/web/test.eurostore.cl…’, referer: https://test.eurostore.cloud/root_blank_after_login/
I am certain that the username and password are correct; I’ve verified them against a table, and I’ve even tried entering them manually!
I have tested using both ‘localhost’ and ‘127.0.0.1’ as the server, as well as omitting the server parameter entirely (providing only dbuser, dbpassw, and dbname).
I also created a small PHP script that establishes a mysqli connection using these same credentials, and it works perfectly.
Therefore, the issue is clearly isolated to ScriptCase.
- In the configuration for
test.eurostore.cloud/_lib, I set up the connections required for the project; the “Test connection” function succeeds using both ‘localhost’ and ‘127.0.0.1’. - In that same configuration, I attempted to “Update production environment” via the menu option, but after about 20 seconds, a “Gateway timeout” occurred. I let it run for nearly an hour, but no confirmation of a completed update ever appeared!
The connection is stable—it’s a hardwired network connection!
Essentially, if I use the database defined in the connection settings (a fixed database containing administrative tables), everything works fine. However, as soon as I attempt to change the connection using sc_connection_edit(conn, array), the aforementioned error occurs.
The logic is as follows:
- In the
onValidateevent of theroot_control_loginform, I usesc_connection_edit()to switch the connection to a specific company database (there are several such databases, which are not explicitly defined as connections in the configuration). - I then use
sc_redirto navigate toroot_blank_after_login, which performs its intended tasks before executing anothersc_redirtoroot_menuapp_t1. - The menu fails to load, and instead, an “Internal Server Error 500” is displayed.
It appears that the connection is NOT actually being changed; it remains set to the one defined under “Edit connection” in the configuration! So, the credentials are different:conn_companypoints to the ‘dev’ database with its own specific credentials, while the other database naturally uses different credentials.
I should also add that, in my local environment, I am able to switch companies (i.e., databases) without any issues.
I came across a thread on the forum regarding ScriptCase v9.13.020 (2026-05-05 21:22):
“Fixed a connection error in the production menu application after using the sc_connection_edit macro. Production environment update required.”
As mentioned above, I attempted the update, but it fails to complete.
I am currently using version 9.13.021(2), which you provided via the link.
Could you please advise on how to resolve this?
If there is a cost for professional assistance, I am more than willing to pay—I just need to get this fixed so I can conduct real-world remote testing of the application’s various functions. This application accounts for 80% of my revenue—it’s how I put food on the table!
It consists of about 700 individual applications, which makes the testing process a massive undertaking!
Thanks
PS
I am asking here in hopes of getting an answer more quickly than through Scriptcase support:
is it possible to obtain these 2 files (adodb-mysqli.inc e nm_ini_perfil.php), so that I can check whether the ones I received via the Scriptcase link are up to date?
Thank you so much!
EDIT
I might add:
I converted another application from Scriptcase 9.5.003 to 9.13.021(2)—backup, restore, generation, deployment—and everything works.
In this application, there is no sc_connection_edit() whatsoever.
So, the problem lies precisely there.