« previous next »
Pages: [1]

Author Topic: DB Error  (Read 6657 times)

0 Members and 1 Guest are viewing this topic.

Offline aedemirci

  • Newbie
  • *
  • Posts: 14
    • View Profile
DB Error
« 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 :-) :-)
Logged

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: DB Error
« Reply #1 on: November 21, 2005, 02:57:07 PM »
common problem with non latin letters. don't know a sollution...
Logged
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline aedemirci

  • Newbie
  • *
  • Posts: 14
    • View Profile
Re: DB Error
« Reply #2 on: November 21, 2005, 03:01:23 PM »
but as I mentioned I validated many other images with non-latin letters without any problem...
Logged

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: DB Error
« Reply #3 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...
Logged
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline aedemirci

  • Newbie
  • *
  • Posts: 14
    • View Profile
Re: DB Error
« Reply #4 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
Logged

Offline paburmester

  • Full Member
  • ***
  • Posts: 244
    • View Profile
Re: DB Error
« Reply #5 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
Logged
Pages: [1]
« previous next »