[eglyntine]

Hi all,

I have been trying to get this to work for a couple of days now. I've looked all over but I haven't seen the particular error that I'm getting so I thought I would brave the wild and finally ask.

I uploaded all of the files in the upload dir to my forum root, changed the data folder perm to 0777.

I already have an .htaccess file so I added the required lines to it so it looks like this:

Redirect /forums/ http://www.houseofparents.com/
AddHandler php5-script .php
RewriteEngine On
RewriteRule ^((urllist|sitemap).*\.(xml|txt)(\.gz)?)$ vbseo_sitemap/vbseo_getsitemap.php?sitemap=$1 [L]

I installed the product and left the settings pretty much at default. I don't have vbSEO installed so that was changed to "No".

Everything looks great but when I try to generate the sitemap I get the following error:

[homepage] [5,819.8Kb mem used] [0s (+0s)]
[SECTION START] forumdisplay [5,819.9Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 12, total threads: 189, pages: 4 [5,819.9Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 21, total threads: 1377, pages: 28 [5,819.9Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 105, total threads: 40, pages: 1 [5,820.1Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 106, total threads: 9, pages: 1 [5,820.1Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 20, total threads: 173, pages: 4 [5,820.1Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 118, total threads: 34, pages: 1 [5,820.1Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 45, total threads: 23, pages: 1 [5,820.1Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 15, total threads: 125, pages: 3 [5,820.1Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 16, total threads: 457, pages: 10 [5,820.1Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 17, total threads: 54, pages: 2 [5,820.3Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 18, total threads: 15, pages: 1 [5,820.6Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 14, total threads: 190, pages: 4 [5,820.8Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 38, total threads: 0, pages: 1 [5,821.4Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 121, total threads: 1, pages: 1 [5,821.5Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 42, total threads: 3, pages: 1 [5,821.7Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 41, total threads: 91, pages: 2 [5,821.9Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 43, total threads: 3, pages: 1 [5,822.4Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 40, total threads: 66, pages: 2 [5,822.6Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 6, total threads: 0, pages: 1 [5,823.0Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 82, total threads: 8, pages: 1 [5,823.2Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 125, total threads: 60, pages: 2 [5,823.4Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 27, total threads: 84, pages: 2 [5,823.8Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 24, total threads: 252, pages: 6 [5,824.2Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 99, total threads: 8, pages: 1 [5,825.4Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 25, total threads: 43, pages: 1 [5,825.6Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 31, total threads: 0, pages: 1 [5,825.8Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 37, total threads: 31, pages: 1 [5,826.0Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 36, total threads: 32, pages: 1 [5,826.2Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 47, total threads: 35, pages: 1 [5,826.4Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 56, total threads: 0, pages: 1 [5,826.6Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 57, total threads: 55, pages: 2 [5,826.9Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 127, total threads: 2, pages: 1 [5,827.3Kb mem used] [0s (+0s)]
[forumdisplay] forum_id: 53, total threads: 0, pages: 1 [5,827.5Kb mem used] [0s (+0s)]
[SECTION START] showthread [5,827.5Kb mem used] [0s (+0s)]
[create sitemap file] filename: sitemap_1.xml.gz, number of urls: 20000 [5,850.5Kb mem used] [6s (+6s)]
[create sitemap in text format] part #2 [5,850.4Kb mem used] [6s (+0s)]
[create sitemap file] filename: sitemap_2.xml.gz, number of urls: 20000 [5,853.6Kb mem used] [9s (+3s)]
[create sitemap in text format] part #3 [5,853.5Kb mem used] [9s (+0s)]
[SECTION START] member [6,113.4Kb mem used] [11s (+2s)]
[SECTION START] polls [5,876.6Kb mem used] [11s (+0s)]
[SECTION START] blogs [5,900.6Kb mem used] [11s (+0s)]
[SECTION START] albums [5,921.3Kb mem used] [11s (+0s)]
[SECTION START] groups [5,921.4Kb mem used] [11s (+0s)]
[SECTION START] tags [5,921.5Kb mem used] [11s (+0s)]
[addon module] vbseo_sm_downloads.php [5,921.5Kb mem used] [11s (+0s)]
Database Error

No other error codes or anything are displayed so I don't even know where to begin to look. But I do get this generated to my e-mail afterwards:

   Database error in vBulletin 3.7.4:
   
  Invalid SQL:
  SELECT id,name FROM file_cats ORDER BY `order`;
   
  MySQL Error   : Table 'mydatabasename.file_cats' doesn't exist
  Error Number  : 1146
  Request Date  : Saturday, December 13th 2008 @ 11:25:18 PM
  Error Date    : Saturday, December 13th 2008 @ 11:25:30 PM
  Script        : ../vbseo_sitemap/vbseo_sitemap.php
  Referrer      : ../vbseo_sitemap/index.php?rlist=true
  IP Address    : xx.xxx.xxx.xxx
  Username      : Unregistered
  Classname     : vb_database
  MySQL Version :

Do I need to manually create this table or is there something else that I've failed to setup that wasn't in the instructions?

I'm running vBulletin 3.7.4 PL. Any help you could provide would be greatly appreciated. I'd really like to have this Add-on for my site.

Thanks,