Error when opening the Stats page in Admin tab

[GoogleCodeExporter]

When I try to open the stats page elsaIP/dashboard/_system I get the following 
error. 
Error:
groupby required at /usr/local/elsa/web/lib/Web/GoogleDatasource.pm line 139.

I was not getting this error before. I just run the update command on elsa web 
and node and started getting this.
Has anyone had this problem and can help me solve this? 

Thank you!

Original issue reported on code.google.com by raquel.b...@gmail.com on 25 Jul 2013 at 2:08

[GoogleCodeExporter]

I also get this error if I try to search something. Can anyone help me to how I 
can repare a table in the DB??

Errors: node 127.0.0.1 got error DBD::mysql::st execute failed: Table 
'syslogs_index_10005973' is marked as crashed and should be repaired at 
/usr/local/elsa/web/lib/SyncMysql.pm line 55. , node 127.0.0.1 got error 
DBD::mysql::st execute failed: Table 'syslogs_index_1' is marked as crashed and 
should be repaired at /usr/local/elsa/web/lib/SyncMysql.pm line 55. 

Original comment by raquel.b...@gmail.com on 25 Jul 2013 at 2:10

[GoogleCodeExporter]

The dashboard error should be fixed with my latest update (994).  Your 
"crashed" error means either you ran out of disk space or the box was 
improperly shut down.  You need to run this to repair:

mysql -uroot -e "REPAIR TABLE syslog_data.syslogs_index_10005973"

Original comment by mchol...@gmail.com on 25 Jul 2013 at 9:47

• Changed state: Fixed

[GoogleCodeExporter]

thank you for your help :) I will try that :)

Original comment by raquel.b...@gmail.com on 26 Jul 2013 at 10:27

[GoogleCodeExporter]

I think I resolved it :) it doesn't give any error now. :) thanks!!

Original comment by raquel.b...@gmail.com on 26 Jul 2013 at 10:57