auto dismiss notifications

[plongeur.com]

I just tried it using the default vb bulletin theme and it still does work as expected...

[Mark.B]

I just tried it using the default vb bulletin theme and it still does work as expected...

Does...or doesn't?

[plongeur.com]

sorry.. does not...

[Wayne Luke]

Can you be more specific on what your expected behavior is? Visiting the topic should be enough to dismiss the notification.

However, this isn't reflected on a page that is already loaded and the Notification alert number in the header will not decrease until the page is reloaded. For most users, this behavior is sufficient because few people will open multiple tabs to view content on a site.

[plongeur.com]

As i understood expected behaviour is the notification to be dismissed once the page is visited.

On my instance the notification is only dismissed if you reply to the discussion. it stays there if you go on the disucssion, then leave and go back or refresh.

[Wayne Luke]

Are you using a CDN or a tool like Varnish?

[plongeur.com]

No, i do not use any caching system either... this is weird.

I will do some more testing tomorrow on my updated beta site and come back.

[plongeur.com]

OK, my test site is now fully UTF8 which is a good news (well you don't care but for me this is a relief ).

Now, what i am testing :
- I suscribe to a discussion
- with another account, i aswer to the discussion.
- the first account gets a notification
- i click on the "notification" button on the top bar and this takes me to the "private messages" page
- in the "notification preview" area, i click on the link to the discussion
- after reading the discussion, i go back to the forum home.

The notification is still present at the end.

I have the same behaviour on the default vbulletin style and on my own.
I have the same behaviour in french and in english
I have the same behaviour when i disable all hooks

[Mark.B]

There has to be some sort of caching going on. This simply doesn't happen on a default installation. I've used the system at least six times today already on various sites, and works exactly as it should.

[plongeur.com]

Is there any way it could a DB or config related issue ?

I honestly do not think there is any caching on my server but i will ask to the hoster just to make sure.

[plongeur.com]

OK, i took a look at the DB and it is definitely not a caching issue :

In the notification table, the "lastreadtime" column stays empty during my test.
If i put in a time right after the "lastsenttime", the notification goes away.

So for some reason, the "lastreadtime" column is not updated when it should be...

[Wayne Luke]

Is there any way it could a DB or config related issue ?

I honestly do not think there is any caching on my server but i will ask to the hoster just to make sure.

To delete the notification requires running a query on the database. If that query doesn't run properly, then yes. Do they dismiss without error when you click "Dismiss"?

What is the output of the query "show create table notification"?

You can try truncating the notification table and starting from scratch.

[plongeur.com]

I don not have any error when a dismiss the notification, nor when i just browse on/out of the concerned topic.

Here is the show create table notification on my instance :

CREATE TABLE `notification` (
`notificationid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`recipient` int(10) unsigned NOT NULL,
`sender` int(10) unsigned DEFAULT NULL,
`lookupid` varchar(150) DEFAULT NULL,
`lookupid_hashed` char(32) DEFAULT NULL,
`sentbynodeid` int(10) unsigned DEFAULT NULL,
`customdata` mediumtext,
`typeid` smallint(5) unsigned NOT NULL,
`lastsenttime` int(10) unsigned NOT NULL DEFAULT '0',
`lastreadtime` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`notificationid`),
UNIQUE KEY `guid` (`recipient`,`lookupid_hashed`),
KEY `recipient` (`recipient`),
KEY `lookupid_hashed` (`lookupid_hashed`),
KEY `lastsenttime` (`lastsenttime`),
KEY `lastreadtime` (`lastreadtime`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8

I also have a brand new fresh installed DB, here is the same on it :
CREATE TABLE `notification` (
`notificationid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`recipient` int(10) unsigned NOT NULL,
`sender` int(10) unsigned DEFAULT NULL,
`lookupid` varchar(150) DEFAULT NULL,
`lookupid_hashed` char(32) DEFAULT NULL,
`sentbynodeid` int(10) unsigned DEFAULT NULL,
`customdata` mediumtext,
`typeid` smallint(5) unsigned NOT NULL,
`lastsenttime` int(10) unsigned NOT NULL DEFAULT '0',
`lastreadtime` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`notificationid`),
UNIQUE KEY `guid` (`recipient`,`lookupid_hashed`),
KEY `recipient` (`recipient`),
KEY `lookupid_hashed` (`lookupid_hashed`),
KEY `lastsenttime` (`lastsenttime`),
KEY `lastreadtime` (`lastreadtime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

[Wayne Luke]

Are there any 500 or 404 errors listed in your http access log? Anything related to AJAX?

[plongeur.com]

We might be closing in on something, i have 2 warnings :

mod_fcgid: stderr: Warning: include_once(/var/www/vhosts/de2954.ispfr.net/beta.plongeur.com/forums/core/./includes/cron/queueprocessor.php): failed to open stream: No such file or directory in /var/www/vhosts/de2954.ispfr.net/beta.plongeur.com/forums/core/includes/functions_cron.php on line 250, referer: https://beta.plongeur.com/forums/

mod_fcgid: stderr: Warning: include_once(): Failed opening '/var/www/vhosts/de2954.ispfr.net/beta.plongeur.com/forums/core/./includes/cron/queueprocessor.php' for inclusion (include_path='.:/opt/plesk/php/7.0/share/pear') in /var/www/vhosts/de2954.ispfr.net/beta.plongeur.com/forums/core/includes/functions_cron.php on line 250, referer: https://beta.plongeur.com/forums/