another d/b error

[karlm]

Here's what I wrote on vbseo, in regards their site map generator.

Originally Posted by karlm

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

It got as far as...

[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.

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

I've tried their answer;

Originally Posted by Michael Biddle

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.

This has not helped, unfortunately. Has the structure been changed, and how may I get around this problem?
In the meantime, I have removed the site-map generator's references to the links directory in order to build a site map of everywhere aside from the links directory. This has worked, but I'd like to be able to include the links directory if possible, but it seems the tables are not created the same (in the newest incarnation of the links directory) as was programmed in to the vbseo addon tool to include the links directory.

[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 . ')')
); 


[karlm]

okies, cheers, Brian... I've posted this at vbseo so they're aware... but your code, to me, means nothing - sorry - I'm clueless at coding except the very, very, very basics.

How might I go about applying the code you've given... or shoudl it be used by vbseo for updating their next release of vbseo?

[Brian]

I've never used vBSEO, so I'm not really sure where that code would need to be placed. Should be a pretty simple fix for the guys over at vBSEO though if you've shown them that code/post.

[briansol]

vbseo released a new addon for version vBaL 3.0 that isn't in the addons folder.

http://www.vbseo.com/f66/vba-links-d...18/#post116379

[Brian]

That's not for v3.0. Actually it wouldn't work for anything past vBa Links v1.0.

[briansol]

are you sure? I have it in production and working...

[Brian]

It may still work, but will not filter out categories that the user does not have permission to view.