4images Forum & Community
4images Issues / Ausgaben => Installation, Update & Configuration => Topic started by: namasy on January 31, 2010, 01:42:06 AM
-
Receive an error while adding the image
DB Error: Bad SQL Query: INSERT INTO 4images_wordmatch (image_id, word_id, name_match, desc_match, keys_match) SELECT DISTINCT 17, word_id, 0, 1, 0 FROM 4images_wordlist WHERE word_text = '?ae'
Duplicate entry '17-17' for key 1
But the image is added successfully
Search for a solution to the problem or hide the error
my charset = windows-1256
my lang = arabic
-
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.0
after 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 ...
-
@ tramfahrer
und hier : http://www.4homepages.de/forum/index.php?topic=28267.0