XF 1.1 Issue with User Groups

[Toxic]

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 Dark Wizard]

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?

Users are only promoted if they have been active in the last 3 days.

 

[Chris D]

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.

 

[Toxic]

Thanks for the prompt replies!

 

[The Dark Wizard]

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]

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]

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

By how much should it be increased?