Keyword Search Not Working.

Keywords and keyword search is not fit for purpose.

I have an image with numerous keywords.
https://www.elliottcolemanphoto.com/royalty-free-stock/6325-a-paraglider-flies-over-the-remnants-of-an-old-slate-quarry-on-black-mountain-pass-in-the-brecon-beacons

Please note that the keywords displayed on the screen on this link are not all of the keywords that are present on the admin side.

Search keywords for : moorland, mountain, national park, nature, outdoor, para glide, paraglide, paraglider, paragliding, quarry all return zero results yet the keywords are showing on the admin side.

Here are the existing keywords as shown in admin:
action, active, activity, adrenaline, adventure, aerial, black mountain, black mountain pass, brecon beacons, brynamman, extreme, extreme sport, floating, fly, flyer, glide, gliding, grassy, height, hills, hobby, landscape, leisure, lifestyle, llangadog, moorland, mountain, national park, nature, outdoor, para glide, paraglide, paraglider, paragliding, quarry, rocks, scary, scenery, sport, sports, tourism, travel, view, wales

I also notice that many random keywords are being generated when importing the keywords on import. eg. I have "muscle ca" and "muscle car". I also have "r", "rac" and "race" as keywords but the images only have muscle car and race as actual keywords.

Basically, keywords do not work properly.

Edited Fri Nov 22, 19 9:33 AM by Elliott Coleman

Another example
https://www.elliottcolemanphoto.com/royalty-free-stock/6321-pendine-sands-carmarthenshire-wales-june-16th-2019-hot-rod-races-a-green-ford-hot-rod-on-the-beach-at-pendine-sands

Displayed keywords:
american, auto, automobile, automotive, beach, car, carmarthenshire, classic, classic car, custom, dragster, emblem, engine, event, fast, ford, green, grille, hood, hot, hot rod, hot-rod, hotrod, icon, motor, muscle, muscle car, old, pendine sands, pendine sands hot rod races, race


Actual keywords assigned to image
american, auto, automobile, automotive, beach, car, carmarthenshire, classic, classic car, custom, dragster, emblem, engine, event, fast, ford, green, grille, hood, hot, hot rod, hot-rod, hotrod, icon, motor, muscle, muscle car, old, pendine sands, pendine sands hot rod races, race, racing, retro, roadster, rod, speed, sports, style, tire, transport, transportation, turbo, vehicle, vintage, wheel, wheels

All kewords that I search for after race do not find any result for this particular image.

Edited by

issue Solve.

The pic_keywords field in the ms_photos table is set to varchar(255). This is too small and truncates the keywords. You obviously use this field to search from and as keywords have been truncated not all the keywords are being added to the photo.

Change this to a text field with no character limit.

Edited Sun Nov 24, 19 11:15 AM by Elliott Coleman