Logs not running in Moodle

[beeswax]

I have a problem with our Moodle (hosted in house Server2008+IIS7) in that I can no longer access the logs. This is the debug message I get -

 

Error: Could not insert a new entry to the Moodle log

• line 1961 of lib\datalib.php: call to debugging()
  
• line 52 of course\report\log\index.php: call to add_to_log()
  

Does anyone have a solution to this?

[StevieC]

Which database are you using?

 

Oracle? or MySql?

[FN-GM]

He is using MySQL, i helped setup the server.

 

Z

[beeswax]

Thanks Zak. ^^Bump^^

[FN-GM]

Is the Cron Script running? Has it ever worked on IIS7?

 

What Version are you running? Might be worth trying to update

[kmount]

Quick google to moodle forums reckons db corruption (here) suggesting you repair your dbs with the info here.

[beeswax]

Thanks kmount, that's actually a reply to one of my posts on the Moodle forums which I hadn't seen as I was too busy getting my final dissertation ready for handing in. I haven't had a chance to check the dbs yet as I spent most of the first week of Christmas hols asleep/recovering from coursework.

[beeswax]

Managed to resolve this problem by opening MySQL Administrator on the server, selecting the mdl_log table and running the Check Table option from the Maintenance button. I assumed that if a table was "faulty" it would be highlighted in red, as has happened to me previously and I could simply use the Repair function from the Maintenance button. This wasn't the case this time but the Check Table function brought up some irregularities which have been corrected by running the Repair option. Thanks for all your help.

[kmount]

Brill news, good start to the year

[beeswax]

Yes it was. Thanks.