[TYPO3-Solr] devlog errors when initializing index queue for pages
raka
raka86 at gmx.de
Thu Jul 26 13:03:45 CEST 2012
hi,
i get the following erros in devlog with the new version 2.2.1 when
initializing the index queue for pages:
Index Queue initialized for indexing configuration pages
class.tx_solr_indexqueue_initializer_abstract.php, line 167
site: Home, Root Page ID: 1
indexing configuration name: pages
type: pages
query: INSERT INTO tx_solr_indexqueue_item (root, item_type,
item_uid, indexing_configuration, changed, has_indexing_properties)
SELECT '1' as root, 'pages' AS item_type, uid AS item_uid, 'pages' as
indexing_configuration, 0 AS indexing_priority, tstamp AS changed, 1
FROM pages WHERE uid IN(29435,25408) AND deleted = 0 AND hidden = 0 AND
starttime < 1343299692 AND (endtime > 1343299692 OR endtime = 0) AND pid
!= -1 AND uid=32411 AND doktype = 1 AND no_search = 0
rows: -1
error: 1136: Column count doesn't match value count at row 1
I think it's the missing new field "indexing_priority" in the
insert-into-clause.
Probably adding this field in row 189 in
"/classes/indexqueue/initializer/class.tx_solr_indexqueue_initializer_page.php"
in function "addMountedPagesToIndexQueue" will fix this?
BEFORE: $initializationQuery = 'INSERT INTO tx_solr_indexqueue_item
(root, item_type, item_uid, indexing_configuration, changed,
has_indexing_properties) '
AFTER: $initializationQuery = 'INSERT INTO tx_solr_indexqueue_item
(root, item_type, item_uid, indexing_configuration, indexing_priority,
changed, has_indexing_properties) '
raka
More information about the TYPO3-project-solr
mailing list