[TYPO3-Solr] Custom Index on tt_content is not refreshe automatically
Holger
hbirkner at gv-bayern.de
Mon Sep 23 12:50:13 CEST 2013
Hallo everybody,
we have Typo3 6.1.4, solr extension 2.8.2
we have a custom index on tt_content using sys_categories.
Indexing works fine, when
1 ) clicking in module Search on Empty Site Index,
2 ) initialize queue and finally
3 ) clicking on index Queue worker.
But when I just use the scheduler tasks no changes, no new articles and deletion of articles causes new indexing of the content, the progress bar of the index Queue worker always stays on 100%.
I am missing something? Do I have to add special date fields to the index?
How can I find out where something goes wrong any hints on where to look? which logfiles
We have the following index definition:
plugin.tx_solr.index {
# für alle indizes
# typo3 hat timestamp --> solr isodate
fieldProcessingInstructions {
changed = timestampToIsoDate
created = timestampToIsoDate
endtime = timestampToIsoDate
sortDate_dateS = timestampToIsoDate
}
# definition der warteschlangen zuerst allgemein beitrag
queue {
# queue mit namen beitrag
# queue beitrag aktivieren (sonst erscheint sie gar nicht)
artikel = 1
artikel {
# tabelle definieren, die die inhalte enthält
table = tt_content
fields {
##################
# Überschrift
##################
title = header
##################
# Text
##################
content = SOLR_CONTENT
content {
field = bodytext
}
##################
# Datum (Sortierung)
##################
sortDate_dateS = sort_date
##################
# Kategorien
##################
cat_stringM = SOLR_MULTIVALUE
cat_stringM {
cObject = CONTENT
cObject {
table = tt_content
select {
#recursive = 30
uidInList.field = uid
pidInList = 0
selectFields = sys_category.*
join = sys_category_record_mm ON tt_content.uid = sys_category_record_mm.uid_foreign JOIN sys_category ON sys_category.uid = sys_category_record_mm.uid_local
andWhere = ((sys_category_record_mm.tablenames = 'tt_content' AND NOT tt_content.fe_group="") OR (sys_category_record_mm.tablenames = 'tt_content' AND tt_content.fe_group=""))
andWhere = tt_content.deleted = 0
andWhere = sys_category.pid = 510
}
renderObj = COA
renderObj {
10 = TEXT
10.field = title
10.wrap = |,
}
}
separator = ,
removeEmptyValues = 1
}
##################
# Beitragstyp
##################
typeString_stringS = TEXT
typeString_stringS.value = Artikel
###################
url = TEXT
url {
typolink.parameter = {$plugin.tx_article.artikelAnsichtPID}
typolink.additionalParams.insertData = 1
typolink.returnLast = url
typolink.useCacheHash = 0
}
}
# zusaetzliche Einschränkung, contenttypen indiziert werden sollen
# wahrscheinlich wird text rausfallen
additionalWhereClause = ctype IN('article')
}
}
Thank you very much
More information about the TYPO3-project-solr
mailing list