Since the import from SMF to VB3 to Xen....

[onthefly]

Any member that has a message in there inbox before the import now has an alert for each message, so if I had 130 messages in my inbox before the import I have 130 alerts. How do I reset the alerts back to zero for all members?

 

[borbole]

Any member that has a message in there inbox before the import now has an alert for each message, so if I had 130 messages in my inbox before the import I have 130 alerts. How do I reset the alerts back to zero for all members?

That is probably because the conversations are set as unread. Try this. At phpmyadmin, run the following query.

UPDATE `xf_user` SET conversations_unread = 0;

This will take care to turn all the conversations as read so no alerts will be displayed.

2 things to note. First make a thorough backup of the user table before you run the query and if your db tables use a custom prefix then you should use that instead of the xenforo''s default prefix (xf_ ) . Hope it helps.

 

[onthefly]

Try this. At phpmyadmin, run the following query.

UPDATE `xf_user` SET conversations_unread = 0;

This will take care to turn all the conversations as read so no alerts will be displayed.

2 things to note. First make a thorough backup of the user table before you run the query and if your db tables use a custom prefix then you should use that instead of the xenforo''s default prefix (xf_ ) . Hope it helps.

Back up this table
xf_user
?

 

[borbole]

Back up this table
xf_user
?

Yes, because that is the table that will be affected by the query. It is not really necessary for a query like this, but it is always betst to backup the db prior to making changes to it.

 

[onthefly]

Worked great, thanks so much!

 

[borbole]

Worked great, thanks so much!

You are welcome. Glad to have been of help