Composr 10.0.30 released

  • 2K views
  • 2 comments
Version 10.0.30 has now been released. This version is a patch release that introduces a number of bug fixes since the last release. Upgrading to this release is suggested due to PHP 7.4 compatibility fixes.

To upgrade follow the steps in your website's http://mybaseurl/upgrader.php script. You will need to copy the URL of the attached file (created via the form below) during step 3.


A block file is missing: composr_homesite_make_upgrader (sources/blocks/composr_homesite_make_upgrader.php or an overridden equivalent to this path)

Important

If you have existing comment topics or ratings for catalogue entries, you will need to reassociate them, as database IDs have necessarily changed.

Run this SQL code in something like phpMyAdmin:

Code (SQL)

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__%';
 
If you have MySQL 8+:

Code (SQL)

UPDATE cms_f_topics SET t_description=REGEXP_REPLACE(t_description,'catalogues__\\w+(_\\d+)','catalogues$1') WHERE t_description LIKE '%#catalogues__%';
 
Otherwise for each catalogue with comments (substituting example for catalogue names):

Code (SQL)

UPDATE cms_f_topics SET t_description=REPLACE(t_description,'catalogues__example','catalogues') WHERE t_description LIKE '%#catalogues__%';
 
Substitute cms_ with your configured table prefix (cms_ is the default).

The following changes have been made since version 10.0.29…
Edited

← Previous Article

Composr 10.1 beta21 released

Next Article →

Composr 10.1 beta22 released