[apokphp]

I'm on a shared server. I have installed successfully. I'm trying to recount.

I can recount all options except Update Experience points.

I have about 4,500 members. I'm starting with userid 1. The default is 150 per cycle. I continue to get a sql error:

Database error in vBulletin 4.0.5:

Invalid SQL:
SELECT
P.userid, COUNT(userid) AS times
FROM thread AS T
INNER JOIN post AS P ON T.lastpostid=P.postid
WHERE P.userid=1
GROUP BY P.userid
ORDER BY P.dateline DESC, P.userid;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Monday, August 2nd 2010 @ 04:53:21 AM
Error Date : Monday, August 2nd 2010 @ 04:54:03 AM
Script : http://www.onlinedebate.net/forums/a...min_recount_xp
Referrer : http://www.onlinedebate.net/forums/a...php?do=recount
IP Address : xxxx
Username : Apokalupsis
Classname : vB_Database
MySQL Version :

I've reduced the # per cycle down to 1. It doesn't matter what I put in there for # per cycle, I just can't update the points via recount. With my host...the longest that a query can run, is 15 secs. Anything after that will timeout.

What are some solutions? If I can't update my 7 year old board to take into account all the posts and activity my members have...then I don't think this mod will work right and I should just uninstall...right?