Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
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
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
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