I'm looking to do a simple export of a basic devices report for multiple orgs, URL like this http://localhost/open-audit/index.php/devices?org_id=IN10,22. When I click on export button, the URL changes to this http://localhost/open-audit/index.php/devices?org_id=in%28%2710%27%2C%2722%27%29&format=csv and then I get this SQL error.
Error Number: 1048
Column 'timestamp' cannot be null
/* log_helper */ INSERT INTO `logs` VALUES (NULL, NULL, 'system', 3, 'error', 4520, 'Administrator', 'SERVER', '10.0.0.66', 'devices', 'collection', 'm_devices::collection', 'failure', 'running sql', '/* m_devices::collection */ /* m_devices::collection */ SELECT count(*) as total FROM system WHERE system.org_id IN (1,7,2,3,14,15,16,17,18,23,24,4,8,9,10,11,12,13,21,22,5,6,20) AND org_id in (\'(\'10\'\',\'\'22\')\') - FAILURE - 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 \'10\'\',\'\'22\')\')\' at line 1')
Line Number: 330
I'm looking on 3.0.2 and it appears there is a bug in the linnk creation of that button.
You should be able to create the URL manually and have it work (as a work-around).
I'll log a ticket in our bug tracker. Thanks for raising the issue.
FYI - Fixed for 3.3.0 release (unsure when that will be, but it's fixed).
Powered by a free Atlassian Confluence Open Source Project License granted to Opmantek. Evaluate Confluence today.