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...
Anyone any ideas how I can fix this error. Any help or advice very much appreciated.
Thanks
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
