hallo, scheint ein doppelter eintrag zu sein.
installiere dies unter plugin und lösche vorher die tabellen
du siehst dann die option im plugin
http://www.4homepages.de/forum/index.php?topic=6718.0
gruss ivan
Hallo Ivan,
danke für deine Rückmeldung, - ich habe dieses Plugin bereits installiert - Tabellen geleert
und neu erstellen lassen.
Bei Neuindexierung werden wieder Probleme festgestellt, wie z.B.
DB Error: Bad SQL Query: INSERT INTO 4images_wordmatch (image_id, word_id, name_match, desc_match, keys_match) SELECT DISTINCT 2162, word_id, 0, 1, 0 FROM 4images_wordlist WHERE word_text = 'léon'
DB Error: Bad SQL Query: INSERT INTO 4images_wordmatch (image_id, word_id, name_match, desc_match, keys_match) SELECT DISTINCT 2911, word_id, 0, 1, 0 FROM 4images_wordlist WHERE word_text = 'françine'
DB Error: Bad SQL Query: INSERT INTO 4images_wordmatch (image_id, word_id, name_match, desc_match, keys_match) SELECT DISTINCT 8595, word_id, 0, 0, 1 FROM 4images_wordlist WHERE word_text = 'ärzte'
Duplicate entry '8595-27973' for key 1
OK
Processing image alive 2005 059, ID 8596 ...
DB Error: Bad SQL Query: INSERT INTO 4images_wordmatch (image_id, word_id, name_match, desc_match, keys_match) SELECT DISTINCT 8596, word_id, 0, 0, 1 FROM 4images_wordlist WHERE word_text = 'ärzte'
Duplicate entry '8596-27973' for key 1
OK
Processing image alive 2005 062, ID 8599 ...
DB Error: Bad SQL Query: INSERT INTO 4images_wordmatch (image_id, word_id, name_match, desc_match, keys_match) SELECT DISTINCT 8599, word_id, 0, 0, 1 FROM 4images_wordlist WHERE word_text = 'ärzte'
Duplicate entry '8599-27973' for key 1
OK
Processing image alive 2005 063, ID 8600 ...
DB Error: Bad SQL Query: INSERT INTO 4images_wordmatch (image_id, word_id, name_match, desc_match, keys_match) SELECT DISTINCT 8600, word_id, 0, 0, 1 FROM 4images_wordlist WHERE word_text = 'ärzte'
Duplicate entry '8600-27973' for key 1
OK
Processing image alive 2005 064, ID 8601 ...
DB Error: Bad SQL Query: INSERT INTO 4images_wordmatch (image_id, word_id, name_match, desc_match, keys_match) SELECT DISTINCT 8601, word_id, 0, 0, 1 FROM 4images_wordlist WHERE word_text = 'ärzte'
Duplicate entry '8601-27973' for key 1
OK
Processing image alive 2005 065, ID 8602 ...
DB Error: Bad SQL Query: INSERT INTO 4images_wordmatch (image_id, word_id, name_match, desc_match, keys_match) SELECT DISTINCT 8602, word_id, 0, 0, 1 FROM 4images_wordlist WHERE word_text = 'ärzte'
Ich frage mich, ob dieses Problem nichts zu tun hat mit Umlauten, Akzenten u.Ä.
Eine andere Erklärung sehe ich nicht, allerdings auch noch keine Lösung
