Announcement

Collapse
No announcement yet.

SECURITY module not working with existing tables

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

  • SECURITY module not working with existing tables

    This is my third attempt (after SC7) to implement security module. Unfortunately after multiple reports to NetMake this feature is still full of bugs.
    I have a table with the following structure

    HTML Code:
    CREATE TABLE IF NOT EXISTS `klon56_tecrep`.`sec_users` (
      `StaffID` INT(11) NOT NULL AUTO_INCREMENT,
      `login` VARCHAR(150) NULL,
      `pswd` VARCHAR(150) NULL,
      `name` TEXT NULL,
      `email` TEXT NULL,
      `usr_active` TEXT NULL,
      `activation_code` TEXT NULL,
      `priv_admin` TEXT NULL,
      `CompanyID` INT(11) NULL,
      `FirstName` VARCHAR(45) NULL,
      `LastName` VARCHAR(45) NULL,
      `Picture` BLOB NULL,
      `AdminFlag` CHAR(1) NULL DEFAULT NULL,
      `Language` VARCHAR(30) NULL DEFAULT NULL,
      `Signature` VARCHAR(255) NULL DEFAULT NULL,
      `RegistrationDate` DATE NULL,
      `Active` VARCHAR(1) NULL,
      `Continent` VARCHAR(45) NULL,
      `Country` VARCHAR(45) NULL,
      `Region` VARCHAR(45) NULL,
      `ZIP` VARCHAR(45) NULL,
      `Town` VARCHAR(45) NULL,
      `Street` VARCHAR(45) NULL,
      `HomePhone` VARCHAR(45) NULL,
      `BusinessPhone` VARCHAR(45) NULL,
      `CellPhone` VARCHAR(45) NULL,
      `Fax` VARCHAR(45) NULL,
      `EmergencyPhone` VARCHAR(45) NULL,
      `AccessLevel` INT NULL,
      `Stamper` TIMESTAMP NULL,
      `OperatorID` INT NULL,
      INDEX `OperatorIDIDXa` (`OperatorID` ASC),
      PRIMARY KEY (`StaffID`),
      CONSTRAINT `StaffID2StaffRoles_KEY`
        FOREIGN KEY (`StaffID`)
        REFERENCES `klon56_tecrep`.`S_staffroles` (`StaffID`)
        ON DELETE NO ACTION
        ON UPDATE NO ACTION,
      CONSTRAINT `Stuff2Customers_KEY`
        FOREIGN KEY (`StaffID`)
        REFERENCES `klon56_tecrep`.`CRF_stuffcust` (`StaffID`)
        ON DELETE NO ACTION
        ON UPDATE NO ACTION)
    ENGINE = InnoDB
    AUTO_INCREMENT = 11
    When I try to use this table the fields that are used for the Security Module aWe not visible (although they are present within physical table).
    I remember similar problem about year ago. I reported this to NetMake but unfortunately looks like fixing bugs is the last thing they are willing to do.
    Am I doing something wrong or this is just a bug that needs to be fixed ASAP. At this point the whole security module is useless

    ARTHUR
    Last edited by aka; 10-09-2015, 10:11 PM.
    -----------------------------------------
    Arthur Klisiewicz
    dATA POINT SOFTWARE
    www.datapointsoftware.com

  • #2
    I would start with SC to generate a standard security module with tables and look if that works well. Besides a bug in the synchronize table (to be repared this week I was promissed) the module works as expected although it might not be sufficient in certain needs. Scriptcase does not generate a userid of 150 chars, so yes, there might be some fiddling involved.
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment

    Working...
    X