XF 1.1 Issue with User Groups

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?
 
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 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?
 
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
 
Top Bottom