kurgans Wrote:Hello,
PROBLEM:
=======
I already informed that there is a problem with the table domain_traffic. When this table does not work, you receive this message

Table '. / Ispcp / login' is marked as crashed and should be repaired

I had a crash once per Week!

SOLUTION:
========
To solve this problem I tried many solutions. Since 1 month I don't have any Crash.

Edit the file ispc-vrl-traff. If you are familiare with UNIX, you have to type as administrator this line

nano /var/www/ispcp/engine/traffic/ispcp-vrl-traff

Search for the line 225 of this PHP script or search for this PHP line:
$sql = "insert into domain_traffic (domain_id, dtraff_time,....

After the line:
($rs, $rdata) = doSQL($sql);

Insert this PATCH:
# PATCH for DOMAIN_TRAFFIC problem: Sleep for 0,1 ms
usleep(100);
# PATCH for DOMAIN_TRAFFIC problem: Sleep for 0,1 ms


EXPLAINATION
===========
I suppose that the PHP script is too fast or the Database is too slow when there is an update of the Traffic Statistics, consequently the table domain_traffic is not any more consisten (Should be repaired).
This line that I suggest is just a delay of 0,1ms, so that the database has the time to update the table.