Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save orakili/e92638bf5849f377ec38a6633b357842 to your computer and use it in GitHub Desktop.
Save orakili/e92638bf5849f377ec38a6633b357842 to your computer and use it in GitHub Desktop.
Avoid term name and user name to overlap in taxonomy_revision_list query.
diff --git a/taxonomy_revision.module b/taxonomy_revision.module
index ea72297..a9ba3f8 100644
--- a/taxonomy_revision.module
+++ b/taxonomy_revision.module
@@ -132,7 +132,7 @@ function taxonomy_revision_theme() {
function taxonomy_revision_list($term) {
$revisions = array();
- $result = db_query('SELECT r.revision_id, r.name, r.log, r.uid, t.revision_id AS current_revision_id, r.timestamp, u.name FROM {taxonomy_term_data_revision} r LEFT JOIN {taxonomy_term_data} t ON t.revision_id = r.revision_id INNER JOIN {users} u ON u.uid = r.uid WHERE r.tid = :tid ORDER BY r.revision_id DESC', array(':tid' => $term->tid));
+ $result = db_query('SELECT r.revision_id, r.name, r.log, r.uid, t.revision_id AS current_revision_id, r.timestamp, u.name AS user_name FROM {taxonomy_term_data_revision} r LEFT JOIN {taxonomy_term_data} t ON t.revision_id = r.revision_id INNER JOIN {users} u ON u.uid = r.uid WHERE r.tid = :tid ORDER BY r.revision_id DESC', array(':tid' => $term->tid));
foreach ($result as $revision) {
$revisions[$revision->revision_id] = $revision;
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment