mysql problem attribute keys

Permalink 1 user found helpful
Hi, had problem with bulk SEO updater not saving.

I tracked down the problem to overwritten values in attribute keys in database whereby attribute keys ak_meta_title and ak_meta_description, had been overwritten with previous meta values ?? Very Odd.

I've changed the ak's back to meta_title and meta_description, which now allows me to update these individually in each page properties however bulk seo updater is showing the following when launched...

mysql error: [1054: Unknown column 'ak_meta_title' 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 max(cvID) from CollectionVersions where 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 (psi.cName like '%%' or psi.cDescription like '%%' or psi.content like '%%' OR ak_meta_title like '%%' OR ak_meta_description like '%%' OR ak_meta_keywords like '%%' OR ak_exclude_nav like '%%' OR ak_exclude_page_list like '%%' OR ak_header_extra_content like '%%' OR ak_exclude_search_index like '%%' OR ak_exclude_sitemapxml like '%%' OR ak_tags like '%%' ) and (p1.cPointerID < 1 or p1.cPointerID is null) and p1.cIsTemplate = '0' and p1.cIsActive = '1' and (p1.cIsSystemPage = 0) order by cDateModified desc limit 0,20 ")


Anyone any ideas how I can fix this error. Any help or advice very much appreciated.

Thanks

 
mrtrumpy replied on at Permalink Best Answer Reply
Problem solved by editing CollectionSearchIndexAttributes table and changing cID values to match those edited in attribute keys in phpmyadmin.