vt master branch: Can't Save Role2Picklist values.
Clean code - The jQuery Notify says it was saved correctly but if you refresh the page the changes to the Role2Picklist were not saved... This is the error in my debug log:
Fri Jun 19 14:39:31 2020,054 [21883] DEBUG VT - Prepared sql query being executed : INSERT IGNORE INTO vtiger_role2picklist (roleid,picklistvalueid,picklistid) VALUES ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?
Fri Jun 19 14:39:31 2020,054 [21883] DEBUG VT - Prepared sql query parameters : [("H2","1569","154"),("H2","2017","154"),("H2","1579","154"),("H2","2016","154"),("H2","1578","154"),("H2","1577","154"),("H2","1576","154"),("H2","1575","154"),("H2","1574","154"),("H2","1573","154"),("H2","1572","154"),("H2","1571","154"),("H2","1570","154"),("H2","1222","154"),("H2","1568","154"),("H2","1567","154"),("H2","1566","154"),("H2","1565","154"),("H2","1564","154"),("H2","1563","154"),("H2","1562","154"),("H2","1561","154"),("H2","1225","154"),("H2","1224","154"),("H2","1223","154")]
Fri Jun 19 14:39:31 2020,054 [21883] INFO VT - PearDatabase ->ADODB error Query Failed:INSERT IGNORE INTO vtiger_role2picklist (roleid,picklistvalueid,picklistid) VALUES ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?::->[1064]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''(\"H2\",\"1569\",\"154\")','(\"H2\",\"2017\",\"154\")','(\"H2\",\"1579\",\"154\' at line 1
Fri Jun 19 14:39:31 2020,054 [21883] DEBUG VT - Prepared sql query being executed : DELETE FROM vtiger_role2picklist WHERE
Fri Jun 19 14:39:31 2020,054 [21883] INFO VT - PearDatabase ->ADODB error Query Failed:DELETE FROM vtiger_role2picklist WHERE ::->[1064]You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1