Get error when trying to automatically index site
Permalink
This is the message i get from c5 when trying to index site:
mysql error: [1054: Unknown column 'ak_exclude_search_index' in 'where clause'] in EXECUTE("select p1.cID, pt.ctHandle from Pages p1 left join PagePaths on (PagePaths.cID = p1.cID and PagePaths.ppIsCanonical = 1) left join PageSearchIndex psi on (psi.cID = p1.cID) inner join CollectionVersions cv on (cv.cID = p1.cID and cvID = (select cvID from CollectionVersions where cvIsApproved = 1 and cID = cv.cID)) left join PageTypes pt on (pt.ctID = cv.ctID) inner join Collections c on (c.cID = p1.cID) left join CollectionSearchIndexAttributes on (CollectionSearchIndexAttributes.cID = p1.cID) where 1=1 and (c.cDateModified > psi.cDateLastIndexed or UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(psi.cDateLastIndexed) > 259200 or psi.cID is null or psi.cDateLastIndexed is null) and (ak_exclude_search_index is null or ak_exclude_search_index = 0) and (p1.cPointerID < 1 or p1.cPointerID is null) and cvIsApproved = '1' and p1.cIsTemplate = '0' and p1.cIsActive = '1' and (p1.cIsSystemPage = 0) order by p1.cID asc limit 0,200 ")
I'm sorry, but I don't know how to fix this.
mysql error: [1054: Unknown column 'ak_exclude_search_index' in 'where clause'] in EXECUTE("select p1.cID, pt.ctHandle from Pages p1 left join PagePaths on (PagePaths.cID = p1.cID and PagePaths.ppIsCanonical = 1) left join PageSearchIndex psi on (psi.cID = p1.cID) inner join CollectionVersions cv on (cv.cID = p1.cID and cvID = (select cvID from CollectionVersions where cvIsApproved = 1 and cID = cv.cID)) left join PageTypes pt on (pt.ctID = cv.ctID) inner join Collections c on (c.cID = p1.cID) left join CollectionSearchIndexAttributes on (CollectionSearchIndexAttributes.cID = p1.cID) where 1=1 and (c.cDateModified > psi.cDateLastIndexed or UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(psi.cDateLastIndexed) > 259200 or psi.cID is null or psi.cDateLastIndexed is null) and (ak_exclude_search_index is null or ak_exclude_search_index = 0) and (p1.cPointerID < 1 or p1.cPointerID is null) and cvIsApproved = '1' and p1.cIsTemplate = '0' and p1.cIsActive = '1' and (p1.cIsSystemPage = 0) order by p1.cID asc limit 0,200 ")
I'm sorry, but I don't know how to fix this.
Did you delete the Exclude From Search Index (exclude_search_index) page attribute?
Is that something you are saying I should do? Or are you asking if I did that by mistake and need to put it back in?
I think he's suggesting that the 'exclude_search_index' attribute might have been deleted and needs to be added back in. I have attached a screenshot of my 'exclude_search_index' setup. I have not touched that attribute since installing C5 version 5.6.
Yes. I am saying that it would need to be replaced if it has been deleted.
Thanks, I had already gone ahead and done just what you asked. The index was then created normally. Thank you again for your help.
