Error in control applications after upgrade to version 9.4.014

Scriptcase 9 General
#1

After upgrading to version [B]9.4.014 i am getting an error when I execute queries in a control form in the production server. The control forms have not been updated other than regenerate them with the new version. All control forms are affected.

For example[/B]

This code snippet:

// SQL statement parameters
$insert_table = ‘datosexalog’; // Table name
$insert_fields = array( // Field list, add as many as needed
‘numerex’ => $numerex,
‘userid’ => “’$usuario’”,
‘evento’ => “’$evento’”,
);
$insert_sql = ‘INSERT INTO ’ . $insert_table
. ’ (’ . implode(’, ‘, array_keys($insert_fields)) . ‘)’
. ’ VALUES (’ . implode(’, ', array_values($insert_fields)) . ‘)’;
sc_exec_sql($insert_sql,“conn_mysql”);

Gives this error:

(pdo-mysql): INSERT INTO datosexalog (numerex, userid, evento) VALUES (1008458, ‘administrador’, ‘Imprimio reporte sin logo’) [HR][/HR]2006: MySQL server has gone away
ADOConnection._Execute(INSERT INTO datosexalog (numerex, userid, evento) VALUES (1008458, ‘administrador’, ‘Imprimio reporte sin logo’), false) % line 1149, file: adodb.inc.php ADOConnection.Execute(INSERT INTO datosexalog (numerex, userid, evento) VALUES (1008458, ‘administrador’, ‘Imprimio reporte sin logo’)) % line 2343, file: control_reportes_apl.php control_reportes_apl.datosexalog(1008458, administrador, Imprimio reporte sin logo) % line 1635, file: control_reportes_apl.php control_reportes_apl.Valida_campos(null, null, null) % line 1086, file: control_reportes_apl.php control_reportes_apl.controle() % line 2048, file: index.php

Can you help me to solve this issue. We had to do a rollback of the production deploy.

#2

This error comes from server side(mysql ),try to controle whith a queries in phpmyadmin when you can, not from scriptcase, contact your provider if the problem persists

#3

But it only happens in the control application, all other do not have the problem and only happens after I update to version 9.014. If I do not upgrade the error does not show.
We have tested in 5 servers with different mysql servers and the problem is replicated.

I do not think the problem is the database server.

#4

fill you always the connection when using sc_exec_sql ?
in your sc_exec_sql, try a simple, limited insert, and leave your connection blank,
try with this:
// SQL statement parameters
$insert_table = ‘datosexalog’; // Table name
$insert_fields = array (// list field, add as many as needed
‘numerex’ => $numerex,
‘userid’ => “‘usuario’”,
‘evento’ => “’$evento’”,
);
$insert_sql = ‘INSERT INTO’. $ insert_table
. ‘(’. implode (’,’, array_keys ($insert_fields)). ‘)’
. ‘VALUES (’ implode (’,’, array_values ($insert_fields)). ‘)’;
sc_exec_sql ($insert_sql);