|
|
|
|
| Re: Post count problems after migration [message #186698 is a reply to message #186697] |
Wed, 31 December 2014 11:58   |
 |
Shanga_BP
Messages: 7
Registered: December 2014
Karma: 0
|
Junior Member |
|
|
Yep, they probably are. But (excuse my ignorance) is there a way to approve/publish them from admin? I have no clue why they got the status changed on importing, all the 137k messages should've been active.
EDIT: Actually looking at the _MSG table, it has all the 137k rows. So the messages are clearly inside the db. But what key exactly need I look for that prevents them from showing up? I might try and run an SQL query to mass-approve them if I knew what to look for. I've checked the APR key and it's "1" for all of them.
[Updated on: Wed, 31 December 2014 13:07] Report message to a moderator |
|
|
|
|
|
|
|
| Re: Post count problems after migration [message #186702 is a reply to message #186701] |
Wed, 31 December 2014 23:54 |
|
Shanga_BP
Messages: 7
Registered: December 2014
Karma: 0
|
Junior Member |
|
|
Apr is set properly (i've run a mysql query and both 0 and NULL came out with zero results). It seems it's just the footer stats who are reporting strange numbers. I've also summed the individual user post counts (the new ones, after rebuilding them) and they do amount to 137k. So admin stats report the proper number, total user post counts sum up to 137k, that little box with stats keeps saying 70k... Maybe there's a different math behind it? It ignores certain forums?
And btw.. Happy New Year and thanks for creating an awesome piece of software (i am still getting the hang of it but I am starting to fall in love).
[Updated on: Wed, 31 December 2014 23:56] Report message to a moderator |
|
|
|
| Re: Post count problems after migration [message #186703 is a reply to message #186702] |
Thu, 01 January 2015 18:54 |
|
Shanga_BP
Messages: 7
Registered: December 2014
Karma: 0
|
Junior Member |
|
|
Oh my God...
After 4 days of hair pulling I finally solved the big mistery. It turns out the the footer statistics only take into account the index forums and completely ignore subforums. Why? Dunno. But I had a hunch when I saw unlogged users have different post count from logged users. And I moved a subforum up to index... and bingo 3k more posts showed up on the "Our users have posted a total of..." message.
Talk about a storm in a glass. Btw, although I do appreciate the dynamic factor of the footer count, I think not counting subforums is kinda annoying. Any idea where I can alter this function?
[Updated on: Thu, 01 January 2015 18:54] Report message to a moderator |
|
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]