After update at latest version in date 14/05/2024 in ALL MY PROJECTS, the Master/Detail application don’t run.
If i open master/detail in existing record all is OK, but if open new record, after insert in master form, the ‘inserted successfully’ message appears, but the detail form is not opened and I can only exit or insert another record in the master table. Please resolve the problem promptly, because I cannot make changes to ANY project.
My environment is :
Linux Centos 8, php 7.3, Db. Mariadb, Scriptcase enterprise
Probably a PHP problem.
As far as I know, the latest version only runs with PHP 8.1.
Unfortunately, PHP 8.1 is no longer officially supported as of November 25, 2024.
But, just at preovius version ( 9.10.20 ) all ok. i don’t know comunications by Netmake about request of php 8.1 to using scriptcase 9.10.21.
Now i can’t abandone php 7.3 both developing and running environment.
I hope Netmake solve promptly
Dear @fregnella,
After carrying out some tests in the most recent version of Scriptcase (9.10.021(2)) in an environment with PHP 7.3 and using a MariaDB database, the insertion of the record was done successfully and immediately afterwards it displayed the detail form for insertion /editing new records.
Do you have any other details to share with us so that we can try to simulate the problem? Is an error returned in the browser console in the detail form area after inserting a record in the master form?
We are waiting for your return.
Best regards!
Hello, i have installed environment in php 8.1 and imported all project successfully, but problem persist.
Setting debug mode i note this :
(pdo-mysql): INSERT INTO testata (numero, codcli, data, status, pagato, importo, tipopa, datapre, lettera) VALUES (737, 882, ‘2024-05-15’, ‘P’, ‘0’, 0.00, 0, ‘2024-05-19’, ‘D’) (pdo-mysql): SELECT COUNT() AS countTest FROM testata WHERE ((idtestata < 0)) (pdo-mysql): SELECT MAX(idtestata) from testata (pdo-mysql): INSERT INTO sc_log (inserted_date, username, application, creator, ip_user, action, description) VALUES (‘2024-05-15 18:53:32’, ‘fregian’, ‘form_testata_1’, ‘Scriptcase’, ‘127.0.0.1’, ‘insert’, '–> keys ← idtestata : 0||–> fields ← numero (new) : 737||numero (label) : NR. CONSEGNA||codcli (new) : 882||codcli (label) : CLIENTE||data (new) : 2024-05-15||data (label) : DATA COMMESSA||status (new) : P||status (label) : Status||pagato (new) : 0||pagato (label) : Pagato||importo (new) : 0.00||importo (label) : ACCONTO||tipopa (new) : 0||tipopa (label) : Tipopa||datapre (new) : 2024-05-19||datapre (label) : DATA CONSEGNA||lettera (new) : D||lettera (label) : IDR||righe (new) : ||righe (label) : ') (pdo-mysql): SELECT count() AS countTest from testata (pdo-mysql): SELECT idtestata, numero, codcli, data, status, pagato, importo, tipopa, datapre, lettera from testata WHERE (idtestata = 0) order by idtestata (pdo-mysql): SELECT SUM(numero) AS totq,SUM(costouni * numero) AS totp FROM righe WHERE (idtestata = ‘’)
but ‘idtestata’ is prymary key in table testata and in table is correct insert as automatic increment ( 9219 ).
Another question is : why just at preovius scriptcase version this function correctly ?
In browser no error and no warning, only message ‘record add successfully’
Solved!
deleting and reccreating connection all return Ok !
That’s great! Thanks for your feedback.
Best regards!
Hello, I have the same problem as the fregnella colleague. Since the last update, after making any changes to a form that has a “master-detail” link. The problem is that the master form is saved, but the detail is not shown, in my case a grid. It appears to be reloading the master form again. I have tried deleting the database connection as fregnella recommends, but it does not fix the problem in my case.
PHP: 8.1.6
Hostname: ubuntu-22-04-1
Ioncube:
SourceGuardian: 13.0.3
ZendGuard:
Sistema operacional: LINUX UBUNTU-22-04-1 6.2.16-3-PVE #1 SMP PREEMPT_DYNAMIC PVE 6.2.16-3 (2023-06-17T05:58Z) X86_64
Servidor web: Apache/2.4.41 (Unix) OpenSSL/1.1.1f mod_fastcgi/mod_fastcgi-SNAP-0910052141
ScriptCase Devel: 9.10.021
ScriptCase Build: 2
ScriptCase Prod: 1.0.001
ScriptCase Prod Build: 6
Server time: 20240517 201601000000
hello newsaeta,
if old connection use mysql and DBMS is mariadb, recreate the new connection using proper mariadb chiose
Hi fregnella, I have made the change from mysql to mariadb in my development scriptcase and everything seems to work ok.
The question is do I have to change this also in all my production applications if I update a form?
To the scriptcase guys, checking the changelog, I see that they say “Added a new connection to MariaDB” they don’t specify anything that everything is broken if we don’t change it. The truth is that every time I see a scriptcase update, I start to cry, you don’t know what can be broken. Anyway, patience.
Fregnella I don’t want to take away your prominence, thank you very much for the help, you have saved me many hours of refactor.
Hi, I have tested on my production server, and if I compile on my development server and upload it to production it doesn’t work. So I have to change the connection in production too, and for that I have to upload the _lib folder to add the mariadb connection.
A lot of hours of work. 
Hello, same problem with all of my master-detail apps since last update. Redo the connection without success.
| OK | PHP: 8.1.6 |
|---|---|
| OK | Hostname: LAP…1 |
| Ioncube: | |
| SourceGuardian: 13.0.3 | |
| ZendGuard: | |
| OK | Système opérationnel: WINDOWS NT LAP-HYPERV-P01 10.0 BUILD 20348 (WINDOWS SERVER 2022) AMD64 |
| OK | Serveur Web: Apache/2.4.53 (Win64) mod_fcgid/2.3.10-dev |
| ScriptCase Devel: 9.10.021 | |
| ScriptCase Build: 2 | |
| ScriptCase Prod: 1.0.001 | |
| ScriptCase Prod Build: 6 | |
| Server time: 20240519 062622000000 |