Problem upgrade Moodle 2.0 to 2.4 Joomla 1.5

More
13 years 3 months ago #1 by Ian
I had Joomdle working perfectly wi J1.5 and M2.0 - upgrade to 2.4 and installed the latest J1.5 components and modules.

The interconection is working as I can display course in Joomla - see able.edu.au

The problem comes when I click on a course - I get this

XML-RPC Error (95042507): Error reading from database | DEBUG INFO: Unknown column 'co.numsections' in 'field list' SELECT co.id AS remoteid, ca.id AS cat_id, ca.name AS cat_name, ca.description AS cat_description, co.sortorder, co.fullname, co.shortname, co.idnumber, co.summary, co.startdate, co.numsections, co.lang FROM mdl_course_categories ca JOIN mdl_course co ON ca.id = co.category WHERE co.id = ? ORDER BY sortorder ASC [array ( 0 => 22, )] | ERRORCODE: dmlreadexception

Please Log in or Create an account to join the conversation.

More
13 years 3 months ago #2 by Antonio Durán
Replied by Antonio Durán on topic Problem upgrade Moodle 2.0 to 2.4 Joomla 1.5
What Joomdle version are you running?

Please Log in or Create an account to join the conversation.

More
13 years 3 months ago #3 by Ian
Sorry - didn't put that in as I posted on R09 support section - so it's R09 I installed

Please Log in or Create an account to join the conversation.

More
13 years 3 months ago #4 by Antonio Durán
Replied by Antonio Durán on topic Problem upgrade Moodle 2.0 to 2.4 Joomla 1.5
It seems they removed that field (numsections) in the last release. You can search "numsections" in auth.php and remove it form the query, but you will need to add that field in the returned data, or it will give another error (unless you modify web service definition)

Please Log in or Create an account to join the conversation.

More
13 years 3 months ago - 13 years 3 months ago #5 by Ian
Thanks - removed co.numsections and as you say the error is now different

XML-RPC Error (28260048): Invalid response value detected | DEBUG INFO: Error in response - Missing following required key in a single structure: numsections | ERRORCODE: invalidresponse

Any suggestions how I add numsections to the return data?
Last edit: 13 years 3 months ago by Ian.

Please Log in or Create an account to join the conversation.

More
13 years 3 months ago #6 by Antonio Durán
Replied by Antonio Durán on topic Problem upgrade Moodle 2.0 to 2.4 Joomla 1.5
yes, you need to add:
$course_info = 0;

but of course, you won't be able to have the right number of sections showing in Joomdle.

I will try t fix this for next release, but it will take a while as my schedule is tight right now.

Please Log in or Create an account to join the conversation.