Hi, 
I'm using pf 5.0.0, I thing there is a bug in advanced search, when I search 
with two conditions, both "source switch ip", I get an error and the logs say: 

Apr 30 10:18:18 httpd.admin(11181) WARN: database query failed with: Not unique 
table/alias: 'locationlog_distinct' (errno: 1066), will try again 
(pf::db::db_query_execute) 
Apr 30 10:18:18 httpd.admin(11181) WARN: database query failed with: Not unique 
table/alias: 'locationlog_distinct' (errno: 1066), will try again 
(pf::db::db_query_execute) 
Apr 30 10:18:18 httpd.admin(11181) WARN: database query failed with: Not unique 
table/alias: 'locationlog_distinct' (errno: 1066), will try again 
(pf::db::db_query_execute) 
Apr 30 10:18:18 httpd.admin(11181) ERROR: Database issue: We tried 3 times to 
serve query node_custom_search_sql_customer called from pf::db::db_data and we 
failed. Is the database running? (pf::db::db_query_execute) 
Apr 30 10:18:18 httpd.admin(11181) WARN: database query failed with: Not unique 
table/alias: 'locationlog_distinct' (errno: 1066), will try again 
(pf::db::db_query_execute) 
Apr 30 10:18:18 httpd.admin(11181) WARN: database query failed with: Not unique 
table/alias: 'locationlog_distinct' (errno: 1066), will try again 
(pf::db::db_query_execute) 
Apr 30 10:18:18 httpd.admin(11181) WARN: database query failed with: Not unique 
table/alias: 'locationlog_distinct' (errno: 1066), will try again 
(pf::db::db_query_execute) 
Apr 30 10:18:18 httpd.admin(11181) ERROR: Database issue: We tried 3 times to 
serve query node_custom_search_sql_customer called from pf::db::db_data and we 
failed. Is the database running? (pf::db::db_query_execute) 
Apr 30 10:18:18 httpd.admin(11181) ERROR: Caught exception in 
pfappserver::Controller::Node->search "Can't use string ("0") as a HASH ref 
while "strict refs" in use at 
/usr/local/pf/html/pfappserver/lib/pfappserver/Model/Search/Node.pm line 61." 
(pfappserver::PacketFence::Controller::Root::end) 

Diego Bonfigli 



-- 
Dr. Diego Bonfigli 
tel: 366 5898323 
email: [email protected] 
Laboratori Guglielmo Marconi - www.labs.it 
------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud 
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users

Reply via email to