AJAX marking block beta for 1.8.2

AJAX marking block beta for 1.8.2

by Matt Gibson -
Number of replies: 120
Hi all,

I've made an AJAX version of block_marking which allows all grading to be done without leaving the front page.

Features:
  • The block use the YUI treeview widget so each course and each assessment are expandable nodes of a tree
  • Every time a node is expanded it queries the database and creates or re-creates its children dynamically
  • Each course and assessment node has a count of how many pieces of unmarked work are currently waiting. This count is updated every time the nodes change
  • The total count at the top is also updated whenever the nodes change
  • The submission nodes have a border around them which indicates the length of time since it was submitted green -> yellow -> orange -> red up to a maximum of 2 weeks (by which time you will have marked everything of course smile)
  • When a submission node is clicked, it opens a grading pop up and adds javascript to the submit button so that it removes its node from the tree and closes itself when you are done grading.
  • Currently supports Assignments, Workshops and Forums only (more being added...) and only for people who have grading capability at course level.
I've tested in IE6, IE7 and Firefox 2.0. IE is a bit quirky so I have had to disable the tooltips in order to make it work.

Feedback and feature requests are more than welcome smile

Matt


Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Matt Gibson -
I should have added - install by unzipping the file in your moodle directory and visiting the admin->notifications screen. You can then add the block just like any other.

Here it is in action.
Attachment AJAX.gif
Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Julian Ridden -
Sadly couldn't get this working sad

All I see is a spinning "loading" animation in the block when I try and use it in a course.

Any ideas?
Average of ratings: -
In reply to Julian Ridden

Re: AJAX marking block beta for 1.8.2

by Matt Gibson -
Actually, I didn't test it in a course, only on the front page. Can you get it working there? If you still have no joy, load the firebug extension for firefox and you can see the AJAX response text in the console. Paste the response here and I'll be able to diagnose a lot better. Loading icon means request sent, but dodgy response. I'm almost done with a new version that supports quiz essays along with a few other fixes, so that may help...

Matt
Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Bruno Vernier -
i tested it in the FrontPage and it also has an un-ending spinning animation and no firebug warnings when I check it as admin and there is nothing to mark

when i check it as a student, i see the same spinning animation and a message "Horray, nothing to mark!"

when there is an assignment to be marked, admin mode still just shows an animation and a green checkmark in firebug

ditto for student mode: the animation and the message about nothing to be marked

a request: both marking blocks have the label "marking" which confuses me a bit. Any chance you could relabel yours "Ajax Marking" (for the drop down 'Add a new block') just like you did for the source code?


Average of ratings: -
In reply to Bruno Vernier

Re: AJAX marking block beta for 1.8.2

by Matt Gibson -
Thanks for testing - I'll rename it as requested. I'm developing on 1.8.2 with debian etch, php 5.2.0, and firefox. Are you using anything significantly different? I'll run it on a clean install and see what I've missed.

Matt
Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Bruno Vernier -
we use the exact same environment
Average of ratings: -
In reply to Bruno Vernier

Re: AJAX marking block beta for 1.8.2

by Matt Gibson -
OK, here's a new version that works on a clean 1.8.2 install. I think the problem was that i had left in a limit on get_my_courses and wasn't taking admin rights into account. Both issues are fixed along with the loading icon.

This version now lists quiz essay questions.

It works fine in courses too, but I think it should have the course its in as the top one, which it doesn't do yet. Hope it works for you now.
Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Bruno Vernier -
i installed the new one and went into administration/ blocks to make sure the new version was processed. But still : same behavior. I think maybe the only thing i do differently from you is that i have two marking blocks (the non-ajax and the ajax showing on the FrontPage) ... also I only tested with one assignment activity
Average of ratings: -
In reply to Bruno Vernier

Re: AJAX marking block beta for 1.8.2

by Julian Ridden -
Slight movement.

Now the block is showing the courses. But if I try to expand the course to see the marking I get the spinning animation and nothing else again.

It lists the assignment twice for some reason. If I click on "collapse and refresh" it goes back to just one. But same issue persists.

Certainly a step in the right direction though
Attachment Untitled-1.gif
Average of ratings: -
In reply to Julian Ridden

Re: AJAX marking block beta for 1.8.2

by Matt Gibson -
That's odd. The spinning icon means that the AJAX request has been sent successfully but either the response is malformed or it contains an error message.

Having said that, I noticed that the title of your block is 'marking', whereas I changed the title to 'AJAX marking' last night before posting that zip, so you may have some old code in your cache. Try clearing it and refreshing.

I'm using get_my_courses and then looping through them looking for work, so I can't think why it would list one twice.

If it still doesn't work, uncomment lines 110 & 173 of javascript.js to get the AJAX response displayed on screen and tell me what it says.




Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Julian Ridden -
only reason it still says marking is because i changed the lang file back to marking smile

With the new lang file situation remains unchanged
Average of ratings: -
In reply to Julian Ridden

Re: AJAX marking block beta for 1.8.2

by Matt Gibson -
Hmmm...

In that case, could you try uncommenting those 2 lines and posting the response text you get?
Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Bruno Vernier -
1. thanks for renaming to ajax_marking (and please do leave the lang file with "marking" as users do not need to get confused with the term ajax. I only meant to un-confuse managers who install blocks and see two marking blocks to choose from)

2. even refreshing the cache, i get the same problem and here is the debugging output after uncommenting those two lines:


Warning: Invalid argument supplied for foreach() in /mnt/sdb1/var/www/moodle_1.8.2/blocks/ajax_marking/ajax.php on line 273
(repeated several times)

[{"name":"Moodle Introduction for All","id":"2","type":"assessments","summary":" This program is called "Moodle". This mini-course will help you quickly learn how to use it so that you can have maximum success smile
","count":"1","cid":"c2"}]

which is the course for which there is an assignment item to be marked. Note that we have around 50 courses.

bruno
Average of ratings: -
In reply to Bruno Vernier

Re: AJAX marking block beta for 1.8.2

by Matt Gibson -
Great! I hadn't checked to see if a query returned false before trying to loop it, so that's fixed now. I've also found out that if the course summary has been made using htmleditor, the " characters confuse things and make it hang. I'll sort out a way to escape them tonight.
Average of ratings: -
In reply to Bruno Vernier

Re: AJAX marking block beta for 1.8.2

by Matt Gibson -
Bruno...

I've just installed block_marking on the clean install and they both work together with no problems. Did you refresh the page/clear the cache? I put all the javascript in a .js file, so the new version will still use the cached javascript until you force it update.

The only other thing may be the total number of courses - I've not tested on a very large install yet. Are you using a test install that's got only a few courses, or is it a very big install?

Matt


Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block issues

by Allan Kealey -
Hi
I have had the marking block working, very well I might add, until I came to import this years groups. Now I have to mark each assessment with the groups I want, before I am sure I just did the course and ther settings filtered down to alll the assessments. Worse still when I open the tree for the first assessment I see all my groups with the same pupils in each one. I have uninstalled and reinstalled the block and I still cannot get it to work. Both Moodle and the block are the latest versions
Help!!!
Allan
Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Matt Gibson -
Spoke too soon. This should be better.
Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Bruno Vernier -
success! this last one works smile thank you smile
Average of ratings: -
In reply to Bruno Vernier

Re: AJAX marking block beta for 1.8.2

by Matt Gibson -
This version fixes more issues with line breaks and special characters and displays forums properly.
Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Monico Briseño -
Picture of Testers
Hi, Matt. First, thank you for create this kind of useful blocks. Second, I installed your ajax_marking block. But, when I put on it. The block window showed the following error:


Any idea?

TIA

Attachment ajaxmarking.jpg
Average of ratings: -
In reply to Monico Briseño

Re: AJAX marking block beta for 1.8.2

by Matt Gibson -
Hi Monico,

This is almost certainly because I am guessing you are using moodle in a different language and I have used an english language string as a temporary measure to get the teacher and student roles.

I will fix this over the next week as I find an alternative, but for now, please look at lines, 150 and 151 of ajax.php and alter the names for the two roles to your equivalents.

Matt

Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Monico Briseño -
Picture of Testers
Hi, Matt. Thank you for your answer. I'm using Moodle in English version. However, today I starter up my computer and Logged into Moodle account and Ajax marking block was working properly.
Finally, great job, this block is exactly that I need to work more easily with assignment activities.

Cheers

Mónico

Average of ratings: -
In reply to Bruno Vernier

Re: AJAX marking block beta for 1.8.2

by Matt Gibson -
Glad you got it going! I'm going to tidy up the code now and make it a bit more secure before trying to integrate it with block_marking.
Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Bruno Vernier -
this new version also works fine smile

for us to use it , we will need to incorporate journal activities and include a limit on the size of the titles to make our long activity titles use less real estate in the ajax marking block
Average of ratings: -
In reply to Bruno Vernier

Re: AJAX marking block beta for 1.8.2

by Matt Gibson -
I've just set the course titles to shortname and will limit the length of the strings for the others. I've never used journals, so I will look into how they work and see about adapting your code from block_marking over weekend. Hopefully I can get a working version with journals by monday.
Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by AjnabiZ ... -
WOuld this be compatible with 1.9 ?
Average of ratings: -
In reply to AjnabiZ ...

Re: AJAX marking block beta for 1.8.2

by Matt Gibson -
I've not tested in 1.9 yet, but the changes to make it work, if any, will be trivial and I'll have a working version quickly after 1.9 is released. I'm focused on adding journal support at the moment and making it recognise groups, so feel free to test it if you are running 1.9 beta already smile
Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Julian Ridden -
Yup, I am using 1.9 and it works a treat. smile
Average of ratings: -
In reply to Julian Ridden

Re: AJAX marking block beta for 1.8.2

by Oliver James -
Hi there,

First of all I just want to say great work on creating a wonderful block!

My question is though "Can I disable forum support easily?" At my place we use forum posts for alot of the A level work, as a result we generate a large number each week. We then discuss it in class and I have no intention of going through them all and putting some sort of rating.

Any help on this would be greatly appreciated as at the moment I have "supposedly" over 880 odd marking submissions to attend to sad

Oliver.
Average of ratings: -
In reply to Oliver James

Re: AJAX marking block beta for 1.8.2

by Matt Gibson -
Hi Oliver, glad you like it smile and wow, that is a lot of grading.

You can certainly disable it for forums, the easiest way being to turn off forum ratings in the individual forums. It only displays those ones that have ratings turned on anyway. If you want the ratings on, but not to display the forums as well, you need to disable all forums functionality in the code.

Open up ajax.php and comment line 54 (add // before it):

//$this->forums();

also, you need to go to line 266 and start a block comment with /* :

/* $forums = get_records('forum', 'course', $course->id);

then goto line 311 to end it with */ (should be the last of the curly braces in the cascade):

} */

I'm looking at my latest development version, so its possible the line numbers are a bit off, but it won't be by much. I'm planning on adding a config screen so that specific assignments or forums can be excluded on a per user basis as well as choosing to sort the student by group, but this looks like being a bit complex and may take a while.

Julian - Great to hear it's working on 1.9 and thanks for testing smile!
Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Oliver James -
Many thanks Matt for the information.

I think I have found a bug and am not sure if the problem is due my configuration or not.

It seems that it has duplicated all of the courses and assignments. I have highlighted where the duplicaion starts.

Could this be because I am using the admin account as my only account for all admin and teaching roles? So within all of the courses the admin role can view etc and then some of them I have added myself as a teacher of the course?

Marking Block
Average of ratings: -
In reply to Oliver James

Re: AJAX marking block beta for 1.8.2

by Oliver James -
Sorry to be a pain but I think I have found something else.

If you havnt marked something for a student, reset the course and effectivly remove them from it. It still shows up in the block as something that needs grading.

Regards

Oliver.
Average of ratings: -
In reply to Oliver James

Re: AJAX marking block beta for 1.8.2

by Matt Gibson -
Hi Oliver, thanks for the feedback.

I noticed the second issue last week and have already fixed it in the attached release. As for the duplication, that is less easy. I set it to only show courses that you have a teacher or non-editing teacher role in, so being admin should make no difference. It also uses get_my_courses, which is an internal function that provides the list of courses on your user profile page.

When you view your profile, do you see the same duplication there?

I have made quite a few internal changes in this new version, so I think the first thing to try is to install it and see if the duplication persists.

Also in this release:
  • Journal support
  • All nodes in the tree are now limited to one line, saving space.
Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Larry Elchuck -
Hi Matt

Thanks for the update ... it did solve the posts shown for non-active users for my install.

I noticed that on the first log-in by a teacher, a couple of anomalies exist.
You can see them in
Marking Block Issue

After refreshing the page, all appears as normal.

=====

A second issue (maybe just for us) is how forum posts are handled. I would like to have the option for only their initial post to be flagged and not their replies to other students' posts.

We often use the "each person starts one discussion" type of forum. Then students comment on each other's initial post. Only the initial post in each new thread is graded. Is it possible to chose to display only the first post in each thread of a "each person starts one discussion" type of forum?

Thanks for your work.

larry
Average of ratings: -
In reply to Larry Elchuck

Re: AJAX marking block beta for 1.8.2

by Oliver James -
Matt, Larry

I also noticed the undefined (undefined) error appearing on my install but after hitting the collapse and refresh button it went away.

With the duplication of all of the courses error this to went away after hitting the collapse and refresh button a few times.

Also in answer to your question, no the list of courses from the get_my_courses() function does not duplicate. My list of courses has always worked fine.

HTH

Oliver.
Average of ratings: -
In reply to Oliver James

Re: AJAX marking block beta for 1.8.2

by Oliver James -
Matt,

I think that I have managed to track the behavior of the duplication.

Steps to reproduce
1. Open browser
2. Load Moodle Site
3. Login
4. Marking Block Duplicates

5. Click Collapse and Refresh button
6. Marking Block is fine.

What ever happens when you login and the block is first run must be different to whatever happens when the Collapse and Refresh button is pressed.

HTH

Oliver.
Average of ratings: -
In reply to Oliver James

Re: AJAX marking block beta for 1.8.2

by Oliver James -
Is this part of the block or a problem with Moodle itself?

I just marked an assignment submission accessed via the marking block, its an online text assignment with teacher comments inline. I wrote a comment and clicked save with the new mark and a warning box appeared saying

Coursenode thing fired

Regards

Oliver.
Average of ratings: -
In reply to Oliver James

Re: AJAX marking block beta for 1.8.2

by Matt Gibson -
Whoops, that's one of my debugging alerts to check things are working. Its safe to ignore and I will comment it out tonight.
Average of ratings: -
In reply to Oliver James

Re: AJAX marking block beta for 1.8.2

by Matt Gibson -

Oliver,

How about if you (after doing all the steps you outlined), log out of moodle and then log in again?

Also, are you using https logins?

Can you also tell me a bit about your browser/server? It sounds like this is happening on the client side in your browser, but I'm not able to reproduce it yet. Its possible that the javascript is not loading properly or is being interrupted but I'm not sure by what. Do you have any other non-standard blocks on your front page?

Average of ratings: -
In reply to Larry Elchuck

Re: AJAX marking block beta for 1.8.2

by Matt Gibson -

Hi Larry,

the forum thing sounds like a good idea - I'll investigate tonight.

As for the undefined error, that's odd. Do those nodes represent real courses that have not appeared correctly or are they extras which should not be there at all?

When you say 'refreshing the page' do you mean the whole page or just clicking 'collapse and refresh'?

Also, can you tell me about your setup - what browser and server are you using?

The icons not loading is simply due to the page not loading them at the start, and the AJAX assuming they are cached already, but I think I have a solution for that which I will add in tonight as well.

Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Larry Elchuck -
Thanks for considering the forum adaptation Matt.

The undefined error nodes do not represent real courses. They are extras that should not be there at all.

In our cases, the browser (Firefox 2.0.0.7 - latest) on Macs were refreshed causing the entire page to reload.

The server is a MAMP server running:
Apache/2.0.59 (Unix) PHP/5.2.1 DAV/2 mod_ssl/2.0.59 OpenSSL/0.9.7l
mySQL 5.0.37

larry
Average of ratings: -
In reply to Larry Elchuck

Re: AJAX marking block beta for 1.8.2

by Matt Gibson -
Weirdly, I managed to get it to reproduce by updating my production server and accessing it with IE, but now I can't get it to do it again. Do you have the same issue every time you open the browser, or just the first time you use a browser that you have used to access thae marking block before?

Its possible this was due to old code being in the browser cache, in which case, once it has been refreshed, you should not see it again. I can think of a reason for this happening too, so it would fit.
Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Larry Elchuck -
Matt

I just went to the site in the browser on the machine I accessed it before and on a computer that has never been used for our site as this teacher.

All is well ... sounds like it was a browser cache issue.

thanks
larry
Average of ratings: -
In reply to Larry Elchuck

Re: AJAX marking block beta for 1.8.2

by Matt Gibson -
great smile
Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Oliver James -
Matt,

Yes it does appear if I log out and login again.

Server
IIS6, Win2k03, PHP 5, Mysql 5. No HTTPS.

Browser
Firefox 2.0.0.7, Javascript enabled. Also the same results appear in IE6. This has also been tested in Firefox from two different machines, one at work and one at home.

No other non-standard blocks installed. It is pretty much a fresh install of 1.8.2+ with the marking block. I am using Imagine as my theme.

If you need anymore info then please let me know

Oliver.
Average of ratings: -
In reply to Oliver James

Re: AJAX marking block beta for 1.8.2

by Matt Gibson -
OK, here's a new version, without that debugging alert and with a line you can uncomment (// div.innerHTML += o.responseText; - line 124 of javascript.js) which will output the server's response direct to the screen.

When you uncomment this line, you will get a load of garbage (seemingly) at the top of the block, but which on closer inspection will show the name of each node e.g. :

[{"type":"courses"},{"name":"A2 Psy Unit 4 '07-'08","id":"66","type":"assessments","count":"1","cid"
:"c66"},{"name":"A2 Psy Unit 6 '07-'08","id":"58","type":"assessments","count":"24","cid":"c58"},{"name"
:"AS Psy Unit 2 '07-'08","id":"64","type":"assessments","count":"7","cid":"c64"}]

Could you do this and see if the repeating appears in there? If so, it means there is a server problem. If not, its browser based.
Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Oliver James -
Yes it does repeat in the output. I can post it here if you would like?

Also not to add to your woes but I the error that Monico reported about the ajax error, Transaction id 0, http status -1 status code transaction aborted is also happening here sporadically.

I am running with English UK language.

Oliver.
Average of ratings: -
In reply to Oliver James

Re: AJAX marking block beta for 1.8.2

by Bruno Vernier -
the ajax error, Transaction id 0, http status -1 status code transaction aborted is also happening on our site, also sporadically
Average of ratings: -
In reply to Bruno Vernier

Re: AJAX marking block beta for 1.8.2

by Matt Gibson -
Hmm....

The ajax error simply means that the request has timed out. Its set to 7 seconds, but maybe I should lengthen that. Collapse and refresh should fix it (do you find this?) so I will alter the error message to reflect that.

The repeating I'm still trying to diagnose...
Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Matt Gibson -
Oliver,

I'm still not quite sure what's causing the repeating and I can't reproduce the problem. Could you add this line of code below the one you uncommented last time:

alert('ajax function fired');

This should give you a pop-up alert only once when the block loads. Its possible you will get two, so please let me know.

I cannot find anywhere in the code that would be making this happen, so I think it may be that somehow the function is called twice perhaps, or that the roles are interfering and getting too many courses.
Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Oliver James -
Matt,

Yes indeed I do get two warning popup alert boxes appear.

I am using meta courses for a number of the ones that require marking if that makes any difference.

Oliver.
Average of ratings: -
In reply to Oliver James

Re: AJAX marking block beta for 1.8.2

by Oliver James -
Matt,

I was giving this some thought... When I load the homepage all of the elements are loaded like the header, footer etc. When I click the collapse and refresh button it only loads the block.

Could there be something in my header and footer that could cause this to be a problem?

I will be honest and say that I am unsure of what to look for in each of them so i thought I would give you the URL and see if you wanted to look in them and see if there is a problem.

http://learning.lingfieldnotredame.co.uk/theme/imagine/header.html

http://learning.lingfieldnotredame.co.uk/theme/imagine/footer.html
Average of ratings: -
In reply to Oliver James

Re: AJAX marking block beta for 1.8.2

by Matt Gibson -
OK,

we're getting closer. After looking at your header and footer, I've no idea how this could be happening and although not really tested metacourses, if they were having an effect, it should remain even after clicking collapse and refresh. However, it does seem that one of the functions is being called twice.

Could you try adding the same alert line just below this line, which is around line 97

function ajaxBuild() {

and see if you get the same thing (2 alerts), then also below this line (around line 68)

function treeBuild() {

Once we find out which bit is the original one firing twice, I will put a counter in so it won't fire a second time.
Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Matt Gibson -
Right. That indenting was getting a bit crazy.

Here's a new version.

Larry - this should make the forums where each student posts only one discussion show only the initial post.

Oliver - I've put the counter in anyway, hazarding a guess at where it might work. Maybe we'll be lucky.


Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Larry Elchuck -
I installed it Matt. Looks good to me. The one teacher I checked before/after went from 56 to 43 unmarked assignments.

I'll ask the teachers to check tomorrow and will report any issues 9if there are any).

thanks
larry
Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Oliver James -
Matt,

Unfortunately we werent lucky on this occasion. Still repeating.

Oliver.
Average of ratings: -
In reply to Oliver James

Re: AJAX marking block beta for 1.8.2

by Matt Gibson -
Just realised that fix broke collapse and refresh. This one now puts everything in reverse date order on viewing.

Oliver - did you try putting the alert in the function above?
Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Oliver James -
Matt,

Sincerest apologies for not replying sooner to this. I have had to rebuild our gallery application because I didn't realise you werent allowed apostrophes in the folder names when you upload them. (Who knew!)

Anyway I can now refocus my energies back to Moodle. With regards the block it seems to all be working at the moment. Strange as it may seem but it hasnt repeated over the past few days. The only thing is the coursenode fire thing appearing. Where abouts in the code can i switch that off?

Regards

Oliver.
Average of ratings: -
In reply to Oliver James

Re: AJAX marking block beta for 1.8.2

by Matt Gibson -
Coursenode thing is fixed in the latest version I posted above, or at line 758 of javascript.js.

Glad its working now, but weird that it did so without any reason mixed
Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Karlene Clapp -
I installed this on 1.9 Beta, and it works great. I do have one question: Is there an easy way to get it to only show things for classes which you are a regular teacher, and not show those for which you are a non-editing teacher? I tried to comment out the part that checks for non-editing teacher roles (in all spots), but that didn't seem to do anything.
Average of ratings: -
In reply to Karlene Clapp

Re: AJAX marking block beta for 1.8.2

by Matt Gibson -
Hi Karlene,

Glad it works for you smile The block is set to display (at all) based on whether you are an editing or non editing teacher in any course, but beyond that, it just uses the role thing as a security check and looks at roles and capabilities. If you have the capability to grade an assignment, the assumption is that you will. A quick fix would be to remove the ability for non-editing teachers to grade assignments via the roles interface. Alternatively, I am working right now on a config screen that will allow you to specify which assignments you want visible and allow you to choose which groups to display or not. This should fix your problem, but I'm not sure how long it will take me. Several weeks at least I should think.

Matt
Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Karlene Clapp -
Thanks Matt! It works great now for everyone inside of a course, but for some people, if I use the log in as them button in Moodle and go to their front page that lists all their courses, I get the spinning loading image in the Marking block. Firebug shows the response as being the html of the entire page. Have you ever seen this before? I checked and it's sending the same parameters as when I'm inside a class logged in as them, so I'm baffled. I'm hoping you have seen it before or can point me in the right direction. It doesn't seem to be consistent as it only happens with random users, not everyone.

Also, on a side note I'm getting a coursetooltips not defined error on line 237 of the javascript file both inside a classroom and on the front page.

Thanks again for your help!

Karlene
Average of ratings: -
In reply to Karlene Clapp

Re: AJAX marking block beta for 1.8.2

by Matt Gibson -
Ah, all new issues to me. Thanks for the feedback!

Tragically, my home broadband connection has just tanked, so I can't do much till friday (feels like my life has been unplugged. I should probably get out more.) I didn't test 'login as' at all so I will find out about that.

The tooltips thing - firefox, IE or both? Does it load the tooltips at all, or just give you the error and no tooltips?

Matt
Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Karlene Clapp -
The tooltips thing only happens when the box first loads, but the tooltips work without error once you expand the tree. Hope that helps.

Karlene
Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Anthony Borrow -
Picture of Core developers Picture of Plugin developers Picture of Testers
Matt - Many thanks for your contribution of the ajax_marking block. In response to CONTRIB-227, I have added the block to CONTRIB in CVS (http://cvs.moodle.org/contrib/plugins/blocks/ajax_marking/). Folks wishing to create bug reports, make suggestions for improvements, etc. can create an issue in the tracker in the CONTRIB project for the Blocks: AJAX Marking component. I know that the tracker really helped me to focus on one issue at a time since sometimes all the feedback from a forum can become overwhelming. I hope that having the block in CVS and a space in the tracker will help support your efforts and help those who are using it provide feedback to you so that the block can continue to be improved. Let me know if you have any questions. Peace - Anthony
Average of ratings: -
In reply to Anthony Borrow

Re: AJAX marking block beta for 1.8.2

by Barry Lindler -
Hey,
I'm having some problems installing Ajax marking block. Can you tell me if I did anything wrong?
I downloaded the files from CVS and put them in moodle\blocks\ajax_marking:
it currently has 5 files in it ( ajax.php, block_ajax_marking.php, dmlib.php, javascript.js, and styles.php).
I also copied the block_ajax_marking.php file to the lang\utf8 folder-
I'm using Moodle 1.8.4, and when I go to admin/notifications/blocks, I do not see a listing for ajax_marking. I do have a listing for Marking which I use, but not for the new one.

Am I doing something really wrong? It sounds like a great block, and I'd love to try it!
thanks in advance.
Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Clinton Branscombe -
Problem: After installing AJAX_marking on a fresh copy of Moodle 1.9, the Marking block said "Hooray, nothing to mark" even though there definitely were items that needed marking.

Solution: Although I am the administrator and was listed as the teacher of the course, I needed to manually assign myself to the teacher role of the course. Voila--unmarked assignments are now listed properly.
Average of ratings: -
In reply to Clinton Branscombe

Re: AJAX marking block beta for 1.8.2

by Rick Barnes -
I have tried to install the 1.9 version on a test 1.92 moodle. When I log in as admin it tells me that it has installed but when I try to configure the block I get this message.

Configuring a AJAX marking block

This block has not been implemented correctly and thus cannot provide a configuration interface.

What have I done wrong?


Average of ratings: -
In reply to Rick Barnes

Re: AJAX marking block beta for 1.8.2

by Frederic Nevers -
I'm getting the same message. I'll poke into the bug tracker to see if something similar has been reported.
Most of it seems to work fine though
Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Shaun Burford -

Hi,

Excellent block this ajax grading is, and i want to implement it into our moodle site, but we use the criteria reference block to allow students to see where they currently are in the course and that works based on manual grade items added to the course gradebook..

so my question is is it posible for manual grade items to be visable in the block as at present they remain invisible...

cheers,

shaun

Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Jaap Marsman -
Hey Matt,

I love your grading block and I hope work still continues on this block. I've just installed it on my Moodle 1.9.2 page and unfortunately ran into an error. It lists forums even though they're non-graded forums. Strangely enough, it only lists a few of them, not all.

Also, when I click on "Configure" the whole screen gets dimmed and I can't edit anything.

Any help would be most appreciated!
Average of ratings: -
In reply to Jaap Marsman

Re: AJAX marking block beta for 1.8.2

by Dan Jeffries -
Hi

Have installed the marking block onto 1.9.2 however there are a couple of glitches we are noticing.

1. When going to configure it seems to take a very long time to load.
2. Forums - we don't use forums for marking work, merely for social interaction. However it seems that the 'configure' actions (once they finally load) don't seem to filter these off. I have made sure the forums aren't using ratings, yet still they dhow. Any ideas?

Think that's it so far - thanks for such a great block!

Dan
Average of ratings: -
In reply to Dan Jeffries

Re: AJAX marking block beta for 1.8.2

by Frederic Nevers -
Hi,

I've installed the block on a 1.9.1 version and a 1.9.2 clean version and I cannot get the block to work. It shows me the endless spinning wheel (the data in brackets seems correct though).

Is there anything I need to do? Or that I'm not doing right? I've switched AJAX on.

Cheers,
Fred
Average of ratings: -
In reply to Frederic Nevers

Re: AJAX marking block beta for 1.8.2

by Frederic Nevers -
Okay, so I'll reply to my own post smile

I've realised what most of the problem was. I have the same account for teacher and admin purposes and that caused the un-ending spinning wheel.

So it "almost" works. I cannot get the "essay" questions to be included in the marking block. I might comment it out altogether.

Cheers,
Fred
Average of ratings: -
In reply to Frederic Nevers

Re: AJAX marking block beta for 1.8.2

by Rick Barnes -
How do I configure this block, we don't need to see journal entries.
When I tried marking the journals and saved the feedback the total unmarked went down but then when I refreshed the block they all appear again.
Is there any way to show only the groups that I teach and not all pupils on the course (I am the course creator/editing teacher).
This is making life much easier, finding new work (not so easy keeping up).
Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Larry Elchuck -
Hi Matt

Ran into some issues in the past 48 hours with the ajax marking block.

I think some are attributed to the problem discussed in http://moodle.org/mod/forum/discuss.php?d=106233#p473262
and at MDL-15800. Prior to applying the patch in the above links, our teachers received the following error: "require_js: http://oursite.com/moodle/blocks/ajax_marking/javascript-min.js file not found.

But even applying those fixes and having the block reappear properly, as one drills down to observe the assignments to grade, in some instances the spinning wheel occurs and in all other instances, the hyperlinking capabilities do not exist for the student names.

Both issues did appear in close proximity to the issues in the aforementioned links.

larry

Average of ratings: -
In reply to Larry Elchuck

Re: AJAX marking block beta for 1.9.2

by Larry Elchuck -
I downgraded the block to the latest Sept. 07 release and the same problem of not hyperlinking to student assignments persists.

I created a tracker issue at CONTRIB-748

larry
Average of ratings: -
In reply to Larry Elchuck

Re: AJAX marking block beta for 1.9.2

by Raymond Kersting -

I have not long ago changed to 1.9.3 version and now the Ajax marking no longer works. I deleted it and tried to reinstall and the following is the error message I get.

Can you suggest what I need to do to make it work for this verison please.

____________________________________________________________

ajax_marking

Errors found in XMLDB file: Problem loading table block_ajax_marking, Some FIELDS previous/next values are incorrect

Block ajax_marking tables could NOT be set up successfully!

----------------------------------------------------

Jim

Average of ratings: -
In reply to Raymond Kersting

Re: AJAX marking block beta for 1.9.2

by Raymond Kersting -
Now I get the following message after updating to the current CVS.

This block has not been implemented correctly and thus cannot provide a configuration interface.

Any suggestions on what or where I might have gone wrong as all I have done is added the files to the block folder after deleting the old one.

jim
Average of ratings: -
In reply to Raymond Kersting

Ajax Marking Block

by Anuja Gaunekar -

Ajax Marking Block has been added on Front page. An account "teacher" is created which is allowed to grade one course. When I login into this account I can only see the spinning wheel.If i click configure, it shows a blank popup with the spinning wheel.

My environment is win 2003 and moodle 1.9.2+ with oracle backend.

Average of ratings: -
In reply to Anuja Gaunekar

Re: Ajax Marking Block

by Matt Gibson -
@Anuja

CONTRIB-1003

Can you try the latest version of Moodle and of the block and see if this persists? If so, please give details on the tracker item.
Average of ratings: -
In reply to Raymond Kersting

Re: AJAX marking block beta for 1.9.2

by Dan Leighton -
I get the same problem...

In fact, if I click on the block edit button I get this message.

If I click on conffigure in FF and Chrome I get a total page freakout (see screenshot)

In IE I get nothing at all when I try to use the block or when I try to configure...

Pity. It's a great block otherwise which we really want to use!
Attachment sshotofpage.gif
Average of ratings: -
In reply to Dan Leighton

Re: AJAX marking block beta for 1.9.2

by Matt Gibson -
CONTRIB-1002
Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.9.2

by ben reynolds -
Hi Matt,
My IT person installed this block on our test server. I have a teacher role and a student in a test classroom. When the student uploads a file in advanced uploading, the block does not recognize that there is an item to grade.

Unlike other peoples' experience, I do not get a spinning wheel. I just get this in the block:

You have no courses with graded assessments yet

and the configure link.

We're using 1.9.4 and a custom theme.

I don't have access to the tables, but my IT person does. I suspect we've missed some basic step. I read the documentation and confirmed that the block has been put in the correct directory. Admin has checked into notifications.


Average of ratings: -
In reply to ben reynolds

Re: AJAX marking block beta for 1.9.2

by Martin F -
I'm having the same problem, since upgrading to 1.9.5..

"You have no courses with graded assessments yet" but there are items to grade!
Average of ratings: -
In reply to Martin F

Re: AJAX marking block beta for 1.9.2

by Rob Monk -

We're having the same problem as Dexter.

We upgraded to 1.9.5 and it stopped working so we removed it and did a clean reinstall and now it just tells us

"You have no courses with graded assessments yet"
While my teachers initially were pleased and took the message to mean they had done all their marking, (some had a weekend off) eventually reality hit and they started to complain that the module had stopped working.
We have become addicted to the "Marking Block" and we need it back!!
Average of ratings: -
In reply to Rob Monk

Re: AJAX marking block beta for 1.9.2

by Dan Jeffries -
Yes we're in the same boat! My tutors are addicted to the Marking Block and it's becoming problematic - not identifying submitted work and also some occurrences of tutors adding feedback and the marking block not saving it.

Really hoping a fix is on its way!
Average of ratings: -
In reply to Dan Jeffries

Re: AJAX marking block beta for 1.9.2

by Martin F -
I've now switched to the "Grade Me" block, not as great, but does a good job.
Average of ratings: -
In reply to ben reynolds

Re: AJAX marking block beta for 1.9.2

by Simon Ryder -
Having the same issues after upgrading to moodle 1.95, anyone found a solution?
Average of ratings: -
In reply to Raymond Kersting

Re: AJAX marking block beta for 1.9.2

by Matt Gibson -
@ Raymond/Jim

Config error is fixed in CVS now.
Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.9.2

by Rob Monk -
Is the AJAX marking block compatible with 1.9.5? We have just upgraded and would like to get it going again.
Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Matt Gibson -
Hi everyone,

I firstly need to apologise to several people who have posted here in the last few months - I've not been monitoring the forum, assuming that problems would be filed as tracker items (which some have been) so I missed the continuation of this thread.

Most of these issues are now fixed and should be OK provided that
  • you use the latest version of the block
  • you use moodle 1.9.3 or later (Moodle's YUI libraries were updated, breaking the old version)
The one exception is the configuration screen error message which is deliberate, due to the lack of any site-wide settings. All configuration is currently is per-user and done via AJAX.

I am now working on an internal sort-out which will result in an additional non-AJAX and fully accessible mode, with AJAX used only if the user has specified it in their profile.

Could anyone with outstanding issues please try with the latest versions and file a bug in the tracker if they persist (choose 'non-core contributed modules' and then block_ajax_marking). I get emailed immediately if you do that and will respond promptly.


Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Dhoom La -
Thanks for the new ajax marking block. I have added this block in to my moodle.

But if i am adding this and testing, like i have submitted the assignment and checked by logged in as admin. But its showing that "You have no courses with graded assessments yet"

Can you help me out for this???
Average of ratings: -
In reply to Matt Gibson

AJAX marking block for 1.9.5 - Internet Explorer

by Ed Main -
After testing this excellent block on a local installation, using both Explorer and Fire Fox, away we went with the installation on our production version of Moodle. It continues to be excellent and has become VERY popular with our teachers, at least those who use it from home where they are able to use Fire Fox. With the production server, Explorer only shows the spinning wheel. However, using Explorer and the local installation, all is fine. Fire Fox is fine with either. Our tech department only "allows" the use of Explorer and have banned the use of Fire Fox. We have tried to use a number of different boxes both within the school district along with at home . . . using both Explorer 7 and 8 . . . is this a known issue . . . is there a simple change in an Explorer setting that someone may know of? Any help would be appreciated and would get everyone being able to enjoy the advantages of this excellent block!
Average of ratings: -
In reply to Ed Main

Re: AJAX marking block for 1.9.5 - Internet Explorer

by Dan Jeffries -
hi!

Love this block.

Have an issue though which I've posted in the Tracker, but figured I'd ask it here too.

I can't seem to see Adanced Upload of Files or Upload a File assignments. Any ideas?

Also, in Configure it says 'Course default'. Where is the Course default?

Thanks!
Average of ratings: -
In reply to Dan Jeffries

Re: AJAX marking block for 1.9.5 - Internet Explorer

by Rick Barnes -

I wonder if this could be our issue too in 1.9.10 . The only items that I have seen have been forums.

We use the advanced upload assignemnts almost exclusively to collect all of the files for each project that we are assessing.

Average of ratings: -
In reply to Rick Barnes

Re: AJAX marking block for 1.9.5 - Internet Explorer

by Dan Leighton -

This block has become 100% essential for us.  We love it.  Is the Moodle 2.0 work nearing completion?  If so, we'd love to give it a try!

smile

Great block - thanks so much for all you time and effort on it.

Average of ratings: -
In reply to Matt Gibson

AJAX marking block for Moodle 2.0

by Alex Sayles -

Hi, I've been using your marking block for a few months now and the staff at my school love the block. I am currently working on a test site for Moodle 2.0 to work out which features will and won't be available for when we upgrade our version of Moodle sometime in the new year and one of the most important features that is currently missing is this marking block.

I was wondering if there was a date for when this will be available for Moodle 2 as currently when we try to install the version that is available, it does nothing, after uploading the files and going to notificiations, there is no message saying anything has been installed and the block does not appear in the plugins list.

All the staff find this block really useful and I would appreciate it if you could give me some sort of idea of when this really useful block will be available in some form of stable build for the new version of Moodle.

Average of ratings: -
In reply to Alex Sayles

Re: AJAX marking block for Moodle 2.0

by George Burdo -

I have the same issue on my test site, but I was able to trick it into attempting to install: I did this by uploading another block at the same time, and then ran the notification, it showed both blocks, and generated errors for the AJAX block (which admittedly did not install, but at least I know the problem is with the plugin and not my installation).

I have attached a pdf of the errors generated for those who might know the coding...

Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.9.10

by Rick Barnes -

We have just had our server updated to the latest versions of MySQL and php and updated to moodle 1.9.10.

The marking block stopped working correctly (all icons disapeared and the link to grade the assessment did not work) so only showing us what needed marking not letting us mark it.

Today we have updated the block which seems to have installed correctly, however now insted of seeing the 260ish pieces of work awaiting marking I now see Hooray nothing to mark (would be nice) The 2 links at the bottom of the block to colapse and for settings are not available either.

I have gone in to two of the courses I teach in to make sure that I am the editing teacher and to add myself to groups with the pupils that I am teaching but this has had no effect either.

Where should I start looking in moodle? or is there something that I need the server admin to look at first?

Average of ratings: -
In reply to Rick Barnes

Re: AJAX marking block beta for 1.9.10

by Rick Barnes -

The configure pop up is giving me the options that I need. However it is listing all of the courses that I am a teacher on but only 1 is showing that it has any work to mark.

When I try to change the configure options there is no save button and when I close the pop up the settings are lost.

Average of ratings: -
In reply to Matt Gibson

AJAX marking block for 2.0.2

by Kimber Warden -

I'm very excited to install this block, since the GradeMe block I'm currently using won't work on my new 2.0.2 installation. However, when I download the 2.0 version of the Ajax block, unzip it to /blocks and upload it on my server, I don't get a message in Notifications and the block isn't listed in the drop-down menu of Add New block...

Is there something I should check?

Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Steve Dowdall -

Hi

We are on 1.9.10 and have the latest block installed.  We are having an issue with it appearing as your does.  We see work for grading but not the class groups.  We just get taken to the normal assignment quick grading page.  How do we get groups and students to show so we can pick up own marking?

I log in with admin rights and I am not normally added to each class as a teacher.

cheers

steve

Average of ratings: -
In reply to Steve Dowdall

Re: AJAX marking block beta for 1.8.2

by Gary Newport -

Hi

I have just installed this on to 2.1 and the block appears and installs fine. I have added it to the front page and it appears without issue but then I simply get the rotating arrows and nothing else.

I have purged the cache and tried again but aside from once getting an AJAX Connection Error I simply get the rotating arrows. I have checked and I am a teacher in at least one course with grades awaiting marking so where am I going wrong?

Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Matt Gibson -

Hi everyone.

The latest and greatest code now lives here.

It seems to be stable for me on 2.0, but I don't have every single combination of DBs etc to try it on, so there may be small bugs to iron out still. I've completely rewritten the block to make it more scalable, so it now works very differently under the hood. I'm planning on a very thorough load testing session pretty soon, using a copy of a very large production database, but any feedback on speed and reliability etc would be great.

For 2.1, it should work, but the quiz has been altered, so it may break if you try to view quiz questions. I'm working on that now, but if you don't use quiz (or don't mind if it doesn't work, just delete the /modules/quiz folder.

The code that allows selective hiding of some groups has gone temporarily, whilst I work out a more efficient/user friendly way of implementing it. In rough order of priority, the coming changes are:

  1. get the quiz working with random questions
  2. get the quiz working with 2.1
  3. get the config stuff back in for hiding stuff
  4. add a tab for searching for individual students by name
  5. Massive performance, and scalability tests
  6. Improve grading UI so it doesn't use such ugly popups
  7. Support other modules - journal, lesson, glossary etc

These aren't all in the tracker yet, but once they are, I'll post here again (in a new thread, I think!) to solicit votes, then change the order based on your feedback.

Glad you're all finding it useful!

Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Gary Newport -

Sorry but I am still getting the spinning arrows and nothing else.

Average of ratings: -
In reply to Gary Newport

Re: AJAX marking block beta for 1.8.2

by Gary Newport -

I have run it in IE as well as Firefox and IE let me know that:

'M.block_ajax_marking' is null or not an object

The latest version simply states:

'undefined' is null or not an object

Both errors give a code of 0 (zero)

Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Gary Newport -

I now no longer have the rotating arrows but I have nothing at all appearing.

I am a teacher on several courses and I know there are questions awaiting for marking as well as at least one assignment; yet nothing!

Anyone any ideas why?

I know that on some courses I am listed as having 'several roles' even though under Assign Roles I only have Teacher!

Average of ratings: -
In reply to Gary Newport

Re: AJAX marking block beta for 1.8.2

by Gary Newport -

This may be a long post but I have come across the following in my error logs on the server. Anyone any ideas?

[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: PHP Notice:  Use of undefined constant QUESTION_EVENTS_GRADED - assumed 'QUESTION_EVENTS_GRADED' in /var/www/vhosts/bexhill-vle.co.uk/httpdocs/blocks/ajax_marking/modules/quiz/block_ajax_marking_quiz.class.php on line 499
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: Default exception handler: Error reading from database Debug: Unknown column 'QUESTION_EVENTS_GRADED' in 'where clause'
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: SELECT combinedmodulesubquery.id AS courseid,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: combinedmodulesubquery.count,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: course.shortname AS name,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: course.fullname AS tooltip
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:  FROM (
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:             SELECT moduleunion.courseid AS id, SUM(moduleunion.count) AS count
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:               FROM (SELECT moduletable.course AS courseid,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:  COUNT(DISTINCT sub.id)  AS count
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:  FROM mdl_assignment moduletable
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: INNER JOIN mdl_assignment_submissions sub ON sub.assignment = moduletable.id
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: INNER JOIN (SELECT enrol.courseid
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:  FROM mdl_user_enrolments user_enrolments
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: INNER JOIN mdl_enrol enrol ON enrol.id = user_enrolments.enrolid
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:  WHERE  user_enrolments.userid = ? ) ue ON ue.courseid = moduletable.course
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: INNER JOIN mdl_course_modules cm ON cm.instance = moduletable.id
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: INNER JOIN mdl_course course ON course.id = moduletable.course
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: LEFT JOIN mdl_block_ajax_marking bama ON cm.id = bama.coursemoduleid
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: LEFT JOIN mdl_block_ajax_marking bamc ON moduletable.course = bamc.courseid
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:  WHERE  sub.timemarked < sub.timemodified
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: AND NOT ( (moduletable.resubmit = 0 AND sub.timemarked > 0)
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                        OR (moduletable.assignmenttype = 'upload'
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                            AND sub.data2 != 'submitted') )
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: AND sub.userid != ?
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: AND cm.module = ?
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: AND cm.visible = 1
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: AND course.visible = 1
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: AND
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                 (   bama.display = 1
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                     OR
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                     ( bama.display = 2 AND  EXISTS (SELECT 1
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                 FROM mdl_groups_members gm
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                           INNER JOIN mdl_groups g
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                   ON gm.groupid = g.id
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                           INNER JOIN mdl_block_ajax_marking_groups gs
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                   ON g.id = gs.groupid
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                WHERE gm.userid = sub.userid
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                  AND gs.configid = bama.id)  )
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                     OR
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                     ( ( bama.display IS NULL OR bama.display = 0 )
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                         AND
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                         ( bamc.display IS NULL
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                           OR bamc.display = 1
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                           OR (bamc.display = 2
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                               AND  EXISTS (SELECT 1
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                 FROM mdl_groups_members gm
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                           INNER JOIN mdl_groups g
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                   ON gm.groupid = g.id
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                           INNER JOIN mdl_block_ajax_marking_groups gs
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                   ON g.id = gs.groupid
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                WHERE gm.userid = sub.userid
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                  AND gs.configid = bamc.id) )
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                         )
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                     )
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                     )
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: AND course.id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:  GROUP BY moduletable.course
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:  UNION ALL
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: SELECT moduletable.course AS courseid,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:  COUNT(DISTINCT sub.id)  AS count
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:  FROM mdl_forum_posts sub
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: LEFT JOIN mdl_rating r ON sub.id = r.itemid
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: INNER JOIN mdl_forum_discussions discussions ON sub.discussion = discussions.id
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: INNER JOIN mdl_forum moduletable ON discussions.forum = moduletable.id
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: INNER JOIN (SELECT enrol.courseid
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:  FROM mdl_user_enrolments user_enrolments
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: INNER JOIN mdl_enrol enrol ON enrol.id = user_enrolments.enrolid
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:  WHERE  user_enrolments.userid = ? ) ue ON ue.courseid = moduletable.course
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: INNER JOIN mdl_course_modules cm ON cm.instance = moduletable.id
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: INNER JOIN mdl_course course ON course.id = moduletable.course
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: LEFT JOIN mdl_block_ajax_marking bama ON cm.id = bama.coursemoduleid
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: LEFT JOIN mdl_block_ajax_marking bamc ON moduletable.course = bamc.courseid
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:  WHERE  sub.userid <> ?
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: AND moduletable.assessed > 0
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: AND ( ( ( r.userid <> ?)
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                 AND NOT EXISTS( SELECT 1
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                  FROM mdl_role_assignments ra
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                            INNER JOIN mdl_context cx
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                    ON ra.contextid = cx.id
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                            INNER JOIN mdl_course_categories cat1
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                    ON cx.instanceid = cat1.id LEFT JOIN mdl_course_categories cat2
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                    ON cat1.parent = cat2.id WHERE(course.category = cat1.id OR course.category = cat2.id) AND ra.userid = r.userid
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                     AND cx.contextlevel = 40  UNION
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                        SELECT 1
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                          FROM mdl_role_assignments ra
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                    INNER JOIN mdl_context cx
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                            ON ra.contextid = cx.id
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                         WHERE cx.contextlevel = 50
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                           AND ra.userid = r.userid
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                           AND cx.instanceid = course.id
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                         ) )
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                               OR r.userid IS NULL)
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                             AND ( ( moduletable.type != 'eachuser')
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                   OR ( moduletable.type = 'eachuser'
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                        AND sub.id = discussions.firstpost))
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: AND ( (moduletable.assesstimestart = 0) OR
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                                  (sub.created >= moduletable.assesstimestart) )  
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: AND ( (moduletable.assesstimefinish = 0) OR
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                                  (sub.created <= moduletable.assesstimefinish) )
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: AND sub.userid != ?
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: AND cm.module = ?
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: AND cm.visible = 1
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: AND course.visible = 1
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: AND
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                 (   bama.display = 1
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                     OR
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                     ( bama.display = 2 AND  EXISTS (SELECT 1
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                 FROM mdl_groups_members gm
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                           INNER JOIN mdl_groups g
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                   ON gm.groupid = g.id
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                           INNER JOIN mdl_block_ajax_marking_groups gs
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                   ON g.id = gs.groupid
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                WHERE gm.userid = sub.userid
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                  AND gs.configid = bama.id)  )
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                     OR
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                     ( ( bama.display IS NULL OR bama.display = 0 )
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                         AND
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                         ( bamc.display IS NULL
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                           OR bamc.display = 1
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                           OR (bamc.display = 2
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                               AND  EXISTS (SELECT 1
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                 FROM mdl_groups_members gm
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                           INNER JOIN mdl_groups g
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                   ON gm.groupid = g.id
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                           INNER JOIN mdl_block_ajax_marking_groups gs
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                   ON g.id = gs.groupid
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                WHERE gm.userid = sub.userid
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                  AND gs.configid = bamc.id) )
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                         )
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                     )
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                     )
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: AND course.id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:  GROUP BY moduletable.course
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:  UNION ALL
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: SELECT moduletable.course AS courseid,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:  COUNT(DISTINCT sub.id)  AS count
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:  FROM mdl_quiz moduletable
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: INNER JOIN mdl_quiz_attempts quiz_attempts ON moduletable.id = quiz_attempts.quiz
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: INNER JOIN mdl_question_sessions qsess ON qsess.attemptid = quiz_attempts.uniqueid
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: INNER JOIN mdl_question_states sub ON qsess.newest = sub.id
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: INNER JOIN mdl_question question ON qsess.questionid = question.id
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: INNER JOIN (SELECT enrol.courseid
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:  FROM mdl_user_enrolments user_enrolments
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: INNER JOIN mdl_enrol enrol ON enrol.id = user_enrolments.enrolid
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:  WHERE  user_enrolments.userid = ? ) ue ON ue.courseid = moduletable.course
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: INNER JOIN mdl_course_modules cm ON cm.instance = moduletable.id
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: INNER JOIN mdl_course course ON course.id = moduletable.course
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: LEFT JOIN mdl_block_ajax_marking bama ON cm.id = bama.coursemoduleid
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: LEFT JOIN mdl_block_ajax_marking bamc ON moduletable.course = bamc.courseid
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:  WHERE  quiz_attempts.timefinish > 0
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: AND quiz_attempts.preview = 0
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: AND question.qtype = 'essay'
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: AND sub.event NOT IN (QUESTION_EVENTS_GRADED)  
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: AND quiz_attempts.userid != ?
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: T 1
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                 FROM mdl_groups_members gm
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                           INNER JOIN mdl_groups g
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                   ON gm.groupid = g.id
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                           INNER JOIN mdl_block_ajax_marking_groups gs
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                   ON g.id = gs.groupid
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                WHERE gm.userid = quiz_attempts.userid
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                  AND gs.configid = bama.id)  )
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                     OR
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                     ( ( bama.display IS NULL OR bama.display = 0 )
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                         AND
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                         ( bamc.display IS NULL
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                           OR bamc.display = 1
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                           OR (bamc.display = 2
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                               AND  EXISTS (SELECT 1
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                 FROM mdl_groups_members gm
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                           INNER JOIN mdl_groups g
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                   ON gm.groupid = g.id
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                           INNER JOIN mdl_block_ajax_marking_groups gs
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                   ON g.id = gs.groupid
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                WHERE gm.userid = quiz_attempts.userid
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                  AND gs.configid = bamc.id) )
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                         )
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                     )
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                     )
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: AND course.id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:  GROUP BY moduletable.course
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:  UNION ALL
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: SELECT moduletable.course AS courseid,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:  COUNT(DISTINCT sub.id)  AS count
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:  FROM mdl_workshop moduletable
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: INNER JOIN mdl_workshop_submissions sub ON sub.workshopid = moduletable.id
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: LEFT JOIN mdl_workshop_assessments a ON sub.id = a.submissionid
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: INNER JOIN (SELECT enrol.courseid
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:  FROM mdl_user_enrolments user_enrolments
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: INNER JOIN mdl_enrol enrol ON enrol.id = user_enrolments.enrolid
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:  WHERE  user_enrolments.userid = ? ) ue ON ue.courseid = moduletable.course
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: INNER JOIN mdl_course_modules cm ON cm.instance = moduletable.id
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: INNER JOIN mdl_course course ON course.id = moduletable.course
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: LEFT JOIN mdl_block_ajax_marking bama ON cm.id = bama.coursemoduleid
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: LEFT JOIN mdl_block_ajax_marking bamc ON moduletable.course = bamc.courseid
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:  WHERE  (a.reviewerid != ?
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                    OR (a.reviewerid = ?
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                        AND a.grade = -1))
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: AND moduletable.phase < 50
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: AND sub.authorid != ?
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: AND cm.module = ?
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: AND cm.visible = 1
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: AND course.visible = 1
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: AND
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                 (   bama.display = 1
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                     OR
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                     ( bama.display = 2 AND  EXISTS (SELECT 1
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                 FROM mdl_groups_members gm
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                           INNER JOIN mdl_groups g
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                   ON gm.groupid = g.id
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                           INNER JOIN mdl_block_ajax_marking_groups gs
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                   ON g.id = gs.groupid
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                WHERE gm.userid = sub.authorid
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                  AND gs.configid = bama.id)  )
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                     OR
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                     ( ( bama.display IS NULL OR bama.display = 0 )
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                         AND
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                         ( bamc.display IS NULL
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                           OR bamc.display = 1
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                           OR (bamc.display = 2
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                               AND  EXISTS (SELECT 1
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                 FROM mdl_groups_members gm
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                           INNER JOIN mdl_groups g
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                   ON gm.groupid = g.id
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                           INNER JOIN mdl_block_ajax_marking_groups gs
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                   ON g.id = gs.groupid
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                WHERE gm.userid = sub.authorid
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                                  AND gs.configid = bamc.id) )
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                         )
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                     )
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:                     )
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: AND course.id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:  GROUP BY moduletable.course ) moduleunion
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:           GROUP BY moduleunion.courseid
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:           ) combinedmodulesubquery
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: INNER JOIN mdl_course course ON combinedmodulesubquery.id = course.id
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: [array (
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   0 => '5',
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   1 => '5',
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   2 => '1',
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   3 => 3,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   4 => 17,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   5 => 14,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   6 => 8,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   7 => 19,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   8 => 4,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   9 => 5,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   10 => 18,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   11 => 23,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   12 => 24,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   13 => 25,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   14 => 26,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   15 => 28,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   16 => 21,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   17 => 22,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   18 => 27,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   19 => 29,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   20 => '5',
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   21 => '5',
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   22 => '5',
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   23 => '5',
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   24 => '7',
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   25 => 3,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   26 => 17,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   27 => 14,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   28 => 8,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   29 => 19,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   30 => 4,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   31 => 5,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   32 => 18,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   33 => 23,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   34 => 24,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   35 => 25,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   36 => 26,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   37 => 28,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   38 => 21,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   39 => 22,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   40 => 27,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   41 => 29,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   42 => '5',
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   43 => '5',
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   44 => '13',
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   45 => 3,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   46 => 17,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   47 => 14,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   48 => 8,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   49 => 19,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   50 => 4,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   51 => 5,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   52 => 18,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   53 => 23,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   54 => 24,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   55 => 25,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   56 => 26,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   57 => 28,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   58 => 21,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   59 => 22,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   60 => 27,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   61 => 29,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   62 => '5',
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   63 => '5',
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   64 => '5',
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   65 => '5',
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   66 => '19',
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   67 => 3,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   68 => 17,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   69 => 14,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   70 => 8,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   71 => 19,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   72 => 4,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   73 => 5,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   74 => 18,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   75 => 23,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   76 => 24,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   77 => 25,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   78 => 26,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   79 => 28,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   80 => 21,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   81 => 22,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   82 => 27,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr:   83 => 29,
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: )]
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: * line 394 of /lib/dml/moodle_database.php: dml_read_exception thrown
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: * line 795 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: * line 550 of /blocks/ajax_marking/classes/query_base.class.php: call to mysqli_native_moodle_database->get_records_sql()
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: * line 214 of /blocks/ajax_marking/classes/query_factory.class.php: call to block_ajax_marking_query_base->execute()
[Fri Oct 14 01:19:22 2011] [warn] mod_fcgid: stderr: * line 58 of /blocks/ajax_marking/actions/ajax_nodes.php: call to block_ajax_marking_query_factory::get_query()

Average of ratings: -
In reply to Gary Newport

Re: AJAX marking block beta for 1.8.2

by Matt Gibson -

Hi Gary

If you're on 2.1, then that's unfortunately normal - the question bank has been altered and I'm just working on an upgrade to make it work again. You can temporarily delete the ajax_marking/modules/quiz folder and it should all be OK (apart from no quiz functionality). The Javascript error above is fixed in the 2.0.2 build on the plugins page.

Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Allan Kealey -

Hi

I have just carried out the instructions above and I get the tree but when I expand the tree and click on a user whose work needs marking strange things happen.  If there is no work attached the grading window opens as expected but if there is a file to assess then this appears

 error

I have disabled the quiz module.

Also the marking is not split into groups , is this something that will appear on the config  tab?

Allan

Average of ratings: -
In reply to Allan Kealey

Re: AJAX marking block beta for 1.8.2

by Matt Gibson -

Hi Allan

The groups thing is disabled deliberately because the original code wasn't that efficient and the Moodle 2.0 cohorts thing necessitated a new approach. I will be getting the config tab to allow groups stuff to work once I have proper support for 2.1 done, so it's in the pipeline.

I did get the error you have above on my local machine, but assumed it was because I was using a DB dump from a test system which had plagiarism installed. I think it's a bug in Moodle core because the plagiarism_get_links() function is one that I've used before. I expect the source file is not being included. Do you get the same error when you try to mark that work using the normal assignment interface?

Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Matt Gibson -

I was right: MDL-29564

If you download the latest core code, you should find that error goes away.

Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Matt Gibson -

BTW I've started a new thread here for the 2.0 version as this one's getting  a bit long.

Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Allan Kealey -

Hi

No if I use the normal interface everything works fine, however another issue has arisen.  When I loaded the new module, any module, the icons vanish and I have to do a ctrl +f5 several times to get them back

Most Odd

Allan

Average of ratings: -
In reply to Allan Kealey

Re: AJAX marking block beta for 1.8.2

by Matt Gibson -

Hmm. That does sound odd, but I'm not sure exactly what you mean. 'Module' as in clicking on a student's name to get a pop up? And which icons?

Average of ratings: -
In reply to Matt Gibson

Re: AJAX marking block beta for 1.8.2

by Allan Kealey -

Sorry for the confusing message.  If I install a block and go back to the admin page to install it the icons that make up the interface ie assignment resource grades, in fact any little icon disappears and is replaced with a little red cross.  If I crtrl+F5 and force a refresh the screen a few times they reluctantly reappear.

Average of ratings: -
In reply to Allan Kealey

Re: AJAX marking block beta for 1.8.2

by Matt Gibson -

Sounds like a theme issue. Do you get the same thing with the Standardwhite theme?

Average of ratings: -