categories not found problem

[^DJ_Link^]

Hi there!
I can assign a category to a post. I shows correctly on posts.
Thing is, when I click on the category link to show all post with that category it never shows anything, on the error_log it says page not found
you can see what i'm talking here: http://blog.differentpixel.com , just click on a category from a post and you'll see that it cant find anything

my .htaccess is the following:

# BEGIN s9y
ErrorDocument 404 /index.php
DirectoryIndex /index.php
#php_value session.use_trans_sid 0
#php_value register_globals off

RewriteEngine On
RewriteBase /
RewriteRule ^((archives/([0-9]+)-[0-9a-z\.\_!;,\+\-\%]+\.html)/?) index.php?/$1 [NC,L,QSA]
RewriteRule ^(authors/([0-9]+)-[0-9a-z\.\_!;,\+\-\%]+) index.php?/$1 [NC,L,QSA]
RewriteRule ^(feeds/categories/([0-9;]+)-[0-9a-z\.\_!;,\+\-\%]+\.rss) index.php?/$1 [NC,L,QSA]
RewriteRule ^(feeds/authors/([0-9]+)-[0-9a-z\.\_!;,\+\-\%]+\.rss) index.php?/$1 [NC,L,QSA]
RewriteRule ^(categories/([0-9;]+)-[0-9a-z\.\_!;,\+\-\%]+) index.php?/$1 [NC,L,QSA]
RewriteRule ^archives([/A-Za-z0-9]+)\.html index.php?url=/archives/$1.html [NC,L,QSA]
RewriteRule ^([0-9]+)[_\-][0-9a-z_\-]*\.html index.php?url=$1-article.html [L,NC,QSA]
RewriteRule ^feeds/(.*) index.php?url=/feeds/$1 [L,QSA]
RewriteRule ^unsubscribe/(.*)/([0-9]+) index.php?url=/unsubscribe/$1/$2 [L,QSA]
RewriteRule ^approve/(.*)/(.*)/([0-9]+) index.php?url=approve/$1/$2/$3 [L,QSA]
RewriteRule ^delete/(.*)/(.*)/([0-9]+) index.php?url=delete/$1/$2/$3 [L,QSA]
RewriteRule ^(admin|entries)(/.+)? index.php?url=admin/ [L,QSA]
RewriteRule ^archive/? index.php?url=/archive [L,QSA]
RewriteRule ^(index|atom[0-9]*|rss|b2rss|b2rdf).(rss|rdf|rss2|xml) rss.php?file=$1&ext=$2
RewriteRule ^(plugin|plugin)/(.*) index.php?url=$1/$2 [L,QSA]
RewriteRule ^search/(.*) index.php?url=/search/$1 [L,QSA]
RewriteRule ^comments/(.*) index.php?url=/comments/$1 [L,QSA]
RewriteRule ^(serendipity\.css|serendipity_admin\.css) index.php?url=/$1 [L,QSA]
RewriteRule ^index\.(html?|php.+) index.php?url=index.html [L,QSA]
RewriteRule ^htmlarea/(.*) htmlarea/$1 [L,QSA]
RewriteRule (.*\.html?) index.php?url=/$1 [L,QSA]

<Files *.tpl.php>
deny from all
</Files>

<Files *.tpl>
deny from all
</Files>

<Files *.sql>
deny from all
</Files>

<Files *.inc.php>
deny from all
</Files>

<Files *.db>
deny from all
</Files>

# END s9y

[garvinhicking]

Hi!

Did you upgrade serendipity at some point? If so, it seems you did not follow the upgrade requirements, it might have happened that your database structure does not contain all the proper database column fields.

We now need to make sure you properly upgrade your DB structure. From which version did you upgrade to which one?

(The FAQ also mentions how you can re-perform an upgrade, if you'd like to have a stab yourself)

Regards,
Garvin

[^DJ_Link^]

Hi!

Did you upgrade serendipity at some point? If so, it seems you did not follow the upgrade requirements, it might have happened that your database structure does not contain all the proper database column fields.

We now need to make sure you properly upgrade your DB structure. From which version did you upgrade to which one?

(The FAQ also mentions how you can re-perform an upgrade, if you'd like to have a stab yourself)

Regards,
Garvin

Well the last one I did was to 1.3.1 from 1.3.0 I think, but the problem comes from before that. I've even posted the problem here at the time but no one helped so I forgot about it. But lately I've began having lot's of visitors and I'm having lots of erros of the reports, so I want to fix this.
Could someone tell me what fields should I have on the categories table or were ever they are stored?

Everything else works perfectly

[garvinhicking]

Hi!

[qwuote] I've even posted the problem here at the time but no one helped so I forgot about it. [/quote]

Your profile shows no post related to this question...

But lately I've began having lot's of visitors and I'm having lots of erros of the reports, so I want to fix this.
Could someone tell me what fields should I have on the categories table or were ever they are stored?

Check if your category table has those fields:

* sort_order int(11)
* hide_sub int(1)

If not, you can create them with this SQL:

Code: Select all

ALTER TABLE serendipity_category ADD COLUMN sort_order int(11);
ALTER TABLE serendipity_category ADD COLUMN hide_sub int(1);
CREATE INDEX categoryso_idx ON serendipity_category (sort_order);

This update should have occured from s9y 1.2 to 1.3...

HTH,
Garvin

[^DJ_Link^]

Hi!

I've even posted the problem here at the time but no one helped so I forgot about it.

Your profile shows no post related to this question...

Maybe I'm mistaken with another forum. I'm preety sure i've posted it because at the time I had two problems and they solved me one. Sorry for the confusion.

Check if your category table has those fields:

* sort_order int(11)
* hide_sub int(1)

If not, you can create them with this SQL:

Code: Select all

ALTER TABLE serendipity_category ADD COLUMN sort_order int(11);
ALTER TABLE serendipity_category ADD COLUMN hide_sub int(1);
CREATE INDEX categoryso_idx ON serendipity_category (sort_order);

This update should have occured from s9y 1.2 to 1.3...

HTH,
Garvin

Worked =D Those fields were missing. Not it's properly working ehehe