General help

 
 
Picture of linda sarnecki
reports (logs)
 

I am the Moodle administrator at my school.  Neither myself as an administrator, nor my teachers, are able to access reports (logs).  About a year ago we were able, but now when we try to access no records are displayed.

I asked our IT Director if any changes he made to our system could have caused this feature to stop functioning.  He said no.

How do I troubleshoot this problem?

 
Average of ratings: -
Picture of Howard Miller
Re: reports (logs)
Group DevelopersGroup Documentation writersGroup Particularly helpful Moodlers
What does "no records are displayed" mean. Are you getting a wholly or partly blank page or is it simply claiming that no logs where found?

Firstly I would try again with Debugging switched on to see if any underlying error is revealed..

If that doesn't show anything you'll need to go and look at the mdl_log table in the database. It should be reasonably easy to see if stuff is being added to the end of the log. It might well be worth repairing that table too... just in case.
 
Average of ratings: -
Picture of linda sarnecki
Re: reports (logs)
 

Thank you so very much for the reply.  I really didn't think anyone would give me any help.  I am so grateful.  I tried the debugging and the following is what I got when I requested the logs.  Now that I have that I have no idea what to do with it.  Can you point me in the right direction?

Table './servite_moodle/mdl_log' is marked as crashed and should be repaired

SELECT COUNT(*) FROM mdl_log l WHERE l.time > '1250665200' AND l.time line 677 of lib/dmllib.php: call to debugging() line 372 of lib/dmllib.php: call to get_recordset_sql() line 1603 of lib/datalib.php: call to count_records_sql() line 418 of course/lib.php: call to get_logs() line 430 of course/lib.php: call to build_logs_array() line 95 of course/report/log/index.php: call to print_log()


Table './servite_moodle/mdl_log' is marked as crashed and should be repaired

SELECT l.*, u.firstname, u.lastname, u.picture FROM mdl_log l LEFT JOIN mdl_user u ON l.userid = u.id WHERE l.time > '1250665200' AND l.time line 677 of lib/dmllib.php: call to debugging() line 918 of lib/dmllib.php: call to get_recordset_sql() line 1606 of lib/datalib.php: call to get_records_sql() line 418 of course/lib.php: call to get_logs() line 430 of course/lib.php: call to build_logs_array() line 95 of course/report/log/index.php: call to print_log()

Thanks,

Linda Sarnecki


 
Average of ratings: -
Weeping Woman
Re: reports (logs)
 
We had a substation failure recently, and I thought everything was fine until I tried to run the logs. Before the power failure I can access logs, after that day I draw a blank. I turned on debugging and this is the error 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()

I know a couple of tables in the database had to be repaired. We use a 64 bit Win2008K server running iis7 with php and MySQL.
 
Average of ratings: -
moi!!! it is what is is...
Re: reports (logs)
Group Documentation writersGroup Particularly helpful Moodlers
If you go here, then you may be able to get enough information to be able to repair your tables.
 
Average of ratings: -
Weeping Woman
Re: reports (logs)
 
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 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.
 
Average of ratings: -
Picture of AmirAli Bagherzade
Re: reports (logs)
 
Hello Linda .
Try this link , it helped me a lot .By the way do you have any problems with statistics too ??
http://docs.moodle.org/en/Statistics
 
Average of ratings: -