Insert keyword from list on upload.php page not working.

[donnoman]

I know I've got keywords in the database, because I can use them in the search page.

But I get this when I'm on the upload page and click on the "insert from list" link.

[cryogenic]

confirmed, I'm having the same issue... and when I go and "regenerate dictionary", I get a "critical error

Code Select Expand


While executing query "SELECT keyword from cpg130_dict WHERE keyword = 'Goody's'" on 0

mySQL error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 's'' at line 1


File: /homepages/26/d94358824/htdocs/gallery/include/functions.inc.php - Line: 159

Looks to me like it doesn't much care for the apostrophe in my keyword... I'll remove it and see what happens

EDIT: Yep, it doesn't like apostrophes at all. Removed the apostrophe and it was able to regenerate the complete dictionary just fine.

[Tranz]

On my upload.php page, I don't even have "insert from list" link. I know I have two keywords that are listed on the search page.

I just ran cvs update a few hours ago.

[donnoman]

I just tested the latest cvs code, and wasn't able to reproduce the problem.

I believe this was fixed by this thread.

Can someone else confirm so we can mark this fixed.

[Tranz]

I got the result as posted in the first message. Then I ran regenerate dictionary and saw this:

* % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % % * % % % % % % % % % % % % % % % % % %
New keywords found = 2
Return

The keywords then worked.

[donnoman]

Thu do you recall if it printed the mangled HREF as in the screenshot, or did it just say no keywords.

Because it will say "no keywords" until you've run regenerate keywords. but it shouldn't show the mangled HREF.

Alse I'm not positive but I THINK the %%%'s might be by design. They could be leftover debug code, or a failed experment in a status bar

@Tarique can you let us know if the display of the %'s was by design?

[Tranz]

I guess it was a functioning link to regenerate dictionary rather than the mangled code above.

[Tarique Sani]

yes the display of % and * is by design and it prevents the browser timeout if the number of keywords are huge. % denotes a keyord that exists and * shows a new keyword

[Tranz]

Maybe the signs should be explained on that page.

Just something simple like
* = new keyword
% = existing keyword

[Tarique Sani]

go ahead - add and commit

[Tranz]

Since "New keywords found = " is not internationalized, is it ok to just add the explanations right in the code, too?

[Tarique Sani]

Yes

[Tranz]

added and committed.

[Tarique Sani]

thanks

[Joachim Müller]

please internationalize - having a feature freeze doesn't mean there can't be any changes to the language files. The language files haven't gone out to the translators yet; I'll let you know when there will be a freeze for the language file.

Joachim

[donnoman]

I went ahead and internationalized those phrases, marking this done.

Thanks for your help Thu and Tarique.