signature field and a many-to-many relationship

Scriptcase 9 Bugs
#1

Hello,
I use a signature field and also a many-to-many relationship in my form. after creating the many-to-many field, the signature field will not save any date!

maybe a bug?

#2

No :wink: It’s more a bad disign.

Or in other words: how many people can sign with your signature ( by law! )?

there can’t be a m-n-relation!

#3

Hello,

Please turn on debug mode to see what is happening and post here.

Regards,
Eduardo Kahn
Bug Tracker Team

#4

Hello,

Sorry for the delay

For a better understanding.
The form is used to register the employees.
Name, address, signature, job, skills, etc. nicely packaged in block tabs

This form has several tabs. Among other things, one for the signature and another, which records in which branch / position / function / skills etc. the employee is or has. Of course, this field is a many-to-many field because the employee serves several branches or functions. To reproduce the error, I created a form without many-to-many functions and without blocks and tabs. With this form I could create a signature and delete and create again. As soon as I added a many-to-many field, it did not work anymore. Did I delete this field again, it works again. With the form of the production, it is not possible to clean the signature field and save or change, because there are some many-to-many fields defined.

here the output of the debung mode, i hope that helps, to solve the problem!

(pdo-mysql): select count(*) AS countTest from EmployeeProfiles where EmployeeProfileID = 1 [HR][/HR][HR][/HR] (pdo-mysql): UPDATE EmployeeProfiles SET ContactID = 1, EmployeeShortName = ‘SRE’, DayOfBirth = ‘1964-10-12’, Signature = ‘data:image/jsignature;base30,4R6m1u1D1wnd33_4u0Z27a99722’, DrivingTeacherNumber = 961, DefaultStartLocationID = 1, DefaultStateID = 1, DefaultCityID = 3352 WHERE EmployeeProfileID = 1 [HR][/HR][HR][/HR] (pdo-mysql): SELECT ContactID, CONCAT((CASE WHEN Firstname IS NULL THEN ‘-’ ELSE Firstname END),’ ‘,(CASE WHEN Lastname IS NULL THEN ‘-’ ELSE Lastname END)) FROM Contacts ORDER BY Firstname, Lastname [HR][/HR][HR][/HR] (pdo-mysql): SELECT DLSL.DrivingLessonStartLocationID, DLSL.Location FROM DrivingLessonStartLocations AS DLSL INNER JOIN EmployeeProfiles_StartLocations AS EPSL ON (DLSL.DrivingLessonStartLocationID = EPSL.StartLocationID) WHERE EPSL.EmployeeProfileID = ‘1’ [HR][/HR][HR][/HR] (pdo-mysql): SELECT StateID, ISO FROM States ORDER BY ISO [HR][/HR][HR][/HR] (pdo-mysql): SELECT CityID, concat(ZIP,’ ',City) FROM Cities WHERE (StateID = ‘1’) AND CityID = 3352 ORDER BY ZIP, City LIMIT 0,10 [HR][/HR][HR][/HR] (pdo-mysql): select EmployeeProfileID, DrivingLicenseID from DrivingTeacherDrivingLicenses where EmployeeProfileID = 1 [HR][/HR][HR][/HR] (pdo-mysql): select EmployeeProfileID, CourseProductID from CourseInstructors where EmployeeProfileID = 1 [HR][/HR][HR][/HR] (pdo-mysql): select EmployeeProfileID, RTDepartmentID from DrivingTeachers_RTDepartments where EmployeeProfileID = 1 [HR][/HR][HR][/HR] (pdo-mysql): select EmployeeProfileID, BranchID from EmployeeProfiles_Branches where EmployeeProfileID = 1 [HR][/HR][HR][/HR] (pdo-mysql): select EmployeeProfileID, DepartmentID from EmployeeProfiles_Departments where EmployeeProfileID = 1 [HR][/HR][HR][/HR] (pdo-mysql): select EmployeeProfileID, TeamID from EmployeeProfiles_Teams where EmployeeProfileID = 1 [HR][/HR][HR][/HR] (pdo-mysql): select ContactID, Security_Group_ID from Contacts_SecurityGroups where ContactID = 1 [HR][/HR][HR][/HR] (pdo-mysql): select EmployeeProfileID, StartLocationID from EmployeeProfiles_StartLocations where EmployeeProfileID = 1 [HR][/HR][HR][/HR] (pdo-mysql): INSERT INTO AppLog (inserted_date, username, application, creator, ip_user, action, description) VALUES (‘2018-11-09 03:38:27’, ‘Salvi’, ‘form_EmployeeProfiles’, ‘Scriptcase’, ‘192.168.178.48’, ‘update’, ‘–> keys <-- employeeprofileid : 1||–> fields <-- branches (old) : 1;||branches (new) : 1||categories (old) : 4;6;19;||categories (new) : 4@?@6@?@19||courseinstructor (old) : 3;||courseinstructor (new) : 3||departments (old) : 1;2;3;||departments (new) : 1@?@3@?@2||positions (old) : 1;2;3;||positions (new) : 1@?@3@?@2||rtdepartments (old) : 1;2;3;4;||rtdepartments (new) : 1@?@2@?@3@?@4||startlocations (old) : 1;2;3;4;5;6;7;8;9;10;||startlocations (new) : 1@?@4@?@3@?@2@?@5@?@6@?@7@?@10@?@8@?@9||teams (old) : 1;2;3;||teams (new) : 2@?@3@?@1’) [HR][/HR][HR][/HR] (pdo-mysql): SELECT EmployeeProfileID, ContactID, CompanyID, EmployeeShortName, DayOfBirth, Signature, DrivingTeacherNumber, DefaultStartLocationID, DefaultStateID, DefaultCityID from EmployeeProfiles WHERE (EmployeeProfileID = 1) order by EmployeeProfileID [HR][/HR][HR][/HR] (pdo-mysql): select EmployeeProfileID, DrivingLicenseID from DrivingTeacherDrivingLicenses where EmployeeProfileID = 1 [HR][/HR][HR][/HR] (pdo-mysql): select EmployeeProfileID, CourseProductID from CourseInstructors where EmployeeProfileID = 1 [HR][/HR][HR][/HR] (pdo-mysql): select EmployeeProfileID, RTDepartmentID from DrivingTeachers_RTDepartments where EmployeeProfileID = 1 [HR][/HR][HR][/HR] (pdo-mysql): select EmployeeProfileID, BranchID from EmployeeProfiles_Branches where EmployeeProfileID = 1 [HR][/HR][HR][/HR] (pdo-mysql): select EmployeeProfileID, DepartmentID from EmployeeProfiles_Departments where EmployeeProfileID = 1 [HR][/HR][HR][/HR] (pdo-mysql): select EmployeeProfileID, TeamID from EmployeeProfiles_Teams where EmployeeProfileID = 1 [HR][/HR][HR][/HR] (pdo-mysql): select ContactID, Security_Group_ID from Contacts_SecurityGroups where ContactID = 1 [HR][/HR][HR][/HR] (pdo-mysql): select EmployeeProfileID, StartLocationID from EmployeeProfiles_StartLocations where EmployeeProfileID = 1 [HR][/HR][HR][/HR] (pdo-mysql): SELECT * FROM EmployeeProfiles WHERE ContactID = ‘1’

#5

any activities in this case?

#6

It would be desirable if I finally got an answer to this case

#7

Hello, Mr. Salvatore.

I’ve tried to replicate this behavior, but wasn’t succeed.

Can you tell me what is your SC version?

In any case, you can contact our support team. They might guide you to find a solution and, if they confirm a bug, it would be transfer to us.

#8

my sc version 9.2.016

#9

Hello,
Any news?

again for the understanding…

i have a form with multible fields, also a signature field. if y don’t define blocks with tabs or pages in this form, the signature works fine. as soon as i define blocks with tabs or pages, the signature was not saved. after saving, the form will jump to the first block or page and the signature field was empty, no matter if the signature field is in the first block or in a other. if i have also many-to-many fields, for example “Workplaces of Employee” the signature field was empty after saving.

#10

Hello,

Try to update the Scriptcase to a newer version and give us a feedback about the problem. We tried to replicate this issue, but without success.

We are waiting your return.

#11

Sorry, i forgot this case.

Version 9.6.018 is currently running and unfortunately the problem is still the same