- Posts: 4
Problem upgrade Moodle 2.0 to 2.4 Joomla 1.5
- Ian
- Topic Author
- Offline
- New Member
-
Less
More
13 years 3 months ago #1
by Ian
Problem upgrade Moodle 2.0 to 2.4 Joomla 1.5 was created 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
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.
- Antonio Durán
-
- Offline
- Moderator
-
Less
More
- Posts: 7909
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.
- Ian
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 4
13 years 3 months ago #3
by Ian
Replied by Ian on topic Problem upgrade Moodle 2.0 to 2.4 Joomla 1.5
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.
- Antonio Durán
-
- Offline
- Moderator
-
Less
More
- Posts: 7909
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.
- Ian
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 4
13 years 3 months ago - 13 years 3 months ago #5
by Ian
Replied by Ian on topic Problem upgrade Moodle 2.0 to 2.4 Joomla 1.5
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?
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.
- Antonio Durán
-
- Offline
- Moderator
-
Less
More
- Posts: 7909
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.
$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.