Forum LAMS for Tech-Heads - General Forum: Re: Re: Re: Moodle tool adapter, error editing activity

By: Dave Bauer

[ Reply | Forward ]

Curiously the tool_content_id in question does exist:

mysql> select * from lams_tool_content where tool_content_id = 2547;
+-----------------+---------+
| tool_content_id | tool_id |
+-----------------+---------+
| 2547 | 23 |
+-----------------+---------+
1 row in set (0.00 sec)


Not sure where to go from there.

Posted by Dave Bauer

By: Dave Bauer

[ Reply | Forward ]

I turned on SQL debugging in hibernate. No query is ever executed to get the object when I click so it looks like somewhere its caching a bogus object.

I found this SQL where it creates the moodle assignment tool

16:29:19,036 [http-0.0.0.0-80-2] DEBUG org.hibernate.SQL - update tl_mdasgm10_md
lassignment set create_date=?, update_date=?, define_later=?, content_in_use=?,
run_offline=?, tool_content_id=?, ext_tool_content_id=?, ext_user_name=?, ext_co
urse_id=?, ext_section=?, ext_lms_id=? where uid=?
16:29:19,036 [http-0.0.0.0-80-2] DEBUG org.hibernate.jdbc.AbstractBatcher - prep
aring statement
16:29:19,036 [http-0.0.0.0-80-2] DEBUG org.hibernate.persister.entity.BasicEntit
yPersister - Dehydrating entity: [org.lamsfoundation.lams.tool.mdasgm.model.MdlA
ssignment#8]
16:29:19,036 [http-0.0.0.0-80-2] DEBUG org.hibernate.type.TimestampType - bindin
g '2009-07-08 16:29:19' to parameter: 1
16:29:19,036 [http-0.0.0.0-80-2] DEBUG org.hibernate.type.TimestampType - bindin
g null to parameter: 2
16:29:19,036 [http-0.0.0.0-80-2] DEBUG org.hibernate.type.BooleanType - binding
'false' to parameter: 3
16:29:19,036 [http-0.0.0.0-80-2] DEBUG org.hibernate.type.BooleanType - binding
'false' to parameter: 4
16:29:19,036 [http-0.0.0.0-80-2] DEBUG org.hibernate.type.BooleanType - binding
'false' to parameter: 5
16:29:19,036 [http-0.0.0.0-80-2] DEBUG org.hibernate.type.LongType - binding '25
56' to parameter: 6

and its setting the tool_content_id when it inserts the tool.

More from hibernate log

16:29:19,034 [http-0.0.0.0-80-2] DEBUG org.hibernate.pretty.Printer - org.lamsfo
undation.lams.tool.mdasgm.model.MdlAssignment{uid=8, extToolContentId=null, cont
entInUse=false, toolContentId=2556, extUsername=sgadmin, updateDate=null, runOff
line=false, extLmsId=moodle, extCourseId=7, mdlAssignmentSessions=[], extSection
=68, defineLater=false, createDate=2009-07-08 16:29:19}

Posted by Dave Bauer

By: Dave Bauer

[ Reply | Forward ]

I deployed the assignment tool from CVS just in case it was different, but the same results.

Posted by Dave Bauer

By: Dave Bauer

[ Reply | Forward ]

Went into the source, I couldn't see anything that would cause this to fail in this particular way unless there is some sort of caching that is going on.

Posted by Dave Bauer

By: Luke Foxton

[ Reply | Forward ]

Hi Dave,

At which point is this failing, when you attempt to get to the author screen? And which of the tool adapters is it that you are testing?

If its failing in lams, there should be some sort of exception being thrown in the lams.log, can you see anything there.

Also, if you have debug logging on, when the call is made to the external moodle server, it should be printed there like this example for the moodle choice tool:

lams.log.5:2009-05-19 20:49:10,102 [TP-Processor1:] DEBUG org.lamsfoundation.lams.web.action.LamsDispatchAction - Sending to moodle choice edit page: http://moodle.lamscommunity.org/moodle/course/lamsframes.php?lamsUpdateURL=http%253A%252F%252Fintegrations.lamscommunity.org%252Flams%252F%252Ftool%252Fmdchce10%252F%252Fauthoring.do%253Fdispatch%253DupdateContent%2526toolContentID%253D126295&dest=course%2Fmodedit-lams.php§ion=2&add=choice&course=2


Is it getting to this point? Please attach your lams.log after attempting to get to author and i'll see if that tells me anything.

Luke

Posted by Luke Foxton

By: Dave Bauer

[ Reply | Forward ]

Hi.

Opening author works fine.
Then I drag a moodle tool into the workspace, say Moodle Assignment. That works ok.

Then I double click on the tool to edit the content for that tool. It opens a new window and I get the 404 error message. I am getting the 404 error message because the URL its going to is

nullcourse/lamsframes.php?lamsUpdateURL=http%253A%252F%252Flamsdev.solutiongrove
.com%252Flams%252F%252Ftool%252Fmdchce10%252F%252Fauthoring.do%253Fdispatch%253D
updateContent%2526toolContentID%253D2538&dest=course%2Fmodedit-lams.php§ion=
68&add=choice&course=7

null is there instead of the moodle server URL.

This is caused I assume when it tried to get the tool_content_id but it can't.
I'll attach the relevant lams.log.

Posted by Dave Bauer

By: Luke Foxton

[ Reply | Forward ]

Aha!

I think I know the problem now, sorry I should have noticed before.

Since 2.3.1 there is a new field in the "Maintain Integrated Servers" area. When you click on your integrated server, there should be a new field simply asking for the external server url.... (See picture)

Has this been set?

As I said, we will be putting together a proper setup guide for the tool adapters soon, unfortunately for you, we're still ironing out the process, sorry about the difficulties so far.

Luke

Posted by Luke Foxton

By: Dave Bauer

[ Reply | Forward ]

Aha :)

No I recall noticing it was blank before, but I thought it was always that way. I set it.

Progress! Now i get /mod/assignment/assignment_types.php missing error. I'll see why I don't have that file.

Posted by Dave Bauer

By: Dave Bauer

[ Reply | Forward ]

Aha, missing files from merge. I'll have to go through all the mods and find those. I think I got them all, then I get


Fatal error: Cannot delete class mod_assignment_upload_notes_form in /opt/coolstack/apache2/htdocs/MEL/mod/assignment/view.php on line 48

After trying to create the assignment.

Posted by Dave Bauer