My categories have disappeared

kemie · 2006-02-23 17:03:36

All of a sudden I cannot select, see, or edit categories from the txp admin interface.
screenshot1
screenshot2

i can add categories and can see them in the mysql database, but not edit them.

has anybody run into something similar?

Jeremie · 2006-02-23 17:12:09

How is you database looking ?

Just yesterday I had a TXP website going fully blank for no reasons. After several hours, the good people (and very baaaad, ugly machines and setup) of Textdrive tracked it down to the TXP /tmp directory content going nuts.

My point is, strange things do happen (but rarely, TXP is pretty much quite reliable). CHeck with the begining. Are your servrs ok ? Is your databse ok ? Is the content here ? etc.

Edit: Ok, I need a new pair of eyes. Sorry for that one. I did experience that once, a very long time ago (just before the 1.0RC I think). Have you tried to repair your database ?

Last edited by Jeremie (2006-02-23 17:13:17)

kemie · 2006-02-23 17:24:22

i am mysql illiterate :P using phpmysql i was able to figure out how to check the table for categories and see that they were actually there. nothing looked abnormal (then again i didn’t quite know what to look for). Can someone give me some pointers as to what could be wrong with the db and how to look for it?

one possible reason i can think of is i did an import of entries from movabletype, wonder if something got screwed up then.

Jeremie · 2006-02-23 17:26:54

Try to select all your TXP tables (textpattern and txp_*) in PhpMyAdmin, and use the “repair tool”.

maniqui · 2006-02-23 17:29:48

hola kemie! cómo va? (ahora paso al inglés para que esta respuesta quede para la posteridad)

about repairing tables (as Jeremie told you) you can try this plug-in by wilshire

It’s like a mini PHPMyAdmin for TXP.
And you have the repair tables option.

The plug-in isnt working totally fine with 4.0.3, but you can use the option of repairing tables.

kemie · 2006-02-23 17:40:23

thanks to both of you, ill try this :)

kemie · 2006-02-24 11:23:25

repaired tables. still not working :( should i just try reinstalling it all?

kemie · 2006-02-24 12:39:49

ugh. tried clearing the articles & categories tables in the database, reuploading all the txp files, disabling all plugins. and still, nothing. a complete, fresh install?

Mary · 2006-02-24 16:58:50

Can you view the source of the category page? is there nothing getting output?

kemie · 2006-02-26 20:04:02

nope, nothing in the source. i thought it might be some style problem, but nope. i’m baffled.

Mary · 2006-02-26 20:24:48

Check the category table: there should be 4 categories with a name and title of “root”, one for each category type (article, link, image, file).

kemie · 2006-02-27 11:36:38

ok, so that’s not there. that must be what’s causing it. is there a way to repair this by just inserting those lines into the database? is fo, what should i include in the fields parent, lft, and rgt?
or would it just be better to wipe my db and start over?

Textpattern CMS

Textpattern CMS support forum

#1 2006-02-23 17:03:36

My categories have disappeared

#2 2006-02-23 17:12:09

Re: My categories have disappeared

#3 2006-02-23 17:24:22

Re: My categories have disappeared

#4 2006-02-23 17:26:54

Re: My categories have disappeared

#5 2006-02-23 17:29:48

Re: My categories have disappeared

#6 2006-02-23 17:40:23

Re: My categories have disappeared

#7 2006-02-24 11:23:25

Re: My categories have disappeared

#8 2006-02-24 12:39:49

Re: My categories have disappeared

#9 2006-02-24 16:58:50

Re: My categories have disappeared

#10 2006-02-26 20:04:02

Re: My categories have disappeared

#11 2006-02-26 20:24:48

Re: My categories have disappeared

#12 2006-02-27 11:36:38

Re: My categories have disappeared

Board footer