Looks like getting backup again from the old host did the trick. Might as well close this topic 
1 2007-06-16 23:14
Re: Problem viewing old topics after host change (9 replies, posted in PunBB 1.2 troubleshooting)
2 2007-06-16 21:18
Topic: Problem viewing old topics after host change (9 replies, posted in PunBB 1.2 troubleshooting)
Hi
Like the topic says I changed from old host to new one. I did take backup from the punbb db with the backup plugin. After importing the data and modifying the config files to use right database everything looked fine.
However in the forum view it does show the topic name but it doesnt show reply/view/last post for that thread and when I try to view those threads it will display the following message.
Bad request. The link you followed is incorrect or outdated.
Making new thread(s) and displaying them works just fine.
Here's the debug information I get when I try to view topic
0.00067 SELECT u.*, g.*, o.logged, o.idle FROM users AS u INNER JOIN groups AS g ON u.group_id=g.g_id LEFT JOIN online AS o ON o.user_id=u.id WHERE u.id=49
0.00052 UPDATE online SET logged=1182028507 WHERE user_id=49
0.00014 SELECT * FROM online WHERE logged<1182028207
0.00037 SELECT t.subject, t.closed, t.num_replies, t.sticky, f.id AS forum_id, f.forum_name, f.moderators, fp.post_replies, s.user_id AS is_subscribed FROM topics AS t INNER JOIN forums AS f ON f.id=t.forum_id LEFT JOIN subscriptions AS s ON (t.id=s.topic_id AND s.user_id=49) LEFT JOIN forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id=1) WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND t.id=449 AND t.moved_to IS NULL
0.00009 SELECT COUNT(id) FROM reports WHERE zapped IS NULL
0.00007 SELECT COUNT(id) FROM messages WHERE showed=0 AND owner=49
Total query time: 0.00186 sI have no idea what's wrong so I came to seek help from here.
The server is running php 5.1.6 and mysql 5