Previous Thread
Next Thread
Print Thread
Hop To
Joined: Jul 2007
Posts: 70
journeyman
journeyman
Joined: Jul 2007
Posts: 70
Your Private Messages

It keep Flashing telling me I have a private message however there is no NEW message.

I have empty the cache rebuilt all messages, topic, PM and it still telling me I have a new message.

I had a admin PM me and they removed there account it removed the message however I still see the flashing you have new mail.

I have also removed the message from MYSQL with no joy

Any help would be great!


Best Regards

Danny de Hek - Below is our Office Cam Image

[Linked Image from newzealandnz.co.nz]
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
This was a old issue that was addressed in the 7.5x series. Which you have so I would suggest open a support ticket so Rick can take a look at it.
I don't know why you would delete a message in the tables. But you may try the "Content rebuilder" in the ubb control panel now, to see if it corrects the problem.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Feb 2007
Posts: 1,294
Likes: 2
Veteran
Veteran
Joined: Feb 2007
Posts: 1,294
Likes: 2
You would think that a public fix would be done or at least the file responsible for the problem released as so those who do not wish to upgrade to 8.0 will not have to wait for a fix not just put in a ticket on a one by one basis.

Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
I think that the mysql query has been posted on the forums that would mark all pt's read for specific users.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Feb 2007
Posts: 1,294
Likes: 2
Veteran
Veteran
Joined: Feb 2007
Posts: 1,294
Likes: 2
Why not just fix the problem? Issue a bug release? Not worth the time for a real fix over a SQL injection? We have seen this reported several times. Same old some old not just with this problem but many others.

I have been reading all the not so final fixes for the bugs in version 7 and even see a recurring problem now effecting sites on THIS server.

Now I totally understand that you can not always bug test or make everything compatible for every server out there but it is hilarious that a existing problem is still seen on the creators OWN server. This is said to be a completable issue with a certain function on the server?

Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Well it was supposed to have been fixed in v7.5 (according to the latest bug report); when a user logs back in it's supposed to update...

The query i mentioned was just pointing that this issue has come up before so there is a temp fix to aid your users if the v7.5 addition doesn't work for them.



I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Jul 2007
Posts: 70
journeyman
journeyman
Joined: Jul 2007
Posts: 70
So what table is it? were this information is keeped?

Or anyone go the mysql query to re-set to all read?


Best Regards

Danny de Hek - Below is our Office Cam Image

[Linked Image from newzealandnz.co.nz]
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
Found the topic for clearing PM's
HERE
It was for version 7.3


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
We have made a couple of attempts to fix this. In fact, when you initially login now it does a complete check of the PMs with your ID attached to it and checks to see if any posts actually exist with the topic. In most cases this has fixed it for those that have upgraded and have had the problem, it just requires a direct login and logout.

Joined: Jul 2007
Posts: 70
journeyman
journeyman
Joined: Jul 2007
Posts: 70
I have emptied my cookies and re-logged in with no joy.

The message was from another admin who deleted there account as I was about to reply if that help ;-)

I will tried logging it from another computer.



Best Regards

Danny de Hek - Below is our Office Cam Image

[Linked Image from newzealandnz.co.nz]
Joined: Jul 2007
Posts: 70
journeyman
journeyman
Joined: Jul 2007
Posts: 70
Quote
The quickest/easiest way to fix this is to mark every PM as read for that particular user. You'll need the userid and the current time in seconds, for example: 1213616430 is the current time.

update ubbt_PRIVATE_MESSAGE_USERS
set MESSAGE_LAST_READ='1213616430'
where USER_ID='#'

Replace # with the userid in question.

I tried that and it did not work for me?

So I when into ubbt_USER_PROFILE and edit my userID and edited USER_TOTAL_PM from 5 to 0 (after I removed all PM messages)

Looked to have worked or the world is about to blow up!


Best Regards

Danny de Hek - Below is our Office Cam Image

[Linked Image from newzealandnz.co.nz]
Joined: Jul 2007
Posts: 70
journeyman
journeyman
Joined: Jul 2007
Posts: 70
I ran this again

update ubbt_PRIVATE_MESSAGE_USERS
set MESSAGE_LAST_READ='1248380858'
where USER_ID='#'

And used a new web browser and it worked!! bloody caching (firefox)


Best Regards

Danny de Hek - Below is our Office Cam Image

[Linked Image from newzealandnz.co.nz]
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
Firefox is one of the easier browsers to clear cache.
But darn browsers cache systems seem to get in the way sometimes.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
1 members (Ruben), 476 guests, and 111 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)