Created
September 17, 2016 08:28
-
-
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.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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