vbadvanced links directory / vbseo sitemap

Upon running the sitemap generator, it went through most (I assume) of it...

It got as far as...

Code:

[SECTION START] tags [9,105.4Kb mem used] [93s (+0s)]
[create sitemap file] filename: sitemap_11.xml.gz, number of urls: 20000 [9,077.8Kb mem used] [96s (+3s)]
[create sitemap in text format] part #12 [9,077.7Kb mem used] [96s (+0s)]
[create sitemap file] filename: sitemap_12.xml.gz, number of urls: 20000 [9,072.0Kb mem used] [103s (+8s)]
[create sitemap in text format] part #13 [9,071.9Kb mem used] [103s (+0s)]
[addon module] vbseo_sm_vba_links.php [9,341.3Kb mem used] [104s (+1s)]

and promptly displayed the following d/b error.

Code:

Database error in vBulletin 3.7.3:

Invalid SQL:
SELECT * FROM vblinks_categories WHERE private = 0;

MySQL Error   : Table 'antimisan6.vblinks_categories' doesn't exist
Error Number  : 1146
Request Date  : Thursday, September 4th 2008 @ 11:07:16 AM
Error Date    : Thursday, September 4th 2008 @ 11:09:00 AM
Script        : http://mysite.com/vbseo_sitemap/vbseo_sitemap.php
Referrer      : http://mysite.com/vbseo_sitemap/index.php
IP Address    : xx.xx.xx.xx
Username      : Unregistered
Classname     : vB_Database

I'm running the latest vba links directory (3.0RC1) & vBSEO (3.2.0 gold).

Any ideas folks?


ETA: When I click my sitemap link, it says one doesn't exist.
http://mysite.com/sitemap_index.xml

Sitemap file not found

Do you have existing "vblinks_categories" table in your database?

I have
vbadv_links_categories

How on Earth that's got there instead??? I'll have a word over on vbadvanced.com and see what Brian says... 'cos this has me slightly stumped

ps - this was supposed to be in troubleshooting for the sitemap forum, my apologies for posting it in wrong area. if a mod could move it to the appropriate area, i'd appreciate it. cheers

Looks like he changed the structure of the table then. From within your vbseo_sitemap/addons/vbseo_sm_vba_links.php file find: links_categories and change that too: vbadv_links_categories.

Let me know how that turns out.

I removed the links from the Addon Generator Modules input box... that seems to have got it working.

Oops, same issue here, I've open a Ticket for this, but I'm thinking that's the cause..
Anyway in my DB structure I haven't any of that table, I'll create and post the feedback. BrB

I don not have vblinks_categories nor vbadv_links_categories
EDIT, I don't use a vb link directory, it just removed from module addons in config.

It works great now, sorry for confisung.

Here's what Brian at vbadvanced replied with...

Originally Posted by Brian

The table names changed quite a while ago in v1.0.1. The table name needs to be changed to 'adv_links_categories', and the 'WHERE private = 1' part needs to be updated to use vBa Links permissions system, something like this:

PHP Code:

require_once(DIR . '/includes/vba_links_functions.php');

$privcats = links_fetch_private_categories();

$something = $db->query_read("
    SELECT *
    FROM " . TABLE_PREFIX . "adv_links_categories
    " . iif($privcats, 'WHERE catid NOT IN(' . $privcats . ')')
);