Author Topic: Why I am seeing this error ?  (Read 4381 times)

0 Members and 1 Guest are viewing this topic.

Offline zaisk

  • Jr. Member
  • **
  • Posts: 93
    • View Profile
Why I am seeing this error ?
« on: February 15, 2006, 01:17:12 PM »
When uploading or validating images sometime I am seeing this error:

DB Error: Bad SQL Query: INSERT INTO 4images_wordmatch (image_id, word_id, name_match, desc_match, keys_match) SELECT DISTINCT 56, word_id, 0, 1, 0 FROM 4images_wordlist WHERE word_text = 'Ávesties'
Duplicate entry '56-1513' for key 1


Could this error be for the reason my native language I am using with the symbols like thses: ą,č,ę,ė,į,š,ų,ū,ž ?

I am just seeing this error, but the images are added correctly.

But I still do not like it.

Please help.

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: Why I am seeing this error ?
« Reply #1 on: February 15, 2006, 02:51:05 PM »
Yes, it caused by non-latin letters...Dont have a solution for you on this one though...it only affects search keywords, and in your example it will not find any images if you search for Ávesties
Its something database related, that's all I know...
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 zaisk

  • Jr. Member
  • **
  • Posts: 93
    • View Profile
Re: Why I am seeing this error ?
« Reply #2 on: February 15, 2006, 08:00:53 PM »
I dont know about databases much, but if I will change the mysql db collation to my native language collation, would it help or not ?

I am scared to configure my database :/ Becasue I can make a mess from it :)

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: Why I am seeing this error ?
« Reply #3 on: February 16, 2006, 12:45:06 AM »
Well, try ;) just make sure you made a backup before you do that
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)