Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#13 2008-07-20 15:50:25

thebombsite
Archived Plugin Author
From: Exmouth, England
Registered: 2004-08-24
Posts: 3,251
Website

Re: We need some testers please - Deleting Categories Problem

According to the page’s souce code, value=“35” so I assume that is the ID. No, the category I tried to delete has no images in it and does not appear in that list. It is newly created though I created one that I will need so the fact that I can’t delete it at the moment is not a big hassle.

Something has occurred to me whilst doing this. This site is hosted by Media Temple. When I was getting the passwords and login information from Matthew I noticed that there were 2 paths to the database, one “internal” and one “external”. I’m using the one I was told to but I’m wondering if there may be certain “permission” restrictions on the path I’m using? Maybe I can create and modify but not destroy? I haven’t tried to delete any actual articles, images or files though I have overwritten. Shall I modify the config and try the other path? See if it has any effect?


Stuart

In a Time of Universal Deceit
Telling the Truth is Revolutionary.

Offline

#14 2008-07-20 15:56:51

ruud
Developer Emeritus
From: a galaxy far far away
Registered: 2006-06-04
Posts: 5,068
Website

Re: We need some testers please - Deleting Categories Problem

If Textpattern doesn’t attempt delete (there’s no DELETE query showing in your post), this can have two reasons only:
  • the category is still in use… but it’s not, you say, so we can ignore this one
  • the category is a parent to other categories. A newly created category is not a parent. You can check this by viewing the contents of the txp_category table (perhaps using Rob Sable’s database manager plugin) and checking if the values for rgt and lft are just 1 apart (rgt minus lft should be equal to 1). If that’s not true for a new category, I think your category table is corrupt.

I’m not quite sure what you mean by database paths, although I doubt it would cause this. It won’t hurt trying though…

Last edited by ruud (2008-07-20 15:59:58)

Offline

#15 2008-07-20 16:04:13

thebombsite
Archived Plugin Author
From: Exmouth, England
Registered: 2004-08-24
Posts: 3,251
Website

Re: We need some testers please - Deleting Categories Problem

Mmm. Well I’ve checked all the categories via the tab and there are no parents showing. It’s not something I use.

Let me install the plug-in and get back.


Stuart

In a Time of Universal Deceit
Telling the Truth is Revolutionary.

Offline

#16 2008-07-20 16:29:44

thebombsite
Archived Plugin Author
From: Exmouth, England
Registered: 2004-08-24
Posts: 3,251
Website

Re: We need some testers please - Deleting Categories Problem

Installed the db plug-in and all seems fine with the table. In the mean time I’ve deleted a plug-in and deleted an image with out problem so “deletion” itself seems to work OK.

Tried the other db “path” but it had no effect so I’ve swapped it back again.

I wonder if I have a corrupted TXP file? Which one would cover this, /include/txp_category.php?

Last edited by thebombsite (2008-07-20 16:40:55)


Stuart

In a Time of Universal Deceit
Telling the Truth is Revolutionary.

Offline

#17 2008-07-20 16:47:23

ruud
Developer Emeritus
From: a galaxy far far away
Registered: 2006-06-04
Posts: 5,068
Website

Re: We need some testers please - Deleting Categories Problem

Yes, that’s the file that would cover this.

Offline

#18 2008-07-20 17:19:05

thebombsite
Archived Plugin Author
From: Exmouth, England
Registered: 2004-08-24
Posts: 3,251
Website

Re: We need some testers please - Deleting Categories Problem

OK. I’ve tried uploading a new copy of that file with no effect. To make matters worse I have exactly the same problem with thebombsite and a vanilla install I have running so whatever the problem is it must be common to all methinks.

I have a completely new SVN download so I’m now going to upload the whole file set in case it is some other file that is causing the problem. But I’m going to have something to eat first as my stomach thinks my throat has been cut. ;)


Stuart

In a Time of Universal Deceit
Telling the Truth is Revolutionary.

Offline

#19 2008-07-20 19:39:58

thebombsite
Archived Plugin Author
From: Exmouth, England
Registered: 2004-08-24
Posts: 3,251
Website

Re: We need some testers please - Deleting Categories Problem

As I mentioned I have a completely new SVN download via TortoiseSVN. I have removed all the files in my vanilla install and “dropped” all the database tables. I have upload the new TXP file set via FTP (Filezilla) and run through the set up process. Install was successful and I’ve logged in. I’ve gone to the categories tab, created a new “file” category and tried to delete it. No go I’m afraid. I’m suspecting some kind of bug now.


Stuart

In a Time of Universal Deceit
Telling the Truth is Revolutionary.

Offline

#20 2008-07-20 20:05:12

ruud
Developer Emeritus
From: a galaxy far far away
Registered: 2006-06-04
Posts: 5,068
Website

Re: We need some testers please - Deleting Categories Problem

Can anyone else reproduce this with a recent SVN copy of TXP?

Stuart, can you edit the topic title to indicate that we need more people testing this?
And can you post the MySQL and PHP version you have installed?

Last edited by ruud (2008-07-20 20:08:13)

Offline

#21 2008-07-20 20:20:47

thebombsite
Archived Plugin Author
From: Exmouth, England
Registered: 2004-08-24
Posts: 3,251
Website

Re: We need some testers please - Deleting Categories Problem

Title edited.

The new site I’m working on uses PHP 4.4.8 and MySQL 4.1.11-Debian_4sarge7.
Thebombsite, Just Another Theme and my “vanilla” install all use PHP 5.2.5 and MySQL 4.1.22-standard.


Stuart

In a Time of Universal Deceit
Telling the Truth is Revolutionary.

Offline

#22 2008-07-20 20:25:32

the_ghost
Plugin Author
From: Minsk, The Republic of Belarus
Registered: 2007-07-26
Posts: 907
Website

Re: We need some testers please - Deleting Categories Problem

Yeah… Had the same problem – svn’s install used. Deleted after some magic – renamed categories, i think, solved problem.
More info need?


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

#23 2008-07-20 20:32:00

thebombsite
Archived Plugin Author
From: Exmouth, England
Registered: 2004-08-24
Posts: 3,251
Website

Re: We need some testers please - Deleting Categories Problem

Well I renamed the 3 original article categories for the new site but still can’t delete them. Have you tried creating any other category types and deleting them?

Last edited by thebombsite (2008-07-20 20:33:26)


Stuart

In a Time of Universal Deceit
Telling the Truth is Revolutionary.

Offline

#24 2008-07-20 20:37:48

ruud
Developer Emeritus
From: a galaxy far far away
Registered: 2006-06-04
Posts: 5,068
Website

Re: We need some testers please - Deleting Categories Problem

Six questions. For the category that you cannot delete:
  • does it have child categories?
  • is it used by an article/file/image/link?
  • can you post the corresponding row contents for that category from the txp_category table?
  • can you delete a newly created category?
  • is this a problem with all of the 4 category types or just with a few or one (please specify)?
  • which SVN version are you using?

Last edited by ruud (2008-07-20 20:38:43)

Offline

Board footer

Powered by FluxBB