XML-RPC Error (95042507) message on clicking My Courses link

Hi,
I'm having problems since updating Joomla.

• Joomdle system check shows all green
• Joomdle version 1.0.5
• Joomla version now 3.8.13
• Moodle version 3.0.2
• PHP version 5.6.16

Enabled Moodle debugging. Got this:
Full error message:

XML-RPC Error (95042507): Error reading from database | DEBUG INFO: Unknown column 'co.enddate' 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.enddate, co.lang FROM mdlax_course_categories ca JOIN mdlax_course co ON ca.id = co.category WHERE co.id = ? ORDER BY sortorder ASC [array ( 0 => 350, )] | ERRORCODE: dmlreadexception

Worked until latest Joomla update to 3.8.13. Now clicking on listed courses breaks links and produces above error message in Joomla.

Please help.

Hi.
I don't think upgrading Joomla can be responsible for this error, as it is Moodle-related.
Maybe you also updated Joomdle? That code is not present in Joomdle 1.0.5.
If you have updated Joomdle, you will need to upgrade Moodle, as current Joomdle version needs Moodle>.2.
If you cannot upgrade Moodle, you could do a simple mod to Joomdle code to remove the use of the new enddate field. If you want to do it, tell me and I will give instructions.

Thanks. I'll probably need to do the Joomdle code mod then, as I can't update Moodle at this point.
Can you please assist with this?

Thanks

Sure, just do this:

- Remove this line:
co.enddate,
In moodle/auth/joomdle/auth.php, function get_course_info

-Remove this line :
'enddate' => new external_value(PARAM_INT, 'end date'),
from moodle/auth/joomdle/helpers/externallib.php, get_course_info_returns function

Working now, thanks.
Is there anything else I should be aware of regarding Joomdle 1.0.5 and Moodle 3.02, or will everything else still work ok?

Thanks for the assistance.

Great. I don't know of anything else... if you notice something strange, you can ask us.

Hi,

I have installed
Joomla = 3.9.2,
Moodle = 3.1.5
Joomdle Core = 1.2.1

I got the same error (XML-RPC Error (95042507): Error reading from database | DEBUG INFO: Unknown column 'co.enddate' 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.enddate, 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 => 4, )] | ERRORCODE: dmlreadexception)

my problem has been resolved after updating those files as you mention above.

Thanks

Great, thanks for the feedback.