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

XF 1.5 Data too long for column 'ignored'

Discussion in 'Troubleshooting and Problems' started by howarde, Jan 11, 2016.

  1. howarde

    howarde Member

    When trying to add a certain user as a super mod, we get this error:


  2. Xon

    Xon Well-Known Member

    This would require something like 500-1000 ignored users. I'm not surprised that it fails.
  3. howarde

    howarde Member

    Ok. Will check. Thanks.
  4. howarde

    howarde Member

    Oddly enough, I was able to add this person as an administrator, but not as a moderator?
  5. Mike

    Mike XenForo Developer Staff Member

    It's the act of displaying them as staff which prevents people from ignoring them. We've handled the length case in importing, but I may need to expand it to day to day use as well.

    It does require a user to ignore 1000+ users (note that in this case, it's that this user is being ignored by another who ignores huge numbers of people, not the other way around). You can identify this person via this query:
    SELECT user_id, COUNT(*) AS ignored
    FROM xf_user_ignored
    GROUP BY user_id
    ORDER BY ignored DESC
    LIMIT 20;
    The user ID listed first will almost certainly be the problem. (I'd be curious how many people they're ignoring.)

    The only way to stop them ignoring some people would be to remove some of those records from the database directly unfortunately.
    Xon likes this.
  6. howarde

    howarde Member

    OMG... it's 3699

    What's the easiest way to clean that out??
  7. Mike

    Mike XenForo Developer Staff Member

    It's a little strange, but you'll need to remove some records from xf_user_ignored for that user ID (based on the user_id column). I'd probably remove a few hundred. Alternatively, you can tell this user to remove people. It's a bit odd for someone productive to be ignoring 3700 people, but that may vary based on your forum.

    There isn't actually a great way to force a rebuild of the ignore cache for this user consistently, but if you toggle the "display as staff" option for a user this person is ignoring (which is what you did in the original post), it should rebuild it as necessary.
  8. howarde

    howarde Member

    As it turned out, the user with 3k ignores isn't the Mod, but someone else entirely. This particular user hasn't been active in 5 years and our Xenforo is still in Dev. We're migrating from VB hopefully this week.

    It doesn't make sense to me why
    a) This guy had ignored that many people (why even use the forums then)?
    b) Why this guy's ignores were blocking us from adding only this one (other) person as a mod

    I dumped his ignores in the VB DB so that they don't transfer over, and hopefully everything is kosher when I do the real migration.

    Thanks for the help.

Share This Page