PDA

View Full Version : Posts dont show after import db


S!p
11-26-2015, 04:55 PM
Hi, after import db from myBB old posts dont show in forumdisplay.php
On forumhome i can see last post and posts count, I can view all posts and search them.
Rebuild Forum and Threadas don`t help

Dave
11-26-2015, 05:20 PM
My guess is that the visible column in the thread and post table are set to 0.

Execute the following 2 queries individually:
UPDATE post SET visible = 1 WHERE visible = 0;
UPDATE thread SET visible = 1 WHERE visible = 0;

S!p
11-26-2015, 05:30 PM
UPDATE vb_post SET visible =1 WHERE visible =0;# mysql returned an empty result set (i.e. zero rows)
UPDATE vb_thread SET visible =1 WHERE visible =0;# mysql returned an empty result set (i.e. zero rows)

Thread Display Options
Show threads from the...

How to change defalout value to beginning?

#EDIT:

I found UPDATE forum SET daysprune=-1
and after querry -> Rebuild Forum Information

Thanks for help :)