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
రేటింగుల సగటు: -
In reply to Kevin Hickey

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

by Marina Glancy -
Core developers బొమ్మ Moodle HQ బొమ్మ Moodle Workplace team బొమ్మ Peer reviewers బొమ్మ Plugin developers బొమ్మ 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.