RESOLVED: Index Search Engine - Incorrect decimal value error - Database error
Permalink
Hi,
when I'm trying to use "Index Search Engine" from "Automated jobs", and I'm getting this error:
I know it is related to a page attribute by a handle "feature_value_4" but the odd thing is that I have disabled these from the attribute:
Searchable
Content included in search index.
Field available in advanced search.
So it should not be crawled by "the Index Search Engine"?
But this may be related to a older problem I had when I removed a this same attribute long ago and made another one with the same name, but I changed the attribute so it can also contain text now instead of just numerals.
https://www.concrete5.org/community/forums/usage/after-deleting-page...
So my question probably actually is if anyone knows how to either stop the "Index Search Engine" from crawling this "feature_value_4"?
or
If I can force the database to just accept text in the feature_value_4?
Cheers,
Petro
when I'm trying to use "Index Search Engine" from "Automated jobs", and I'm getting this error:
An exception occurred while executing 'UPDATE CollectionSearchIndexAttributes SET ak_feature_value_4 = ? WHERE cID = ?' with params ["", 28286]: SQLSTATE[HY000]: General error: 1366 Incorrect decimal value: '' for column 'ak_feature_value_4' at row 1
I know it is related to a page attribute by a handle "feature_value_4" but the odd thing is that I have disabled these from the attribute:
Searchable
Content included in search index.
Field available in advanced search.
So it should not be crawled by "the Index Search Engine"?
But this may be related to a older problem I had when I removed a this same attribute long ago and made another one with the same name, but I changed the attribute so it can also contain text now instead of just numerals.
https://www.concrete5.org/community/forums/usage/after-deleting-page...
So my question probably actually is if anyone knows how to either stop the "Index Search Engine" from crawling this "feature_value_4"?
or
If I can force the database to just accept text in the feature_value_4?
Cheers,
Petro
had to use phpMyAdmin to just change "ak_feature_value_4" in "CollectionSearchIndexAttributes" line to be "longtext" instead of "decimal" (had to make some other changes miner adjustments to it as well):
ak_feature_value_4 longtext utf8mb4_unicode_ci Kyllä
Cheers,
Petro