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

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

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

附件 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)

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.