Default concrete search not working

Permalink
Hi All,

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 ?

View Replies:
Mainio replied on at Permalink Reply
Mainio
In case you're talking about the internal site search, the new content might not have been indexed yet. You will probably need to run the "Index Search Engine" automated job through the dashboard of your site.

http://documentation.concrete5.org/editors/dashboard/system-and-mai...
mohamedkhalid replied on at Permalink Reply
I get this sql error when i try running the automated jobs SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'ak_meta_description' at row 1 .

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 .
Mainio replied on at Permalink Reply
Mainio
One of your pages seems to have a long meta description set to it that breaks the process. The limit for that column in the search index table is 255 characters in the current versions of c5.

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).
mohamedkhalid replied on at Permalink Reply 1 Attachment
I have too many pages to do so .
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
Mainio replied on at Permalink Reply
Mainio
The part of the error does not show there that really matters but it's the previous error that tells the problem.

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.
Parasek replied on at Permalink Reply
Parasek
I bet you installed concrete5/added attributes on Windows.
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:
FileSearchIndexAttributes
CollectionSearchIndexAttributes
UserSearchIndexAttributes