summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorrandomdan <randomdan@localhost>2010-08-13 01:42:23 +0000
committerrandomdan <randomdan@localhost>2010-08-13 01:42:23 +0000
commitd59662a0ff4b78de82a0eae9a841045e5954909c (patch)
treed789af6934aa01dcdca6f32ffea658d9a9622e86
parentImport and deal with the existance of changelogs (diff)
downloadgentoobrowse-d59662a0ff4b78de82a0eae9a841045e5954909c.tar.bz2
gentoobrowse-d59662a0ff4b78de82a0eae9a841045e5954909c.tar.xz
gentoobrowse-d59662a0ff4b78de82a0eae9a841045e5954909c.zip
Add missing filetypeid filter
-rw-r--r--gentoobrowse/console/packageimport.xml1
1 files changed, 1 insertions, 0 deletions
diff --git a/gentoobrowse/console/packageimport.xml b/gentoobrowse/console/packageimport.xml
index 82ab447..84872ed 100644
--- a/gentoobrowse/console/packageimport.xml
+++ b/gentoobrowse/console/packageimport.xml
@@ -17,6 +17,7 @@
(REGEXP_MATCHES(filename, '^[^/]+'))[1] AS cat,
(REGEXP_MATCHES(filename, '/(.+)-[0-9]'))[1] AS name
FROM files f
+ WHERE f.filetypeid = 1
GROUP BY cat, name) f LEFT OUTER JOIN filecache fc
ON fc.fileid = f.fileid AND fc.line = 8,
categories c