Author Topic: DB Error: Bad SQL Query: INSERT INTO 4images_wordmatch (image_id, word_id, name_  (Read 5541 times)

0 Members and 1 Guest are viewing this topic.

Offline namasy

  • Newbie
  • *
  • Posts: 15
    • View Profile
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
« Last Edit: January 31, 2010, 01:37:51 PM by namasy »

Offline tramfahrer

  • Full Member
  • ***
  • Posts: 112
    • View Profile
    • Straßenbahn-, Bus- und Eisenbahnbilder
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 ...

Offline mawenzi

  • 4images Moderator
  • 4images Guru
  • *****
  • Posts: 4.500
    • View Profile
Your first three "must do" before you ask a question ! ( © by V@no )
- please read the Forum Rules ...
- please study the FAQ ...
- please try to Search for your answer ...

You are on search for top 4images MOD's ?
- then please search here ... Mawenzi's Top 100+ MOD List (unsorted sorted) ...