i had the same problem since yesterday ...
DB Error: Bad SQL Query: INSERT INTO 4images_wordmatch (image_id, word_id, name_match, desc_match, keys_match) SELECT DISTINCT 4685, word_id, 0, 0, 1 FROM 4images_wordlist WHERE word_text = 'Dresden'
Duplicate entry '4685-14232' for key 1
Bild erfolgreich hinzugefügt: Dresden 201 009 (29.05.2010_201_009.jpg)
I update from 1.7.8 to 1.7.9 an i would use the Facebooc Mod
http://www.4homepages.de/forum/index.php?topic=27396.0after I see that the facebook mod not really Work (I get an white site or HTTP 500 ), I delete all changes and recover the database which I saved before install the FB database mod ...
Whats now wrong ???
EDIT: I had seen that the mistake happens when in the ImageName the same name is like in Imagedescription was ...
for example:
Img Name: Dresden
ImgDescription: Dresden, picture from City ....
bute the images are shown correctly in the gallery ...
EDIT II i found this Error in ONLY one categorie, if I upload Pictures, in other categories it doesn't happen ...