#4059 - Issues with ratings

This is a spacer post for a website comment topic. The content this topic relates to: #4059 - Issues with ratings
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.
0 guests and 0 members have recently viewed this.