I have been using Moodle 2.0 since RC1 and have been using a glossary for a couple of weeks. I've just upgraded and I get this error message when trying to add a new item.
Any ideas?
Looks like someone has used some SQL that does not work in all the different databases that Moodle supports.
Please file a bug at http://tracker.moodle.org/. Please say which database your Moodle site is using, and copy-and-paste the error message into the bug.
If possible, turn Debugging to DEVELOPER level, and copy and paste any extra information that generates into the bug report too.
I've the same error, shown below with developer level debug. I'm using Moodle 2.0 (20101130) on LAMP (Mysql 5.1.53). Sorry, I've been unable to access tracker.moodle.org to check if the bug had been filed.
---------
Field "LOWER(concept)" does not exist in table "glossary_entries"
Stack trace:
- line 508 of /lib/dml/moodle_database.php: dml_exception thrown
- line 1207 of /lib/dml/moodle_database.php: call to moodle_database->where_clause()
- line 124 of /mod/glossary/edit_form.php: call to moodle_database->get_record()
- line 438 of /lib/formslib.php: call to mod_glossary_entry_form->validation()
- line 397 of /lib/formslib.php: call to moodleform->validate_defined_fields()
- line 484 of /lib/formslib.php: call to moodleform->is_validated()
- line 88 of /mod/glossary/edit.php: call to moodleform->get_data()
This bug has been reported as MDL-25418. It's a real blocker, hope it will be fixed ASAP.
Joseph
EDIT.-
One reason why this bug has escaped QA tests in moodle 2.0 is that it only occurs if a glossary has been set to Duplicate entries allowed: No
Since this is default-set to Yes, no-one detected the bug. Pending bug fix in Moodle 2.0 you can continue to use your glossaries by setting Duplicate entries allowed to YES.
