Vbseo Sitemap Generator gives error.

I am manually trying to run the sitemap generator and it gives a database error after following:

Code:

[homepage] [5,834.1Kb mem used] [0s (+0s)]
[SECTION START] forumdisplay [5,834.1Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 81, total threads: 0, pages: 1 [5,834.2Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 70, total threads: 0, pages: 1 [5,844.4Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 144, total threads: 0, pages: 1 [5,846.0Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 129, total threads: 474, pages: 16 [5,848.1Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 95, total threads: 185, pages: 7 [5,864.6Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 96, total threads: 48, pages: 2 [5,873.8Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 106, total threads: 66, pages: 3 [5,878.2Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 89, total threads: 34, pages: 2 [5,883.6Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 145, total threads: 0, pages: 1 [5,888.4Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 118, total threads: 107, pages: 4 [5,892.1Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 119, total threads: 246, pages: 9 [5,898.6Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 120, total threads: 92, pages: 4 [5,917.0Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 121, total threads: 68, pages: 3 [5,930.6Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 122, total threads: 46, pages: 2 [5,940.1Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 146, total threads: 0, pages: 1 [5,944.3Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 108, total threads: 280, pages: 10 [5,947.3Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 109, total threads: 266, pages: 9 [5,961.3Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 77, total threads: 1457, pages: 49 [5,973.6Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 110, total threads: 313, pages: 11 [6,023.3Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 111, total threads: 1786, pages: 60 [6,040.8Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 112, total threads: 263, pages: 9 [6,100.2Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 113, total threads: 193, pages: 7 [6,118.9Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 127, total threads: 789, pages: 27 [6,127.8Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 84, total threads: 1170, pages: 39 [6,154.5Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 82, total threads: 218, pages: 8 [6,197.4Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 147, total threads: 0, pages: 1 [6,213.6Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 115, total threads: 126, pages: 5 [6,218.6Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 114, total threads: 116, pages: 4 [6,222.5Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 116, total threads: 181, pages: 7 [6,228.2Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 83, total threads: 3557, pages: 119 [6,236.0Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 117, total threads: 214, pages: 8 [6,358.9Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 123, total threads: 141, pages: 5 [6,376.6Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 124, total threads: 154, pages: 6 [6,383.5Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 125, total threads: 111, pages: 4 [6,390.6Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 128, total threads: 3565, pages: 119 [6,396.6Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 73, total threads: 667, pages: 23 [5,991.9Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 126, total threads: 467, pages: 16 [6,018.1Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 74, total threads: 227, pages: 8 [6,038.4Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 148, total threads: 0, pages: 1 [6,050.1Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 92, total threads: 280, pages: 10 [6,055.1Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 91, total threads: 652, pages: 22 [6,062.8Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 76, total threads: 1649, pages: 55 [6,085.8Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 88, total threads: 305, pages: 11 [6,142.1Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 93, total threads: 30, pages: 1 [6,163.2Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 94, total threads: 30, pages: 1 [6,169.5Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 149, total threads: 0, pages: 1 [6,171.8Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 79, total threads: 469, pages: 16 [6,174.4Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 103, total threads: 184, pages: 7 [6,188.4Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 104, total threads: 196, pages: 7 [6,199.2Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 105, total threads: 167, pages: 6 [6,208.5Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 107, total threads: 117, pages: 4 [6,216.6Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 150, total threads: 0, pages: 1 [6,222.8Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 99, total threads: 1140, pages: 38 [6,227.5Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 101, total threads: 54, pages: 2 [6,263.1Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 100, total threads: 71, pages: 3 [6,275.0Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 102, total threads: 24, pages: 1 [6,278.8Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 85, total threads: 933, pages: 32 [6,282.8Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 87, total threads: 269, pages: 9 [6,311.3Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 151, total threads: 0, pages: 1 [6,327.1Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 97, total threads: 32, pages: 2 [6,332.6Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 98, total threads: 16, pages: 1 [6,335.5Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 130, total threads: 38, pages: 2 [6,338.7Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 131, total threads: 24, pages: 1 [6,341.3Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 75, total threads: 179, pages: 6 [6,344.4Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 152, total threads: 0, pages: 1 [6,349.7Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 132, total threads: 4926, pages: 165 [6,355.0Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 133, total threads: 240, pages: 8 [5,989.4Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 134, total threads: 236, pages: 8 [5,999.2Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 135, total threads: 379, pages: 13 [6,011.6Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 136, total threads: 1332, pages: 45 [6,031.6Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 137, total threads: 1004, pages: 34 [6,077.2Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 138, total threads: 798, pages: 27 [6,119.9Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 139, total threads: 418, pages: 14 [6,155.8Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 140, total threads: 881, pages: 30 [6,174.6Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 141, total threads: 592, pages: 20 [6,205.9Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 142, total threads: 403, pages: 14 [6,231.8Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 143, total threads: 389, pages: 13 [6,249.6Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 15, total threads: 0, pages: 1 [6,265.1Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 16, total threads: 146, pages: 5 [6,272.2Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 17, total threads: 198, pages: 7 [6,276.8Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 18, total threads: 297, pages: 10 [6,287.7Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 24, total threads: 331, pages: 12 [6,299.2Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 37, total threads: 0, pages: 1 [6,314.0Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 38, total threads: 2987, pages: 100 [6,320.2Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 40, total threads: 3167, pages: 106 [6,419.6Kb mem used] [1s (+1s)]
[forumdisplay] forum_id: 42, total threads: 1264, pages: 43 [6,537.1Kb mem used] [1s (+0s)]
[forumdisplay] forum_id: 39, total threads: 237, pages: 8 [6,041.4Kb mem used] [1s (+0s)]
[forumdisplay] forum_id: 41, total threads: 561, pages: 19 [6,061.4Kb mem used] [1s (+0s)]
[forumdisplay] forum_id: 6, total threads: 0, pages: 1 [6,081.2Kb mem used] [1s (+0s)]
[forumdisplay] forum_id: 14, total threads: 236, pages: 8 [6,085.8Kb mem used] [1s (+0s)]
[forumdisplay] forum_id: 11, total threads: 327, pages: 11 [6,094.4Kb mem used] [1s (+0s)]
[forumdisplay] forum_id: 46, total threads: 2761, pages: 93 [6,109.9Kb mem used] [1s (+0s)]
[forumdisplay] forum_id: 10, total threads: 415, pages: 14 [6,212.6Kb mem used] [1s (+0s)]
[forumdisplay] forum_id: 54, total threads: 98, pages: 4 [6,234.1Kb mem used] [1s (+0s)]
[forumdisplay] forum_id: 30, total threads: 0, pages: 1 [6,242.6Kb mem used] [1s (+0s)]
[forumdisplay] forum_id: 32, total threads: 3166, pages: 106 [6,245.6Kb mem used] [1s (+0s)]
[forumdisplay] forum_id: 33, total threads: 2559, pages: 86 [6,359.6Kb mem used] [1s (+0s)]
[forumdisplay] forum_id: 43, total threads: 2374, pages: 80 [6,456.2Kb mem used] [1s (+0s)]
[forumdisplay] forum_id: 34, total threads: 597, pages: 20 [6,545.5Kb mem used] [1s (+0s)]
[forumdisplay] forum_id: 31, total threads: 982, pages: 33 [6,571.4Kb mem used] [1s (+0s)]
[forumdisplay] forum_id: 19, total threads: 0, pages: 1 [6,054.8Kb mem used] [1s (+0s)]
[forumdisplay] forum_id: 7, total threads: 506, pages: 17 [6,063.4Kb mem used] [1s (+0s)]
[forumdisplay] forum_id: 20, total threads: 49, pages: 2 [6,084.8Kb mem used] [1s (+0s)]
[forumdisplay] forum_id: 5, total threads: 581, pages: 20 [6,089.4Kb mem used] [1s (+0s)]
[forumdisplay] forum_id: 45, total threads: 30, pages: 1 [6,109.8Kb mem used] [1s (+0s)]
[forumdisplay] forum_id: 68, total threads: 3, pages: 1 [6,115.8Kb mem used] [1s (+0s)]
[SECTION START] showthread [6,118.6Kb mem used] [1s (+0s)]
[create sitemap file] filename: sitemap_1.xml.gz, number of urls: 49000 [6,064.2Kb mem used] [9s (+8s)]
[create sitemap in text format] part #2 [6,064.2Kb mem used] [9s (+0s)]
[create sitemap file] filename: sitemap_2.xml.gz, number of urls: 49000 [6,066.8Kb mem used] [22s (+13s)]
[create sitemap in text format] part #3 [6,066.8Kb mem used] [22s (+0s)]
[SECTION START] member [6,088.3Kb mem used] [32s (+10s)]
[create sitemap file] filename: sitemap_3.xml.gz, number of urls: 49000 [6,063.1Kb mem used] [34s (+2s)]
[create sitemap in text format] part #4 [6,063.0Kb mem used] [34s (+0s)]
[create sitemap file] filename: sitemap_4.xml.gz, number of urls: 49000 [6,063.6Kb mem used] [44s (+10s)]
[create sitemap in text format] part #5 [6,063.6Kb mem used] [44s (+0s)]
[SECTION START] polls [6,420.9Kb mem used] [53s (+9s)]

Morever even the email of database error is not send to webmaster address.

What is the error?

Sitemap generator hangs giving a database error same has been send to webmaster email address, but we have not received any email on webmaster email ID.

This was happening when we set following option to YES.
If you have vBSEO, include old urls?

We set the above to NO, and now its working fine, however there are no showthread.php and forumdisplay.php urls in ur sitemap now is it good better ?

yes, you DONT want those.

turning that on is good for like the first couple weeks of having vbseo installed... but after that, no good.

Thanks but in case we set the above option to YES sitemap generator gets crash.

When you have that option enabled there are two times more URLs included in sitemap and probably you have your memory_limit PHP setting exceeded. And as Brian mentioned, you don't need to enable that option.

memory_limit PHP setting exceeded.

We have 8 MB setup for this. But as Brain said including the same for a few weeks shall be helpful hence thought if we can fix the problem.

8mb is really low.

i run 128