Hello,
I received an email with the following message.
Insert into log table failed at Wednesday 16th of June 2010 04:03:47 PM.
It is possible that your disk is full.
The failed SQL is:
INSERT INTO mdl_log (time, userid, course, ip, module, cmid, action, url, info)
VALUES ('1276718627', '2', '1', '201.153.6.111', 'course', '0', 'view', 'view.php?id=1', '1')
I have Moodle 1.9.8 (Build: 20100326) installed, and it is the very first time that I got a message with such an error.
I have looked into it and found out that a "full disk" cannot be the problem.
Now I wonder, if I could/should add this entry manually (how do I do it? I use MySQL 5.0.45 ), or should I just ignore it. How could the error be caused?
It is also worth doing this: How_to_check_your_database_for_corruption
Thanks a lot for your advice.
I used the command "
I got the note that it got repaired and has the status OK. However, I don't know if it ever was broken.
Do I have to insert the failed entry manually now? Through the SQL query window? I am so cautious and ask because I don't want to mess up the database (since I don't know much about SQL).
Thank you for your help!
I used the command "
REPAIR TABLE mdl_log" on the moodle database.I got the note that it got repaired and has the status OK. However, I don't know if it ever was broken.
Do I have to insert the failed entry manually now? Through the SQL query window? I am so cautious and ask because I don't want to mess up the database (since I don't know much about SQL).
Thank you for your help!
Log entries are not that important. Unless you care about having a 100% accurate record of everything anyone every did to your Moodle site, you can probably forget about it.
Thanks a lot, Tim. You were of great help!! Thanks!!!!
Tim,
it's not that these logs are so critically important. But the fact something is not working as expected is a sign that not everything is ship-shape, and that in the nearest future something else may start malfunctioning. This is what makes one feel uneasy about it.
THat said, I'm writing because I have had the same problem for a while now (Moodle 1.9.9, plenty of server space).
The question is, should I wait for the next upgrade in hope this problem just disappears on its own, or should I start nudging the hosting tech support in hope that the problem lies in the server malfunction rather than in Moodle?
TIA -
Lev
Hello,
I'm also experiencing this problem. Anyone figured out the cause/solution yet?
Thanks,
Fernando
Sometimes it happens when your power goes down and you don`t have a UPS installed. Other times the cause may be in hard disk itself (it dies slowly). All this is much probable if you are running your own server, but who said that hosting providers dont have the same problems.