IT

Le caratteristiche di NTool per l'Area ICT

Error SQL!
Non riesco ad eseguire la query.
myDBcount();
Query: SELECT COUNT(*) FROM (SELECT TB.IDst,TB.StDRew,TB.StiIDst,IDditem FROM (SELECT IDst,StDRew,StiIDst,StiIDitem,IDditem FROM tbdynamic_group,tbsez,tbsez_temp,tbsez_temp_item,tbdynamic_items,tbutenti_group_users WHERE (IDdgroup=7 OR DgroupMaster LIKE "0,4,5,7" OR DgroupMaster LIKE "0,4,5,7,%") AND DgroupIDsez=IDsez AND SezMaster="-1" AND StIDsez=IDsez AND IDditem=StiOrder AND StiIDst=IDst AND StiDati="" AND StBPart>-1 AND (UguIDug=StiPermission AND UguIDlevel="1") AND (StiDataPubFrom="0000-00-00" OR StiDataPubFrom<"2021-11-28 01:56:33") AND (StiDataPubTo="0000-00-00" OR StiDataPubTo>="2021-11-28")) AS TB, tbitems WHERE IDitem=TB.StiIDitem AND (TB.IDditem=14)) AS C;;
MySQL Error: Unknown column 'StDRew' in 'field list';
Error SQL!
Non riesco ad eseguire la query.
myDBload();
Query: SELECT TB.IDst,TB.StDRew,TB.StiIDst,IDditem FROM (SELECT IDst,StDRew,StiIDst,StiIDitem,IDditem FROM tbdynamic_group,tbsez,tbsez_temp,tbsez_temp_item,tbdynamic_items,tbutenti_group_users WHERE (IDdgroup=7 OR DgroupMaster LIKE "0,4,5,7" OR DgroupMaster LIKE "0,4,5,7,%") AND DgroupIDsez=IDsez AND SezMaster="-1" AND StIDsez=IDsez AND IDditem=StiOrder AND StiIDst=IDst AND StiDati="" AND StBPart>-1 AND (UguIDug=StiPermission AND UguIDlevel="1") AND (StiDataPubFrom="0000-00-00" OR StiDataPubFrom<"2021-11-28 01:56:33") AND (StiDataPubTo="0000-00-00" OR StiDataPubTo>="2021-11-28")) AS TB, tbitems WHERE IDitem=TB.StiIDitem AND (TB.IDditem=14) GROUP BY IDst ORDER BY ItemDati DESC LIMIT 0, 30;
MySQL Error: Unknown column 'StDRew' in 'field list';

Gestione utenti e granular permission

Error SQL!
Non riesco ad eseguire la query.
myDBcount();
Query: SELECT COUNT(*) FROM (SELECT TB.IDst,TB.StDRew,TB.StiIDst,IDditem FROM (SELECT IDst,StDRew,StiIDst,StiIDitem,IDditem FROM tbdynamic_group,tbsez,tbsez_temp,tbsez_temp_item,tbdynamic_items,tbutenti_group_users WHERE IDdgroup=8 AND DgroupIDsez=IDsez AND SezMaster="-1" AND StIDsez=IDsez AND IDditem=StiOrder AND StiIDst=IDst AND StiDati="" AND StBPart>-1 AND (UguIDug=StiPermission AND UguIDlevel="1") AND (StiDataPubFrom="0000-00-00" OR StiDataPubFrom<"2021-11-28 01:56:33") AND (StiDataPubTo="0000-00-00" OR StiDataPubTo>="2021-11-28")) AS TB, tbitems WHERE IDitem=TB.StiIDitem AND (TB.IDditem=14)) AS C;;
MySQL Error: Unknown column 'StDRew' in 'field list';
Error SQL!
Non riesco ad eseguire la query.
myDBload();
Query: SELECT TB.IDst,TB.StDRew,TB.StiIDst,IDditem FROM (SELECT IDst,StDRew,StiIDst,StiIDitem,IDditem FROM tbdynamic_group,tbsez,tbsez_temp,tbsez_temp_item,tbdynamic_items,tbutenti_group_users WHERE IDdgroup=8 AND DgroupIDsez=IDsez AND SezMaster="-1" AND StIDsez=IDsez AND IDditem=StiOrder AND StiIDst=IDst AND StiDati="" AND StBPart>-1 AND (UguIDug=StiPermission AND UguIDlevel="1") AND (StiDataPubFrom="0000-00-00" OR StiDataPubFrom<"2021-11-28 01:56:33") AND (StiDataPubTo="0000-00-00" OR StiDataPubTo>="2021-11-28")) AS TB, tbitems WHERE IDitem=TB.StiIDitem AND (TB.IDditem=14) GROUP BY IDst ORDER BY ItemDati DESC LIMIT 0, 30;
MySQL Error: Unknown column 'StDRew' in 'field list';

Sicurezza, integrazione e business logic