Increase keyword character limit

[Walkinman]

hey Folks,

In response to this thread:

http://forum.coppermine-gallery.net/index.php/topic,73899.msg356307.html#msg356307

I thought I'd post and see if someone might help explain this? I searched around for the answer to do this, but couldn't find the thread André mentions. What I want to do is increase the number of keywords cpg allows me to enter via the 'edit files' function. I use embedded IPTC data so the # of keywords I have per image is almost always greater than cpg allows me to edit, so I can't change anything without deleting some in the keywords box, which I don't want to do. I just want to be allowed to add more.

Any assistance is much appreciated.

Thank you.

Cheers

Carl

[Αndré]

I searched around for the answer to do this, but couldn't find the thread André mentions.

I just found the thread in the German support board: http://forum.coppermine-gallery.net/index.php/topic,73706.msg354951.html#msg354951

Translation:

1. In the database, increase the character limit for the column "keywords" in the table "pictures" (e.g. to "VARCHAR(512)").

2. Open edit_one_pic.php, find

Code Select Expand

<input type="text" style="width: 100%" name="keywords" maxlength="255" value="{$CURRENT_PIC['keywords']}" id="keywords" class="textinput" />
and increase the value for "maxlength" (e.g. to 512):

Code Select Expand

<input type="text" style="width: 100%" name="keywords" maxlength="512" value="{$CURRENT_PIC['keywords']}" id="keywords" class="textinput" />

3. Open editpics.php, find

Code Select Expand

array($icon_array['keyword'] . $keywordLabel, 'keywords', 0, 255),
and increase the last value (e.g. to 512):

Code Select Expand

array($icon_array['keyword'] . $keywordLabel, 'keywords', 0, 512),

[Walkinman]

hey André

Ahh, great, thanks. I'll do that easily enough. Except the database part; tha's via phpMyAdmin correct? I'll have a look and see how I go.

Thanks again.

Cheers

Carl

[Walkinman]

hey André

Got it, thanks so much.I didn't have to do anything in the database, I think I had actually already changed that in an earlier version of cpg, then lost the changes in the 2 files you specified below in an upgrade. So it's allowing me to change edit the keywords via "edit files" now.

Thanks so much for your help.

Cheers

Carl