1
Discussion & Troubleshooting / DB Error: Bad SQL Query: INSERT INTO 4images_wordmatch ... Duplicate entry ...
« on: March 10, 2007, 03:05:09 PM »
Hello, I get this error on the page that shows the jpg right after it was uploaded:
DB Error: Bad SQL Query: INSERT INTO 4images_wordmatch (image_id, word_id, name_match, desc_match, keys_match) SELECT DISTINCT 77, word_id, 0, 1, 0 FROM 4images_wordlist WHERE word_text = 'murcielago'
Duplicate entry '77-178' for key 1
Edit: it seems to be happening if i have 2 words like this in description:
Murciélago Murcielago
Anyone has an idea?
Thank you.
DB Error: Bad SQL Query: INSERT INTO 4images_wordmatch (image_id, word_id, name_match, desc_match, keys_match) SELECT DISTINCT 77, word_id, 0, 1, 0 FROM 4images_wordlist WHERE word_text = 'murcielago'
Duplicate entry '77-178' for key 1
Edit: it seems to be happening if i have 2 words like this in description:
Murciélago Murcielago
Anyone has an idea?
Thank you.