SC 9 Problem with multi-upload function

Scriptcase 9 General
#1

Install SC9 and migrate a project that was working on SC8.1. When trying to save a new record in the mysql database using the multi-upload function I get the error “Insert Error”. I do not know what I should do to correct this mistake, someone can help me.

#2

Hi guys

I think I found the problem with the SC9 Multi-Upload function.
When SC9 is to insert a file into the MySQL database it uses the $ sMUFileData variable accompanied by single quotes, while SC8.1 uses the $ NM_seq_auto variable without the single quotes. Make this change in the production code and work correctly.
Then I show you the changes you make.

CODE SC9
$comando = “INSERT INTO tb_isoevi_archivos (file, filename, tb_IsoEvidencias_Id, date, Direccion_IP) VALUES (’” . $sMUFileData . "’, " . $this->Db->qstr($aUlFileData[1]) . ", " . $this->id . “, '” . date(‘Y-m-d H:i:s’) . “’, '” . $_SERVER[‘REMOTE_ADDR’] . “’)”;

CODE SC8.1
$comando = “INSERT INTO tabla (file, filename, tb_IsoEvidencias_Id, date, Direccion_IP) VALUES (” . $NM_seq_auto . ", ‘’, " . $this->Db->qstr($aUlFileData[1]) . ", " . $this->id . “, '” . date(‘Y-m-d H:i:s’) . “’, '” . $_SERVER[‘REMOTE_ADDR’] . “’)”;

I hope the ScriptCase team can solve this problem.

#3

Hello,

This problem has been reported to our development team.

Thanks!