Moodle in English: AJAX marking block beta for 1.8.2

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 )
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

Matt

block_AJAXmarking_2007082902.zip

平均分： -

Re: AJAX marking block beta for 1.8.2

Matt Gibson - 2007年08月30日星期四 01:35

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.

平均分： -

Re: AJAX marking block beta for 1.8.2

Julian Ridden - 2007年09月4日星期二 13:02

Sadly couldn't get this working

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

Any ideas?

平均分： -

Re: AJAX marking block beta for 1.8.2

Matt Gibson - 2007年09月4日星期二 15:44

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

平均分： -

Re: AJAX marking block beta for 1.8.2

Bruno Vernier - 2007年09月5日星期三 03:38

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?

平均分： -

Re: AJAX marking block beta for 1.8.2

Matt Gibson - 2007年09月5日星期三 03:55

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

平均分： -

Re: AJAX marking block beta for 1.8.2

Bruno Vernier - 2007年09月5日星期三 04:57

we use the exact same environment

平均分： -

Re: AJAX marking block beta for 1.8.2

Matt Gibson - 2007年09月5日星期三 07:26

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.

block_AJAX_marking_2007090407.zip

平均分： -

Re: AJAX marking block beta for 1.8.2

Bruno Vernier - 2007年09月5日星期三 10:12

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

平均分： -

Re: AJAX marking block beta for 1.8.2

Julian Ridden - 2007年09月5日星期三 16:08

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

平均分： -

Re: AJAX marking block beta for 1.8.2

Matt Gibson - 2007年09月5日星期三 16:52

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.

平均分： -

Re: AJAX marking block beta for 1.8.2

Julian Ridden - 2007年09月5日星期三 19:23

only reason it still says marking is because i changed the lang file back to marking

With the new lang file situation remains unchanged

平均分： -

Re: AJAX marking block beta for 1.8.2

Matt Gibson - 2007年09月5日星期三 21:20

Hmmm...

In that case, could you try uncommenting those 2 lines and posting the response text you get?

平均分： -

Re: AJAX marking block beta for 1.8.2

Bruno Vernier - 2007年09月5日星期三 23:06

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

","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

平均分： -

Re: AJAX marking block beta for 1.8.2

Matt Gibson - 2007年09月6日星期四 00:13

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.

平均分： -

Re: AJAX marking block beta for 1.8.2

Matt Gibson - 2007年09月5日星期三 16:32

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

平均分： -

Re: AJAX marking block issues

Allan Kealey - 2010年09月14日星期二 21:04

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

平均分： -

Re: AJAX marking block beta for 1.8.2

Matt Gibson - 2007年09月6日星期四 05:26

OK, I've fixed it now I think. Courses with double quotes in the name should work and all tags are stripped from the names and summaries before the AJAX data comes back.

block_AJAX_marking_2007090501.zip

平均分： -

Re: AJAX marking block beta for 1.8.2

Matt Gibson - 2007年09月6日星期四 06:49

Spoke too soon. This should be better.

block_AJAX_marking_2007090503.zip

平均分： -

Re: AJAX marking block beta for 1.8.2

Bruno Vernier - 2007年09月6日星期四 14:14

success! this last one works

thank you

平均分： -

Re: AJAX marking block beta for 1.8.2

Matt Gibson - 2007年09月6日星期四 23:40

This version fixes more issues with line breaks and special characters and displays forums properly.

block_AJAX_marking_2007090600.zip

平均分： -

Re: AJAX marking block beta for 1.8.2

Monico Briseño - 2007年09月8日星期六 03:26

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

平均分： -

Re: AJAX marking block beta for 1.8.2

Matt Gibson - 2007年09月10日星期一 04:39

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

平均分： -

Re: AJAX marking block beta for 1.8.2

Monico Briseño - 2007年09月10日星期一 21:53

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

平均分： -

Re: AJAX marking block beta for 1.8.2

Matt Gibson - 2007年09月7日星期五 05:52

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.

平均分： -

Re: AJAX marking block beta for 1.8.2

Bruno Vernier - 2007年09月7日星期五 06:58

this new version also works fine

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

平均分： -

Re: AJAX marking block beta for 1.8.2

Matt Gibson - 2007年09月7日星期五 07:07

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.

平均分： -

Re: AJAX marking block beta for 1.8.2

AjnabiZ ... - 2007年09月15日星期六 18:43

WOuld this be compatible with 1.9 ?

平均分： -

Re: AJAX marking block beta for 1.8.2

Matt Gibson - 2007年09月17日星期一 17:32

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

平均分： -

Re: AJAX marking block beta for 1.8.2

Julian Ridden - 2007年09月19日星期三 06:52

Yup, I am using 1.9 and it works a treat.

平均分： -

Re: AJAX marking block beta for 1.8.2

Oliver James - 2007年09月20日星期四 16:42

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.

平均分： -

Re: AJAX marking block beta for 1.8.2

Matt Gibson - 2007年09月20日星期四 20:41

Hi Oliver, glad you like it

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

平均分： -

Re: AJAX marking block beta for 1.8.2

Oliver James - 2007年09月23日星期日 16:37

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

平均分： -

Re: AJAX marking block beta for 1.8.2

Oliver James - 2007年09月23日星期日 16:51

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.

平均分： -

Re: AJAX marking block beta for 1.8.2

Matt Gibson - 2007年09月24日星期一 03:15

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.

block_AJAX_marking_2007092300.zip

平均分： -

Re: AJAX marking block beta for 1.8.2

Larry Elchuck - 2007年09月24日星期一 06:27

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

平均分： -

Re: AJAX marking block beta for 1.8.2

Oliver James - 2007年09月24日星期一 15:12

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.

平均分： -

Re: AJAX marking block beta for 1.8.2

Oliver James - 2007年09月24日星期一 18:09

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.

平均分： -

Re: AJAX marking block beta for 1.8.2

Oliver James - 2007年09月24日星期一 18:14

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.

平均分： -

Re: AJAX marking block beta for 1.8.2

Matt Gibson - 2007年09月24日星期一 18:32

Whoops, that's one of my debugging alerts to check things are working. Its safe to ignore and I will comment it out tonight.

平均分： -

Re: AJAX marking block beta for 1.8.2

Matt Gibson - 2007年09月24日星期一 18:38

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?

平均分： -

Re: AJAX marking block beta for 1.8.2

Matt Gibson - 2007年09月24日星期一 18:45

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.

平均分： -

Re: AJAX marking block beta for 1.8.2

Larry Elchuck - 2007年09月24日星期一 20:24

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

平均分： -

Re: AJAX marking block beta for 1.8.2

Matt Gibson - 2007年09月24日星期一 20:35

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.

平均分： -

Re: AJAX marking block beta for 1.8.2

Larry Elchuck - 2007年09月24日星期一 20:47

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

平均分： -

Re: AJAX marking block beta for 1.8.2

Matt Gibson - 2007年09月24日星期一 20:48

great

平均分： -

Re: AJAX marking block beta for 1.8.2

Oliver James - 2007年09月24日星期一 22:47

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.

平均分： -

Re: AJAX marking block beta for 1.8.2

Matt Gibson - 2007年09月25日星期二 03:02

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.

block_AJAX_marking_2007092400.zip

平均分： -

Re: AJAX marking block beta for 1.8.2

Oliver James - 2007年09月25日星期二 03:38

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.

平均分： -

Re: AJAX marking block beta for 1.8.2

Bruno Vernier - 2007年09月25日星期二 14:41

the ajax error, Transaction id 0, http status -1 status code transaction aborted is also happening on our site, also sporadically

平均分： -

Re: AJAX marking block beta for 1.8.2

Matt Gibson - 2007年09月25日星期二 17:05

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...

平均分： -

Re: AJAX marking block beta for 1.8.2

Matt Gibson - 2007年09月25日星期二 19:39

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.

平均分： -

Re: AJAX marking block beta for 1.8.2

Oliver James - 2007年09月25日星期二 19:58

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.

平均分： -

Re: AJAX marking block beta for 1.8.2

Oliver James - 2007年09月25日星期二 23:45

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

平均分： -

Re: AJAX marking block beta for 1.8.2

Matt Gibson - 2007年09月26日星期三 02:55

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.

平均分： -

Re: AJAX marking block beta for 1.8.2

Matt Gibson - 2007年09月26日星期三 03:26

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.

block_AJAX_marking_2007092500.zip

平均分： -

Re: AJAX marking block beta for 1.8.2

Larry Elchuck - 2007年09月26日星期三 04:32

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

平均分： -

Re: AJAX marking block beta for 1.8.2

Oliver James - 2007年09月26日星期三 18:02

Matt,

Unfortunately we werent lucky on this occasion. Still repeating.

Oliver.

平均分： -

Re: AJAX marking block beta for 1.8.2

Matt Gibson - 2007年09月26日星期三 18:12

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?

block_AJAX_marking_2007092600.zip

平均分： -

Re: AJAX marking block beta for 1.8.2

Oliver James - 2007年10月1日星期一 18:02

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.

平均分： -

Re: AJAX marking block beta for 1.8.2

Matt Gibson - 2007年10月1日星期一 20:46

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

平均分： -

Re: AJAX marking block beta for 1.8.2

Karlene Clapp - 2007年10月2日星期二 05:10

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.

平均分： -

Re: AJAX marking block beta for 1.8.2

Matt Gibson - 2007年10月2日星期二 06:14

Hi Karlene,

Glad it works for you

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

平均分： -

Re: AJAX marking block beta for 1.8.2

Karlene Clapp - 2007年10月3日星期三 01:09

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

平均分： -

Re: AJAX marking block beta for 1.8.2

Matt Gibson - 2007年10月3日星期三 17:25

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

平均分： -

Re: AJAX marking block beta for 1.8.2

Karlene Clapp - 2007年10月6日星期六 00:30

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

平均分： -

Re: AJAX marking block beta for 1.8.2

Anthony Borrow - 2007年12月12日星期三 03:51

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

平均分： -

Re: AJAX marking block beta for 1.8.2

Barry Lindler - 2008年02月4日星期一 01:55

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.

平均分： -

Re: AJAX marking block beta for 1.8.2

Clinton Branscombe - 2008年06月23日星期一 19:58

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.

平均分： -

Re: AJAX marking block beta for 1.8.2

Rick Barnes - 2008年08月12日星期二 06:44

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?

平均分： -

Re: AJAX marking block beta for 1.8.2

Frederic Nevers - 2008年09月18日星期四 17:41

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

平均分： -

Re: AJAX marking block beta for 1.8.2

Frederic Nevers - 2008年09月18日星期四 17:49

Okay, nobody seems to have reported this so I created a new issue in the bug tracker. If you want this fixed as well, please vote for it here http://tracker.moodle.org/browse/CONTRIB-712

平均分： -

Re: AJAX marking block beta for 1.8.2

Shaun Burford - 2008年08月11日星期一 05:11

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

平均分： -

Re: AJAX marking block beta for 1.8.2

Jaap Marsman - 2008年09月7日星期日 01:32

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!

平均分： -

Re: AJAX marking block beta for 1.8.2

Dan Jeffries - 2008年09月14日星期日 17:17

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

平均分： -

Re: AJAX marking block beta for 1.8.2

Frederic Nevers - 2008年09月15日星期一 17:44

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

平均分： -

Re: AJAX marking block beta for 1.8.2

Frederic Nevers - 2008年09月18日星期四 17:19

Okay, so I'll reply to my own post

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

平均分： -

Re: AJAX marking block beta for 1.8.2

Rick Barnes - 2008年09月25日星期四 05:13

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).

平均分： -

Re: AJAX marking block beta for 1.8.2

Larry Elchuck - 2008年10月8日星期三 04:24

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

平均分： -

Re: AJAX marking block beta for 1.9.2

Larry Elchuck - 2008年10月8日星期三 16:40

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

平均分： -

Re: AJAX marking block beta for 1.9.2

Raymond Kersting - 2008年11月4日星期二 11:34

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

平均分： -

Re: AJAX marking block beta for 1.9.2

Raymond Kersting - 2008年11月6日星期四 09:35

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

平均分： -

Ajax Marking Block

Anuja Gaunekar - 2008年11月11日星期二 22:30

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.

平均分： -

Re: Ajax Marking Block

Matt Gibson - 2009年01月29日星期四 22:54

@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.

平均分： -

Re: AJAX marking block beta for 1.9.2

Dan Leighton - 2008年12月1日星期一 03:46

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!

平均分： -

Re: AJAX marking block beta for 1.9.2

Matt Gibson - 2009年01月29日星期四 22:51

CONTRIB-1002

平均分： -

Re: AJAX marking block beta for 1.9.2

ben reynolds - 2009年05月31日星期日 06:24

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

Collapse & refresh

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.

平均分： -

Re: AJAX marking block beta for 1.9.2

Martin F - 2009年06月1日星期一 06:28

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!

平均分： -

Re: AJAX marking block beta for 1.9.2

Rob Monk - 2009年06月3日星期三 18:13

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!!

平均分： -

Re: AJAX marking block beta for 1.9.2

Dan Jeffries - 2009年06月3日星期三 19:04

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!

平均分： -

Re: AJAX marking block beta for 1.9.2

Martin F - 2009年06月4日星期四 02:06

I've now switched to the "Grade Me" block, not as great, but does a good job.

平均分： -

Re: AJAX marking block beta for 1.9.2

Simon Ryder - 2009年06月16日星期二 18:34

Having the same issues after upgrading to moodle 1.95, anyone found a solution?

平均分： -

Re: AJAX marking block beta for 1.9.2

Matt Gibson - 2009年01月30日星期五 00:26

@ Raymond/Jim

Config error is fixed in CVS now.

平均分： -

Re: AJAX marking block beta for 1.9.2

Rob Monk - 2009年05月28日星期四 10:09

Is the AJAX marking block compatible with 1.9.5? We have just upgraded and would like to get it going again.

平均分： -

Re: AJAX marking block beta for 1.8.2

Matt Gibson - 2009年01月29日星期四 22:44

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.

平均分： -

Re: AJAX marking block beta for 1.8.2

Dhoom La - 2009年10月14日星期三 11:50

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???

平均分： -

AJAX marking block for 1.9.5 - Internet Explorer

Ed Main - 2009年12月9日星期三 10:51

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!

平均分： -

Re: AJAX marking block for 1.9.5 - Internet Explorer

Dan Jeffries - 2010年01月13日星期三 22:31

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!

平均分： -

Re: AJAX marking block for 1.9.5 - Internet Explorer

Rick Barnes - 2010年12月10日星期五 06:23

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.

平均分： -

Re: AJAX marking block for 1.9.5 - Internet Explorer

Dan Leighton - 2011年03月3日星期四 05:46

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!

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

平均分： -

AJAX marking block for Moodle 2.0

Alex Sayles - 2010年12月6日星期一 10:49

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.

平均分： -

Re: AJAX marking block for Moodle 2.0

George Burdo - 2010年12月8日星期三 09:59

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...

ajax-marking.pdf

平均分： -

Re: AJAX marking block beta for 1.9.10

Rick Barnes - 2010年12月9日星期四 06:40

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?

平均分： -

Re: AJAX marking block beta for 1.9.10

Rick Barnes - 2010年12月9日星期四 07:54

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.

平均分： -

AJAX marking block for 2.0.2

Kimber Warden - 2011年03月4日星期五 02:36

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?

平均分： -

Re: AJAX marking block beta for 1.8.2

Steve Dowdall - 2011年03月4日星期五 17:56

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

平均分： -

Re: AJAX marking block beta for 1.8.2

Gary Newport - 2011年10月7日星期五 16:31

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?

平均分： -

Re: AJAX marking block beta for 1.8.2

Matt Gibson - 2011年10月7日星期五 19:39

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:

get the quiz working with random questions
get the quiz working with 2.1
get the config stuff back in for hiding stuff
add a tab for searching for individual students by name
Massive performance, and scalability tests
Improve grading UI so it doesn't use such ugly popups
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!

平均分： -

Re: AJAX marking block beta for 1.8.2

Gary Newport - 2011年10月11日星期二 04:46

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

平均分： -

Re: AJAX marking block beta for 1.8.2

Gary Newport - 2011年10月11日星期二 04:59

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)

平均分： -

Re: AJAX marking block beta for 1.8.2

Gary Newport - 2011年10月14日星期五 04:53

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!

平均分： -

Re: AJAX marking block beta for 1.8.2

Gary Newport - 2011年10月14日星期五 05:25

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()

平均分： -

Re: AJAX marking block beta for 1.8.2

Matt Gibson - 2011年10月14日星期五 17:16

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.

平均分： -

Re: AJAX marking block beta for 1.8.2

Allan Kealey - 2011年10月14日星期五 18:53

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

平均分： -

Re: AJAX marking block beta for 1.8.2

Matt Gibson - 2011年10月14日星期五 19:54

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?

平均分： -

Re: AJAX marking block beta for 1.8.2

Matt Gibson - 2011年10月14日星期五 20:00

I was right: MDL-29564

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

平均分： -

Re: AJAX marking block beta for 1.8.2

Matt Gibson - 2011年10月14日星期五 20:09

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

平均分： -

Re: AJAX marking block beta for 1.8.2

Allan Kealey - 2011年10月14日星期五 20:42

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

平均分： -

Re: AJAX marking block beta for 1.8.2

Matt Gibson - 2011年10月15日星期六 04:12

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?

平均分： -

Re: AJAX marking block beta for 1.8.2

Allan Kealey - 2011年10月16日星期日 17:01

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.

平均分： -

Re: AJAX marking block beta for 1.8.2

Matt Gibson - 2011年10月18日星期二 19:50

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

平均分： -