• 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

#1
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?
 

Chris D

XenForo developer
Staff member
#3
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.
 

The Dark Wizard

Well-known member
#5
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.
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?
 

Jake Bunce

XenForo moderator
Staff member
#6
Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction - library/Zend/Db/Statement/Mysqli.php:214
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:
http://dev.mysql.com/doc/refman/5.0/en/innodb-parameters.html#sysvar_innodb_lock_wait_timeout
 

The Dark Wizard

Well-known member
#7