Moodle

grouping creation dml

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Minor Minor
  • Resolution: Fixed
  • Affects Version/s: 2.0
  • Fix Version/s: 2.0
  • Component/s: Groups
  • Labels:
    None
  • Environment:
    suse 11.1 apache 2 mysql 5.0.67 php 5.2.8
  • Database:
    MySQL
  • URL:
    /group/grouping.php
  • Affected Branches:
    MOODLE_20_STABLE
  • Fixed Branches:
    MOODLE_20_STABLE

Description

Cannot create groupings. Throws a dml_read_exception .

Unknown column 'Array' in 'where clause'

SELECT * FROM mdl_groupings WHERE Array
[array ( )]

  • line 305 of lib\dml\moodle_database.php: dml_read_exception thrown
  • line 558 of lib\dml\mysqli_native_moodle_database.php: call to moodle_database->query_end()
  • line 913 of lib\dml\moodle_database.php: call to mysqli_native_moodle_database->get_records_sql()
  • line 74 of lib\grouplib.php: call to moodle_database->get_records_select()
  • line 45 of group\grouping_form.php: call to groups_get_grouping_by_name()
  • line 358 of lib\formslib.php: call to grouping_form->validation()
  • line 404 of lib\formslib.php: call to moodleform->is_validated()
  • line 77 of group\grouping.php: call to moodleform->get_data()

Activity

Hide
Petr Škoda (skodak) added a comment -

fixed in cvs, thanks!

Show
Petr Škoda (skodak) added a comment - fixed in cvs, thanks!
Hide
mert gokkaya added a comment -

great! we also had problems after group assignment. We made changes at assign.php too, did you get an error message on the assignment too? around line 48, my colleague added a select on that record. It seemed to fix that one too but not sure if it fits in

Show
mert gokkaya added a comment - great! we also had problems after group assignment. We made changes at assign.php too, did you get an error message on the assignment too? around line 48, my colleague added a select on that record. It seemed to fix that one too but not sure if it fits in
Hide
mert gokkaya added a comment -

If you replace line 48 at /group/assign.php with if ($groups = $DB->get_records_select('groups', 'courseid', array($courseid=>'name'))) { (_select statement is added after get_records) the error goes away. But this time on the group assignment part, multiple groups display. ( It works fine but it displays multiple groups)

Show
mert gokkaya added a comment - If you replace line 48 at /group/assign.php with if ($groups = $DB->get_records_select('groups', 'courseid', array($courseid=>'name'))) { (_select statement is added after get_records) the error goes away. But this time on the group assignment part, multiple groups display. ( It works fine but it displays multiple groups)
Hide
Petr Škoda (skodak) added a comment -

should be fixed now too, thanks a lot

Show
Petr Škoda (skodak) added a comment - should be fixed now too, thanks a lot

People

Vote (0)
Watch (0)

Dates

  • Created:
    Updated:
    Resolved: