Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: DieGoO on September 26, 2013, 11:31:29 AM

Title: Unread Replies - Empty Results
Post by: DieGoO on September 26, 2013, 11:31:29 AM
This happened when we upgraded from 2.0.3 to 2.0.5 ..

?action=unreadreplies shows nothing.. even though there ARE new replies to topics that i created.. Any ideas on how to fix this?
Title: Re: Unread Replies - Empty Results
Post by: kat on September 26, 2013, 11:41:06 AM
Tried emptying the forum's cache, in Forum Maintenance?
Title: Re: Unread Replies - Empty Results
Post by: DieGoO on September 26, 2013, 11:47:14 AM
Quote from: K@ on September 26, 2013, 11:41:06 AM
Tried emptying the forum's cache, in Forum Maintenance?
Yes, but nothing changed..
Title: Re: Unread Replies - Empty Results
Post by: DieGoO on September 27, 2013, 08:17:09 AM
Anyone?
Title: Re: Unread Replies - Empty Results
Post by: margarett on September 27, 2013, 09:27:48 AM
I would tell you to mark everything as read so that you "start over". If, after that, you still miss replies, we can have another look at it.
Title: Re: Unread Replies - Empty Results
Post by: DieGoO on September 27, 2013, 10:07:19 AM
Quote from: margarett on September 27, 2013, 09:27:48 AM
I would tell you to mark everything as read so that you "start over". If, after that, you still miss replies, we can have another look at it.
I already did that as well, but it is still showing nothing.. and there are new replies to my threads
Title: Re: Unread Replies - Empty Results
Post by: margarett on September 27, 2013, 10:25:01 AM
Can you get us a test user (normal user, non admin)?
Please let me know a board to post a test topic. You will then reply to it ;)
Title: Re: Unread Replies - Empty Results
Post by: DieGoO on September 27, 2013, 10:31:03 AM
Quote from: margarett on September 27, 2013, 10:25:01 AM
Can you get us a test user (normal user, non admin)?
Please let me know a board to post a test topic. You will then reply to it ;)
Login -> Testuser
Pass -> 123123

You can post it here : http://www.usinavirtual.com/portal/forum/index.php?board=22.0

The forum is in portuguese, but looking at your signature i guess that wont be a problem :P
Title: Re: Unread Replies - Empty Results
Post by: margarett on September 27, 2013, 10:51:53 AM
Quote from: DieGoO on September 27, 2013, 10:31:03 AM
The forum is in portuguese, but looking at your signature i guess that wont be a problem :P
:P Eheeheh yes.
Done, please give me a "hello" there ;)
Title: Re: Unread Replies - Empty Results
Post by: DieGoO on September 27, 2013, 10:55:31 AM
Quote from: margarett on September 27, 2013, 10:51:53 AM
Quote from: DieGoO on September 27, 2013, 10:31:03 AM
The forum is in portuguese, but looking at your signature i guess that wont be a problem :P
:P Eheeheh yes.
Done, please give me a "hello" there ;)
Done ^^
Title: Re: Unread Replies - Empty Results
Post by: margarett on September 27, 2013, 10:58:51 AM
No problems at all, as far as I see. Look at the attachment, I clicked Respostas (http://www.usinavirtual.com/portal/forum/index.php?action=unreadreplies) and I got yours...
Title: Re: Unread Replies - Empty Results
Post by: DieGoO on September 27, 2013, 11:04:19 AM
Quote from: margarett on September 27, 2013, 10:58:51 AM
No problems at all, as far as I see. Look at the attachment, I clicked Respostas (http://www.usinavirtual.com/portal/forum/index.php?action=unreadreplies) and I got yours...
Well, on mine it shows nothing.. How is that even possible? :o
Title: Re: Unread Replies - Empty Results
Post by: margarett on September 27, 2013, 11:09:56 AM
Errmmm... The way the "new"/"not new" topic works is not very "straight"...

If you try ?action=unreadreplies;all;start=0

Does it show something?
Title: Re: Unread Replies - Empty Results
Post by: DieGoO on September 27, 2013, 11:21:25 AM
Quote from: margarett on September 27, 2013, 11:09:56 AM
Errmmm... The way the "new"/"not new" topic works is not very "straight"...

If you try ?action=unreadreplies;all;start=0

Does it show something?
Yeah.. It shows all unread posts, not just from topics i replied to..

I think i just confirmed something..

Recently , we had a problem in the database where some users were deleted (me included).. we had a backup and restored those accounts. The accounts that were deleted and got restored are apparently the only ones having problems with the unread replies.. Anything to do in this case?
Title: Re: Unread Replies - Empty Results
Post by: margarett on September 27, 2013, 12:12:36 PM
Did you restore just those members from "smf_members" table (kind of a "merge" operation) or did you restore the whole database?

If you restored the members (thus messing with the tables) it's very likely you should expect issues... Was this the case?
If it is, then I'm afraid this is now out of my league, sorry :(
Title: Re: Unread Replies - Empty Results
Post by: DieGoO on September 27, 2013, 12:20:08 PM
Quote from: margarett on September 27, 2013, 12:12:36 PM
Did you restore just those members from "smf_members" table (kind of a "merge" operation) or did you restore the whole database?

If you restored the members (thus messing with the tables) it's very likely you should expect issues... Was this the case?
If it is, then I'm afraid this is now out of my league, sorry :(
We restored just the smf_members table.. 

So.. i guess this can't be solved?
Title: Re: Unread Replies - Empty Results
Post by: margarett on September 27, 2013, 12:30:16 PM
I'm not sure, sorry...

The thing is, when you removed the users, the table "log_mark_read" (at least) had the respective rows, related to those users, also removed. So, it's very likely you do not get notifications about existing topics. Nevertheless, I believe new ones should be added. But now I'm just guessing...

edit: Can you try the maintenance tasks => "Find and repair any errors" and "Recount all forum totals and statistics"?
Title: Re: Unread Replies - Empty Results
Post by: Kindred on September 27, 2013, 01:18:59 PM
the problem with restoring just one table (or even worse, just one row in a table) is that SMF, like many other programs, has data spread between multiple tables and restoring one does not restore the necessary data in the other tables