Hello,
We have a problem with the multi-criteria search, in particular with the "Machines not seen in more than 5 day(s)" information displayed at the top of the Welcome page.
Using the DEBUG mode, we can see the SQL syntax used for this request (as of today January 23rd ) is the following:
SELECT SQL_CALC_FOUND_ROWS hardware.ID AS hardwareID , hardware.DEVICEID AS hardwareDEVICEID , hardware.NAME AS hardwareNAME , hardware.WORKGROUP AS hardwareWORKGROUP , hardware.USERDOMAIN AS hardwareUSERDOMAIN , hardware.OSNAME AS hardwareOSNAME , hardware.OSVERSION AS hardwareOSVERSION , hardware.OSCOMMENTS AS hardwareOSCOMMENTS , hardware.PROCESSORT AS hardwarePROCESSORT , hardware.PROCESSORS AS hardwarePROCESSORS , hardware.PROCESSORN AS hardwarePROCESSORN , hardware.MEMORY AS hardwareMEMORY , hardware.SWAP AS hardwareSWAP , hardware.IPADDR AS hardwareIPADDR , hardware.DNS AS hardwareDNS , hardware.DEFAULTGATEWAY AS hardwareDEFAULTGATEWAY , hardware.ETIME AS hardwareETIME , hardware.LASTDATE AS hardwareLASTDATE , hardware.LASTCOME AS hardwareLASTCOME , hardware.QUALITY AS hardwareQUALITY , hardware.FIDELITY AS hardwareFIDELITY , hardware.USERID AS hardwareUSERID , hardware.TYPE AS hardwareTYPE , hardware.DESCRIPTION AS hardwareDESCRIPTION , hardware.WINCOMPANY AS hardwareWINCOMPANY , hardware.WINOWNER AS hardwareWINOWNER , hardware.WINPRODID AS hardwareWINPRODID , hardware.WINPRODKEY AS hardwareWINPRODKEY , hardware.USERAGENT AS hardwareUSERAGENT , hardware.CHECKSUM AS hardwareCHECKSUM , hardware.SSTATE AS hardwareSSTATE , hardware.IPSRC AS hardwareIPSRC , hardware.UUID AS hardwareUUID , hardware.ARCH AS hardwareARCH , hardware.CATEGORY_ID AS hardwareCATEGORY_ID FROM hardware WHERE hardware.LASTCOME < 'str_to_date(01/18/2019 12:00, \'%m/%d/%Y %H:%i\')' GROUP BY hardware.id order by hardwareDEVICEID asc limit 0 , 10
The error returned for this request is :
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 3
Our setup is the following:
Software
Could you please help us in troubleshooting this issue ?
Thanks in advance !
Best regards,
Yann
