[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