1
0
-1

OA 2.3.3

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.  

A Database Error Occurred

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')

Filename: E:\WAMP\code_igniter\system\database\DB_driver.php

Line Number: 330

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      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).

      http://localhost/open-audit/index.php/devices?org_id=in10,22&format=csv

      I'll log a ticket in our bug tracker. Thanks for raising the issue.

        CommentAdd your comment...