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

XF 1.1 Issue with User Groups

Discussion in 'XenForo Questions and Support' started by Toxic, Mar 10, 2013.

  1. Toxic

    Toxic Member

    I wanted to create all Registered users to be added to another User group using Group Promotions, however when i run the Promotions cron job, it only seem to promote half of the users.

    is there a way of doing this via SQL Query?
  2. The Dark Wizard

    The Dark Wizard Well-Known Member

    Users are only promoted if they have been active in the last 3 days.
    Jake Bunce and Toxic like this.
  3. Chris D

    Chris D XenForo Developer Staff Member

    The reason for this is that it will only promote users who have been active within the last 3 days.

    So, you have two options...

    1) http://xenforo.com/community/threads/user-group-promotions.40847/#post-442977 (This will lead you to an updated file by Jake where if you replace the existing file on your server and remove the code Jake posted in red it will run the promotion regardless of their activity).

    2) Allow the users to be promoted once they become active.
    Jake Bunce and Toxic like this.
  4. Toxic

    Toxic Member

    Thanks for the prompt replies!
  5. The Dark Wizard

    The Dark Wizard Well-Known Member

    Hey I used Option 1 and now the cron doesn't stop because of memory but I do get connection timeouts and Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction - library/Zend/Db/Statement/Mysqli.php:214

    Any ideas?
  6. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    That's a server limit.

    If you have root access to the server then you can edit the my.cnf file (usually at /etc/my.cnf) to increase the value of innodb_lock_wait_timeout. Increasing that limit should avoid this error. If you don't have root access then you need to ask your host or server person to do this.

    For reference:
  7. The Dark Wizard

    The Dark Wizard Well-Known Member

    By how much should it be increased?

Share This Page