Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#25 2021-05-24 06:35:05

gomedia
Plugin Author
Registered: 2008-06-01
Posts: 1,373

Re: adi_detritus - Sweep up the rubbish

Version 0.6 now available:

- fix: removed objection to INSTALL.txt & UPGRADE.txt (for TXP 4.8.5)
- fix: “Missing” language string name change (for TXP 4.8)
- fix: improved event discovery
- new: warnings for uninstalled plugins that have files in textpattern/plugins dir

Offline

#26 2021-07-01 04:33:43

gomedia
Plugin Author
Registered: 2008-06-01
Posts: 1,373

Re: adi_detritus - Sweep up the rubbish

Updated to 0.7 – now with added plugin perusal:

  • new: removed objections to all .webmanifest files
  • new objections your honour: textpattern/jquery.js, textpattern/txp_img (4.6+)
  • new: check writability of image thumbnails
  • new: TXP 4.8+ plugin file & manifest checks – type/order/code mismatches
  • improved: slightly less whingey about images

Offline

#27 2021-11-12 10:32:17

etc
Developer
Registered: 2010-11-11
Posts: 5,243
Website GitHub

Re: adi_detritus - Sweep up the rubbish

Hi Adi,

given the upcoming changes in the categories management (notably that their tree is not rebuilt on each operation any more), would it be possible to add a tree integrity check/repair to adi_detritus? Just in case :-) Thanks.

Offline

#28 2021-11-12 10:47:27

gomedia
Plugin Author
Registered: 2008-06-01
Posts: 1,373

Re: adi_detritus - Sweep up the rubbish

etc wrote #331932:

given the upcoming changes in the categories management (notably that their tree is not rebuilt on each operation any more), would it be possible to add a tree integrity check/repair to adi_detritus? Just in case :-) Thanks.

Sure thing, but could you point me in the direction of categories management changes?

Offline

#29 2021-11-12 11:13:40

etc
Developer
Registered: 2010-11-11
Posts: 5,243
Website GitHub

Re: adi_detritus - Sweep up the rubbish

gomedia wrote #331933:

Sure thing, but could you point me in the direction of categories management changes?

Thanks. The db/tree structure remains unchanged. Currently (4.8.7) the whole tree is rebuilt when some category is altered (inserted/moved/deleted). This keeps the tree sane but yields two db queries per category, which can become rather long for heavily categorized sites (1000 cats or more).

In 4.8.8 these operations are optimized and everything should work fine. But, if someone manipulates categories outside of txp, things can go west. Since the cat tree is not fully rebuilt by core any more, users would be lost in this case. I thought adi_detritus might add a ‘repair’ possibility, just in case. Of course, we could do it in core, but the feature would be of no use for most users.

Few things that adi_detritus might check and rebuild the tree if needed:

  1. orphan children (parent do not exist)
  2. wrong nesting (category not within the branch of its parent)
  3. orphan parents (missing children)

The first point is easy. For the second one, you might test

SELECT child.id FROM txp_category child, txp_category parent
    WHERE child.parent=parent.name
    AND child.type=parent.type
    AND (child.lft<=parent.lft OR child.rgt>=parent.rgt)

The third one looks more tricky, I leave it with you ;-)

Edit: also, starting from some version, category name must be lowercase. Older sites could thus contain invalid category names.

Offline

Board footer

Powered by FluxBB