I've tried to create a report using the "user " field and then run past 7 days report and got the error delow
2011:06:01-21:43:03 ***** postgres[22753]: [2-1] ERROR: column "departments" does not exist at character 361
2011:06:01-21:43:03 ***** postgres[22753]: [2-2] STATEMENT: select sum(transfer) as traffic, pct(cast(sum(transfer) as bigint), cast(x.trafsum as bigint)) as traffic_pct, sum(requests) as requests, pct(cast(sum(requests) as bigint), cast(x.reqsum as bigint)) as req_pct, term as term from websecsearches_data cross join (select sum(transfer) as trafsum, sum(requests) as reqsum from websecsearches_data where $1 = ANY (departments) and logday between $2 and $3) as x where $4 = ANY (departments) and logday between $5 and $6 group by term, x.trafsum, x.reqsum order by term DESC limit 40 offset 0
2011:06:01-21:43:11 ***** postgres[22759]: [2-1] ERROR: column "departments" does not exist at character 361
2011:06:01-21:43:11 ***** postgres[22759]: [2-2] STATEMENT: select sum(transfer) as traffic, pct(cast(sum(transfer) as bigint), cast(x.trafsum as bigint)) as traffic_pct, sum(requests) as requests, pct(cast(sum(requests) as bigint), cast(x.reqsum as bigint)) as req_pct, term as term from websecsearches_data cross join (select sum(transfer) as trafsum, sum(requests) as reqsum from websecsearches_data where $1 = ANY (departments) and logday between $2 and $3) as x where $4 = ANY (departments) and logday between $5 and $6 group by term, x.trafsum, x.reqsum order by term DESC limit 40 offset 0
At the same time from middleware
2011:06:01-21:43:03 ***** confd[21622]: >=========================================================================
2011:06:01-21:43:03 ***** confd[21622]: E DBD:[[:P]]g::st execute failed: ERROR: column "departments" does not exist
2011:06:01-21:43:03 ***** confd[21622]: LINE 1: ... reqsum from websecsearches_data where $1 = ANY (department...
2011:06:01-21:43:03 ***** confd[21622]: ^ at /Astaro/Reporting/SQLgen.pm line 227.
2011:06:01-21:43:03 ***** confd[21622]:
2011:06:01-21:43:03 ***** confd[21622]: 1. sys::_warn:47() /sys.pm
2011:06:01-21:43:03 ***** confd[21622]: 2. Astaro::Reporting::SQLgen::report_execute:227() /Astaro/Reporting/SQLgen.pm
2011:06:01-21:43:03 ***** confd[21622]: 3. Astaro::Reporting::Websecurity::clickable_handler:387() /Astaro/Reporting/Websecurity.pm
2011:06:01-21:43:03 ***** confd[21622]: 4. reporting::get_webreport:75() /reporting.pm
2011:06:01-21:43:03 ***** confd[21622]: 5. (eval):1() (eval 145752)
2011:06:01-21:43:03 ***** confd[21622]: 6. sys::AUTOLOAD:323() /sys.pm
2011:06:01-21:43:03 ***** confd[21622]: 7. (eval):1() (eval 145749)
2011:06:01-21:43:03 ***** confd[21622]: 8. Astaro::RPC::server_loop:173() /rpc.pm
2011:06:01-21:43:03 ***** confd[21622]: 9. rpc::launch:27() /rpc.pm
2011:06:01-21:43:03 ***** confd[21622]: 10. main::_rpc:1822() confd.pl
2011:06:01-21:43:03 ***** confd[21622]: 11. main::top-level:285() confd.pl
2011:06:01-21:43:11 ***** confd[21622]: >=========================================================================
2011:06:01-21:43:11 ***** confd[21622]: E DBD:[[:P]]g::st execute failed: ERROR: column "departments" does not exist
2011:06:01-21:43:11 ***** confd[21622]: LINE 1: ... reqsum from websecsearches_data where $1 = ANY (department...
2011:06:01-21:43:11 ***** confd[21622]: ^ at /Astaro/Reporting/SQLgen.pm line 227.
2011:06:01-21:43:11 ***** confd[21622]:
2011:06:01-21:43:11 ***** confd[21622]: 1. sys::_warn:47() /sys.pm
2011:06:01-21:43:11 ***** confd[21622]: 2. Astaro::Reporting::SQLgen::report_execute:227() /Astaro/Reporting/SQLgen.pm
2011:06:01-21:43:11 ***** confd[21622]: 3. Astaro::Reporting::Websecurity::clickable_handler:387() /Astaro/Reporting/Websecurity.pm
2011:06:01-21:43:11 ***** confd[21622]: 4. reporting::get_webreport:75() /reporting.pm
2011:06:01-21:43:11 ***** confd[21622]: 5. (eval):1() (eval 147745)
2011:06:01-21:43:11 ***** confd[21622]: 6. sys::AUTOLOAD:323() /sys.pm
2011:06:01-21:43:11 ***** confd[21622]: 7. (eval):1() (eval 147742)
2011:06:01-21:43:11 ***** confd[21622]: 8. Astaro::RPC::server_loop:173() /rpc.pm
2011:06:01-21:43:11 ***** confd[21622]: 9. rpc::launch:27() /rpc.pm
2011:06:01-21:43:11 ***** confd[21622]: 10. main::_rpc:1822() confd.pl
2011:06:01-21:43:11 ***** confd[21622]: 11. main::top-level:285() confd.pl
Thanks
