1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'Troubleshooting and Problems' started by onthefly, Oct 15, 2010.

  1. onthefly

    onthefly Active Member

    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? :confused:
     
  2. borbole

    borbole Well-Known Member


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

    Code:
    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 likes this.
  3. onthefly

    onthefly Active Member

    Back up this table
    xf_user
    ?
     
  4. borbole

    borbole Well-Known Member


    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 likes this.
  5. onthefly

    onthefly Active Member

    Worked great, thanks so much!
     
    borbole likes this.
  6. borbole

    borbole Well-Known Member

    You are welcome. Glad to have been of help :)
     
    onthefly likes this.

Share This Page