Error Reading from Database (View User Profiles & Adding New Users)

Error Reading from Database (View User Profiles & Adding New Users)

by Kevin Hickey -
Number of replies: 1

Hello,

I'm currently getting "Error Reading From Database" when either trying to view/edit existing user profiles or when trying to add new users.

Error when trying to Add a New User:

Error reading from database

More information about this error

Debug info: Unknown column 'tg.tagtype' in 'field list'
SELECT ti.id AS taginstanceid, tg.id, tg.tagtype, tg.name, tg.rawname, tg.flag, ti.ordering
FROM mdl_tag_instance ti
JOIN mdl_tag tg ON tg.id = ti.tagid
WHERE ti.itemtype = ? AND ti.itemid = ? 
ORDER BY ti.ordering ASC
[array (
0 => 'user',
1 => -1,
)]
Error code: dmlreadexception
Stack trace:
  • line 443 of /lib/dml/moodle_database.php: dml_read_exception thrown
  • line 1080 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
  • line 372 of /tag/lib.php: call to mysqli_native_moodle_database->get_records_sql()
  • line 396 of /tag/lib.php: call to tag_get_tags()
  • line 121 of /user/editadvanced.php: call to tag_get_tags_array()
Error when trying to view/edit user profile:

Error reading from database

More information about this error

Debug info: Unknown column 'tg.tagtype' in 'field list'
SELECT ti.id AS taginstanceid, tg.id, tg.tagtype, tg.name, tg.rawname, tg.flag, ti.ordering
FROM mdl_tag_instance ti
JOIN mdl_tag tg ON tg.id = ti.tagid
WHERE ti.itemtype = ? AND ti.itemid = ? 
ORDER BY ti.ordering ASC
[array (
0 => 'user',
1 => 27,
)]
Error code: dmlreadexception
Stack trace:
  • line 443 of /lib/dml/moodle_database.php: dml_read_exception thrown
  • line 1080 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
  • line 372 of /tag/lib.php: call to mysqli_native_moodle_database->get_records_sql()
  • line 396 of /tag/lib.php: call to tag_get_tags()
  • line 121 of /user/editadvanced.php: call to tag_get_tags_array()
Any tips? Thanks!

-Kevin

Attachment Screen Shot 2016-09-13 at 9.23.26 AM.png
Average of ratings: -
In reply to Kevin Hickey

Re: Error Reading from Database (View User Profiles & Adding New Users)

by Marina Glancy -
Picture of Core developers Picture of Moodle HQ Picture of Moodle Workplace team Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers Picture of Testers

Hello Kevin,

field tag.tagtype was dropped in Moodle 3.1 .  Functions tag_get_tags_array() and tag_get_tags() were deprecated at the same time and they should not be present in user/editadvanced.php or tag/lib.php.
Please make sure that your sourcecode files correspond to the database version you are using.