Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Pages: 1
#1 2007-06-08 08:37:47
- xoulone
- New Member
- Registered: 2007-06-08
- Posts: 4
Not creating categories?
I’ve search the forums and FAQs for a couple of nights now, but I still can’t seem to find the solution or anyone else with my problem.
Earlier this week I edited one of my categories “Article category name.” After I tried that a “404” page popped up. I then clicked the back button and about half of my categories were deleted. Apparently all of my articles that were placed under those categories still exist, but those particular categories just don’t exist anymore. I tried making new categories but every time I do I just get another 404 page. I’ve never had this problem before and I haven’t changed or added anything to my site in a couple of months. Its frustrating me how I cant make anymore new categories.
I thought if I upgraded from 4.0.3 to 4.0.4 it would solve the problem, but it didn’t.
Does anyone know what’s going on here or how to fix it?
Much appreciated!
Offline
Re: Not creating categories?
Can you post the full diagnostics (via the TXP admin tab) and the URL in the address bar when you see the 404 error?
Offline
#3 2007-06-08 15:29:12
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: Not creating categories?
It is possible that your categories are not actually deleted, but are just not entered in the database correctly anymore. Can you make an SQL dump of your categories table for me to check?
Offline
#4 2007-06-08 20:09:52
- xoulone
- New Member
- Registered: 2007-06-08
- Posts: 4
Re: Not creating categories?
Thanks for the responses ruud and Mary.
The diagonstics are the following:
Textpattern version: 4.0.4 (r1956)
Last Update: 2007-06-06 22:32:02/2007-06-06 22:31:48
Document root: /home/xinairne/public_html
$path_to_site: /home/xinairne/public_html
Textpattern path: /home/xinairne/public_html/textpattern
Permanent link mode: section_id_title
Temporary directory path: /home/xinairne/public_html/textpattern/tmp
Site URL: www.xinair.net
PHP version: 4.4.7
Server Local Time: 2007-06-08 20:07:44
MySQL: 4.1.21-standard
Locale: en_US.UTF-8
Server: Apache/1.3.37 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 FrontPage/5.0.2.2635.SR1.2 mod_ssl/2.8.28 OpenSSL/0.9.7a PHP-CGI/0.1b
PHP Server API: cgi
RFC 2616 headers:
Server OS: Linux 2.6.18.1.dn1.am
Active plugins: glx_gravatar-0.1, dru_chatometer-0.1, dru_recent_referers-0.4, pfa_beginning-0.5 rc3, rss_thumbpop-0.7, zem_contact-0.6, rss_suparchive-0.18, cbs_category_list-0.9, rss_live_search-0.7
Pre-flight check:
————————————
/home/xinairne/public_html/textpattern/setup/ still exists
The following PHP functions (which may be necessary to run Textpattern) are disabled on your server: exec,passthru,proc_open,shell_exec,system,posix_kill,popen
————————————
.htaccess file contents:
————————————
#DirectoryIndex index.php index.html
#Options +FollowSymLinks
#RewriteBase /relative/web/path/
<IfModule mod_rewrite.c> RewriteEngine On RewriteCond %{REQUEST_FILENAME} -f [OR] RewriteCond %{REQUEST_FILENAME} -d RewriteRule ^(.+) – [PT,L]
RewriteRule ^(.*) index.php </IfModule>#php_value register_globals 0
————————————
The 404 error page I land on after creating a new category is: http://www.xinair.net/textpattern/index.php
And Mary, here is a SQL dump of the categories table you requested:
— phpMyAdmin SQL Dump
— version 2.9.0.2
— http://www.phpmyadmin.net
—
— Host: localhost
— Generation Time: Jun 08, 2007 at 08:05 PM
— Server version: 4.1.21
— PHP Version: 4.4.2
—
— Database: `xinairne_xinairtxtpat`
—
— ————————————————————————————
—
— Table structure for table `txtpat1_txp_category`
—
CREATE TABLE `txtpat1_txp_category` (
`id` int(6) NOT NULL auto_increment,
`name` varchar(64) NOT NULL default ‘’,
`type` varchar(64) NOT NULL default ‘’,
`parent` varchar(64) NOT NULL default ‘’,
`lft` int(6) NOT NULL default ‘0’,
`rgt` int(6) NOT NULL default ‘0’,
`title` varchar(255) NOT NULL default ‘’,
`idx` int(11) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=1 AUTO_INCREMENT=95 ;
—
— Dumping data for table `txtpat1_txp_category`
—
INSERT INTO `txtpat1_txp_category` VALUES (67, ‘root’, ‘file’, ‘inspire’, 1, 10, ‘root’, NULL);
INSERT INTO `txtpat1_txp_category` VALUES (66, ‘root’, ‘image’, ‘inspire’, 1, 14, ‘root’, NULL);
INSERT INTO `txtpat1_txp_category` VALUES (65, ‘root’, ‘link’, ‘inspire’, 1, 10, ‘root’, NULL);
INSERT INTO `txtpat1_txp_category` VALUES (79, ‘Wallpaper’, ‘file’, ‘root’, 8, 9, ‘Wallpaper’, NULL);
INSERT INTO `txtpat1_txp_category` VALUES (82, ‘none’, ‘article’, ‘root’, 10, 11, ‘-none’, 0);
INSERT INTO `txtpat1_txp_category` VALUES (80, ‘Layouts’, ‘file’, ‘root’, 6, 7, ‘Layouts’, NULL);
INSERT INTO `txtpat1_txp_category` VALUES (81, ‘Internet’, ‘article’, ‘root’, 8, 9, ‘Internet’, 5);
INSERT INTO `txtpat1_txp_category` VALUES (78, ‘Avatars’, ‘file’, ‘root’, 2, 3, ‘Avatars’, NULL);
INSERT INTO `txtpat1_txp_category` VALUES (64, ‘root’, ‘article’, ‘inspire’, 1, 14, ‘root’, NULL);
INSERT INTO `txtpat1_txp_category` VALUES (68, ‘Sister-Sites’, ‘link’, ‘root’, 8, 9, ‘Sister Sites’, NULL);
INSERT INTO `txtpat1_txp_category` VALUES (69, ‘Goodies’, ‘file’, ‘root’, 4, 5, ‘Goodies’, NULL);
INSERT INTO `txtpat1_txp_category` VALUES (70, ‘Art-Gallery’, ‘image’, ‘root’, 2, 3, ‘Art Gallery’, NULL);
INSERT INTO `txtpat1_txp_category` VALUES (71, ‘Education’, ‘article’, ‘root’, 13986, 13987, ‘Education’, 1);
INSERT INTO `txtpat1_txp_category` VALUES (73, ‘Hobbies’, ‘article’, ‘root’, 13990, 13991, ‘Hobbies’, 4);
INSERT INTO `txtpat1_txp_category` VALUES (74, ‘inspire’, ‘article’, ‘root’, 6, 7, ‘Inspiration’, 3);
INSERT INTO `txtpat1_txp_category` VALUES (75, ‘Normal-Living’, ‘article’, ‘root’, 12, 13, ‘Living’, 6);
INSERT INTO `txtpat1_txp_category` VALUES (83, ‘doodle’, ‘image’, ‘root’, 4, 5, ‘doodle’, NULL);
INSERT INTO `txtpat1_txp_category` VALUES (84, ‘Original’, ‘image’, ‘root’, 8, 9, ‘Original’, NULL);
INSERT INTO `txtpat1_txp_category` VALUES (85, ‘Fan-Art’, ‘image’, ‘root’, 6, 7, ‘Fan Art’, NULL);
INSERT INTO `txtpat1_txp_category` VALUES (86, ‘WoW’, ‘image’, ‘root’, 12, 13, ‘WoW’, NULL);
INSERT INTO `txtpat1_txp_category` VALUES (87, ‘photo’, ‘image’, ‘root’, 10, 11, ‘photo’, NULL);
INSERT INTO `txtpat1_txp_category` VALUES (88, ‘Myako-Likes’, ‘link’, ‘root’, 4, 5, ‘Myako Likes!’, NULL);
INSERT INTO `txtpat1_txp_category` VALUES (89, ‘Affiliates’, ‘link’, ‘root’, 2, 3, ‘Affiliates’, NULL);
INSERT INTO `txtpat1_txp_category` VALUES (90, ‘Resources’, ‘link’, ‘root’, 6, 7, ‘Resources’, NULL);
INSERT INTO `txtpat1_txp_category` VALUES (91, ‘Gaming’, ‘article’, ‘root’, 13988, 13989, ‘Gaming’, 2);
INSERT INTO `txtpat1_txp_category` VALUES (92, ‘Work-in-Progress’, ‘article’, ‘root’, 0, 0, ‘Work in Progress’, NULL);
INSERT INTO `txtpat1_txp_category` VALUES (93, ‘test’, ‘article’, ‘root’, 0, 0, ‘test’, NULL);
INSERT INTO `txtpat1_txp_category` VALUES (94, ‘test1’, ‘article’, ‘root’, 0, 0, ‘test1’, NULL);
And I guess I should say a little more about my problem. When I make the categories, they do not show up under the “Article Categories” list in the “Categories” tab. They also don’t show up as a category to “Sort and Display” when I write an article. However, they DO show up in the list of categories on my main page. For example, the only categories I see now in the “Content > Categories” tab are: Inspiration (4), Internet (7), -none (0), and Living (4). On my blog it shows these: Education (3), Hobbies (1), Inspiration (4), Internet (7), and Living (4). (http://www.xinair.net)
Last edited by xoulone (2007-06-08 20:31:50)
Offline
Re: Not creating categories?
Hmm… what a mess.
Change this (in PHPmyadmin):
INSERT INTO `txtpat1_txp_category` VALUES (67, 'root', 'file', 'inspire', 1, 10, 'root', NULL);
INSERT INTO `txtpat1_txp_category` VALUES (66, 'root', 'image', 'inspire', 1, 14, 'root', NULL);
INSERT INTO `txtpat1_txp_category` VALUES (65, 'root', 'link', 'inspire', 1, 10, 'root', NULL);
INSERT INTO `txtpat1_txp_category` VALUES (64, 'root', 'article', 'inspire', 1, 14, 'root', NULL);Into:
INSERT INTO `txtpat1_txp_category` VALUES (67, 'root', 'file', '', 1, 10, 'root', NULL);
INSERT INTO `txtpat1_txp_category` VALUES (66, 'root', 'image', '', 1, 14, 'root', NULL);
INSERT INTO `txtpat1_txp_category` VALUES (65, 'root', 'link', '', 1, 10, 'root', NULL);
INSERT INTO `txtpat1_txp_category` VALUES (64, 'root', 'article', '', 1, 14, 'root', NULL);Change (in PHPmyadmin):
INSERT INTO `txtpat1_txp_category` VALUES (71, 'Education', 'article', 'root', 13986, 13987, 'Education', 1);
INSERT INTO `txtpat1_txp_category` VALUES (73, 'Hobbies', 'article', 'root', 13990, 13991, 'Hobbies', 4);Into:
INSERT INTO `txtpat1_txp_category` VALUES (71, 'Education', 'article', 'root', 2, 3, 'Education', 1);
INSERT INTO `txtpat1_txp_category` VALUES (73, 'Hobbies', 'article', 'root', 4, 5, 'Hobbies', 4);Delete these 4 rows in PHPmyadmin (you can add them again in TXP afterwards):
INSERT INTO `txtpat1_txp_category` VALUES (91, 'Gaming', 'article', 'root', 4, 5, 'Gaming', 2);
INSERT INTO `txtpat1_txp_category` VALUES (92, 'Work-in-Progress', 'article', 'root', 0, 0, 'Work in Progress', NULL);
INSERT INTO `txtpat1_txp_category` VALUES (93, 'test', 'article', 'root', 0, 0, 'test', NULL);
INSERT INTO `txtpat1_txp_category` VALUES (94, 'test1', 'article', 'root', 0, 0, 'test1', NULL);(Edit: fixed the quotes. -Mary)
Last edited by Mary (2007-06-08 22:32:38)
Offline
#6 2007-06-08 22:30:50
- xoulone
- New Member
- Registered: 2007-06-08
- Posts: 4
Re: Not creating categories?
Thank you SO much for spending the time to help me fix this problem. Things are now back to normal. I have one last question and hopefully it can be answered.
Do you think you can define what caused the entries to change? Or what started the problem in the first place? Maybe I can prevent this from happening again. If you don’t know what started it, then maybe its something I’ll have to be aware of in the future.
Thanks so much and I’m sorry for all of the trouble!
Offline
#7 2007-06-08 22:34:41
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: Not creating categories?
I haven’t been able to figure out the original cause, but once it starts it is self-perpetuating, due to how nesting categories works. A couple people have had the same kind of problem before.
Offline
#8 2007-06-08 22:38:39
- xoulone
- New Member
- Registered: 2007-06-08
- Posts: 4
Re: Not creating categories?
Alright, thanks for the response. If it ever does happen before, I think I have the general idea of how to fix it. Thanks again. :)
Offline
Re: Not creating categories?
It was a problem in version 4.0.3 that was fixed in 4.0.4, but once the table was corrupted, upgrading to 4.0.4 did not help because the damage was already done, so some manual intervention was needed. It’s very unlikely that you’ll have this problem again now that you’re using 4.0.4.
Last edited by ruud (2007-06-08 22:55:34)
Offline
Pages: 1