No announcement yet.

Move / Prune User SQL Error Bug??

  • Filter
  • Time
  • Show
Clear All
new posts

  • Move / Prune User SQL Error Bug??

    When trying to Move Prune Users from Usergroup Manager i.e from Users Waiting for confirmation I get the following Error message
    The Query being generated as below

    Error Invalid SQL: SELECT DISTINCT user.userid, username, email, posts, lastactivity, joindate, user.usergroupid, moderator.moderatorid, usergroup.title FROM user AS user LEFT JOIN moderator AS moderator ON(moderator.userid = user.userid) LEFT JOIN usergroup AS usergroup ON(usergroup.usergroupid = user.usergroupid) WHERE user.usergroupid = 3AND lastactivity < 1538221505 GROUP BY user.userid ORDER BY username ASC;

    I think the problematic code maybe the one highlighted in Red, but when i try to run this query in SQL Manager and putting a space between the 3 AND
    the query runs however from there cant perform the move action

    is this a bug

  • #2
    Yes, was about to report the same problem. Worked fine in 5.5.3. Not sure whether it broke in 5.5.4 or Patch 1
    VB 5.5.5
    PHP 7.2
    MySQL 5.7.24


    • #3
      Ahh okay great atleast its not just me!


      • #4
        This issue will be resolved in vBulletin 5.5.5.
        Translations provided by Google.

        Wayne Luke
        The Rabid Badger - a vBulletin Cloud demonstration site.
        vBulletin 5 API - Full / Mobile
        Vote for your favorite feature requests and the bugs you want to see fixed.


        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.