Not Functional on Version 8

Permalink Browser Info Environment
I am in the PRB, and tested Up Down Vote Lister on 8.0.3, and it doesn't work properly.

I am unable to add a vote block, and on the dashboard votes list page, I get this error:
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_mdicon_total_votes IS NOT NULL OR ak_gnt_ballotbox_total_votes IS NOT NULL OR ak_listing_logo_total_votes IS NOT NULL OR ak_listing_url_total_votes IS NOT NULL OR ak_listing_fb_page_total_votes IS NOT NULL OR ak_listing_twitter_total_votes IS NOT NULL OR ak_listing_demo_url_total_votes IS NOT NULL OR ak_market_total_votes IS NOT NULL OR ak_deployment_total_votes IS NOT NULL OR ak_cost_total_votes IS NOT NULL OR ak_license_total_votes IS NOT NULL OR ak_extended_info_total_votes IS NOT NULL OR ak_additional_info_total_votes IS NOT NULL OR ak_og_image_total_votes IS NOT NULL OR ak_likes_this_page_count_total_votes IS NOT NULL OR ak_tech_total_votes IS NOT NULL OR ak_has_vid_total_votes IS NOT NULL OR ak_has_screenshots_total_votes IS NOT NULL )) AND (p.cPointerID < 1) AND (p.cIsTemplate = 0) AND (cvIsApproved = 1) AND (p.cIsActive = ?) AND (p.siteTreeID = ?) AND (p.cIsSystemPage = ?) ORDER BY p.cDisplayOrder asc' with params [true, 1, false]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ak_meta_title_total_votes' in 'where clause'

Thought I would let you know.

Type: Discussion
Status: In Progress
View Replies:
PineCreativeLabs replied on at Permalink Reply
UPDATE: Also, uninstalling the package throws this error:
An exception occurred while executing 'DELETE FROM AttributeKeys WHERE akID = ?' with params [28]: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (`cmsguide_cmsinfo`.`atEmptySettings`, CONSTRAINT `FK_ED1BF189B6561A7E` FOREIGN KEY (`akID`) REFERENCES `AttributeKeys` (`akID`))
goutnet replied on at Permalink Reply
Thanks, I already found that this addon is not compatible with 5.8 *sigh* again to update the whole thing.

For now I disabled the addon serving in the list, so it should not be available for 5.8.

The porting seems (once again) pretty long process, and will probably require drastic changes in the code as I am affraid…

Not sure when I will have time to update it, will update this post.
hoyton replied on at Permalink Reply
Any luck with the 5.8 compatibility update, goutnet? This is a great addon and would love a more up-to-date version.

goutnet replied on at Permalink Reply
there is no version planned for 5.8.


On Wed, 27 Jun 2018, 01:29 concrete5 Community, <[email protected]>

concrete5 Environment Information


Browser User-Agent String

Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36

Hide Post Content

This will replace the post content with the message: "Content has been removed by an Administrator"

Hide Content

Request Refund

You have not specified a license for this support ticket. You must have a valid license assigned to a support ticket to request a refund.