XML-RPC Error (95042507) message on clicking My Courses link
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
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.
Please Log in or Create an account to join the conversation.
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>=3.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.
Please Log in or Create an account to join the conversation.
Can you please assist with this?
Thanks
Please Log in or Create an account to join the conversation.
- 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
Please Log in or Create an account to join the conversation.
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.
Please Log in or Create an account to join the conversation.
Please Log in or Create an account to join the conversation.
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
Please Log in or Create an account to join the conversation.
Please Log in or Create an account to join the conversation.