I still show unread messages, [Solved]

[shamroc]

Hi

I show unread messages, yet I have no messages that are still in my inbox that are unread. Can I reset this?

Cheers

[tmotley]

You could try this...

You can use phpmyadmin to browse phpbb_users and browse to your username, edit your pm unread messages to 0, OK.


Here's a link with more detail. http://www.integramod.com/forum/viewtop ... d+messages

[Michalis]

I have this problem too as my unread messages is a total of 65535. I must be popular hehehe

I am hoping a patch or fix will be out soon
as phpmyadmin is something I dont know how to use. I know all the team & scipt writers are busy, patients is what we have cause we love integramod. <img>

[tmotley]

It is very quick and simple to edit large unread messages numbers via phpmyadmin. If you have access to phpmyadmin, here's what to do. This takes just a few seconds on my setup.

1. Log into phpmyadmin
2. Select the correct database on the left
3. You should see a list of tables in the right pane. Look for the phpbb_users table and click the Browse button (your tables may have a different prefix)
4. There should be a Sort by key: dropdown for you to use above the list of users. Select user_unread_privmsgs (Descending) to put the really high unread messages at the top. Click Go.
5. Click edit next to the top name in the list (if it has a really high unread messages... you may have to scroll right) and simply edit the user_unread_privmsg to 0 and click Go.
6. Repeat for each user that has a really high unread private messages number.

[shamroc]

HI

PhpbBBadmin in General Configuration displayed nothing in the main window to edit. Not sure why.

[tmotley]

I was describing using the phpmyadmin via your website's control panel. Do you have access to that?

[Michalis]

I have finally fixed this & i am a first time user of the PHPMyAdmin too.

thanx for the advice that has been provided here. percentage came in very useful.


Even got to remove the unread messages in who is online block too.

[Michalis]

Heres a strange return.
even tho I keep fixing this in the database.
it keeps coming back after 4 or 5 days that i have 65335 messages. very unusual this.

could this be a bug or just plain human stupidity hehehe

[MWE_001]

There was an honest to god actual fix for this posted in the old Integramod archive site. I used it back about 4 years ago and it worked great. I would suggest a search there for more info.

[Michalis]

I had to do it again today rid the total messages.

[Helter]

you may search the original Integramod site using the "search archive" link in the "Board navigation" block on your left

[tmotley]

I searched the archive and found this that resets everyone's unread # to 0.

Code: Select all

UPDATE phpbb_users SET user_unread_privmsg = '0' ;

However, I'm wondering if doing that might cause the 65335 unread message issue? If I have 1 unread message and my unread messages get reset to 0, what does it go to when I read that 1 unread message?

There was also mention of a .script file the reset everyone's but it wasn't in the download area that I could see.

I'd say phpmyadmin is the quickest way...

[Allen]

I made some changes to my site the other night back to a portal_body.tpl and now I am showing 65535 unread messages. I have never seen this before. I have read this thread and I see php my admin mentioned but I also read that I will have to keep doing this every few days?

Is there a permanent fix? or should I just go back to the 3 collumn tpl??

[Helter]

acp/General Admin/DB Maintenance/Check private message tables

[Allen]

Thank You! SOLVED! Your Awesome, thanks for the reply.