Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
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: North Wales, UK
- Registered: 2005-11-25
- Posts: 1,095
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
Re: We need some testers please - Deleting Categories Problem
I didn’t want to mess with the new site too much so I’ve run this in the “vanilla” site I re-created last night using a new downloaded SVN file set. The table details I show in my earlier post are what we are looking at and I’m trying to delete the “testing” category which is for files. Here’s the query I’ve used:-
select id, name from txp_category where id IN (14) AND type='file' AND rgt - lft = 1 AND NOT name IN ('')and this is the result shown:-
select id, name from txp_category where id IN (14) AND type='file' AND rgt - lft = 1 AND NOT name IN ('')
1/1 Query(s) Executed SuccessfullyI also tried to delete the “Test” category which is for articles and then used this query:-
select id, name from txp_category where id IN (7) AND type='article' AND rgt - lft = 1 AND NOT name IN ('hope-for-the-future','meaningful-labor')with this result:-
select id, name from txp_category where id IN (7) AND type='article' AND rgt - lft = 1 AND NOT name IN ('hope-for-the-future','meaningful-labor')
1/1 Query(s) Executed Successfullywhich is the same result really isn’t it? Is it not meant to tell me what the selection is?
Last edited by thebombsite (2008-07-21 15:20:26)
Stuart
In a Time of Universal Deceit
Telling the Truth is Revolutionary.
Offline
Re: We need some testers please - Deleting Categories Problem
Select queries return a table with a result set. That’s what I’m interested in (although the fact that the query executed succesfully is a good start). You should see a table listing the ID/name combinations of categories that are approved for deletion.
Btw, if that first query does not give results (and category ID 14 isn’t deleted), then according to the query it’s not because the category is in use, because apparently none of your files are linked to a category. That’s good, makes testing easier.
If I could get access to a test install of TXP that has problems with deleting categories and DEBUG set to 1 and the rss_db… plugin installed, perhaps it’s easier to diagnose?
Last edited by ruud (2008-07-21 16:21:25)
Offline
Re: We need some testers please - Deleting Categories Problem
There are no files in that install. It is totally virgin apart from renaming 1 article category and adding 1 file category.
Do you want me to send you a login?
Last edited by thebombsite (2008-07-21 19:43:49)
Stuart
In a Time of Universal Deceit
Telling the Truth is Revolutionary.
Offline
Re: We need some testers please - Deleting Categories Problem
Yes, please.
Offline
Re: We need some testers please - Deleting Categories Problem
Sent.
Stuart
In a Time of Universal Deceit
Telling the Truth is Revolutionary.
Offline
Re: We need some testers please - Deleting Categories Problem
Heh, apparently, having DEBUG set to 1 prevents the login cookie from being sent. I need to login first before it can be set.
Offline
Re: We need some testers please - Deleting Categories Problem
Done. Let me know when you need it changing back.
Stuart
In a Time of Universal Deceit
Telling the Truth is Revolutionary.
Offline
Re: We need some testers please - Deleting Categories Problem
I’m logged in now. You can change it back.
Offline
Re: We need some testers please - Deleting Categories Problem
Done.
Stuart
In a Time of Universal Deceit
Telling the Truth is Revolutionary.
Offline