Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Re: We need some testers please - Deleting Categories Problem
ruud,
Installed Textpattern version: 4.0.6 (r2946)
On XAMPP 1.6.7, WinXP
I signed on to the backend:
1. deleted Reciprocal Affection, got this message: Article categories deleted: 7.
2. created a category under File Categories, called it bert, deleted bert, go this message: File categories deleted: 14.
Seems fine to me.
Here’s a final dump:
"13";"root";"file";;"1";"2";"root"
"12";"root";"image";;"1";"4";"root"
"11";"root";"link";;"1";"4";"root"
"10";"root";"article";;"1";"6";"root"
"5";"hope-for-the-future";"article";"root";"2";"3";"Hope for the Future"
"6";"meaningful-labor";"article";"root";"4";"5";"Meaningful Labor"
"8";"textpattern";"link";"root";"2";"3";"Textpattern"
"9";"site-design";"image";"root";"2";"3";"Site Design"We Love TXP . TXP Themes . TXP Tags . TXP Planet . TXP Make
Offline
#26 2008-07-20 20:55:25
- masa
- Member
- From: Asturias, Spain
- Registered: 2005-11-25
- Posts: 1,091
Re: We need some testers please - Deleting Categories Problem
OK, I’ve had a go on my local MAMP install, PHP version: 5.2.5, MySQL: 5.0.41, Server: Apache/2.0.59 (Unix) PHP/5.2.5 DAV/2. I downloaded everything from here – I suppose that’s the latest?!
- created a new category and deleted it = works
- created a few child cats and deleted them = works
- tried to delete the parent = does not work, as expected (thanks ruud :-)
- tried to delete any used category = does not work, as expected
So from all I can tell everything works as it should.
Offline
Re: We need some testers please - Deleting Categories Problem
I’ve installed the db plug-in to my “vanilla2 install. This is the table:-
id name type parent lft rgt title
13 root file 1 4 root
12 root image 1 4 root
11 root link 1 4 root
10 root article 1 8 root
5 hope-for-the-future article root 2 3 Hope for the Future
6 meaningful-labor article root 4 5 Meaningful Labor
7 test article root 6 7 Test
8 textpattern link root 2 3 Textpattern
9 site-design image root 2 3 Site Design
14 testing file root 2 3 Testingid7 is one of the 3 original article categories renamed to “test” and is empty.
id14 is a new category created for “files” and is empty.
I can’t delete either of them.
I should point out that Bert and Martin are both testing on a local install – XAMPP or MAMPP – whereas all the sites I’m having problems with are on remote servers – so I shall go try that on my own XAMPP and see what happens.
Stuart
In a Time of Universal Deceit
Telling the Truth is Revolutionary.
Offline
Re: We need some testers please - Deleting Categories Problem
Just updated my txp install and installed newly test site:
- does it have child categories?
- no
- is it used by an article/file/image/link?
- no
- can you post the corresponding row contents for that category from the txp_category table?
CODE
13 root file 1 2 root
12 root image 1 4 root
11 root link 1 4 root
10 root article 1 8 root
5 hope-for-the-future article meaningful-labor 3 4 Hope for the Future
6 meaningful-labor article root 2 5 Meaningful Labor
7 reciprocal-affection article root 6 7 Reciprocal Affection
8 textpattern link root 2 3 Textpattern
9 site-design image root 2 3 Site DesignImage:
- can you delete a newly created category?
- yes
- is this a problem with all of the 4 category types or just with a few or one (please specify)?
- all preinstalled categories types (articles,link,image) cannot be deleted
- which SVN version are you using?
- the last at current time
What else? Renaming, moving over the tree of categories doesn’t help. I think, i solved it by this – is just renamed it in the category i need :)
I unchecked categories from articles\images\links but they aren’t deleted anyway. One article category after installed wasn’t assigned to any article – it cannot be deleted to.
Tried to edit one of categories, and…
Deleting steps:
- Created such hierarchy:
- Tried to delete parent
- Nothing happend – no message at the top
Last edited by the_ghost (2008-07-20 21:14:50)
Providing help in hacking ATM! Come to courses and don’t forget to bring us notebook and hammer! What for notebook? What a kind of hacker you are without notebok?
Offline
Re: We need some testers please - Deleting Categories Problem
OK. I’ve just installed a new site on XAMPP and deleting categories works fine provided that they are empty.
So what’s the difference between a local install and a remote one? Can anyone please test this on a hosting server rather than XAMPP or MAMPP?
Victor – you shouldn’t be able to delete a “parent” category now or a category that contains articles/files/links/images.
Last edited by thebombsite (2008-07-20 21:30:47)
Stuart
In a Time of Universal Deceit
Telling the Truth is Revolutionary.
Offline
Re: We need some testers please - Deleting Categories Problem
thebombsite
Victor – you shouldn’t be able to delete a “parent” category now or a category that contains articles/files/links/images.
I thought there should appear warning message…
Providing help in hacking ATM! Come to courses and don’t forget to bring us notebook and hammer! What for notebook? What a kind of hacker you are without notebok?
Offline
Re: We need some testers please - Deleting Categories Problem
Yes I believe there should be. Have you tried deleting that “Reciprocal Affection” category?
Stuart
In a Time of Universal Deceit
Telling the Truth is Revolutionary.
Offline
Re: We need some testers please - Deleting Categories Problem
thebombsite wrote:
Have you tried deleting that “Reciprocal Affection” category?
Tried – no effect.
Added category which is parent and subcategory the same time – it was deleted ok.
Last edited by the_ghost (2008-07-20 21:50:45)
Providing help in hacking ATM! Come to courses and don’t forget to bring us notebook and hammer! What for notebook? What a kind of hacker you are without notebok?
Offline
Re: We need some testers please - Deleting Categories Problem
Victor, it doesn’t show a warning message. It assumes that no-one would ever want to delete a parent category or a category containing articles on purpose. Contrary to sections or style sheets, on the category tab it clearly shows which categories are in use or are parents.
Just to be sure, if a category does not have any children and is not used (for example the ‘reciprocal affection’ category in the screenshots you posted), can you delete that one?
Stuart, so you’re saying it does work on a local install, but not when installed on a webserver managed by someone else. The fact that it’s remote or local probably doesn’t matter. More likely a configuration or DB issue.
Offline
#34 2008-07-20 21:50:06
- masa
- Member
- From: Asturias, Spain
- Registered: 2005-11-25
- Posts: 1,091
Re: We need some testers please - Deleting Categories Problem
There’s no warning message, only the category won’t be deleted.
Something like “Sorry, this category is in use and can’t be deleted.” would probably be helpful.
Offline
Re: We need some testers please - Deleting Categories Problem
No, i cannot delete any of preinstalled categories
Providing help in hacking ATM! Come to courses and don’t forget to bring us notebook and hammer! What for notebook? What a kind of hacker you are without notebok?
Offline
Re: We need some testers please - Deleting Categories Problem
Stuart, if you still have DEBUG set to ‘1’ in constants.php.
Try deleting a category that should be deletable. The SQL query below the one containing DISTINC, something like this one:
select id, name from txp_category where id IN (35) AND type='image' AND rgt - lft = 1 AND NOT name IN ('site-design','acoustics','audio','electrical','it-communication','lighting','video','article-images','cos','fbcb','gcfm','hcc','lumc','ssj','vcce')It would be interesting to see what the result of that query is, you can execute the query using the rss_db_something plugin you have installed.
Offline