Re: Re: concrete5 8.5.2 非対応アドオンの削除方法

2019年11月21日 at 18:33

すいません、追記です。
管理画面のUp/Down Voteで
予期せぬエラーが発生しました。
An exception occurred while executing 'SELECT p.cID FROM Pages p LEFT JOIN PagePaths pp ON (p.cID = pp.cID and pp.ppIsCanonical = true) LEFT JOIN PageSearchIndex psi ON p.cID = psi.cID LEFT JOIN PageTypes pt ON p.ptID = pt.ptID INNER JOIN Collections c ON p.cID = c.cID INNER JOIN CollectionVersions cv ON p.cID = cv.cID LEFT JOIN CollectionSearchIndexAttributes csi ON c.cID = csi.cID WHERE (( ak_meta_title_total_votes IS NOT NULL OR ak_meta_description_total_votes IS NOT NULL OR ak_meta_keywords_total_votes IS NOT NULL OR ak_exclude_nav_total_votes IS NOT NULL OR ak_exclude_page_list_total_votes IS NOT NULL OR ak_header_extra_content_total_votes IS NOT NULL OR ak_tags_total_votes IS NOT NULL OR ak_is_featured_total_votes IS NOT NULL OR ak_exclude_search_index_total_votes IS NOT NULL OR ak_exclude_sitemapxml_total_votes IS NOT NULL OR ak_thumbnail_total_votes IS NOT NULL OR ak_banner_total_votes IS NOT NULL OR ak_hide_banner_total_votes IS NOT NULL OR ak_page_bg_total_votes IS NOT NULL OR ak_ios_fallback_total_votes IS NOT NULL OR ak_job_title_total_votes IS NOT NULL OR ak_force_android_total_votes IS NOT NULL OR ak_gnt_ballotbox_total_votes IS NOT NULL )) AND (p.cPointerID < 1) AND (p.cIsTemplate = 0) AND (cv.cvIsApproved = 1) AND ((cv.cvPublishDate IS NULL) OR (cv.cvPublishDate <= ?)) AND ((cv.cvPublishEndDate IS NULL) OR (cv.cvPublishEndDate >= ?)) AND (p.cIsActive = ?) AND (p.siteTreeID = 1) AND (p.cIsSystemPage = 0) ORDER BY p.cDisplayOrder asc' with params ["2019-11-21 18:29:32", "2019-11-21 18:29:32", true]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ak_meta_title_total_votes' in 'where clause'

上記のエラーも発生しています。

出来れば使用したいのでよろしくお願いいたします。

タグ:

Re: Re: Re: concrete5 8.5.2 非対応アドオンの削除方法

2019年11月24日 at 23:23
下記の表示でアンインストールもできなくなりました。
何とかなりませんでしょうか?
宜しくお願い致します。

Doctrine \ DBAL \ Exception \ ForeignKeyConstraintViolationException

An exception occurred while executing 'DELETE FROM AttributeKeys WHERE akID = ?' with params [29]: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`DB`.`atEmptySettings`, CONSTRAINT `FK_ED1BF189B6561A7E` FOREIGN KEY (`akID`) REFERENCES `AttributeKeys` (`akID`))

Previous exceptions
•SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`DB`.`atEmptySettings`, CONSTRAINT `FK_ED1BF189B6561A7E` FOREIGN KEY (`akID`) REFERENCES `AttributeKeys` (`akID`)) (23000)
•SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`DB`.`atEmptySettings`, CONSTRAINT `FK_ED1BF189B6561A7E` FOREIGN KEY (`akID`) REFERENCES `AttributeKeys` (`akID`))