Default concrete search not working
I have added few new content to my website but when i search the keywords of newly added content it is not being searched.
Anyone facing similar issue ?
I know this can be fixed by changing the length but not so keen to do it on live site which may cause on loosing my data .
You will have to find the page that is causing this to happen and shorten its meta description below 255. After that, try running the job again.
Please also note the general SEO guidelines regarding the meta description for your site's optimal search performance: the current gudelines say it should be 160 characters or less (it's not a strict limit because it really depends on the text width as shown in Google but generally under 160 should be OK).
Cant i increase the width of the column in the database and try doing it ?
I am getting this error now
An exception occurred while executing 'INSERT INTO CollectionSearchIndexAttributes (cID, ak_video_thumb_url) VALUES (?, ?)' with params ["272", "\n
You could theoretically increase the column size manually, yes. But you are risking your system's upgrade processes since if there is still a point release (maintenance release) for the current version, the upgrade would change the column size back to its original value.
However, I think the next major version release should change a bit how attributes are handled and I think it also changes that column type to TEXT which would get rid of this problem. But that is not until the next major release.
Meanwhile, I would either suggest shortening the descriptions as it would also benefit the SEO of your site (and requires no coding) or if you are up for a little bit of technical work modify the attribute search index to make sure the values they store in that attribute's type search index column are always maximum of 255 long.
Currently there is a bug, that cause columns becoming "tinytext" instead "text" on windows server.
You have to change manually colums from tinytext to text in this tables: