Moodle

List of category courses not working....

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Blocker Blocker
  • Resolution: Duplicate
  • Affects Version/s: 1.7
  • Fix Version/s: 1.7
  • Component/s: General
  • Labels:
    None
  • Environment:
    Under Win 32, but seems to be reproducible everywhere.
  • Affected Branches:
    MOODLE_17_STABLE
  • Fixed Branches:
    MOODLE_17_STABLE

Description

If I click over any category name, I get:

Notice: Undefined property: stdClass::$coursesperpage in C:\cvs_moodle\moodle_head\course\category.php on line 11

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

SELECT c.id,c.sortorder,c.shortname,c.fullname,c.summary,c.visible,c.teacher,c.guest,c.password FROM course c WHERE c.category = '1' ORDER BY c.sortorder ASC LIMIT 0,

Seems that the coursesperpage is undefined so causes an SQL error.

Activity

Hide
Gordon Bateson added a comment -

There is a suggested solution over on MDL-6559
http://tracker.moodle.org/browse/MDL-6559

Show
Gordon Bateson added a comment - There is a suggested solution over on MDL-6559 http://tracker.moodle.org/browse/MDL-6559
Hide
Martin Dougiamas added a comment -

Seems to be the same as MDL-6559

Show
Martin Dougiamas added a comment - Seems to be the same as MDL-6559

People

Dates

  • Created:
    Updated:
    Resolved: