vbseo sitemap generator don't want to generate database problem?

I use vbseo the latest version.

I use vbulletin 4.0.1.

I installed vbseo sitemap generator but i can't make it work!

Each time i try to generate a sitemap i have this error:

Database error in vBulletin 4.0.1:
Invalid SQL:
SELECT
count(*) as maxre
FROM tagthread
GROUP BY tagid
ORDER BY maxre DESC
LIMIT 0,1;
MySQL Error : Table 'samuel_vbulletin.tagthread' doesn't exist
Error Number : 1146
Request Date : Tuesday, February 23rd 2010 @ 08:35:23 AM
Error Date : Tuesday, February 23rd 2010 @ 08:35:23 AM
Script : S'identifier - Gagner de l'argent - vBulletin Logiciel d'administration
Referrer : S'identifier - Gagner de l'argent - vBulletin Logiciel d'administration
IP Address : 74.58.192.108
Username : Samuel
Classname : vB_Database
MySQL Version : 5.1.30

Someone can help me fix this please?

Thanks,
Sam

For vBulletin 4 you need to install vBSEO Sitemap Generator 2.6 Beta

FIXED! Thanks alut. A+++

We're receiving the same error in 2.6 Beta 2.

Code:

Database error in vBulletin 4.0.3:
Invalid SQL:
         SELECT 
          count(*) as maxre
         FROM tagthread
         GROUP BY tagid
         ORDER BY maxre DESC
         LIMIT 0,1;
MySQL Error   : Table 'ncangler_forums.tagthread' doesn't exist
Error Number  : 1146
Request Date  : Wednesday, May 5th 2010 @ 05:22:05 PM
Error Date    : Wednesday, May 5th 2010 @ 05:22:05 PM
Script        : http://www.ncangler.com/forums/vbseo...eo_sitemap.php
Referrer      : 
IP Address    : *
Username      : Unregistered
Classname     : vB_Database

As a temporary fix you can disable the tags from being included.

Hello,

it should work correctly with tags enabled. Please open a ticket with ftp access for troubleshooting.

I'm pretty sure I was able to fix it. The queries for vB3 were still being executed, so I checked this bit of code on line 39 of vbseo_sitemap_functions.php:

Code:

  if($vbulletin->versionnumber >= '4.0')
   $vbseo_vars['isvb4'] = true;

Once I changed it to use $vbulletin->options['versionnumber'] instead then it started loading up fine.

(FYI, this is Brian from vBadvanced posting under NcAngler's account since I'm helping him with his vB4 upgrade )

Strange that it works in some instances, but not in others. Anyway, thanks for the follow-up!
(especially since vBulletin itself uses $vbulletin->versionnumber)