by demetris20 » October 11th 2011, 5:49 pm i need your help urgent
my board have been messed up
as a rookie i install a mod and i didnt make a backup so my board have been messed up
all the topic have been disappear
i check my sql tables and the posts are there but all of the members have 0 posts and the posts are not appear
so i decided to make some experiment to see something
so i have a section called news and all the posts there are made by me and no one has reply as the section is locked
so i run the following sql command
UPDATE phpbb_posts SET `poster_id` = (my poster id0 WHERE `forum_id` = (the forum id of that section);
all the posts start appearing in that section so i went to acp and Resynchronise the post counts
after that i went to my profile and i saw that i have x number of post so it work
but i cant do that for all the sections as different members make a post
i dont know if there is a way to fix it someway either by combining the 2 tables as topics tables seems in order but only the post table is messed up
any help will really appreciated
thanks
demetris20
ps here are 2 screenshots to understand what i mean
screenshots of what i see when i click to a topic
example 1
after clicking on a post this is what i am see
