Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#13 2021-11-06 06:40:21

phiw13
Plugin Author
From: Japan
Registered: 2004-02-27
Posts: 3,058
Website

Re: [solved] child category when parent category has [ ] in title

colak wrote #331897:

I’ve never used MariaDB, but would it be it?

It does not matter. The same issue happens across 3 different sites, localhost + MySQL8 or live host + MariaDB.


Where is that emoji for a solar powered submarine when you need it ?
Sand space – admin theme for Textpattern

Offline

#14 2021-11-06 15:40:07

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 9,007
Website GitHub Mastodon Twitter

Re: [solved] child category when parent category has [ ] in title

If your db. is not utf-8 this plugin may help.


Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.

Offline

#15 2021-11-07 02:16:49

phiw13
Plugin Author
From: Japan
Registered: 2004-02-27
Posts: 3,058
Website

Re: [solved] child category when parent category has [ ] in title

A new trip to Sequel Ace to inspect the txp-category table. I found the problem.

My problematic category had as name abc-Foo-Bar –and title abc [Foo Bar]. Looking at the table in Sequel Ace, I finally saw the issue: the freshly-created child categories where all nicely filed with the abc-foo-bar category as parent. See it ?

The problem: the name had one or more Capital letters in its name. This has worked fine in the past, as mentioned this category and its child categories have existed for a long time without need of modification (even adding articles…). More recent versions of Textpattern are more strict. If you create a category with name foo-Bar, Textpattern normalises the name to foo-bar, but keeps the title as foo-Bar.

Once I changed the name of the offending parent category in the edit panel to be all lower case, my invisible categories suddenly appeared…

Rabah was right: Gremlins…

Edit: the conversion to lowercase is documented

Last edited by phiw13 (2021-11-07 02:50:56)


Where is that emoji for a solar powered submarine when you need it ?
Sand space – admin theme for Textpattern

Offline

Board footer

Powered by FluxBB