[Exceptions while accessing traffic, huge panel_traffic tables has to ui performance]

Hello,

 

we have froxlor since 2016 (current version 0.10.9, debian buster, mysql 8.x) and we log every minute the traffic. The table panel_traffic is very huge. So if you sign in as admin and open the customers the response is round about 2-4 minutes. We check with top and mysql consume everything of cpu power that is available (8 cores). Does any one else have same problems?

Query result 1 Page to last Page

Showing rows 8392875 - 8392897 (8392898 total, Query took 21.7778 seconds.)

Login as admin and look on traffic, takes also long time. clicking on details ends in exception:

SQLSTATE[42000]: Syntax error or access violation: 1064 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 'DESC, `month` DESC LIMIT 12' at line 4

Login as customer and click on traffic:

SQLSTATE[42000]: Syntax error or access violation: 1064 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 'DESC, `month` DESC LIMIT 12' at line 4

 

 

[Froxlor 0.10.0 Creat Email => Email-address contains invalid characters or is incomplete]

Hello,

we upgrade to latest froxlor 0.10.0 and I try to test it on our testserver. New Customer, new Domain, login as customer -> Email Adress

1. Create email-address => OK

2. Creat aacount for new created email address and no Alternative e-mail-address is defined

=> Error: Email-address contains invalid characters or is incomplete

If you define a altenative E-Mail-address everything works fine. Depends this behavior on a2f-option?