Issue Details (XML | Word | Printable)

Key: MDL-18407
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Minor Minor
Assignee: Petr Skoda (frankenstein)
Reporter: mert gokkaya
Votes: 0
Watchers: 0
Operations

Add/Edit UI Mockup to this issue
If you were logged in you would be able to see more operations.
Moodle

grouping creation dml

Created: 28/Feb/09 08:43 AM   Updated: 02/Mar/09 06:04 AM
Component/s: Groups
Affects Version/s: 2.0
Fix Version/s: 2.0

Environment: suse 11.1 apache 2 mysql 5.0.67 php 5.2.8

Database: MySQL
URL: /group/grouping.php
Participants: mert gokkaya and Petr Skoda (frankenstein)
Security Level: None
Resolved date: 28/Feb/09
Affected Branches: MOODLE_20_STABLE
Fixed Branches: MOODLE_20_STABLE


 Description  « Hide
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()


 All   Comments   Change History   Version Control      Sort Order: Ascending order - Click to sort in descending order
Petr Skoda (frankenstein) added a comment - 28/Feb/09 06:09 PM
fixed in cvs, thanks!

mert gokkaya added a comment - 01/Mar/09 12:20 AM
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

mert gokkaya added a comment - 02/Mar/09 05:27 AM
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)

Petr Skoda (frankenstein) added a comment - 02/Mar/09 06:04 AM
should be fixed now too, thanks a lot