Problem with empty "Recent Posts" pages

By Boinng on 31 May 2006 at 15:55 UTC

I'm in the process of converting my Postnuke site to Drupal, using an assortment of code from the Postnuke Migration pages here to import data from my old nuke_ tables to the Drupal structure. Everything's actually gone pretty well - the forums are up and working, all the old news articles and comments are there, my old section articles are now Drupal pages - basically it's all fine, except for one minor irritation, which is the "Recent Posts" list.

Although everything seems present and correct in the list, the page count at the foot of the table is way out - ie, clicking the "last" link will take you to page 102, when in fact the list ends at around page 66, and everything after that is empty. The "my posts" and other user post tracking is similarly out of kilter, by varying degrees.

I'm supposing that at some point in my database hacking, I've upset a counter somewhere from which this page count is taken - but I've not found it so far. Can anyone point me in the right direction?

Comments

I get this too at times. I'd

green monkey commented 31 May 2006 at 17:55

I get this too at times. I'd have the correct about of pages in Recent Posts, but they are all blank.

Then suddenlty they start working again. But the pages that were not showing up -- continue not to display.

Yet, in admin>content they are all there.

I think its either a ModRewrite issue or another module is goofing them up.

Sorry this post doesn't help much, but I also wanted to track this issue.

Is this on a fresh install,

Boinng commented 1 June 2006 at 07:31

Is this on a fresh install, or another conversion? If it's something that's happening on Drupal sites generally I can live with it (tho it's annoying) - my worry is that I've messed something up in the database myself...

fresh installs and usually

green monkey commented 1 June 2006 at 08:12

fresh installs and usually within the first dozen posts, I've seen it in 4.6 and 4.7 ..... the only thing that remains constant is my host and I'm not seeing this error in the forums. The wierd thing is, when it does comes back, it never seems to break again.

cyber ghost thingy

I just did a fresh 4.7.1 install, lost "recent posts" after the 3rd post. But I know it will come back -- itd just a very odd thing. And as far as I can tell, I'm the only person seeing this -- so its got to be my host - I'm thinking.

But importing is a whole diferent story, I know this post doesn't address your issue or offer help, but like I said I wanted to track this -- just in case it offers any light on my ssue.

Well I fixed my own issue -

Boinng commented 1 June 2006 at 19:55

Well I fixed my own issue - this may or may not help you, but I found my problem was with the node_comment_statistics table in my database.

While I'd happily imported all my old content into nodes & node_revisions, and used a 'rebuild node_comment_statistics' script from this site to fill in that table, that only populated it with info on the nodes with comments attached to them. The node_comment_statistics table had no entries for those nodes which nobody had commented on, and it was those missing entries that translated into empty listings on the Recent Posts page.

The moral - make sure your node_comment_statistics table has an entry for every node - especially if you've been manually entering content like I have.