UBB.Developers Forums UBB.threads 7 Development How Do I? new posts not showing up

A few days ago the forum I administer went down. It is running ubbthreads 6.5.0. I fixed it by running "REPAIR TABLE w3t_posts". After that the forum pulled up fine. There is one section that is not showing any new posts. You can post in there but it will not show up. I am able to see that post in the w3t_posts table so I dont think they are missing from the table. Could the indexes be corrupt? Any advice for a newbie?

I would first check the forum Keyword to double check what it is set at.

Do you have phpMyAdmin installed? Very helpful tool to figure this type of stuff out.

Make sure the keyword you have set for the forum actually has posts with that same keyword, and if not, do a test. Post in the forum, then go into phpMyAdmin and see what keyword was assigned to your post in the w3t_Posts table.

Is there a way to rebuild the indexes?

You will have to drop each index in turn and then recreate it to do this.

ALTER TABLE tablename DROP INDEX indexname;
ALTER TABLE tablename ADD INDEX indexname (field1, field2, ...);

As an example I am using the w3t_AddressBook table:

ALTER TABLE w3t_AddressBook DROP INDEX address_ndx1;
ALTER TABLE w3t_AddressBook ADD INDEX address_ndx1 ( Add_Owner );

www.mysql.com will be your guide and ensure that the ADD INDEX is correct while creating the index because the one that you are working on might be a PRIMARY (and then the syntax changes).

I hope this helps.