View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0004059||Composr||core||public||2020-01-28 22:18||2020-01-28 22:19|
|Reporter||Chris Graham||Assigned To||Chris Graham|
|Fixed in Version|
|Summary||0004059: Issues with ratings|
|Description||There 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.
|Tags||No tags attached.|
|Time estimation (hours)|
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/).
hotfix-4059, 2020-01-28 10pm.tar (8,786,432 bytes)
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.