4images Forum & Community

4images Issues / Ausgaben => Discussion & Troubleshooting => Topic started by: aedemirci on November 21, 2005, 01:45:46 PM

Title: DB Error
Post by: aedemirci on November 21, 2005, 01:45:46 PM

Hi All,

I was validating an image submitted by a user. But I faced an error like this :

DB Error: Bad SQL Query: INSERT INTO 4images_wordmatch (image_id, word_id, name_match, desc_match, keys_match) SELECT DISTINCT 25, word_id, 1, 1, 0 FROM 4images_wordlist WHERE word_text = 'Çiçek'
Duplicate entry '25-95' for key 1

But altough I received this error, the image validated. No problem with addind the image but the error message just bothered me. Any solutions to get rid of this error ???  Thx in advance :mrgreen:

P.S. : By the way this is not a language problem as other images with info including same chars was validated smoothly...Is there anything like category and image names cannot include same words ??? Just thinking... If there is something like this, anyway to fix it ? Thanks :-) :-)

Title: Re: DB Error
Post by: V@no on November 21, 2005, 02:57:07 PM

common problem with non latin letters. don't know a sollution...

Title: Re: DB Error
Post by: aedemirci on November 21, 2005, 03:01:23 PM

but as I mentioned I validated many other images with non-latin letters without any problem...

Title: Re: DB Error
Post by: V@no on November 21, 2005, 03:12:30 PM

Well, perhaps word 'Çiçek' is already added as a keyword in the database - that might cause the problem and it seems only happend when non-latin letter used...

Title: Re: DB Error
Post by: aedemirci on November 21, 2005, 03:20:38 PM

So it seems like a duplication error only appears when using a keyword containing some non-latin letters, right ??? Because different images may have common keywords...thx  :D

Title: Re: DB Error
Post by: paburmester on September 23, 2006, 06:11:06 PM

Hey V@no, I got the same problem with 1.7.3 is no solution to this yet? My images uploads fine, but I dont know is that make some problems in my database, can you please explain me?
thanks fory your help and sorry my bad english.
regards