Composr 10.0.30 released

  • 1,187 views
  • Added
  • Author:
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.


Your upgrade to version 10.0.30

You can generate an upgrader from any version of Composr to any other version. If you access this upgrade post via the version information box on your Admin Zone front page then we'll automatically know what version you're running.
If you'd prefer though you can enter in your version number right here:

(usually blank)

(example above is for upgrading from 10.0.0 beta1)


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
Back to Top