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

Fixed Huge load time when updating usergroup's permissions

A

account8226

Guest
#1
Hello,

When I update my members usergroups (more than 200K members), it's taking ages, and after like 30 seconds I got the following error :
Fatal error: Maximum execution time of 30 seconds exceeded in /home/darnkzz55/public_html/library/Zend/Db/Adapter/Mysqli.php on line 110
I'm on a dedicated server with 8GB ram. I don't know how it's working, but I think XenForo is updating every user's permission combination ID field, so that's why it's taking ages ?
 

Mike

XenForo developer
Staff member
#2
Not exactly, but it is updating a lot of records. 1.2 handles this rebuilt a bit differently so it can be broken up but it still can be an extensive process.

In the mean time, you may just want to increase your PHP timeout.
 
A

account8226

Guest
#3
Not exactly, but it is updating a lot of records. 1.2 handles this rebuilt a bit differently so it can be broken up but it still can be an extensive process.

In the mean time, you may just want to increase your PHP timeout.
Great thanks for the awnser, but since there was this PHP error, do you think every members permissions were updated ?
 
A

account8226

Guest
#6
Not exactly, but it is updating a lot of records. 1.2 handles this rebuilt a bit differently so it can be broken up but it still can be an extensive process.

In the mean time, you may just want to increase your PHP timeout.
I can confirm this as fixed in 1.2. I can know update more than 150k members' permissions a lot quicker (like 10 seconds).