Return to Answer

Adjusted formatting in error mesage

Source Link

edited Jan 28, 2019 at 13:54

4.8k
4
18
48

I was getting a very similar error...

Duplicate entry '14-6' for key 'PRIMARY'Duplicate entry '14-6' for key 'PRIMARY'

SQL=INSERT INTO #__finder_links_terms4`#__finder_links_terms4` (link_id`link_id`, term_id`term_id`, weight`weight`) SELECT 14, term_id`term_id`, ROUND(SUM(context_weight`context_weight`), 8) FROM #__finder_tokens_aggregate`#__finder_tokens_aggregate` WHERE map_suffix`map_suffix` = '4' GROUP BY term`term` ORDER BY term`term` DESC

...and solved this by clicking the 'Clear Index' button at the top. After that I was able to index my files.

I was getting a very similar error...

Duplicate entry '14-6' for key 'PRIMARY' SQL=INSERT INTO #__finder_links_terms4 (link_id, term_id, weight) SELECT 14, term_id, ROUND(SUM(context_weight), 8) FROM #__finder_tokens_aggregate WHERE map_suffix = '4' GROUP BY term ORDER BY term DESC

...and solved this by clicking the 'Clear Index' button at the top. After that I was able to index my files.

I was getting a very similar error...

Duplicate entry '14-6' for key 'PRIMARY'

SQL=INSERT INTO `#__finder_links_terms4` (`link_id`, `term_id`, `weight`) SELECT 14, `term_id`, ROUND(SUM(`context_weight`), 8) FROM `#__finder_tokens_aggregate` WHERE `map_suffix` = '4' GROUP BY `term` ORDER BY `term` DESC

...and solved this by clicking the 'Clear Index' button at the top. After that I was able to index my files.

Source Link

created May 16, 2016 at 9:06

flickeringpixel

I was getting a very similar error...

Duplicate entry '14-6' for key 'PRIMARY' SQL=INSERT INTO #__finder_links_terms4 (link_id, term_id, weight) SELECT 14, term_id, ROUND(SUM(context_weight), 8) FROM #__finder_tokens_aggregate WHERE map_suffix = '4' GROUP BY term ORDER BY term DESC

...and solved this by clicking the 'Clear Index' button at the top. After that I was able to index my files.