Support ⇒ Troubleshootings ⇒ user has 65535 unread PMs, how did that happen? ⇒ Community Forums ⇒ CPG Dragonfly™ CMS
Forum IndexTroubleshootings

user has 65535 unread PMs, how did that happen? Reply to topic


Should changing the counter in database to unsigned help? I'm not sure, I haven't dig the issue.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
-


Or signed. Or that's not enough...


That was one pointless reply I made.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
-


I'm fairly think I tried both of those - in a thread discussing it some time back.

Olive Net
British Army
Royal Navy
Military Clothing and Equipment - This Tribe

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Slackware 12 / CentOS, PHP 5.6, MySQL 5, Apache 2


Can someone verify this?
In modules/Private_Messages/delete.php
after (line 117 in delete.php Revision: 9.10, DFCMS 9.21)
SET $type = $type - $dec WHERE user_id IN ($user_ids)");

add

$db->sql_query("UPDATE ".$user_prefix."_users SET $type = 0 WHERE user_id IN ($user_ids) AND ($type > 32768 OR $type < 0)");

Klas
.
My mice Terri & Tracy

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):


This is a workaround, a similar will be included to run during upgrades.

The proper fix is what I'm looking for ... it has to have something to do with the landing page, the private message popup or a combination of both ... probably in forums.

My landing page is the Forum and I do have this issue as well "65528" for me and I do have popup enabled. What about you?

.:: I met php the 03 December 2003 :: Unforgettable day! ::.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
CloudLinux / Apache 2.4 LSAPI / MySQLi 5.6 / PHP 5.6 / DCVS


I didn't have much active users on my site, so I never have had this problem. Someone on the german dragonflycms forum asked for this. Currently I only know that this happens, not when.

Klas
.
My mice Terri & Tracy

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):


After sooo long I might have found the issue.

1. user session get refresh every 30 seconds
2. so the "user_new_privmsgs" gets updated every 30 seconds

What if I "Read" the message straight away (before session gets updated)?

Can someone reproduce this?

.:: I met php the 03 December 2003 :: Unforgettable day! ::.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
CloudLinux / Apache 2.4 LSAPI / MySQLi 5.6 / PHP 5.6 / DCVS


I don't need to. That is the problem. See here.

Pro_News CM™ - Content Management for Dragonfly CMS™

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux / 1.3.39 - 2.4.9 / 5.5.42 - 5.6.16 / 5.4.37 - 5.5.11 / 9.4


Can you reproduce it now or it's still a "I believe"?

.:: I met php the 03 December 2003 :: Unforgettable day! ::.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
CloudLinux / Apache 2.4 LSAPI / MySQLi 5.6 / PHP 5.6 / DCVS


Smile Well even if I could it would still be my word ... Wink

As I said I saw this more than once. So knew what I was looking for the 2nd time. PM came in, I read instantly, and the 'null' In box count had afterwards changed downwards.

It would be tricky to re-stage.

Pro_News CM™ - Content Management for Dragonfly CMS™

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux / 1.3.39 - 2.4.9 / 5.5.42 - 5.6.16 / 5.4.37 - 5.5.11 / 9.4


FYI, still occurring in 9.4 although it displays as -1

I remain convinced that this is caused by reading a new PM BEFORE it gets flagged to you as arriving. Thus same message gets decremented 2 times.

Pro_News CM™ - Content Management for Dragonfly CMS™

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux / 1.3.39 - 2.4.9 / 5.5.42 - 5.6.16 / 5.4.37 - 5.5.11 / 9.4


I hopefully solved this in v10 on 2014-05-31 23:03:02 UTC
code.google.com/p/drag...p;name=v10

The problem is caused by multipe issues.
- session data not updated while online and new PM arrives
- incorrect decrement/increment

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Fedora 25 / Apache 2.4.27 / MariaDB 10.1.26 / PHP 7.1.10 / Mercurial


No hope for v9 then? Oh well ... Wink

Reset isn't hard through phpMyAdmin.

Pro_News CM™ - Content Management for Dragonfly CMS™

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux / 1.3.39 - 2.4.9 / 5.5.42 - 5.6.16 / 5.4.37 - 5.5.11 / 9.4

All times are UTC


Jump to: