View Issue Details

IDProjectCategoryView StatusLast Update
0004059Composrcorepublic2020-01-28 22:19
ReporterChris GrahamAssigned ToChris Graham 
Severityminor 
Status resolvedResolutionfixed 
Product Version10.0.29 
Fixed in Version 
Summary0004059: Issues with ratings
DescriptionThere are a number of ratings bugs:

1) Ratings are not working from image/video screens
2) Ratings are not consistently working for catalogues - due to a feedback-type-code mismatch
3) Ratings shown in category/block views may not be cache safe, particular grid views for galleries and catalogues, and category listings for downloads. i.e. ratings changes do not show until cache expiry.
TagsNo tags attached.
Attach Tags
Time estimation (hours)
Sponsorship open

Activities

admin

2020-01-28 22:18

administrator   ~0006324

Fixed in git commit 934af38ca (https://gitlab.com/composr-foundation/composr/commit/934af38ca - link will become active once code pushed to GitLab)

A hotfix (a TAR of files to upload) have been uploaded to this issue. These files are made to the latest intra-version state (i.e. may roll in earlier fixes too if made to the same files) - so only upload files newer than what you have already. Always take backups of files you are replacing or keep a copy of the manual installer for your version, and only apply fixes you need. These hotfixes are not necessarily reliable or well supported. Not sure how to extract TAR files to your Windows computer? Try 7-zip (http://www.7-zip.org/).

admin

2020-01-28 22:18

administrator  

hotfix-4059, 2020-01-28 10pm.tar (8,786,432 bytes)

Chris Graham

2020-01-28 22:19

administrator   ~0006325

This is a particularly nasty issue because the database contents needs to be changed for catalogue ratings/comments/trackbacks to be able to work consistently with assumptions built into the abstract parts of Composr's architecture. These queries need running to fix existing database content...

UPDATE cms_rating SET rating_for_type='catalogues' WHERE rating_for_type LIKE 'catalogues__%';
UPDATE cms_trackbacks SET trackback_for_type='catalogues' WHERE trackback_for_type LIKE 'catalogues__%';
UPDATE cms_f_topics SET t_description=REGEXP_REPLACE(t_description,'catalogues__\\w+(_\\d+)','catalogues$1') WHERE t_description LIKE '%#catalogues__%';

Fix the 'cms_' table prefix as appropriate.

Issue History

Date Modified Username Field Change
2020-01-28 22:19 Chris Graham Note Added: 0006325