after importing the project in scriptcase 8.01, when starting the application this error is generated:
Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘WHERE 1 = 0 LIMIT 1’ at line 1 in C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\prod\third\adodb\drivers\adodb-mysqli.inc.php:763 Stack trace: #0 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\prod\third\adodb\drivers\adodb-mysqli.inc.php(763): mysqli_query(Object(mysqli), ‘SELECT * FROM …’, 0) #1 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\prod\third\adodb\adodb.inc.php(1169): ADODB_mysqli->_query(‘SELECT * FROM …’, false) #2 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\prod\third\adodb\adodb.inc.php(1151): ADOConnection->_Execute(‘SELECT * FROM …’, false) #3 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\prod\third\adodb\drivers\adodb-mysqli.inc.php(699): ADOConnection->Execute(‘SELECT * FROM …’, false) #4 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\lib\php\database.inc.php(997): ADODB_mysqli->SelectLimit(‘SELECT * FROM …’, 1) #5 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\compat\nm_select.class.php(499): nm_db_fields(‘conn_mssql_1’, ‘’, ‘C:\Program File…’, 499, Object(ADODB_mysqli), ‘mysqli’, Object(nmConnection), false, true) #6 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\compat\nm_select.class.php(158): nm_select->_PrepareFields() #7 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\class\generator\nmFontePHPForm.class.php(25579): nm_select->AnalizeSql() #8 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\class\generator\nmFontePHPForm.class.php(25379): nmFontePHPForm->getWhereLookup(‘SELECT Codice, …’, ‘conn_mssql_1’, ‘%$campo%’) #9 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\class\generator\nmFontePHPForm.class.php(6274): nmFontePHPForm->nm_gera_fast_search(‘form_apl’) #10 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\class\generator\nmControleForm.class.php(55): nmFontePHPForm->InicializaDados() #11 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\class\generator\nmGerador.class.php(2073): nmControleForm->GeraFonte() #12 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\class\generator\gerador.php(100): nmGerador->IniciaGeracao(‘VM_LINUX’, ‘2’, ‘ins_pegiot’, ‘’) #13 C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\devel\class\generator\gerador.php(2): sg_load(‘68ABBE04C7C5024…’) #14 {main} thrown in C:\Program Files\NetMake\v9-php81\wwwroot\scriptcase\prod\third\adodb\drivers\adodb-mysqli.inc.php on line 763
The original query is in a lookup type field type select and it is the following and it seems that the problem is in the subquery, which with php8.001 and php7.3 works…!
SELECT Codice, Descrizione
FROM Magaz m
WHERE m.FlgInattivo = 0 AND m.TipoMag = 2 AND m.Codice !=
(SELECT g.CodFurgoneVD FROM Generale g
WHERE g.Codice=1)
ORDER BY m.Descrizione