Posts made by Judy Hsu

Dear all, I've been having this issue for couple of days now but don't know what would have caused this. When I'm doing CVS update, the TortoiseCVS is complaining that that there are some conflict in the mod/scorm/pix/*.gif files, then it would fail (to do CVS update). Does anyone know what might have caused this? I have never touched any of those *.gif files in my local folder. Thanks!
Attachment scorm_pix_cvs_error.png
Average of ratings: -

Dear all, I have not yet dig into the code level but found that when I login as admin > Site Administration > Miscellaneous > XMLDB editor, then click on the [Test], it will not really finish all the testing and will always got stuck on testing item 43. When I test it on our testing environment, it will show:

43. insert record 1502000 cc. (text) Error
Got a packet bigger than 'max_allowed_packet' bytes

When I test on my local development PC, it would show:

43. insert record 1502000 cc. (text) Error
MySQL server has gone away

(although I know that my local mysql daemon is still running)

Is these two known bugs and had been reported on moodle bug tracker or there is something wrong with my setting? Thank you for your help.

Average of ratings: Useful (1)
Hi there,

We have a pilot site setup for the summer (running 1.8.0) which the moodle DB was imported from our college student/course DB (so initially it created a lot of empty course shells). We would like to query on the database to see during the summer how many (and which) courses was 'touched' (e.g. created resources, quizzes, assignments, etc) by the course instructors. Is there a SQL query I could run to find this out? I have looked at the mdl_course table but there is no field such as 'lastupdated' or something. My guess is that I will have to cross-reference other tables such as mdl_assignment, mdl_choice, mdl_forum, and so on to find out what are the courses that has been modified. Anyone had done this before? Thanks!
Average of ratings: -