[SOLVED] Error when I go to the panel

[kurgans]

Hello good afternoon,
I'm trying to access the panel and I get this error

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

How can I fix it?

thanks

[kurgans]

has been solved only with the commands CHECK and REPAIR, everything returns to work well.

Thanks

[websetcom]

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.

[kurgans]

Thank you,

Now works very well, but added your lines to prevent future occurrences in the table.