Rewrite Rules not working after server move

[winkiller]

Hey there,
I got one installation of s9y that I moved from another server and upgraded to 1.3.1. Now the categories- and feeds-Rewrites aren't working anymore. Neither .htaccess nor Apache errorhandling. Permalinks of entries are working fine btw.

I have a second installation on that machine, 1.3 - there it works. I doublechecked all VHost-settings, all php-settings, config in the admin interface. I also checked it to a 1.3.1 on another host, also working there.

Anyone got any hints how to debug this or where to look? Not too fond of endless fiddling in the index.php.

[garvinhicking]

Hi!

Did you move your installation as outlined in the FAQ? Meaning, only upgrading AFTER you moved the new instlalation? And not moving and upgrading in one step?

What does your .htaccess look like? What do you mean with "does not work"? Give your URL.

Regards,
Garvin

[winkiller]

Sorry for the noise, I got it solved now.

a) my bad: rewrite worked fine, the display of categories didn't work.
so *neither* /categories/11-foo nor /index.php?/categories/11-foo worked.

b) I had updated 1.1-beta5 (I think, according to configfile) to 1.3.1 and somehow the updater didn't execute db_update_1.2-alpha2_1.1-alpha3_mysql.sql

A simple manual

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);

fixed everything