Looks like you have solved the problem now, but I will add that any time you add things direct to the database, you should run the recalculation scripts in Admin > Stats.
"Recount posts" should take care of the pagination issue. "Reindex content" ensures that posts will appear in searches and related questions.
Note: if you have a lot of posts, reindexing takes a long time, unless you empty all the indexing tables (qa_words, qa_contentwords etc). Check the answer here for details.