Problem after update to 1.7.9 with keywords

[Dual]

Hi, at first i want to say sorry if topic has been already taken before. I tried to search the forum without finding a explanation. So what's the deal. Earlier I was using 1.7.7 and everything was working fine, ( for security reasons i decided to update script) but after update to 1.7.8 ( problems with uploading photos) and next update to 1.7.9 something went wrong. Upload process goes fine, without any error msg. But after upload some keywords don't work. I have checked DB via PHP my admin, and i have found that while uploading new photos script searches only an existing keywords in "4images_wordlist" table and marks them in "4images_wordmatch" table. None of new words are created into first table. The reason is probably that i didn't run "Migrate Keywords" plugin from ACP. I tried to do it but 1/2 keywords after using this script give an error msg (most of them have latin letters inside). So I don't know what to do to make my gallery working (3000 pics). Is there any way to go back to "old type of storing keywords" ? Please help

[etiper]

How u update ? upload 1 by 1 file?

[Dual]

How u update ? upload 1 by 1 file?

I have extracted files from archive to website via ftp by mc (i use linux). All old files were overwrited (without config.php of course ). Privileges to files are also checked and good.

[Dual]

Can't any one help ?

[kunik1962]

I also just finished updating to v1.79 and now I am getting this error if I add keywords to new photo and want to use the Keyword "White"

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

[mawenzi]

@ kunik1962

1.0 http://www.4homepages.de/forum/index.php?topic=28267.0
2.1 http://www.4homepages.de/forum/index.php?topic=28267.msg153483#msg153483
2.2 http://www.4homepages.de/forum/index.php?topic=28430.0

[kunik1962]

Thanks for the help, sometimes I wish I spoke German it would make things so much easier

[mawenzi]

... for only english-speaking users ...

2.2 http://www.4homepages.de/forum/index.php?topic=28430.0

[Tino23]

Ich hab nach dem Update auch Probleme mit den Keywords. Habe gerade bemerkt, wenn ich die Keywords hintereinander nur mit einem Komma getrennt eingebe, dann das Bild unter den Keywords nicht gefunden wird z.B.  Keyword1,Keyword2 Gebe ich das ganze aber mit einer Leerzeichen dazwischen ein geht es wieder z.B. Keyword1, Keyword2 Woran kann das denn liegen?

Nachtrag:
Also ich bin mir jetzt fast sicher, das es noch ein Bug der 1.7.9er Version ist. Ich hab das ganze mit einer neu aufgesetzten Version ausprobiert und auch da ist das Problem.
Unter der Demo http://demo.4homepages.de/details.php?image_id=64 wird das Bild beim erstem Keyword auch nicht gefunden!
Oder hier http://demo.4homepages.de/details.php?image_id=8 da wird das Bild von keinem dort angegebenen Keyword gefunden.

[Dual]

Ok, I have downgraded script back to 1.7.7 and now can some one tell me how to update script to 1.7.9 without changing method of storing keywords to new method and stay with old type of presenting keywords at gallery (word1 word2 word3 presented like word1, word2, word3). Sorry for my bad English.

[Tino23]

Wenn ich es richtig verstanden habe suchst du das hier: http://www.4homepages.de/forum/index.php?topic=27693.msg149750#msg149750

[Rembrandt]

Fix for Search  http://www.4homepages.de/forum/index.php?topic=28860.0

mfg Andi

[Dual]

Ok, my problem isn't still fixed, i will try to present it from the other side, so here is my gallery about rail:

http://www.dual.rail.pl/galeria/

And 1 example photo:

http://www.dual.rail.pl/galeria/details.php?image_id=3310

As we can see everything works fine (without keywords with Latin letters , but it's not problem right now). My fault was that when i was adding photos i didn't use semicon between every single keyword separating them only by white spaces. As i think, before i start to update script i should edit every description of added photos from ( word1 word2 word3 ) to ( word1, word2, word3 ). Is there any way to do it automatically in sql database ? I tried to run that:

http://www.4homepages.de/forum/index.php?topic=27693.msg149750#msg149750

But in sql I get msg like: Nothing has been done : 0 (cpanel is now down till Monday)

Please give me some advice

[Rembrandt]

... As i think, before i start to update script i should edit every description of added photos from ( word1 word2 word3 ) to ( word1, word2, word3 ). Is there any way to do it automatically in sql database ? I tried to run that:
 

first step: http://www.4homepages.de/forum/index.php?topic=28860.msg154915#msg154915
then when you update to V1.7.8 or higher, you must run "migrate keyword". This plugin in admin/plugins set automatical comma in the keyword field.

...But in sql I get msg like: Nothing has been done : 0..

this is correct, this SQL command, remove all commas from the keyword field.
that do exactly the opposite of what you want. 

mfg Andi
 

[Dual]

... As i think, before i start to update script i should edit every description of added photos from ( word1 word2 word3 ) to ( word1, word2, word3 ). Is there any way to do it automatically in sql database ? I tried to run that:
 

first step: http://www.4homepages.de/forum/index.php?topic=28860.msg154915#msg154915
then when you update to V1.7.8 or higher, you must run "migrate keyword". This plugin in admin/plugins set automatical comma in the keyword field.

...But in sql I get msg like: Nothing has been done : 0..

this is correct, this SQL command, remove all commas from the keyword field.
that do exactly the opposite of what you want.  

mfg Andi
 

Ok, thank you very much, here is what have I done :

First i made backup copy of whole account and then i have uploaded 1.7.9 via ftp, checked all chmods and runed migrate_keywords.php, here is what I get:

http://wklej.org/id/469330/

So I tried to do same but after upload 1.7.9 I have also uploaded 3 files from fix from here:

http://www.4homepages.de/forum/index.php?topic=28860.msg154915#msg154915

And i get:

http://wklej.org/id/469335/

All keywords has been separated by semicons and thats great, but 1 new problem has occurred after migrate. If keyword have inside " - ", the keyword is being cuted right after " - " while searching the database, example:

keyword EP09-004, when i click on it or write it manually in search i get all photos witch have EP09 , not exactly EP09-004

Same with date keywords, example:

keyword 29-06-2008 is being interpreted as 29 (to short keyword) and result give 0 photos with that keyword.

Thanks for help in advance.