![scriptcase deploy scriptcase deploy](https://a.fsdn.com/con/app/proj/scriptcase.s/screenshots/light-pivot-table.jpg)
Nothing to fetchI can add this same column through phpMyAdmin but not from the Workbench Sync. SQL script execution finished: statements: 3 succeeded, 1 failedįetching back view definitions in final form. HTML Code: Executing SQL script in serverĮRROR: Error 1054: Unknown column 'Facebook' in 's_staff'ĬHANGE COLUMN `Email` `Email` VARCHAR(80) NULL DEFAULT NULL AFTER `EmergencyPhone`,ĬHANGE COLUMN `PinCode` `PinCode` CHAR(4) NULL DEFAULT NULL AFTER `Facebook`,ĬHANGE COLUMN `UserActive` `UserActive` VARCHAR(3) NULL DEFAULT NULL AFTER `PinCode`,ĬHANGE COLUMN `Activation` `Activation` DATE NULL DEFAULT NULL AFTER `UserActive`,ĬHANGE COLUMN `AdminPriv` `AdminPriv` VARCHAR(3) NULL DEFAULT NULL AFTER `Activation`,ĬHANGE COLUMN `AdminFlag` `AdminFlag` CHAR(1) NULL DEFAULT NULL AFTER `AdminPriv`,ĬHANGE COLUMN `Language` `Language` VARCHAR(30) NULL DEFAULT NULL AFTER `AdminFlag`,ĬHANGE COLUMN `Signature` `Signature` BLOB NULL DEFAULT NULL AFTER `Language`,ĬHANGE COLUMN `RegistrationDate` `RegistrationDate` DATE NULL DEFAULT NULL AFTER `Signature`,ĬHANGE COLUMN `Active` `Active` VARCHAR(1) NULL DEFAULT NULL AFTER `RegistrationDate`,ĬHANGE COLUMN `Continent` `Continent` VARCHAR(45) NULL DEFAULT NULL AFTER `Active`,ĬHANGE COLUMN `CompanyID` `CompanyID` INT(11) NULL DEFAULT NULL ,ĬHANGE COLUMN `Stamper` `Stamper` TIMESTAMP NOT NULL ,ĪDD COLUMN `Skype` VARCHAR(30) NULL DEFAULT NULL AFTER `Email`,ĪDD COLUMN `ICQ` VARCHAR(30) NULL DEFAULT NULL AFTER `Skype`,ĪDD COLUMN `Facebook` VARCHAR(80) NULL DEFAULT NULL AFTER `ICQ`, On t.Id = y.tickets_id and y.is_private = 1 and y.state = 0 and y.content REGEXP "Escalade" AND y.content REGEXP "SVP|Administration" and users_id_tech = 0 T.solve_delay_stat "Délai de résolution", GROUP_CONCAT(DISTINCT concat(uz.realname,' ',uz.firstname) SEPARATOR ',') AS "Demandeur FIDAL",Ĭoalesce(s.satisfaction, '0') as Satisfaction,Ĭount(w.tickets_id_1) as "Nombre de ticket dupliqués", T.takeintoaccount_delay_stat as "Délai de prise en compte",
![scriptcase deploy scriptcase deploy](https://miro.medium.com/max/772/1*FsicEwo8Fshmg6eLrP0otQ.png)
T.due_date as "Date d'échéance + Progression", GROUP_CONCAT(DISTINCT concat(uv.realname,' ',uv.firstname) SEPARATOR ',') AS Technicien, GROUP_CONCAT(DISTINCT concat(us.realname,' ',us.firstname) SEPARATOR ',') AS "Bénéficiaire FIDAL", I don't understand why this sql request generate a malfonction when I activate the refined search function inside my grid.