UseBB Community

Hello,

I just installed the board, created forums, and added some posts--all working OK. Took a break, came back, added more posts. Now, posts appear as normal in the forum wher they are posted, but on the home page Topics and Posts remain at 0 and Latest Post constinues to show No Posts. Any ideas on what's wrong? I am not a knowledgeable MySQL user. Version and server details appear below.

TIA,
Ardal

* UseBB version: 1.0.2 (Version Check)
* PHP version: 4.4.2
* SQL server driver: MySQL/4.1.21-log
* HTTP server: Apache/1.3.37 (Unix) (Gentoo) FrontPage/5.0.2.2634 ApacheJServ/1.1.2 mod_auth_pam/1.1.1
* Operating system: Linux
* Server load values: 2.57, 2.78, 2.81

More info: I ran the following query from PHP MyAdmin, and it returned what appear to be the correct results. Those are still not being displayed by index.php, however.

SELECT f.id, f.name, f.descr, f.status, f.topics, f.posts, f.auth, f.hide_mods_list, c.id AS cat_id, c.name AS cat_name, t.topic_title, t.last_post_id, t.count_replies, p.poster_id, p.poster_guest, p.post_time, u.displayed_name AS poster_name, u.level AS poster_level
FROM (
(
(
usebb_forums f
LEFT JOIN usebb_topics t ON f.last_topic_id = t.id
)
LEFT JOIN usebb_posts p ON t.last_post_id = p.id
)
LEFT JOIN usebb_members u ON p.poster_id = u.id
), usebb_cats c
WHERE f.cat_id = c.id
ORDER BY c.sort_id ASC , c.name ASC , f.sort_id ASC , f.name ASC
LIMIT 0 , 30

Solultion: I uploaded index.php again. The posts are now showing up as expected.