vB 3.7 error with database when generating sitemap

OK, thanks

No problem

My hosting company emailed me this:

We tried the scripts in the message you provide and it running without problem:

mysql> SELECT count(*) as cnt
-> ,max(views) as maxv,avg(views) as avgv
-> ,max(replycount) as maxre,avg(replycount) as avgre
-> FROM vb_thread
-> WHERE forumid = 45
-> AND visible = 1;
+------+------+----------+-------+--------+
| cnt | maxv | avgv | maxre | avgre |
+------+------+----------+-------+--------+
| 3742 | 9037 | 261.5436 | 156 | 7.1406 |
+------+------+----------+-------+--------+
1 row in set (0.04 sec)

We did not have the permission to run it from web so you may need to contact vBulletin support.
Please let us know if you need further assistance.


Now what?

Again, this is a long running process to generate all URLs so the host just needs to increase the value so it can get through the entire generation.