404 Error on Menu Item (Categories) [Closed]

  • Adrian H
  • Topic Author
  • Offline
  • New Member
  • New Member
More
11 years 9 months ago - 11 years 9 months ago #1 by Adrian H
Hi,

I am experiencing an issue with a menu item type in Joomla for the Joomdle component. The Item type is a course categories type menu item.

After creating the menu item, then selecting the item from the Joomla homepage >> clicking on the course type >> then clicking on course name I receive a 404 XMLRPC error on the following page.

The link is calling the URL http://joomla2.****.com/joomla3/index.php/joomdle-test/detail/1-miscellaneous/3-course2

Could this be some issue with the XMLRPC plugin. or some issue with the Joomdle menu item? Or maybe some issue with Joomla?

I am Running Joomla 3.3.3
JMoodle 0.9
Last edit: 11 years 9 months ago by Chris.

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

More
11 years 9 months ago #2 by Antonio Durán
Replied by Antonio Durán on topic 404 Error on Menu Item (Categories)
Hi.

I don't know why you are getting that error, but you can enable debugging in moodle to get more info about it.

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

  • Adrian H
  • Topic Author
  • Offline
  • New Member
  • New Member
More
11 years 9 months ago - 11 years 9 months ago #3 by Adrian H
Replied by Adrian H on topic 404 Error on Menu Item (Categories)
Hi, Thanks for your reply. I've enabled debugging. The error is DB related. The link is attempting to pull column name co.numsections from mdl_course in the default moodle database, which does not exist.


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 => 3, )] | ERRORCODE: dmlreadexception




Code:
mysql> use moodle; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> select numsections from mdl_course; ERROR 1054 (42S22): Unknown column 'numsections' in 'field list' mysql>


Ive not made any changes to the moodle database from the default so I am unsure if this is a bug, or is due to some error my side.
Last edit: 11 years 9 months ago by Adrian H.

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

More
11 years 9 months ago #4 by Antonio Durán
Replied by Antonio Durán on topic 404 Error on Menu Item (Categories)
If you are really using R0.9, you should upgrade to current release, that should solve the problem.

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

  • Adrian H
  • Topic Author
  • Offline
  • New Member
  • New Member
More
11 years 9 months ago - 11 years 9 months ago #5 by Adrian H
Replied by Adrian H on topic 404 Error on Menu Item (Categories)
Hi, sorry my mistake I am running Joomdle 0.95. If you can provide a format file for that table for me to import that should solve the issue. Thanks
Last edit: 11 years 9 months ago by Adrian H.

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

More
11 years 9 months ago #6 by Antonio Durán
Replied by Antonio Durán on topic 404 Error on Menu Item (Categories)
Are you running R0.95 in Moodle side too? That code does not seem to be from R0.95.

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

  • Adrian H
  • Topic Author
  • Offline
  • New Member
  • New Member
More
11 years 9 months ago #7 by Adrian H
Replied by Adrian H on topic 404 Error on Menu Item (Categories)
No I am running Moodle 2.6.4. Is that a problem?

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

More
11 years 9 months ago #8 by Antonio Durán
Replied by Antonio Durán on topic 404 Error on Menu Item (Categories)
I meant Joomdle R0.95 in moodle side. Maybe you upgraded only joomla side?

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

  • Adrian H
  • Topic Author
  • Offline
  • New Member
  • New Member
More
11 years 9 months ago - 11 years 9 months ago #9 by Adrian H
Replied by Adrian H on topic 404 Error on Menu Item (Categories)
Hi,

This appears to have been the case. I could see the files were dated Feb 2012 in the moodle/auth folder. So I deleted everything from that folder and copied over 0.95. This error does not occur anymore. Thanks!
Last edit: 11 years 9 months ago by Adrian H.

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