Announcement

Collapse
No announcement yet.

signature field and a many-to-many relationship

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • signature field and a many-to-many relationship

    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 ;-) 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!

    Comment


    • #3
      Hello,

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

      Regards,
      Eduardo Kahn
      Bug Tracker Team
      Best Regards,
      Eduardo Kahn

      Bug Tracker Team
      Netmake - IT Solutions

      Comment


      • #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

        (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

        (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

        (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'

        (pdo-mysql): SELECT StateID, ISO FROM States ORDER BY ISO

        (pdo-mysql): SELECT CityID, concat(ZIP,' ',City) FROM Cities WHERE (StateID = '1') AND CityID = 3352 ORDER BY ZIP, City LIMIT 0,10

        (pdo-mysql): select EmployeeProfileID, DrivingLicenseID from DrivingTeacherDrivingLicenses where EmployeeProfileID = 1

        (pdo-mysql): select EmployeeProfileID, CourseProductID from CourseInstructors where EmployeeProfileID = 1

        (pdo-mysql): select EmployeeProfileID, RTDepartmentID from DrivingTeachers_RTDepartments where EmployeeProfileID = 1

        (pdo-mysql): select EmployeeProfileID, BranchID from EmployeeProfiles_Branches where EmployeeProfileID = 1

        (pdo-mysql): select EmployeeProfileID, DepartmentID from EmployeeProfiles_Departments where EmployeeProfileID = 1

        (pdo-mysql): select EmployeeProfileID, TeamID from EmployeeProfiles_Teams where EmployeeProfileID = 1

        (pdo-mysql): select ContactID, Security_Group_ID from Contacts_SecurityGroups where ContactID = 1

        (pdo-mysql): select EmployeeProfileID, StartLocationID from EmployeeProfiles_StartLocations where EmployeeProfileID = 1

        (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')

        (pdo-mysql): SELECT EmployeeProfileID, ContactID, CompanyID, EmployeeShortName, DayOfBirth, Signature, DrivingTeacherNumber, DefaultStartLocationID, DefaultStateID, DefaultCityID from EmployeeProfiles WHERE (EmployeeProfileID = 1) order by EmployeeProfileID

        (pdo-mysql): select EmployeeProfileID, DrivingLicenseID from DrivingTeacherDrivingLicenses where EmployeeProfileID = 1

        (pdo-mysql): select EmployeeProfileID, CourseProductID from CourseInstructors where EmployeeProfileID = 1

        (pdo-mysql): select EmployeeProfileID, RTDepartmentID from DrivingTeachers_RTDepartments where EmployeeProfileID = 1

        (pdo-mysql): select EmployeeProfileID, BranchID from EmployeeProfiles_Branches where EmployeeProfileID = 1

        (pdo-mysql): select EmployeeProfileID, DepartmentID from EmployeeProfiles_Departments where EmployeeProfileID = 1

        (pdo-mysql): select EmployeeProfileID, TeamID from EmployeeProfiles_Teams where EmployeeProfileID = 1

        (pdo-mysql): select ContactID, Security_Group_ID from Contacts_SecurityGroups where ContactID = 1

        (pdo-mysql): select EmployeeProfileID, StartLocationID from EmployeeProfiles_StartLocations where EmployeeProfileID = 1

        (pdo-mysql): SELECT * FROM EmployeeProfiles WHERE ContactID = '1'







        Comment


        • #5
          Last edited by salvatore@reinemuth.ch; 11-10-2018, 09:46 PM.

          Comment


          • #6
            any activities in this case?

            Comment


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

              Comment


              • #8
                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.
                Best Regards,
                Roberto Ferraz

                Bug Tracker Team
                Netmake - IT Solutions

                Comment


                • #9
                  my sc version 9.2.016

                  Comment

                  Working...
                  X